PPH_DDL_MAT

PPH_DDL_MAT is an SAP database table in S/4HANA. It contains 12 fields.

Fields (12)

KeyField CDS FieldsUsed in Views
KEY berid MRPArea 1
KEY matnr Material 1
KEY werks Plant 1
disgr MRPGroup 1
dismm MRPType 1
dispo MRPController 1
disvf MRPProcedure 1
eisbe MaterialSafetyStockQty 1
eisbe_today MaterialSafetyStockTodayQty 1
mabst MaterialMaxStockLevelQuantity 1
matkl MaterialGroup 1
meins BaseUnitofMeasure 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPH_DDL_MAT (
    BERID,
    MATNR,
    WERKS,
    DISGR,
    DISMM,
    DISPO,
    DISVF,
    EISBE,
    EISBE_TODAY,
    MABST,
    MATKL,
    MEINS,
    PRIMARY KEY (BERID, MATNR, WERKS)
);