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
Showing results for 
Search instead for 
Did you mean: 

Table for total requirement

0 Kudos

Hi,

I have to make 1 report......where i have to display total requirement of a given material and the available stock.

Can anybody provide me with the table name in which i will get te total requirement of the material.

Or is there any other method to get the total requirement against particular material??

1 ACCEPTED SOLUTION

former_member235056
Active Contributor
0 Kudos
4 REPLIES 4

Former Member
0 Kudos

Below is the list of tables related to Material Management

3 MASTER DATA:

3.1 Material master:

MARA Material master

MAKT Material text

MARC Material per plant / stock

MVKE Material master, sales data

MARD Storage location / stock

MSKA Sales order stock

MSPR Project stock

MARM Units of measure

MEAN International article number

PGMI Planning material

PROP Forecast parameters

MAPR Link MARC <=> PROP

MBEW Material valuation

MVER Material consumption

MLGN Material / Warehouse number

MLGT Material / Storage type

MPRP Forecast profiles

MDTB MRP table

MDKP Header data for MRP document

MLAN Tax data material master

MTQSS Material master view: QM

3.1.1 Basic data text (sap script)

STXB SAP script: Texts in non-SAP script format

STXH STXD SAP script text file header

STXL STXD SAP script text file lines

3.1.2 Batches

MCHA Batches

MCH1 Batches

MCHB Stock: batches

3.2 Customer master data

KNA1 Customer master

KNB1 Customer / company

KNVV Customer sales data

KNBK Bank details

KNVH Customer hierarchy

KNVP Customer partners

KNVS Shipment data for customer

KNVK Contact persons

KNVI Customer master tax indicator

3.3 Vendor

LFA1 Vendor master

LFB1 Vendor per company code

LFB5 Vendor dunning data

LFM1 Purchasing organization data

LFM2 Purchasing data

LFBK Bank details

3.4 Customer – material info record

KNMT Customer material info record

3.5 Bank data

BNKA Master bank data

Regards,

Pavan

Former Member
0 Kudos

Hi

Check the Std reports whose Tcode is

MMBE

MB5B

MB53

MD04

CO09

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

Regards

Anji

Former Member
0 Kudos

Use table mara, marc, mchb/ mard..

in mchb, for a particular stock and plants, u will get more than one entries for same material so u have to sum it all......

but, u will get collective data in table mard.

reward if useful

anju

former_member235056
Active Contributor
0 Kudos