PPH_CACHE_MAT

Transparent Table Temporary Data
31 Fields 6 CDS Views

Cache Table Material

PPH_CACHE_MAT is an SAP database table in S/4HANA. Cache Table Material. It contains 31 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
e_mrp_materials view inner
e_mrp_mc_totals view inner
e_mrp_pre_stocktransf_demands view inner
e_mrp_prod_demands view inner
e_mrp_supplier view inner
I_CacheMaterial view from BASIC MRP Cache Material

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY material MATNR Material
KEY mrparea BERID MRP Area
KEY mrpplant WERKS_D Plant
mrpgroup DISGR MRP Group
mrpcontroller DISPO MRP Controller
mrptype DISMM MRP Type
materialprocurementprofile SOBSL Special Procur.
materialprocurementcategory BESKZ Procurement
materialplanneddeliverydurn PLIFZ Pl. Deliv. Time
materialplannedproductiondurn DZEIT InhseProdTime
mrpsafetyduration SHZET Safety Time
planningtimefenceindays FXHOR Plng time fence
purchasinggroup EKGRP Purch. Group
materialgoodsreceiptduration WEBAZ GR proc. time
materialsafetystockqty PPH_DEC_20_3 DEC 20 3
materialbaseunit MEINS Base Unit
materialabcclassification MAABC ABC Indicator
materialusabilityprofile MMSTA P-S Mat. Status
totalreplenishmentleadduration WZEIT Total RL time
materialgroup MATKL Material Group
materialtype MTART Material Type
factorycalendarid FABKL Factory Calend.
productionsupervisor FEVOR Prodn Supervisor
materialreplnmtleaddurnenddate DATS Date
totalreplnmtleaddurnenddate DATS Date
manualplanninghorizonenddate DATS Date
mrpsafetydurationenddate DATS Date
materialreorderpointqty MINBE Reorder Point
mrpsafetystockmethod MRP_SSTOCK_METHOD Safety Stock Method
lastupdated DATETIME_KK Date/Time

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.

-- Cache Table Material
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPH_CACHE_MAT (
    MANDT,                           -- Client [MANDT]
    MATERIAL,                        -- Material [MATNR]
    MRPAREA,                         -- MRP Area [BERID]
    MRPPLANT,                        -- Plant [WERKS_D]
    MRPGROUP,                        -- MRP Group [DISGR]
    MRPCONTROLLER,                   -- MRP Controller [DISPO]
    MRPTYPE,                         -- MRP Type [DISMM]
    MATERIALPROCUREMENTPROFILE,      -- Special Procur. [SOBSL]
    MATERIALPROCUREMENTCATEGORY,     -- Procurement [BESKZ]
    MATERIALPLANNEDDELIVERYDURN,     -- Pl. Deliv. Time [PLIFZ]
    MATERIALPLANNEDPRODUCTIONDURN,   -- InhseProdTime [DZEIT]
    MRPSAFETYDURATION,               -- Safety Time [SHZET]
    PLANNINGTIMEFENCEINDAYS,         -- Plng time fence [FXHOR]
    PURCHASINGGROUP,                 -- Purch. Group [EKGRP]
    MATERIALGOODSRECEIPTDURATION,    -- GR proc. time [WEBAZ]
    MATERIALSAFETYSTOCKQTY,          -- DEC 20 3 [PPH_DEC_20_3]
    MATERIALBASEUNIT,                -- Base Unit [MEINS]
    MATERIALABCCLASSIFICATION,       -- ABC Indicator [MAABC]
    MATERIALUSABILITYPROFILE,        -- P-S Mat. Status [MMSTA]
    TOTALREPLENISHMENTLEADDURATION,  -- Total RL time [WZEIT]
    MATERIALGROUP,                   -- Material Group [MATKL]
    MATERIALTYPE,                    -- Material Type [MTART]
    FACTORYCALENDARID,               -- Factory Calend. [FABKL]
    PRODUCTIONSUPERVISOR,            -- Prodn Supervisor [FEVOR]
    MATERIALREPLNMTLEADDURNENDDATE,  -- Date [DATS]
    TOTALREPLNMTLEADDURNENDDATE,     -- Date [DATS]
    MANUALPLANNINGHORIZONENDDATE,    -- Date [DATS]
    MRPSAFETYDURATIONENDDATE,        -- Date [DATS]
    MATERIALREORDERPOINTQTY,         -- Reorder Point [MINBE]
    MRPSAFETYSTOCKMETHOD,            -- Safety Stock Method [MRP_SSTOCK_METHOD]
    LASTUPDATED,                     -- Date/Time [DATETIME_KK]
    PRIMARY KEY (MANDT, MATERIAL, MRPAREA, MRPPLANT)
);

Learn More