Skip to Content
author's profile photo Former Member
Former Member

Pricing deltas

We have a need to export Pricing changes as an outbound interface. The Pricing info is in table A005. Since I don't see a "Date Changed" field in this table, I'm at a loss as to how one would go about determining that any table entry has changed. They want to export only those entries that have changed since the last export.

Has anyone run across this situation and have a solution?

Thanks.

Nic

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2007 at 10:05 PM

    Hi Nic,

    The effective from and effective to dates are the key here.

    For Eg: If there is an entry in A005 for MATNR ABC eff from 01/01/07 to 12/31/9999(default eff to dat).

    And if there is a price change on today 09/28/2007 then automatically a new record is created and your A005 would have 2 entries as follows:

    <b>COND - MATNR - EFF FROM - EFF TO - KNUMH</b>

    cond type1 - ABC - 01/01/07 09/27/2007 -


    knumh1

    cond type1 - ABC - 09/28/07 12/31/9999 -


    knumh2

    For other details u can use that KNUMH and read tables KONH and KONP.

    Let me know if you need any other info.

    Sri

    Add comment
    10|10000 characters needed characters exceeded