Saturday, February 6, 2016

Material


There are materials with different types of Special Stocks.

Special Stock with Customer
Any material which is at customer end will fall under this. The quantities are saved in table MSKU.
SOBKZ = 'W'


Special Stock with Vendor
Materials/ inventory consigned to a vendor. They are saved in MSLB and MSSL.
SOBKZ = 'O'

Related Tcodes 
MB59

Related Notes
Stock Tables and Types : LINK

Datasource
0MATERIAL_ATTR/TEXT             Material Number
0MAT_PLANT_ATTR/TEXT          Material Number with Plant
0MAT_SALES_ATTR/TEXT          Material number with sales
0MAT_ST_LOC_ATTR                   Material Number Compounded to Plant and Storage Location

T-Codes :
MM01/2/3

Tables : 
MARA,MARC,MARD

0MAT_PLANT_ATTR/TEXT
  • This is Plant Data for Material.
  • Base table for this datasource is MARC
  • In MM03, there is tab which says 'Plant Stock'. Most of the fields from this datasource are present there.
  • Delta  : Create date/Change data in MARA table ( I guess ).

0MAT_ST_LOC_ATTR/TEXT
  • This is Storage Location Data for Material.
  • Base table for this datasource is MARD
  • In MM03, there is tab which says 'St.Loc Stock'. Most of the fields from this datasource are present there.
  • Delta  : Create date/Change data in MARA table ( I guess ).
0MAT_SALES_ATTR
  • This is Sales Data for Material. It is company code ( Sales Organization ) level.
  • Base table for this datasource is MVKE.
  • MM03 - Sales Org Tab

No comments:

Post a Comment