T141

Transparent Table Customizing Table
21 Fields 5 CDS Views

Material Status from Materials Management/PPC View

T141 is an SAP database table in S/4HANA. Material Status from Materials Management/PPC View. It contains 21 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_DDProductStatusCode view_entity from BASIC DD Product Status Code
I_MRPMaterialStatusCode view from BASIC MRP Material Status Code
I_ProductProfileCode view_entity from BASIC Product Profile Code
I_ProductStatus view from BASIC Cross-Plant Product Status
Pir_Read_Aor_Heads view left_outer Read Header data in your area of responsibility

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY mmsta MATSTATUS Material Status
deink DEINK Purchasing msg.
dstlk DSTLK BOM header msg.
dstlp DSTLP BOM item msg.
dapla DAPLA R/R message
dpbed DPBED Ind. reqmt msg.
ddisp DDISP MRP message
dfapo DFAPO PO/network msg.
dfako DFAKO PO header msg.
dinst DINST PM message
dbest DBEST Inv. mgmt msg.
dprog DPROG Forecasting msg
dfhmi DFHMI PRT message
dqmpf DQMPF QM insp. msg.
dtbed DTBED TReqmt msg.
dtauf DTAUF TOrder message
derzk CK_DERZK MatCostEst Procedure
dlfpl DLFPL LT planning msg
dlock DLOCK Distr. Lock
auprf AUPRF Profile Name

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Material Status from Materials Management/PPC View
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T141 (
    MANDT,  -- Client [MANDT]
    MMSTA,  -- Material Status [MATSTATUS]
    DEINK,  -- Purchasing msg. [DEINK]
    DSTLK,  -- BOM header msg. [DSTLK]
    DSTLP,  -- BOM item msg. [DSTLP]
    DAPLA,  -- R/R message [DAPLA]
    DPBED,  -- Ind. reqmt msg. [DPBED]
    DDISP,  -- MRP message [DDISP]
    DFAPO,  -- PO/network msg. [DFAPO]
    DFAKO,  -- PO header msg. [DFAKO]
    DINST,  -- PM message [DINST]
    DBEST,  -- Inv. mgmt msg. [DBEST]
    DPROG,  -- Forecasting msg [DPROG]
    DFHMI,  -- PRT message [DFHMI]
    DQMPF,  -- QM insp. msg. [DQMPF]
    DTBED,  -- TReqmt msg. [DTBED]
    DTAUF,  -- TOrder message [DTAUF]
    DERZK,  -- MatCostEst Procedure [CK_DERZK]
    DLFPL,  -- LT planning msg [DLFPL]
    DLOCK,  -- Distr. Lock [DLOCK]
    AUPRF,  -- Profile Name [AUPRF]
    PRIMARY KEY (MANDT, MMSTA)
);

Learn More