topic Re: Reports in Application Development and Automation Discussions

Reports

Former Member — Wed, 29 Nov 2006 11:58:10 GMT

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

Re: Reports

Former Member — Wed, 29 Nov 2006 12:02:20 GMT

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

Re: Reports

Former Member — Wed, 29 Nov 2006 12:02:44 GMT

Hi,

Use LGORT,MATNR,LIFNR from MARA joining LFA1.

If useful pl reward.

Cheers.

Re: Reports

Former Member — Wed, 29 Nov 2006 12:03:39 GMT

Sorry not from mara, from MSEG!!

Re: Reports

Former Member — Wed, 29 Nov 2006 12:16:01 GMT

plz send me tables names and there fields

Re: Reports

Former Member — Wed, 29 Nov 2006 12:24:24 GMT

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 .

Re: Reports

Former Member — Wed, 29 Nov 2006 12:39:55 GMT

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

Re: Reports

Former Member — Fri, 01 Dec 2006 07:59:06 GMT

thank u

Re: Reports

graghavendra_sharma — Fri, 01 Dec 2006 10:20:50 GMT

Hi Sudheer,

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

Regards

Raghav