CDPOS/CDHDR not getting updated

[former_member580656]

Hi,

I have a requirement to maintain the change log for a custom table. For this i have created a custom object using SCDO and the 'change document' checkbox against the data elements is selected. Inside the table maintenance generator(TMG) events, i am calling the system generated FM to log the changes. This FM is an 'update function module' with 'start delayed' option selected.

However no update happens in the log tables. Since this is an update FM, do i need to call it in 'update task' ? Also is any 'commit work' needed ?

Kindly give me your inputs.

Thanks,

Meera.

Edited by: Meera Alex on Jun 10, 2010 7:32 AM

[birendra_chatterjee]

Hi Meera,

It is very simple to activate change log for custom tables. Maintain (tick) log data changes in the technical settings of the custom table. Then you can see the change log of the table. For every update of this table through TMG, a change log entry will be stored in DBTABLOG.

Regards,

Birendra

[former_member580656]

Hi Birendra,

I have already done that. Also i want my change log in CDPOS table.

Thanks,

Meera

[Former Member]

1) ensure that Chnage Document check it activated at the Data Element Level.

2) Auto generated FM in SCD0 should write entries in CDPOS I dont think any other special processing is required here.

[Former Member]

Hi

Did you select the 'log data changes' check box in the technical settings of your table?

Regards,Deepa

[former_member580656]

Hi,

Yes. That is done. On debugging,i could see the insert into CDHDR/CDPOS statements with the expected data.

However database commit is not happenning due to some reason and i feel hence the data is not getting populated.

Does anyone have any inputs ?

Meera

[former_member536879]

Hi Meera,

After the commit work just use the statement wait upto 3 seconds.

Hope this might solve your problem.

With Regards,

Sumodh.P