Skip to main content
Question

Need help to join 2 SAP S/4HANA tables in a data extraction job with child table key value (16 digits leading zeros) and parent (10, 1 leading zero) are formatted slightly differently

  • September 22, 2023
  • 2 replies
  • 17 views
C
Level 2

Need help to join 2 SAP S/4HANA tables in a data extraction job with child table key value (16 digits leading zeros) and parent (10, 1 leading zero) are formatted slightly differently

 

Tried using Data type conversion CAST_TO_STRING, syntax seems OK, but get error when executing data job:

Error setting up extraction. Illegal join path configuration. Used resource neither child nor parent [CAST_TO_STRING(DFKKZP] - [DFKKZP] / [DFKKPOH]. Celonis Support ID: 2b8cab5b-7442-41cc-9878-77ef645eeed1

 

Able to help?

    2 replies

    R
    Celonaut
    • robert.mcgin
    • Celonaut
    • September 26, 2023
    Hi Christian - Do you still need help? If so we can have an expert take a look and help you out.
    C
    Level 2
    Hi Christian - Do you still need help? If so we can have an expert take a look and help you out.

    yes please, I've tried also contacting, but get syntax error directly in EMS (before even executing it on SAP side): DFKKZP.SELW1 = CONCAT(`000000` , DFKKPOH.PYORD);

    Community Code of ConductAccessibility statement