INFORMATION ABOUT CDHDR AND CDPOS TABLES

[Former Member]

HI

Could you pls let me know the usage of CDHDR and CDPOS tables,

Regards,

D

[Former Member]

Hi

These are change Document related tables

If you change the data in any SAP Transaction those changes with respect to that Transaction code, table, Filed, User, Time based changes are recorded in these tables.

CDPOS is a cluster table which stores lot of data. You can't join this with any table.

So first have to fetch the data from CDHDR and then for all entries of that table fetch the data from CDPOS table.

Regards

Anji

[Former Member]

Hi

How would i capture Delta on VBBE ONLY table Using CDHDR CDPOS

I have to capture Delta when a sales order is created modified and deleted

Regards

D

[former_member387317]

Hi D,

CDHDR and CDPOS contain the last changed date for particular objects.

UDATE and UTIME of the table CDHDR will have the date on which the change docuemnet has been created(Which means the date on which that field's value changed in the DB)

CDHDR has the header information for changes in objects (like material master),

while CDPOS has the information for the positions of the object.

They work together joining fields OBJECTCLAS, OBJECTID & CHANGENR.

Hope it will help you..

Thanks & Regards

ilesh 24x7

[Former Member]

please check this link

http://www.tek-tips.com/viewthread.cfm?qid=262703&page=19

[Former Member]

Use FM CHANGE_DOCUMENTS_READ (dont have access to SAP, pls check name). Pass appropriate Values to the FM. it will return results from CDHDR, CDPOS tables. this is also the fastest way to access them.

L