Pricing deltas

[Former Member]

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

[Former Member]

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