topic Detect change in table in Application Development and Automation Discussions

Detect change in table

Former Member — Mon, 18 Aug 2008 09:04:22 GMT

Hi All,

How can i detect if a value of particular item in a table has been changed. Is thr any field to achieve tht

Re: Detect change in table

former_member188829 — Mon, 18 Aug 2008 09:06:52 GMT

Hi,

Check CDHDR and CDPOS Tables

Re: Detect change in table

Former Member — Mon, 18 Aug 2008 09:07:03 GMT


> Hi All,
> How can i detect if a value of particular item in a table has been changed. Is thr any field to achieve tht

if the Change Document Object is associated with that Table and for the field Data element level change document flag is enable then you can track the changes of that field.

Tables realated are CDHDR and CDPOS.

Re: Detect change in table

RahulKeshav — Mon, 18 Aug 2008 09:07:15 GMT

hi KT,

try to check table CDHDR, CDPOS for change in any field...

thnx

Rohit

Re: Detect change in table

Former Member — Mon, 18 Aug 2008 09:09:43 GMT

Check the DATA ELEMENT of the field to determine whethere CHNAGE DOCUMENT check box was selected or not in the 'Further characteristics tab'. If it selected then if any change is made an entry will be made in CDHDR and CDPOS tables otherwise not.

Regards,

Kiran Bobbala

Re: Detect change in table

RaymondGiuseppi — Mon, 18 Aug 2008 09:10:48 GMT

There are mainly two ways of tracing data change in table.

- Programmaticaly via [Change Documents|http://help.sap.com/erp2005_ehp_03/helpdata/EN/cb/254340a49f6913e10000000a1550b0/frameset.htm] Look at [SCDO documentation|https://www.sdn.sap.com/irj/sdn/advancedsearch?cat=sdn_all&query=scdo&adv=false&sortby=cm_rnd_rankvalue]

- Dictionnary [Database log|https://www.sdn.sap.com/irj/sdn/advancedsearch?cat=sdn_all&query=databaselog&adv=false&sortby=cm_rnd_rankvalue] via activation logging of data element and technical attributes of table.

Regards

Re: Detect change in table

RahulKeshav — Mon, 18 Aug 2008 09:30:10 GMT

hi kartik tarla

any update

Re: Detect change in table

Subhankar — Mon, 18 Aug 2008 10:22:33 GMT

Hi Kartik ,

To track the changes in any field value for a table.....

1. go to TECHNICAL setting.

2. Check LOG DATA CHANGES check box.

3. To fetch the changes data use the FM

DBLOG_READ_TABLE.

CALL FUNCTION 'DBLOG_READ_TABLE'

EXPORTING

from_day = v_b_date

to_day = v_e_date

to_time = v_e_time

obj_list = i_cust_table

CHANGING

log_list = i_log_list[].

Re: Detect change in table

Former Member — Mon, 18 Aug 2008 10:35:17 GMT

Hi,

you can have CDHDR, CDPOS tables.

fetch the data from these tables. if there is any change you can directly apply DELETE statement on these tables.

Regards,

venkat