cancel
Showing results for 
Search instead for 
Did you mean: 

purchase value report

Former Member
0 Kudos

please tell me how to start. i want to know from which table to start for the following requirement.

please tell all the steps. starting table and end table.

Report for Purchase Details:

Input Parameters:

**Plant: - -


to -


(Multiple options)

Storage Loc - -


to -


(Multiple options)

Vendor - -


to -


(Multiple options)

**GR Date - -


to -


(Multiple options)

Material Type - -


to -


(Multiple options)

    • - Mandatory &

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

Output Option:

- Summary of Purchase in Rs. (Storage loc. wise)

- Summary of Purchase in Rs. (Valuation Class wise)

- 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:

It should take the weight of ROH (castings) from GR

Authorization to be given to all MRP, FIFO & Audit user

Report can be executed in Background also.

Accepted Solutions (0)

Answers (1)

Answers (1)

rwarri1
Active Contributor
0 Kudos

Hello,

Looks like you need to develop a custom rep[ort. Have you tried MB51 which could meet many of your requirements.

Cheers !

Former Member
0 Kudos

no mb51 will not meet my requirement. ineed based on mRP controller

csaba_szommer
Active Contributor
0 Kudos

Hi sun,

EKET - EKPO - EKKO is not good for your query?

BR

Csaba

(purchasing table connections: http://www.erpgenie.com/abap/tables_mm.htm#Purchasing%20Tables)

Former Member
0 Kudos

How about EKBE-EKKO-EKPO. please can you tell me how to start it. please write me some steps how to pick date from which table etc.

csaba_szommer
Active Contributor
0 Kudos

Hi sun,

You can connect the tables using the following fields:

(MSEG contains info on the GR)

EKET - EKPO (fields: EBELN, EBELP)

EKPO - EKKO (fields: EBELN)

MSEG - EKPO (fields: EBELN, EBELP)

If you examine a purchasing document (ME23N), or the material movements (in MB51, that contains table: MSEG) you can use F1 + technical information to get the name of the desired fireld.

BR

Csaba

Former Member
0 Kudos

mseg table price is inclusive of delivery cost so i want to take from EKBE table. ekbe value contains without delivery cost.

i know how to join and which table to consider. but i dont know from which table i have to strat writing logic.

my requirement is as follows.

REPORT FOR PURCHASE DETAILS:

Input Parameters:

** Plant -to-(Multiple Options)

Material -to-(Multiple Options)

Storage Location -to-(Multiple Options)

Material group -to-(Multiple Options)

Material Type -to-(Multiple Options)

Purchse group -to-(Multiple Options)

MRP Controller -to-(Multiple Options)

PO Type -to-(Multiple Options)

Vendor -to-(Multiple Options)

** GR Date -to-(Multiple Options)

**- Mandatory

Output Option:

-Summary of purchase in Rs. (Storage loc. wise)

-Summary of purchase in Rs. (Valuation class wise)

-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 material (as per GR)

MVT.Type

Reference (DC.NO.)

It should consider 101, 102 and 122 MVT. made against purchse orders(Std, FP &SC POs(SCFX,SCEF and sch agreement))

and the outcome (purchase value) will be net of these values. ensure only labour charges are considered for S/C receipts.

Other Details:

It should take the weight of ROh (castings) from GR

Authorization to be given to all MRP, FIFO & audit user

Report can be executed in background also.