SAP ABAP Table MOFF (Outstanding Material Master Records)
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 MOFF   Table Relationship Diagram
Short Description Outstanding Material Master Records    
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 STATM STATM STATM CHAR 1   0   Maintenance status of material master record T132
3 ERSDA ERSDA DATUM DATS 8   0   Created On  
4 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
5 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
6 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
7 EKORG EKORG EKORG CHAR 4   0   Purchasing organization T024E
8 BWKEY BWKEY BWKEY CHAR 4   0   Valuation area T001K
9 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
10 LGORT LGORT_D LGORT CHAR 4   0   Storage location T001L
11 LGNUM LGNUM LGNUM CHAR 3   0   Warehouse Number / Warehouse Complex T300
12 LGTYP LGTYP LGTYP CHAR 3   0   Storage Type T301
13 MTART MTART MTART CHAR 4   0   Material type T134
14 MBRSH MBRSH MBRSH CHAR 1   0   Industry sector T137
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 MOFF BWKEY T001K BWKEY KEY 1 CN
2 MOFF EKORG T024E EKORG KEY 1 CN
3 MOFF LGNUM T300 LGNUM KEY 1 CN
4 MOFF LGORT T001L LGORT KEY 1 CN
5 MOFF LGTYP T301 LGTYP KEY 1 CN
6 MOFF MATNR MARA MATNR KEY 1 CN
7 MOFF MBRSH T137 MBRSH REF 1 CN
8 MOFF MTART T134 MTART REF 1 CN
9 MOFF STATM T132 STATM KEY 1 CN
10 MOFF VKORG TVKO VKORG KEY 1 CN
11 MOFF VTWEG TVTW VTWEG KEY 1 CN
12 MOFF WERKS T001W WERKS KEY 1 CN
History
Last changed by/on SAP  20020219 
SAP Release Created in