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
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