Po report

[Former Member]

Hi

i want to prepare custom report for the following details. please provide me related tables and logic to fetch data from tables. it is urgent please

Report for Purchase Details:

Input Parameters:

**Plant: - -

---

to -

---

(Multiple options)

Storage Loc - -

---

to -

---

(Multiple options)

Vendor - -

---

to -

---

(Multiple options)

**GRN Date - -

---

to -

---

(Multiple options)

Material Type - -

---

to -

---

(Multiple options)

• - Mandatory &

Sto.Loc, Material Type & Vendor – should give any one input

- Detail Report – Line item wise

Display Option:

- ALV Output

- List Output

Required Output:

GR No.

GR Date

Material code

Material description

GR Qty

GR Value

PO No. & Line item.

Vendor code

Vendor Name

Plant

Storage Loc.

Valuation class

MRP controller

Wt. of Mateial (as per GR)

Mvt. Type

Reference (DC No.)

Report Logic:

It should consider 101, 102 & 122 Mvt. made against Purchase orders(Std, FP & SC POs) and the outcome (Purchase value) will be net of these values.

Ensure only labour charges are considered for s/c receipts

Other Details:

[Former Member]

MSEG ; GR ITEM

MKPF , GR ITEM HEADER

MARA , MATERIAL

MBEW : MATERIAL VAL. CLASS.

LFA1 ; VENDOR MASTER