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
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
NULL No message
A Warning
B Error message
DSTLK Message if Material Is Used in BOM Header DSTLK CHAR 1 0
NULL No message
A Warning
B Error message
DSTLP Message if material is used as BOM item DSTLP CHAR 1 0
NULL No message
A Warning
B Error message
DAPLA Message if material is used in routing/master recipe DAPLA CHAR 1 0
NULL No message
A Warning
B Error message
DPBED Message if independent requirement is created for material DPBED CHAR 1 0
NULL No message
A Warning
B Error message
DDISP Message if material is used in MRP DDISP CHAR 1 0
NULL No message
A Warning
B Error message
DFAPO Message if Material Used in Production Order or Network Item DFAPO CHAR 1 0
NULL No message
A Warning
B Error message
DFAKO Message if material is used in production order header DFAKO CHAR 1 0
NULL No message
A Warning
B Error message
DINST Message if material is used in Plant Maintenance DINST CHAR 1 0
NULL No message
A Warning
B Error message
DBEST Message if material is used in Inventory Management DBEST CHAR 1 0
NULL No message
A Warning
B Error message
DPROG Message if material is used in Forecasting DPROG CHAR 1 0
NULL No message
A Warning
B Error message
DFHMI Message if PRT are assigned to routing or order DFHMI CHAR 1 0
NULL No message
A Warning
B Error message
DQMPF Message if material is used in QM inspection procedures DQMPF CHAR 1 0
NULL No message
A Warning
B Error message
DTBED Message if material used in WM transfer reqmt/posting change DTBED CHAR 1 0
NULL No message
A Warning
B Error message
DTAUF Message if material is used in WM transfer order DTAUF CHAR 1 0
NULL No message
A Warning
B Error message
DERZK Procedure When Creating Material Cost Estimate CK_DERZK CHAR 1 0
NULL Cost Material
A Cost Material; Issue Warning if Material Component
B Cost Material; Issue Error if Material Component
C Do Not Cost Material; Issue Warning if Material Component
D Do Not Cost Material; Issue Error if Material Component
DLFPL Message if material used in long-term planning DLFPL CHAR 1 0
NULL No message
A Warning
B Error message
DLOCK Indicator: distribution lock DLOCK CHAR 1 0
X Yes
NULL No
AUPRF Profile Name for ALE Change Authorization AUPRF TPRO CHAR 10 0
JSPPP Locked for Purchase Quantity Planning JSPPP CHAR 1 0
NULL No message
A Warning
B Error message
JSPPO Blocked for PO Generation in Purchase Quantity Planning JSPPO CHAR 1 0
NULL No message
A Warning
B Error message
JSPR2P Locked for Return to Publisher JSPR2P CHAR 1 0
NULL No message
A Warning
B Error message
JSPRPO Locked for Purchase Order Gen. for Return to Publisher JSPRPO CHAR 1 0
NULL No message
A Warning
B Error message

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