topic Reading deleted material from change pointer table... in Application Development and Automation Discussions

Reading deleted material from change pointer table...

Former Member — Mon, 17 Apr 2006 18:24:36 GMT

hello everyone,

I am loading deltas using change pointer tables. Now although material is deleted, it is still marked as 'U' in the cdhdr table.

I am reading the changes and then selecting my material data from those changes.

LVORM is the flag for deletion, but how do I write my SELECT statement so that the material data in my change pointer table is selected and then from this data I select materials marked for deletion.

Thanks in advance.

Regards,

Fred.

Re: Reading deleted material from change pointer table...

Former Member — Mon, 17 Apr 2006 18:35:42 GMT

Fred,

Although you are deleting the material, from a change pointer perspective the value of the field LVORM is being changed from SPACE to 'X'.

So, read the change the pointer table for LVORM field where the old value is initial and new value is 'X'.

From there you can read the material data.

Regards,

Ravi

Note : Please mark the helpful answers

Re: Reading deleted material from change pointer table...

Former Member — Mon, 17 Apr 2006 18:39:46 GMT

Ravikumar,

I think when you are talking about old value and new value, you are referring to cdpos. I am not reading changes at cdpos level, I am reading them at cdhdr level.

Am I right?

Regards,

Fred.

Re: Reading deleted material from change pointer table...

Former Member — Mon, 17 Apr 2006 18:40:38 GMT

Hi Fred,

select *
       from CDHDR
       into table IT_DELETE
       where OBJECTCLAS = 'MATERIAL'
        and  CHANGE_IND = 'D'.

D for deletion.

Regards

vijay

Re: Reading deleted material from change pointer table...

Former Member — Mon, 17 Apr 2006 18:45:40 GMT

Fred,

If you are not referring to CDPOS how would you know if the the material is being DELETED or UNDELETED.

Else you will have to look at MATERIAL class level and NOT at LVORM level

Regards,

Ravi

Note : Please mark all the helpful answers

Re: Reading deleted material from change pointer table...

Former Member — Mon, 17 Apr 2006 19:47:42 GMT

Hi,

I am little bit confused about your reference to CDHDR & CDPOS tables as change pointer tables. The actual change pointer table is BDCP and CDHDR & CDPOS are called Change document tables.

Could you please give more details on how you loading delta..

1. Are you using ALE Master data distribution to load your Delta changes?

2. What is actual requirement? Are trying to send only the items (Materials) that are marked for deletion or send only that are not marked for deletion?

If your answer is YES & YES, you can simply use the filtering in ALE and let the RBDMIDOC program generate the IDocs for delta changes using BDCP. (you need to activate the change pointers for material master in this case).

Regards,

Nagaraju Chidurupalli

Re: Reading deleted material from change pointer table...

Former Member — Mon, 17 Apr 2006 20:32:26 GMT

Hi,

I have the following:

select mara_{matnr marc}matnr

from mara

join marc on marc_{matnr = mara}matnr

into table matl_del

FOR ALL ENTRIES IN i_updtd_materials

where mara~matnr = i_updtd_materials-matnr

and mara~lvorm = 'X'

and marc~lvorm = 'X'.

'i_updtd_materials' is my table that holds all changed materials, meaing deltas.

In my deleted table, I want the materials that have been deleted at client and plant level, meaning mara and marc.

Is it the right way to do it?

Regards,

Fred.

Re: Reading deleted material from change pointer table...

Former Member — Mon, 17 Apr 2006 21:51:24 GMT

can anyone help out here please?

Re: Reading deleted material from change pointer table...

Former Member — Mon, 17 Apr 2006 22:18:12 GMT

Hi,

Wanted to add some changes to my issue. I want to select material that is deleted at Client level, Plant level or Storage location level.

Thanx in advance.

Regards,

Fred.

Re: Reading deleted material from change pointer table...

Former Member — Tue, 18 Apr 2006 03:40:38 GMT

Fred,

I guess what you are doing is right.

MARA will give the deletion indicator at client level and MARC at the plant level and I guess storage locations is also in MARC (I am not sure though).

regards,

Ravi

Note : Please mark the helpful answers

Re: Reading deleted material from change pointer table...

Former Member — Tue, 18 Apr 2006 12:51:28 GMT

I understand that your requirement is to display all the materials which are marked for deletion at any of the three levels i.e. Global, Plant & Storage location level.

If that is the case you can use the following code..

data: Begin of Matl_del occurs 0,

matnr like mara-matnr,

werks like marc-werks,

LGORT like mard-LGORT,

Flag_mara(1),

flag_marc(1),

flag_mard(1),

End of matl_del.

Loop at i_updtd_materials.

select single matnr LVORM

from mara

into (Matl_del-matnr, matl_del-flag_mara)

where matnr eq i_updtd_materials-matnr

AND LVORM EQ 'X'.

if sy-subrc eq 0.

APPEND MATL_DEL.

CLEAR matl_del-flag_mara.

endif.

select werks LVORM

from marc

into (Matl_del-werks, matl_del-flag_marc)

where matnr eq i_updtd_materials-matnr.

IF matl_del-flag_marc EQ 'X'.

APPEND MATL_DEL.

CLEAR matl_del-flag_marc.

ENDIF.

select lgort LVORM

from mard

into (Matl_del-lgort, matl_del-flag_mard)

where matnr eq i_updtd_materials-matnr.

and werks eq matl_del-werks

and lvorm eq 'X'.

APPEND MATL_DEL.

endselect.

Endloop.

at this time you will have your MATL_DEL filled with all the deleted levels of your materials in your delta table.

Hope this helps.

Regards,

Nagaraju Chidurupalli