SAP Table MOFF
Outstanding Material Master Records
MOFF (Outstanding Material Master Records) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MOFF to other SAP tables.
MOFF table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||
| STATM | Maintenance status of material master record | STATM | T132 | CHAR | 1 | 0 | ||
| ERSDA | Created On | ERSDA | DATS | 8 | 0 | |||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||
| EKORG | Purchasing Organization | EKORG | T024E | CHAR | 4 | 0 | ||
| BWKEY | Valuation Area | BWKEY | T001K | CHAR | 4 | 0 | ||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
| LGORT | Storage Location | LGORT_D | T001L | CHAR | 4 | 0 | ||
| LGNUM | Warehouse Number / Warehouse Complex | LGNUM | T300 | CHAR | 3 | 0 | ||
| LGTYP | Storage Type | LGTYP | T301 | CHAR | 3 | 0 | ||
| MTART | Material Type | MTART | T134 | CHAR | 4 | 0 | ||
| MBRSH | Industry sector | MBRSH | T137 | CHAR | 1 | 0 | ||
MOFF foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MOFF | BWKEY | MOFF | MANDT | T001K | Valuation area | MANDT |
| MOFF | BWKEY | MOFF | BWKEY | T001K | Valuation area | BWKEY |
| MOFF | EKORG | MOFF | MANDT | T024E | Purchasing Organizations | MANDT |
| MOFF | EKORG | MOFF | EKORG | T024E | Purchasing Organizations | EKORG |
| MOFF | LGNUM | MOFF | LGNUM | T300 | WM Warehouse Numbers | LGNUM |
| MOFF | LGNUM | MOFF | MANDT | T300 | WM Warehouse Numbers | MANDT |
| MOFF | LGORT | MOFF | MANDT | T001L | Storage Locations | MANDT |
| MOFF | LGORT | MOFF | WERKS | T001L | Storage Locations | WERKS |
| MOFF | LGORT | MOFF | LGORT | T001L | Storage Locations | LGORT |
| MOFF | LGTYP | MOFF | MANDT | T301 | WM Storage Types | MANDT |
| MOFF | LGTYP | MOFF | LGNUM | T301 | WM Storage Types | LGNUM |
| MOFF | LGTYP | MOFF | LGTYP | T301 | WM Storage Types | LGTYP |
| MOFF | MATNR | MOFF | MANDT | MARA | General Material Data | MANDT |
| MOFF | MATNR | MOFF | MATNR | MARA | General Material Data | MATNR |
| MOFF | MBRSH | MOFF | MANDT | T137 | Industries for materials | MANDT |
| MOFF | MBRSH | MOFF | MBRSH | T137 | Industries for materials | MBRSH |
| MOFF | MTART | MOFF | MANDT | T134 | Material Types | MANDT |
| MOFF | MTART | MOFF | MTART | T134 | Material Types | MTART |
| MOFF | STATM | MOFF | STATM | T132 | Status definition | STATM |
| MOFF | STATM | MOFF | MANDT | T132 | Status definition | MANDT |
| MOFF | VKORG | MOFF | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| MOFF | VKORG | MOFF | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| MOFF | VTWEG | MOFF | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| MOFF | VTWEG | MOFF | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| MOFF | WERKS | MOFF | MANDT | T001W | Plants/Branches | MANDT |
| MOFF | WERKS | MOFF | WERKS | T001W | Plants/Branches | WERKS |
