select
"MANDT",
"KURST",
"FCURR" YB,
"TCURR" BB,
99999999-"GDATU" YXDSTART,
"UKURS",
"FFACT",
"TFACT"
from "XXXXXX"."TCURR"
SAP对应汇率表为TCURR,需转换字段为GDATU,代表生效时间,生效时间=99999999-GDATU。UKURS为汇率,FCURR为原币,TCURR为本币。
select
"MANDT",
"KURST",
"FCURR" YB,
"TCURR" BB,
99999999-"GDATU" YXDSTART,
"UKURS",
"FFACT",
"TFACT"
from "XXXXXX"."TCURR"
SAP对应汇率表为TCURR,需转换字段为GDATU,代表生效时间,生效时间=99999999-GDATU。UKURS为汇率,FCURR为原币,TCURR为本币。