DDIC table doubt

[Former Member]

Hi,

I have created a Material with discription ' Cup ' it store in Maktx of makt.

now second time i change its description ' Blue 1 liter Cup' .

1) My Qtion is can i get my old value of material i.e only ' Cup' is it possible . if yes Then how ?

2) What happen in DDIC when we change or delete any material or record ?

3) How should i know that data has been changed ?

Jim

[JozsefSzikszai]

1. You can get the changes from CDHDR and CDPOS tables

2. you cannot really delete in SAP, usually the objects will only be marked as deleted (in case of materials, the field mara-lvorm will be set to 'X'), in case of changes the value of the field is overwritten, the old value will be stored in the tables in Answer 1.

3. pls. refer to Answer 1. (if there are entries in the above tables, it means, the data was changed in the past)

[arjun_subhash]

I think u can get it when 'LOG DATA CHANGES' is checked.

You can see it in DDIC, techinical settings of table.There is a checkbox names 'log data changes'.

thanks nd regards

Arjun

Edited by: Arjun Subhash on Nov 14, 2008 11:26 AM

[Former Member]

thanks Eric.