Production Report

[Former Member]

Hi SAP Buddies

Please can u tell me how to get a report with below paramaters

Material No. Date. Del. Schedule/Planned Qty, Production qty. Dispatched Qty.

I want to get this report by using two or three standard T code. is there any option available for this

Please help

Thanks in advance

Regards

Brijesh Verma

[MarcinPciak]

Hi,

Use SAP Query ( t-code SQ01 ). You can create quite complicated reports there just by dragging required fields and setting your requirements.

Regards

Marcin

[Former Member]

Hi,

you will get the data for production in AFRU table. and afpo table for material.

you can use the following code.

select aufnr

budat

ism01

ile01

gmnga

lmnga

meinh

gmein

ism05

ile06

werks

stokz

stzhl

wablnr

rueck

rmzhl

into corresponding fields of table it_afru

from afru

where budat in full_date "so_date

and werks in so_plant.

AND stokz NE 'X'

and stzhl Eq 0.

"----

---

For Material Number -

---

select aufnr

matnr

verid

umrez

pwerk

dwerk from afpo into corresponding fields of table it_afpo

for all entries in it_afru

where aufnr = it_afru-aufnr

and matnr in so_matnr.

and get it in one table accordeing to your requirement

Thanks & Regards