re: what is the use of cdhdr and cdpos change documents

[Former Member]

Hi,

what is the use of cdhdr and cdpos change documents.

regards,

p.kp

[Former Member]

The tables to use are CDHDR and CDPOS - CDHDR is the header, and gives

you a number to link to CDPOS which holds the data changed. These are

huge and a real pain in the butt to use. Have to start with "Changed By"

and "Changed On" to get a list, find the object and go form there.

http://supplychain.ittoolbox.com/groups/technical-functional/sap-r3-log-pm/589914

Also refer this thread

Reward points if u find helpful.

[Former Member]

Reading these tables enable to know changes on : material, invoice, orders, ...

You can get user, last change, field changed, old value, new value, ...

[Former Member]

Change documents are for changes made to various objects like Purchase Order / Sales Order . In SAP most of the customizing tables are directly logged and this is stored in table DBTABLOG ( pertains to table attribute in SE11 ) . But for business objects and other objects SAP stores the changes in CDHDR / CDPOS. The change documents objects can be seen in transaction SCDO.

Check this online help -

http://help.sap.com//saphelp_470/helpdata/EN/2a/fa015b493111d182b70000e829fbfe/content.htm

Cheers

Sanjay

[Former Member]

Hi prasad,

In SE11->Technical Settings, there exits a check box Log data changes. If it is checked, changes done to database data will be tracked in table DBTABPRT, in case it is not checked, even then we can track the changes. This is done by CDHDR, CDPOS tables.

CDHDR is header information with

Object class (Specific for a table),

object id (Concatenated primary key of table tracked for changes)

change number (generated number)

as primary key.

In CDPOS, we can get the information about which table has been modified, by whom , when, which field , its old and new values, which lineitem has got modified.

Regards,

Sailaja.

Dont forget to reward points if answer is helpful to u.

[Former Member]

HI sailaja,

I have created ztable. And in the tech settings i checked the checkbox for log data changes. Then i entered the values into table manually. But these log values are not populated into the table dbtabprt.

you told if we don't check , then we can retrive by using cdhdr. How can i retrive these values.

rgds

p.kp

[Former Member]

Changes / updates to tables entries are saved in table DBTABLOG and not DBTABPRT. Use transaction SCU3 to analyze your table data changes as these are stored in DBTABLOG in LRAW format.

Cheers.

Sanjay

[Former Member]

Hi,

CDHDR - Change Document Header

CDPOS - Change Document Item

You will find the changes history in above tables.

Ex: Say, you have created one custom table and you have developed one screen to the user for entering the data. One of the requirement is you need to capture the changes made to the data stored in the table.

1) you need to create a object in SCDO tcode for the custom table.

2) you need to capture the changes by using function module(generated in SCDO tcode).

Hope it will gives you fair idea.

Thanks