SAP Table T141
Material Status from Materials Management/PPC View
T141 (Material Status from Materials Management/PPC View) 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 T141 to other SAP tables.
T141 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||||||||
|
MMSTA
Material status from MM/PP view
|
MATSTATUS |
CHAR
|
2 | 0 | ||||||||||||||
|
DEINK
Message if material is used in Purchasing
|
DEINK |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DSTLK
Message if Material Is Used in BOM Header
|
DSTLK |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DSTLP
Message if material is used as BOM item
|
DSTLP |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DAPLA
Message if material is used in routing/master recipe
|
DAPLA |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DPBED
Message if independent requirement is created for material
|
DPBED |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DDISP
Message if material is used in MRP
|
DDISP |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DFAPO
Message if Material Used in Production Order or Network Item
|
DFAPO |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DFAKO
Message if material is used in production order header
|
DFAKO |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DINST
Message if material is used in Plant Maintenance
|
DINST |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DBEST
Message if material is used in Inventory Management
|
DBEST |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DPROG
Message if material is used in Forecasting
|
DPROG |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DFHMI
Message if PRT are assigned to routing or order
|
DFHMI |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DQMPF
Message if material is used in QM inspection procedures
|
DQMPF |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DTBED
Message if material used in WM transfer reqmt/posting change
|
DTBED |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DTAUF
Message if material is used in WM transfer order
|
DTAUF |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DERZK
Procedure When Creating Material Cost Estimate
|
CK_DERZK |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DLFPL
Message if material used in long-term planning
|
DLFPL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DLOCK
Indicator: distribution lock
|
DLOCK |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
AUPRF
Profile Name for ALE Change Authorization
|
AUPRF | TPRO |
CHAR
|
10 | 0 | |||||||||||||
|
JSPPP
Locked for Purchase Quantity Planning
|
JSPPP |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
JSPPO
Blocked for PO Generation in Purchase Quantity Planning
|
JSPPO |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
JSPR2P
Locked for Return to Publisher
|
JSPR2P |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
JSPRPO
Locked for Purchase Order Gen. for Return to Publisher
|
JSPRPO |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
T141 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| T141 | AUPRF | T141 | MANDT |
TPRO
Profile Names for ALE Change Authorizations
|
MANDT |
| T141 | AUPRF | 'BUS1001' |
TPRO
Profile Names for ALE Change Authorizations
|
UDDMODL | |
| T141 | AUPRF | T141 | AUPRF |
TPRO
Profile Names for ALE Change Authorizations
|
AUPRF |