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: 

ITEM FIELDS RELATED TO MATNR

Former Member

‎2007 Jul 12 10:03 AM

0 Kudos
487

Hi folks,

Could anyone please suggest any tables to retreive the ESTIMATED NR, ACTUAL COST, ACTUAL NR, ESTIMATED ANUAL SALES.

FOR A GIVEN MATERIAL NUMBER

THANKS IN ADVANCE

2 REPLIES 2

Former Member

‎2007 Jul 12 10:04 AM

0 Kudos
127

Hello,

Check the tables <b>MSEG</b> and <b>MKPF</b>

Please reward if found helpfull.

Regards,

Rakesh.

Former Member

‎2007 Jul 12 10:09 AM

0 Kudos
127

Hi

You have to search in the related tables

Take the Material No MATNR and pass to the respective Item Tables like VBAP,VBRP etc

Estimated Annual Sales : Find from VBAk and VBAP tables

Actual Net revenue, Estimated NR : use VBRk, VBRP tables and BSID and BSAD tables

Actaul Cost from the table: MBEW and MVKE table

Use <b>MVKE</b> table for the related Sales data

<b>Reward points for useful Answers</b>

Regards

Anji