Hi all,
I have an issue with the way that the data in the CDPOS table is stored in S4/HANA.
The issue occurs when an event triggers multiple follow-on events in SAP. For example, changing the company code (BUKRS) on an invoice will update the country code automatically (LAND1) at the same time. The user has only performed one change, but two are reflected in the CDPOS table with the same date, time, change number etc.
When creating the activity in the transformation, I wish to capture the first activity that the user has performed, not the follow-on activity.
Is there a way to detect which CDPOS entry is the first activity?
Example of CDPOS entry
CHNGENR FNAME DATE USER
000001 BUKRS 01-01-23 12:00 John Smith
000001 LAND1 01-01-23 12:00 John Smith
Cheers,
Michael