Question
Hi team,This is related to PQL function CURRENCY_CONVERT_SAP.I want to know how this field GDATU from TCURR table is converted to date once it is in string in celonis.
+3Hi team,
This is related to PQL function CURRENCY_CONVERT_SAP.
I want to know how this field GDATU from TCURR table is converted to date once it is in string in celonis.
+3The field is in inverted date format: the 9er complement of each digit is stored instead of YYYYMMDD. To convert it to YYYYMMD it needs to be subtracted from 99999999
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.