SAP ABAP Table MSTA (Material Master Status)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MG (Package) Application development R/3 material master prior to 3.0
Basic Data
Table Category TRANSP    Transparent table 
Transparent table MSTA   Table Relationship Diagram
Short Description Material Master Status    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client *
2 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
3 STATM STATM STATM CHAR 1   0   Maintenance status of material master record T132
4 ZHLER DZHLER CHAR5 CHAR 5   0   Counter  
5 ERSDA ERSDA DATUM DATS 8   0   Created On  
6 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
7 LAEDA LAEDA DATUM DATS 8   0   Date of Last Change  
8 AENAM AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
9 WERKS WERKS_D WERKS CHAR 4   0   Plant MARC
10 LGORT LGORT_D LGORT CHAR 4   0   Storage location MARD
11 LGNUM LGNUM LGNUM CHAR 3   0   Warehouse Number / Warehouse Complex MLGN
12 LGTYP LGTYP LGTYP CHAR 3   0   Storage Type MLGT
13 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
14 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel MVKE
15 BWKEY BWKEY BWKEY CHAR 4   0   Valuation area T001K
16 BWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type MBEW
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 MSTA BWKEY T001K BWKEY REF C CN
2 MSTA BWTAR MBEW BWTAR REF C CN
3 MSTA LGNUM MLGN LGNUM REF C CN
4 MSTA LGORT MARD LGORT REF C CN
5 MSTA LGTYP MLGT LGTYP REF C CN
6 MSTA MATNR MARA MATNR KEY 1 CN
7 MSTA STATM T132 STATM KEY 1 CN
8 MSTA VKORG TVKO VKORG REF C CN
9 MSTA VTWEG MVKE VTWEG REF C CN
10 MSTA WERKS MARC WERKS REF C CN
History
Last changed by/on SAP  20040210 
SAP Release Created in