CDHDR/CDPOS Tables

[Former Member]

Hello Gurus,

I have been reading different material on the information being saved into CDHDR/CDPOS tables.

and  have a question on the same for which I was not able to find a direct answer.

1) I know about enabling  the  'Change Document' at data element level . Does that mean for sure, any change to these fields would be captured in the CDHDR/CDPOS and if it not checked, will not be recorded at all.?

Mainly I am looking at any change for master data / Transaction data happening on the r/3 system ..

1. Does these tables captures all

2. Or any exceptions

I am working in a BW Project and any information of the working of delta based on the records of these table would be of great help.

Any pointers are appreciated.

Thanks

Indira G

[Former Member]

Hello Gurus,

I have been reading different material on the information being saved into CDHDR/CDPOS tables.

and  have a question on the same for which I was not able to find a direct answer.

1) I know about enabling  the  'Change Document' at data element level . Does that mean for sure, any change to these fields would be captured in the CDHDR/CDPOS and if it not checked, will not be recorded at all.?

Mainly I am looking at any change for master data / Transaction data happening on the r/3 system ..

1. Does these tables captures all

2. Or any exceptions

I am working in a BW Project and any information of the working of delta based on the records of these table would be of great help.

Any pointers are appreciated.

Thanks

Indira G

[Former Member]

checking the change documents flag only sets the data element as ready for the change document object. So if you create a data element, set the flag and update a table with field corresponding to the data element, you will not find anything in CDHEAD/POS.

You always need to do the coding for the change document object. You can find many examples, just search for change documents.

[Former Member]

Thanks for the reply Jozef. I do understand that checking the 'Change Document' doesnot put a value in the field.

My question is, for the standard transaction like 'Change Material' , does any minute change put an entry in the CDHDR table?

Any change/update or other actions, does it always add an entry in the table no matter what transaction or table..? or are there any exceptions as such..?

Regards

Indira G

[Former Member]

I got your point. You can't assure yourself by such thing. As I said, it has to be implemented (coded) at the place, where the update takes place. SAP did some job with that and even if it did a good job, you can always create a z-report running a direct update of the MARA table or other ways of updating without using standard BAPIs. So you can't be sure that every change is going to be recorded.

What you suggested - the "minute change" - is something I do not really understand. You need to check the field at the data element level and also have the field in the structure of the change document object. Once you un-check the flag, the field will no longer get recorded in change documents. And you can consider this a "minute change" . However, you merely need a so quick change of something like this. You still need to think about the buffers used, e.g.

And, of course, standard transactions use standard elements and I doubt you will change their settings of the change documents flag.

[Former Member]

In case of Change Material (MM02), the change documents get automatically created assuming change documents are active. In case of any custom functionality support for change documents needs to be implemented, like Jozef wrote. However SAP has does it with most APIs, such as BAPI_MATERIAL_SAVEDATA.

[Former Member]

Thank you Jofez and Samuli.

I think I am confusing here. My question is,

In SAP R/3 system, there are number of transactions happening at a given point of time.

So, for all the transactions happening ( Master Data and Transaction Data ),

Does all the changes to the various transactions and corresponding tables, get recorded in CDHDR/CDPOS..( And also does that work in both scenarious .. with 'change document checked and also unchecked.(I guess, it doesnot work when unchecked, not sure though ))

In other words, there is no entry in CHDHR for a particular transaction or table entry, does that mean thre are no changes which happened in the system at all..??

Joefz,

What I meant by 'Minute Change' is tiny/small change, not the measure of time 'Minute' .. Say a text change of a field or change to some field which doesnt effect the system .. English at its best..

Thank you so much for your time... !!

Regards

Indira

[Former Member]

not all the transactions work with change documents.

if unchecked - no change documents are created for the field

If your transaction does not fill CDHEAD/POS, you need to know the business background (SPRO?). There may be other ways of logging of the changes, partucular for the corresponding transaction. Finding change document object for every transaction can be a tricky thing, but if you name your one, maybe someone can help you with that. .

change documents can't distinguish between important and unimportant field changes. It, of course, can not recognize that this field does / does not affect the system in any way. So it does the same job with all the fields in the object flagged to be processed.

[Former Member]

I need the log table for T-Code IW32.

I can see the Action Log by going to Extras -> Change Document -> Action Log.

But, I wanted to know the Database table which stores the log data.

Thank you

Indira G

[Former Member]

I believe that is partially CDHEAD/POS. Many transactions use "dynamic creation" (do not know how to name it) of change documents based on it's own application data. You will find a better answer with a separate post naming especially IW32 change documents.