Which field to refer?

[Former Member]

HI!

There is a task tat,

" BASED ON MATNR IN WHICH STORAGE LOCATIONS THIS MATERIAL IS THEIR,THEN PICK UP THE STORAGE LOCATIONS WHERE THE QUANTITY IS 0. THEN ALL THOSE STORAGE LOCATIONS WILL BE DELETED USING MMO06' to which fields i have to refer in MARA n MARD

Give some idea,Please

Thank you,

Divi

[former_member208856]

Hi,

In Table MARD

field MATNR is Material Number

LGORT is Storage Location

LABST is Valuated stock with unrestricted use

use these fields,

Reward points, if helpful

sandeep kaushik

[Former Member]

Hi

Use MARD table

MATNR - Material No

WERKS -Plant

LGORT - Storage Location

LABST - Stock field

write a select for these fields into a Int table ITAB.

<b>Select matnr werks lgort labst into table ITAb where matnr in s_matnr.

sort itab by matnr werks lgort.

delete itab where labst = 0.</b>

<b>Reward points for useful Answers</b>

Regards

Anji

[Former Member]

yeah i got the answer, for checking the stock quantity we have to use all the fields which r having datatype as Quantity.