topic Re: Tables storing changes for master data in Application Development and Automation Discussions

Tables storing changes for master data

Former Member — Mon, 08 Oct 2007 22:17:55 GMT

I am tracking changes in the master data from transaction codes VD02 and XD02; I would then go to Environment ~~> Account changes~~>All Fields.

Would anyone happen to know which transparent table stores these data possibly with valid from and to dates for the chages?

I am allso checking transaction OV51. Which transparent table would have the data ?

Former Member — Mon, 08 Oct 2007 22:21:12 GMT

All the change documents in SAP are stored in table CDHDR and CDPOS.

CDHDR has the header data.

CDPOS has all the change details.

Former Member — Mon, 08 Oct 2007 22:29:48 GMT

Would you happen to know what wouldl be the OBJECTCLAS and OBJECTID shoud be for these transaction codes, VD03 and XD03?

Or how would I determine which to use to look for the changes for a sold-to-party, for example?

ferry_lianto — Mon, 08 Oct 2007 22:35:33 GMT

Hi,

The OBJECTCLAS in table CDHDR for customers is DEBI.

The OBJECTID is the customer number with leading zeroes.

You can go to CDPOS table to find the sold-to changes based on above OBJECTCLASS and OBJECTID.

Regards,

Ferry Lianto

Former Member — Mon, 08 Oct 2007 22:37:14 GMT

The OBJECTCLAS is DEBI for both the tcodes.