Skip to main content
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.

  • Jul 16, 2024 9:26 AM UTC
  • 1 reply
  • 105 views
gauri.pai11
Level 3
Forum|alt.badge.img+3
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.

    1 reply

    rita.kiss12
    Level 7
    Forum|alt.badge.img+3
    • rita.kiss12
    • Level 7
    • Jul 16, 2024 11:17 AM UTC

    The 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

    Community Code of ConductAccessibility statement