Skip to Content
0
Former Member
Feb 11, 2011 at 05:37 AM

CREATING QUERY

52 Views

HI,

SAP EXPERTS,

i want 2 prepare a query

INPUT ARE - MATERIAL NO and PLANT

OUTPUT ARE -MATERIAL ,MATERIAL DESCRIPTION,PLANT STORAGE LOCATION,DESCRIPTION OF STORAGE LOCATION,

BASE UNIT OF MEASURE,QUANTITY IN UNRESTRICTED USE STOCK,QUANTITY IN QUALITY INSPECTION,VENDOR,VENDOR

NAME,DELIVERY NOTE,PURCHASE ORDER NO,MATERIAL DOCUMENT NO.just like mb52 report but some modification are there.

For that i already used table MARD,EKPO,EKBE,MKPF,TOO1L AND LFA1 and MSEG When i joined this its working but vendor no

and vendor

name is not displyed.

please give me some inputs .

Thanks in advance

Regards,

Rahul