SAP Table
T141 Material Status from Materials Management/PPC View
SAP table T141 has 2 primary key fields being MANDT,MMSTA.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
T141 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | MANDT | ||||||||||||
| KeyMMSTA | Material status from MM/PP view | CHAR | 2 | 0 | MATSTATUS | ||||||||||||
| DEINK | Message if material is used in Purchasing | CHAR | 1 | 0 | DEINK | ||||||||||||
| DSTLK | Message if Material Is Used in BOM Header | CHAR | 1 | 0 | DSTLK | ||||||||||||
| DSTLP | Message if material is used as BOM item | CHAR | 1 | 0 | DSTLP | ||||||||||||
| DAPLA | Message if material is used in routing/master recipe | CHAR | 1 | 0 | DAPLA | ||||||||||||
| DPBED | Message if independent requirement is created for material | CHAR | 1 | 0 | DPBED | ||||||||||||
| DDISP | Message if material is used in MRP | CHAR | 1 | 0 | DDISP | ||||||||||||
| DFAPO | Message if Material Used in Production Order or Network Item | CHAR | 1 | 0 | DFAPO | ||||||||||||
| DFAKO | Message if material is used in production order header | CHAR | 1 | 0 | DFAKO | ||||||||||||
| DINST | Message if material is used in Plant Maintenance | CHAR | 1 | 0 | DINST | ||||||||||||
| DBEST | Message if material is used in Inventory Management | CHAR | 1 | 0 | DBEST | ||||||||||||
| DPROG | Message if material is used in Forecasting | CHAR | 1 | 0 | DPROG | ||||||||||||
| DFHMI | Message if PRT are assigned to routing or order | CHAR | 1 | 0 | DFHMI | ||||||||||||
| DQMPF | Message if material is used in QM inspection procedures | CHAR | 1 | 0 | DQMPF | ||||||||||||
| DTBED | Message if material used in WM transfer reqmt/posting change | CHAR | 1 | 0 | DTBED | ||||||||||||
| DTAUF | Message if material is used in WM transfer order | CHAR | 1 | 0 | DTAUF | ||||||||||||
| DERZK | Procedure When Creating Material Cost Estimate | CHAR | 1 | 0 | CK_DERZK | ||||||||||||
|
|||||||||||||||||
| DLFPL | Message if material used in long-term planning | CHAR | 1 | 0 | DLFPL | ||||||||||||
| DLOCK | Indicator: distribution lock | CHAR | 1 | 0 | DLOCK | ||||||||||||
| AUPRF | Profile Name for ALE Change Authorization | CHAR | 10 | 0 | TPRO | AUPRF | |||||||||||