SAP table T141 (Material Status from Materials Management/PPC View)
SAP table T141 has 2 primary key fields being MANDT,MMSTA.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | MANDT | ||||||||||||
| MMSTA | 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 |
T141 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T141 | AUPRF | TPRO | Profile Names for ALE Change Authorizations | MANDT |
| 0 T141 | AUPRF | TPRO | Profile Names for ALE Change Authorizations | AUPRF |