topic Re: DDIC table doubt in Application Development and Automation Discussions

DDIC table doubt

Former Member — Fri, 14 Nov 2008 10:15:31 GMT

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

Re: DDIC table doubt

JozsefSzikszai — Fri, 14 Nov 2008 10:23:10 GMT

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)

Re: DDIC table doubt

arjun_subhash — Fri, 14 Nov 2008 10:26:08 GMT

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

Re: DDIC table doubt

Former Member — Fri, 14 Nov 2008 11:58:07 GMT

thanks Eric.