T141 SAP (Material Status from Materials Management/PPC View) Table details

Dictionary Type: Table
Description: Material Status from Materials Management/PPC View




ABAP Code to SELECT data from T141
Related tables to T141
Access table T141




Table field list including key, data, relationships and ABAP select examples

T141 is a standard SAP Table which is used to store Material Status from Materials Management/PPC View data and is available within R/3 SAP systems depending on the version and release level.

The T141 table consists of various fields, each holding specific information or linking keys about Material Status from Materials Management/PPC View data available in SAP. These include MMSTA (Material status from MM/PP view), DEINK (Message if material is used in Purchasing), DSTLK (Message if Material Is Used in BOM Header), DSTLP (Message if material is used as BOM item).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)

Text table = T141T


SAP T141 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
MMSTAMaterial status from MM/PP view MATSTATUSCHAR2MMSTA
DEINKMessage if material is used in Purchasing DEINKCHAR1FEDIA
DSTLKMessage if Material Is Used in BOM Header DSTLKCHAR1FEDIA
DSTLPMessage if material is used as BOM item DSTLPCHAR1FEDIA
DAPLAMessage if material is used in routing/master recipe DAPLACHAR1FEDIA
DPBEDMessage if independent requirement is created for material DPBEDCHAR1FEDIA
DDISPMessage if material is used in MRP DDISPCHAR1FEDIA
DFAPOMessage if Material Used in Production Order or Network Item DFAPOCHAR1FEDIA
DFAKOMessage if material is used in production order header DFAKOCHAR1FEDIA
DINSTMessage if material is used in Plant Maintenance DINSTCHAR1FEDIA
DBESTMessage if material is used in Inventory Management DBESTCHAR1FEDIA
DPROGMessage if material is used in Forecasting DPROGCHAR1FEDIA
DFHMIMessage if PRT are assigned to routing or order DFHMICHAR1FEDIA
DQMPFMessage if material is used in QM inspection procedures DQMPFCHAR1FEDIA
DTBEDMessage if material used in WM transfer reqmt/posting change DTBEDCHAR1FEDIA
DTAUFMessage if material is used in WM transfer order DTAUFCHAR1FEDIA
DERZKProcedure When Creating Material Cost Estimate CK_DERZKCHAR1CK_DERZK
DLFPLMessage if material used in long-term planning DLFPLCHAR1FEDIA
DLOCKIndicator: distribution lock DLOCKCHAR1XFELD
AUPRFProfile Name for ALE Change Authorization AUPRFCHAR10TPROCHAR10
.INCLU--AP 0
JSPPPLocked for Purchase Quantity Planning JSPPPCHAR1FEDIA
JSPPOBlocked for PO Generation in Purchase Quantity Planning JSPPOCHAR1FEDIA
JSPR2PLocked for Return to Publisher JSPR2PCHAR1FEDIA
JSPRPOLocked for Purchase Order Gen. for Return to Publisher JSPRPOCHAR1FEDIA

Key field Non-key field



How do I retrieve data from SAP table T141 using ABAP code

The following ABAP code Example will allow you to do a basic selection on T141 to SELECT all data from the table
DATA: WA_T141 TYPE T141.

SELECT SINGLE *
FROM T141
INTO CORRESPONDING FIELDS OF WA_T141
WHERE...

How to access SAP table T141

Within an ECC or HANA version of SAP you can also view further information about T141 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!