Reports

[Former Member]

Hi,

How to develop a vendor master analysis report , which lists the material including material number and storage location, also give me the tables we can use

[Former Member]

Hi

There are some standard reports for the same

Please check the following threads

https://forums.sdn.sap.com/click.jspa?searchID=221621&messageID=2381453

https://forums.sdn.sap.com/click.jspa?searchID=221621&messageID=2381767

Hope this helps you

[Former Member]

Hi,

Use LGORT,MATNR,LIFNR from MARA joining LFA1.

If useful pl reward.

Cheers.

[Former Member]

Sorry not from mara, from MSEG!!

[Former Member]

plz send me tables names and there fields

[Former Member]

Here we go:

DATA: BEGIN OF itab occurs 0 ,

lifnr LIKE lfa1-lifnr,

matnr LIKE mseg-matnr,

lgort LIKE mseg-lgort,

END OF itab .

Select lifnr matnr lgort

into table itab

where lifnr in s_lifnr AND

matnr in s_matnr.

Note : Pass lifnr and matnr In selection option .

[Former Member]

Hi,

You can also find the material number and the storage locaiton in Table EKPB

Filed names:

MATNR Material number

LGORT Storage location

Regards

Yamini

[Former Member]

thank u

[graghavendra_sharma]

Hi Sudheer,

If you don't mind, can you please award if the answer satisfies you!!

Regards

Raghav