Hi there,
we are currently in the middle of the extraction of a production planning process from our SAP ECC. Now there is the need to extract only certain lines of the CDHDR and CDPOS. We know that a join is theoretically possible between AUFK.AUFNR and CDHDR/CDPOS.OBJECTID. To make it an exact join, though, one has to extract a substring of the OBJECTID, as the AUFNR is only a part of the OBJECTID. We tried this:
SUBSTRING (CDHDR.OBJECTID,6,12) = AUFK.AUFNR.
It returned an error, though. Does anybody know, where the problem is or is there a better solution to our problem?
Happy for any help and best regards,
Carl
Page 1 / 1
Hi @carl.schad,
in case this error still occurs, I would suggest reaching out to our Servicedesk to find a solution. Without further information, it is difficult to find a solution.
Best,
Kevin
Hi Carl,
you can't transform on the extraction join.
You can achieve similar results by applying a filter on CDPOS.TABNAME = 'AUFK' and joining with CDHDR during extraction.
Let me know if you need any further support
Best,
Gabriel
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.