Detect change in table

[Former Member]

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

[Former Member]

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

[former_member188829]

Hi,

Check CDHDR and CDPOS Tables

[Former Member]

>

> 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.

[RahulKeshav]

hi KT,

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

thnx

Rohit

[Former Member]

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

[RaymondGiuseppi]

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

[RahulKeshav]

hi kartik tarla

any update

[Subhankar]

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[].

[Former Member]

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