Extracting Line Item and Line Item Status

[Former Member]

We are on version 3.5 of BW.

I have a requirement to associate each row in the change log of the ODS - Sales Order: Item Status to a row in the change log of the ODS - Sales Order Item Data.

For example:

When there is a status change recorded in a "before" and "after" image rows in the Item Status change log, how do I associate that to the "before" and "after" image rows in the Sales Order Item Data. Likewise of there is a "N"ew record in the Item Status, how can I associate that row to the "N"ew row in the change log for the Sales Order Item Data.

Is this even possible?

[Former Member · Accepted solution]

Hi

Yes it is.

We do it in our Sales Item.

It is kind of a 'History' keeping of the changes of a Sales Order.

We do it by adding a counter to the line in the change log that is incrementing each time a change is happening in the main ODS.

This way can have many instances of this line over time.

I myself thinks it is an overkill, it is bad for performance and it is not very often used by the users.

We use it to keep Bookings over time, and since bookings changes we track these changes via this mechanism.

Reg's

Edan

[Former Member · Accepted solution]

Thanks for your reply. However can you be a bit more explicit using the terms:

• Sales Item Change Log

• Sales Item Active Data

• Sales Item STATUS Change Log

• Sales Item STATUS Active Data

• Any other table you may be using.

In what table(s) are these counters and how do they cross reference each other? How are you incrementing a counter in the Sales Item ODS and cross referencing it to a counter in the Sales Item STATUS ODS? Remember what I want to do is reference a row in the STATUS ODS to a row in the Sales Item ODS.

Again, thanks!