topic INFORMATION ABOUT CDHDR AND CDPOS TABLES in Application Development and Automation Discussions

INFORMATION ABOUT CDHDR AND CDPOS TABLES

Former Member — Sun, 07 Oct 2007 20:45:33 GMT

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

Regards,

Re: INFORMATION ABOUT CDHDR AND CDPOS TABLES

Former Member — Sun, 07 Oct 2007 21:04:31 GMT

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

Re: INFORMATION ABOUT CDHDR AND CDPOS TABLES

Former Member — Sun, 07 Oct 2007 21:24:52 GMT

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

Re: INFORMATION ABOUT CDHDR AND CDPOS TABLES

Former Member — Sun, 07 Oct 2007 22:02:33 GMT

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

Re: INFORMATION ABOUT CDHDR AND CDPOS TABLES

Former Member — Mon, 08 Oct 2007 04:40:59 GMT

please check this link

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

Re: INFORMATION ABOUT CDHDR AND CDPOS TABLES

Former Member — Mon, 08 Oct 2007 05:26:37 GMT

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.