Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Material Price and Cost Report

Former Member

‎2006 May 09 8:21 AM

0 Kudos
486

Hi Friends,

I have

EKKO ( Purchasing Document Header )

EKPO ( Purchasing Document Item )

EINA ( Purchasing Info Record - General Data )

A017 ( Material Info Record ) Tables

Now i want to fetch

STPRAS ( Standard Price )

PEINH ( Price Unit )

fields from MBEW ( Material Valuation ) Table

Can any one tell me How to Link MBEW Table from the above Tables ?

Points for Sure......

Regards

Srini

3 REPLIES 3

Former Member

‎2006 May 09 8:33 AM

0 Kudos
139

from ekpo u ll get the materials(matnr), valuation type and plant.. u can use this to link mbew n get the details.

Hope it helps.

Regards..

Former Member

‎2006 May 09 8:35 AM

0 Kudos
139

HI

GOOD

YOU CAN JOINING ALL THE TABLE USING THE QUERY INNER JOIN HAVING COMMON FIELD MANDT.

THANKS

MRUTYUN

Former Member

‎2006 May 09 8:45 AM

0 Kudos
139

Hi,

In order to MAP each record of EKPO to MBEW you have to pass 'MATNR' of EKPO to 'MATNR' of MBEW, pass 'WERKS' of EKPO to 'BWKEY' of MBEW and 'BWTAR' of EKPO to 'BWTAR' of MBEW.