‎2007 May 30 8:03 AM
Hi experts,
I have created a Change Document Object for about 5 tables including 2 Z-tables.
Before I record the changes, one of the tables may have different kinds of changes.
For example, some of the entries are inserted, some are updated, and others maybe deleted. Now my question is that how can I recode all these changes which belong to different kinds in one go by calling the FM generated automatically after creating the Change Document Object? Because there are some other tables whose changes also need to be recorded, I can not call the FM several times. Does any1 have some ideas about this?
Thanks in advance. Points will be rewarded.
Vincent
‎2007 May 30 8:14 AM
Hi
Use the Tables CDHDR and CDPOS to find out all the changes with respect to each field in the corresponding object related tables.
Enter the correct change doc and find the field level changles with date and Time and the user who changed it etc.
also use the fun modules
CHANGEDOCUMENT_READ_HEADERS
CHANGEDOCUMENT_READ_POSITIONS
Reward points if useful
Regards
Anji
‎2007 May 30 8:14 AM
Hi
Use the Tables CDHDR and CDPOS to find out all the changes with respect to each field in the corresponding object related tables.
Enter the correct change doc and find the field level changles with date and Time and the user who changed it etc.
also use the fun modules
CHANGEDOCUMENT_READ_HEADERS
CHANGEDOCUMENT_READ_POSITIONS
Reward points if useful
Regards
Anji
‎2007 May 30 8:22 AM
Hi Anji,
My situation is that I have to record the changes for a table for different kinds of db processing( insert, update, delete) in one go using the function module generated atuomatically, I do not have to care about how to get the records.
‎2007 May 30 8:30 AM
Hi Vincent,
To Know if the change document pertains to a Insert / Update / Delete you can use the Table BDCP
the field CDCHGID gives the--> Change type (U, I, E, D)
Regards,
Gaurav
‎2007 May 30 8:16 AM
Hi
<b>CDHDR,CDPOS are the table for Header and Item for Change Documents.</b>You can use the FMs:
<b>CHANGEDOCUMENT_READ_HEADERS
CHANGEDOCUMENT_READ_POSITIONS</b>
Regards,
Sree
‎2007 May 30 9:43 AM
Hi guys,
Thanks for your reply, my problem is solved.
Thank you all the same.
Just Check the "Copy as internal tab" checkbox when create Change document object, and the FM generated has the tables parameters for tables whose changes need to be recorded. The last filed of the structure is the indicator for insert/update/delete.