Skip to Content
avatar image
Former Member

Extracting Line Item and Line Item Status

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?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    May 25, 2006 at 04:59 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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!