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: 

relation between business area and materials

Former Member

‎03-30-2007 12:57 PM

0 Kudos

I have to extract the materials given the business area , can i use these the tables t134g and mbew for that . Both have common field valuation area , t134g has business area and mbew has material number in it. I appreciate your responses.

2 REPLIES 2

Former Member

‎03-30-2007 12:58 PM

0 Kudos

someone mentioned to use mara along with these tables but donno how to use exactly.

Former Member
In response to Former Member

‎03-30-2007 1:07 PM

0 Kudos

Hi Deepthi,

You can directly use MBEW table to retrive Materials for a particelar valuation type. No need to use MARA.

Like this..

Select MATNR from MBEW where BWKEY = 'Put valuation area you want'.

Reward points if helpful.

Regards,

Pankaj Sharma