Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Update rule routine.

Hello All,

I'm extracting PO data using the standard datasource 2LIS_02_ITM.

My problem is related to the fields 0PROCESSKEY and 0PSTNG_DATE.

I simply need to load the two fields to my ODS but using a logic that points this date to two different characteristics into the ODS using a routine (start routine or update routine) that depends on the value of 0PROCESSKEY. The logic is:

IF 0PROCESSKEY = 2.

0PSTNG_DATE = 0PSTNG_DATE.

ELSE.

ZDT_PST_F = 0PSTNG_DATE.

The problem happens when we have two records from the same PO documents coming like the example below:

ID DOC ITM PROCESSKEY PSTNG_DATE

1 1000 1 2 01/01/2008

2 1000 1 3 02/01/2008

Final Result on ODS (key DOC and ITM) would be:

DOC ITM PROCESSKEY PSTNG_DATE ZDT_PST_F

1000 1 3 01/01/2008 02/01/2008

However, the result I got after creating update routines on the two field at the update rule is the following:

DOC ITM PROCESSKEY PSTNG_DATE ZDT_PST_F

1000 1 3 02/01/2008

It seems that the second record is overwriting the first one instead of just fill the characteristic ZDT_PST_F.

Does anybody know how to solve it on an easy way?

Thanks in advance

Raphael Leis

Not what you were looking for? View more on this topic or Ask a question