Report for Goods Receipt

[Former Member]

Hi Gurus, I want to hav create report for Goods receipt which has to show mat description, quantity Received, Date of GR, Rate, vendor name etc. Is there any standard report available? If not which tables I hav 2 use to create querry?

Thanks

[Former Member]

THANKS

[Former Member]

Hi,

Tables Are:-

1) MSEG

2) MKPF

Movement type 101.

T-Code

MB51

Use Movement Type 101.

I hope it Work, if still facing any problem do tell me

[Former Member]

If want to hav vendor name beside vendor code, what to do?

Thanks

[amit_choudhary6]

You'll not get the Vendor Name in MB51, only the number appears. Create a simple ABAP query using MSEG, MKPF and LFA1 (which contains vendor name) tables.

[Former Member]

Hi,

Reports are.

1. MB59 / MB51- Material Document List.

2. ME80FN-General Analysis.

You can try above reports.

Rgds,

Rajesh

[Former Member]

In MB51, you can get the vendor and also the amount of GR.

Change the varient as per your req.

[Former Member]

Hi

Check MB51 Tcode , Tables are MKPF,MSEG

Thanks/Karthik

[Former Member]

U can use Standard report MB51

[Former Member]

But it doesnt sho vendor from which mat is purchase, also rate per quantity is not shown.