cancel
Showing results for 
Search instead for 
Did you mean: 

ABAP QUERY

Former Member
0 Kudos

I Need a report that shows purchase order price differences compared to the material master standard cost. Report should be modeled off of ABAP Query in the Inv_Acctg user group; query titled PO_VS_STDCST.

Report should display results only where EKPO-PEINH (Price unit) <> MBEW-STPRS(Standard Price).

Report should display:

Purchase order #, Doc Date, Material, Material Desc, Plant, PO Quantity, UOM, Price Unit, Price, Material Valuation Area, Standard Price

Accepted Solutions (1)

Accepted Solutions (1)

Ramki
Active Contributor
0 Kudos

Hello Manjula

You seem to be knowing everything required for this report.

Try to create an ABAP query or create an ABAP report.

Most of your info is in tables. EKPO, EKKO, MBEW. Join these tables and get the report you wanted in Abap query (SQVI)

Best regards

Ramki

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Manjula,

Just adding to Ramki's suggestion,

Purchase order #, Doc Date, -> EKKO

Material,Plant, PO Quantity, UOM, Price Unit, Price -> EKPO

Material Desc -> MAKT

Standard Price - > MBEW / MBEWH

Material Valuation Area -> Material valuation area is nothing but plant or company code (check the OX14 transaction code)

Hope this helps.

Regards

Arif Mansuri