ABAP routine help

[Former Member]

I have 4 ODS's. ODS1 has material movement detail. ODS2 has material doc header. ODS3 has derived shift and material document. ODS4 has shift data. I want to derive the shift worked from ODS2 time stamp using ODS4 shift data and place that in ODS3 with selected fields from the ODS1 line level detail. Would the ABAP routine in the update rules be the best place for this? Can you provide some sample code to do this.

[Former Member · Accepted solution]

Hi,

do you load via delta ? then it might be a problem to join the data. What do you do, when a dataset changes ?

But generally i would take one datasource as master and join in it's update rule the 2 other ods data.

Kind regards,

Tobias

[Former Member · Accepted solution]

Yes we do load delta. It seems as though my design would be better if I derive the shift worked from ODS2 time stamp using ODS4 shift data and place that in ODS2 at the update. Would it be best to do that in the update rules ABAP routine.

Can anyone supply some sample code.

ODS2 has the material doc number(header) and time stamp. ODS4 has Date and time (from and to) and the shift number.