Material status field

[Former Member]

Xperts...

i am searching for the field Material status...

in which table can i get the same...

Regards,

Anoop.

[Former Member]

Hi Anoop,

In APO, the material status field is stored under the field "LVORM".

1) This field is being used in the following tables in APO.

/SAPAPO/H_MATTXT

/SAPAPO/VSNP4MLS

/SAPAPO/V_MAT2

/SAPAPO/V_MAT3

/SAPAPO/V_MAT4

/SAPAPO/V_MAT5

/SAPAPO/MATKEY

/SAPAPO/MATLOC

/SAPAPO/V_MATMAP

/SAPAPO/V_MATTXT

/SAPAPO/V_SNP4TM

/SCWM/H_MATBAT

2) This field is also used in the below function module

/SAPAPO/DM_MATERIAL_SET_LVORM

3) This field is used under the following programs.

/SAPAPO/LDM_MATERIALF0

/SAPAPO/LDM_MATERIALU4

/SAPAPO/LDM_PEGAREAU06

/SAPAPO/LMAT_MASTERF01

/SAPAPO/LMAT_MASTERF03

/SAPAPO/LMAT_MASTERFD0

/SAPAPO/LMAT_MASTERO01

/SAPAPO/LMDRP_GETU01

/SAPAPO/LSCC_DETAILSU3

/SAPAPO/RMSDPDEP

Hope this will resolve your query. Please confirm.

Regards

R. Senthil Mareeswaran.

[Former Member]

Hi Anoop,

Refer table /SAPAPO/MATINFO there is a field Obsolete material. If you put the Value as "X" then it should give list of all obsolete materials, but I am not sure if you are maintaing this anywhere in APO.

Also there is the table /SAPAPO/MATKEY or /SAPAPO/MATLOC where you can see the list of materials that are marked for deletion "X". These materials can then be manually deleted from APO.

See if this can be of any help to you.

Thanks,

Harsh

[Former Member]

hi! annop

As such there is no table in APO which has a this field but i found one material master communication structure which contains this field

Structure /SAPAPO/MTCOM

Hope this helps you

regards

vaibhav sareen

[Former Member]

Hi,

The Table name (X-Plant status) is 'MARA' and the field is 'MSTAE' and field name for X-Distribution chnl is 'MSTAV' and Plant-Specific Material Status, table is 'MARC' and field is 'MMSTA'.

Thanks,

Satyajit

[Former Member]

Hi,

I m searching the field in APO ....

i want to find the obselete products in APO...

Regards,

Anoop

[Former Member]

Anoop,

I am not sure about Material status field in APO. Actually the mat. stats is used as a criteria in IM to select the material to be sent to APO. You can do one thing recreate and regenerate your IM for product with one more selection criteria ' materialStatus'.

So, in APO you can get only those material which you want.

Thanks,

Satyajit