2LIS_02_SCL getting the order of changes wrong?

[Former Member]

Hi all,

I've been looking into an issue with the Purchasing line item data I am getting. I've been struggling to find out why a PO isn't being shown as deleted. What i've found in R/3 is when a PO is deleted, it gets the delivery completed flag set. Then the line item gets flagged as deleted. I can look at the item changes and the deletions is definitely the last change that happens to the line item.

What i've seen in BW after the extraction process (in my DW layer) is the Deletion is coming through (ROCANCEL of 'R') and then the delivery completed flag is coming through. Because the deletion is first and then the compl_del is second, it means when this moves onto a secondary DSO it basically resurrects this PO.

The DW layer is a straight mapping from the datasource (2lis_02_scl), so nothing is getting "sorted" or anything.

Any ideas?

[Former Member]

Nobody gonna give it a go?

Oh well.

[Former Member]

Hi,

Is it showing the deleted records in the first ODS?Are you using any fields related to delivery as keyfields in the ODS? Records will be added based on the key field changes in the ODS.Please check PSA and see the keyfield changes.

Thanks.

[Former Member]

yeah i see both records in the DSO, which is a straight map from the PSA.

and no the delivery completed flag is not a key field anywhere. i hadn't thought of that though. It may be a path i need to check.

thanks for a response

[Former Member]

Hi,

Its not delivery completed flag,it could be any other field related to delivery process .Thats what i was trying to mention.I think if you compare the records in PSA,you will know which field is getting changed and you can remove the field if it is not required.

All the best

Thanks.

[Former Member]

unfortunately in the examples that i'm looking at, the only thing that has changed in the PSA is the Delivery completed flag. Regardless, this was changed before the record was deleted. If it came through in the correct order it would be fine.

And we can't remove the delivery completed flag. Its kinda needed.

[Former Member]

Hi,

Check the below links . bit old but might give some hints.

and one more link

Thanks.

[Former Member]

thanks Raja, as you say, the links are a bit old, but it will give me some more direction on where to look.

I looked in the system and don't know how to see the "is statistical" identifier that the links talk about, but i'll have a look and see if it leads me anywhere.