table which stores the history of changes by condition types for po item

[Former Member]

hi experts,

can u tell which table contains all the changes made to the amount and condition values based on condition type for a po item.i see that the table konv has only the recent values based on condition type but i need all the changes that where made earlier too.Please help me out to find it.

[Former Member]

Hi,

Please check in CDHDR and CDPOS tables.

thanks,

[Former Member]

Hello

CDHDR with OBJECTCLAS = 'EINKBELEG' and OBJECTID = number of PO

then

CDPOS with OBJECTCLAS = 'EINKBELEG' and OBJECTID = number of PO and CHANGENR = CDHDR-CHANGENR.

[Former Member]

thanks for ur replys,

but by this i get the recent condition type values but i need all the history of changes of values.

[Former Member]

more over i need the changes in values bsed on condition types.Each condition type what is the onld values and the current value

[Former Member]

Hello

Not quite so

The table CDHDR contains ALL changes.

You must do SELECT * FROM CDHDR WHERE ....

And then in LOOP/ENDLOOP you SELECT SINGLE * FROM CDPOS WHERE ...

So get all changes.

[Former Member]

thanks for ur reply,

but here we dont get the values for each condition type,we see gross and net changes in a group of conditions.but i need for each condition type

[Former Member]

Hi Kiran,

check the tables MSEG EINE EINA

Regards,

Chinna

[Former Member]

THANKS FOR UR HELP