Skip to main content

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

Hello,

 

Unfrotunately not - the only solution is to getting all bunch of variants for CDPOS changes where order of the action with same timestamp is different. Then you'll have to create such event with turned on traceback mode in SAP to see which was accualy the first , based on that analysis you've got few possibilities, but there's not out-of-box solution:

 

A) adjust sorting values for the activities to change default order (Adjust SQL transformations)

B) design different sequences and assign sorting based on specific sequence (Create custom SQL data transformation)

C) Use not only the timestamp but also change number. (Adjust SQL transformations)

D) Try to get more detailed timestamp that may be different (probably not applicable)

 

Best Regards,

Mateusz Dudek

 

 

 


Hello,

 

Unfrotunately not - the only solution is to getting all bunch of variants for CDPOS changes where order of the action with same timestamp is different. Then you'll have to create such event with turned on traceback mode in SAP to see which was accualy the first , based on that analysis you've got few possibilities, but there's not out-of-box solution:

 

A) adjust sorting values for the activities to change default order (Adjust SQL transformations)

B) design different sequences and assign sorting based on specific sequence (Create custom SQL data transformation)

C) Use not only the timestamp but also change number. (Adjust SQL transformations)

D) Try to get more detailed timestamp that may be different (probably not applicable)

 

Best Regards,

Mateusz Dudek

 

 

 

Thanks for the reply Mateusz, appreciate the feedback. I assume that it is not possible to use the order of insertion in the SAP table?

 

I was hoping there was a simple solution, but looks like I will have to do some more scripting

 

Thanks!

Michael


Hi, I don't think so, since the activities are played at the same time. Maybe it works that the activities are transformed so that one activity is displayed in Celonis earlier than the other. But this would have to be defined by you. We have something similar, that we have taken the default time "12:00:00". 


Hi, I don't think so, since the activities are played at the same time. Maybe it works that the activities are transformed so that one activity is displayed in Celonis earlier than the other. But this would have to be defined by you. We have something similar, that we have taken the default time "12:00:00". 

Thanks Andre,

 

Looks like I will have to find someone in the business who knows our SAP setup in detail to help me and define it myself in the transformation script. Thanks for your reply.

 

Cheers,

Michael


Reply