PPH_CACHE_ITEM

Transparent Table Temporary Data
32 Fields 4 CDS Views

Supply demand items and uncovered demand items

PPH_CACHE_ITEM is an SAP database table in S/4HANA. Supply demand items and uncovered demand items. It contains 32 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
e_mrp_mfg_comps view left_outer
e_mrp_pre_stocktransf_demands view left_outer
e_mrp_proddem_aggr view left_outer
I_CacheSupplyDemandItem view from BASIC Supply Demand and Uncovered Demand Item

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY mrpplant WERKS_D Plant
KEY material MATNR Material
KEY mrparea BERID MRP Area
KEY mrpplanningsegmenttype PLAAB MRP segment
KEY mrpplanningsegmentnumber PLANR Plng Segmnt No.
KEY mrpelementcategory DELKZ MRP Elmnt Ind.
KEY mrpelement DEL12 MRP element number
KEY mrpelementitem DELPS MRP elemnt item
KEY mrpelementscheduleline DELET Scheduling
KEY materialshortageprofile MATERIALSHORTAGEPROFILE Shortage Prf.
KEY materialshortageprof_cnt SDM_COUNTER Counter
KEY mrpelementavailyorrqmtdate MRPELEMENTAVAILYORRQMTDATE Avail. or Reqmt Date
mrpelementenddate DATS Date
mrpelementstartdate DATS Date
mrpelementquantityisfirm FIX01 Fixed Lot Size
mrpelementopenquantity PPH_DEC_20_3 DEC 20 3
mrpelementtypeimportance SORT1 Sort ind. 01
productionversion VERID Prod. Version
supplier LIFNR Supplier
customer KUNNR Customer
issuingorreceivingplant WERKS_D Plant
storagelocation LGORT_D Location
sourcemrpelementcategory DELKZ MRP Elmnt Ind.
sourcemrpelement DEL12 MRP element number
sourcemrpelementitem DELPS MRP elemnt item
mrpelementuncoveredquantity PPH_DEC_20_3 DEC 20 3
mrpelementdelayedquantity PPH_DEC_20_3 DEC 20 3
maximumdelaydate DATS Date
maximumdelayindays MAXIMUMDELAYINDAYS Max.DelayInDays
maximumdelayinworkdays MAXIMUMDELAYINWORKDAYS MaxDelayWorkday
procurementprogressindicator PROCUREMENTPROGRESSINDICATOR Proc. Progress

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.

-- Supply demand items and uncovered demand items
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPH_CACHE_ITEM (
    MANDT,                         -- Client [MANDT]
    MRPPLANT,                      -- Plant [WERKS_D]
    MATERIAL,                      -- Material [MATNR]
    MRPAREA,                       -- MRP Area [BERID]
    MRPPLANNINGSEGMENTTYPE,        -- MRP segment [PLAAB]
    MRPPLANNINGSEGMENTNUMBER,      -- Plng Segmnt No. [PLANR]
    MRPELEMENTCATEGORY,            -- MRP Elmnt Ind. [DELKZ]
    MRPELEMENT,                    -- MRP element number [DEL12]
    MRPELEMENTITEM,                -- MRP elemnt item [DELPS]
    MRPELEMENTSCHEDULELINE,        -- Scheduling [DELET]
    MATERIALSHORTAGEPROFILE,       -- Shortage Prf. [MATERIALSHORTAGEPROFILE]
    MATERIALSHORTAGEPROF_CNT,      -- Counter [SDM_COUNTER]
    MRPELEMENTAVAILYORRQMTDATE,    -- Avail. or Reqmt Date [MRPELEMENTAVAILYORRQMTDATE]
    MRPELEMENTENDDATE,             -- Date [DATS]
    MRPELEMENTSTARTDATE,           -- Date [DATS]
    MRPELEMENTQUANTITYISFIRM,      -- Fixed Lot Size [FIX01]
    MRPELEMENTOPENQUANTITY,        -- DEC 20 3 [PPH_DEC_20_3]
    MRPELEMENTTYPEIMPORTANCE,      -- Sort ind. 01 [SORT1]
    PRODUCTIONVERSION,             -- Prod. Version [VERID]
    SUPPLIER,                      -- Supplier [LIFNR]
    CUSTOMER,                      -- Customer [KUNNR]
    ISSUINGORRECEIVINGPLANT,       -- Plant [WERKS_D]
    STORAGELOCATION,               -- Location [LGORT_D]
    SOURCEMRPELEMENTCATEGORY,      -- MRP Elmnt Ind. [DELKZ]
    SOURCEMRPELEMENT,              -- MRP element number [DEL12]
    SOURCEMRPELEMENTITEM,          -- MRP elemnt item [DELPS]
    MRPELEMENTUNCOVEREDQUANTITY,   -- DEC 20 3 [PPH_DEC_20_3]
    MRPELEMENTDELAYEDQUANTITY,     -- DEC 20 3 [PPH_DEC_20_3]
    MAXIMUMDELAYDATE,              -- Date [DATS]
    MAXIMUMDELAYINDAYS,            -- Max.DelayInDays [MAXIMUMDELAYINDAYS]
    MAXIMUMDELAYINWORKDAYS,        -- MaxDelayWorkday [MAXIMUMDELAYINWORKDAYS]
    PROCUREMENTPROGRESSINDICATOR,  -- Proc. Progress [PROCUREMENTPROGRESSINDICATOR]
    PRIMARY KEY (MANDT, MRPPLANT, MATERIAL, MRPAREA, MRPPLANNINGSEGMENTTYPE, MRPPLANNINGSEGMENTNUMBER, MRPELEMENTCATEGORY, MRPELEMENT, MRPELEMENTITEM, MRPELEMENTSCHEDULELINE, MATERIALSHORTAGEPROFILE, MATERIALSHORTAGEPROF_CNT, MRPELEMENTAVAILYORRQMTDATE)
);

Learn More