PPH_CACHE_SHRTST

Transparent Table Temporary Data
28 Fields 1 CDS Views

Cache Table Shortage Statistics

PPH_CACHE_SHRTST is an SAP database table in S/4HANA. Cache Table Shortage Statistics. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CacheShortageStatistic view from BASIC MRP Cache Shortage Statistic

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY mrpplant WERKS_D Plant
KEY material MATNR Material
KEY mrparea BERID MRP Area
KEY mrpplanningsegmenttype MRP_BUF_PLAAB MRP Segment
KEY mrpplanningsegmentnumber PLANR Plng Segmnt No.
KEY materialshortageprofile MATERIALSHORTAGEPROFILE Shortage Prf.
KEY materialshortageprof_cnt SDM_COUNTER Counter
materialshortagestartdate MATERIALSHORTAGESTARTDATE Shortage Start
materialshortageenddate MATERIALSHORTAGEENDDATE Shortage End
materialshortagequantity PPH_DEC_20_3 DEC 20 3
materialshortageduration MATERIALSHORTAGEDURATION Shortage Duration (Calendar Days)
daysofsupplyduration DAYSOFSUPPLYDURATION Days' Supply (Working Days)
daysofsupplycoveragepercent PPH_DEC_5_2 Dec 5,2 data element
minavailableqtyatshortage PPH_DEC_20_3 DEC 20 3
minavailableqtyovercomplhrzn PPH_DEC_20_3 DEC 20 3
materialfirstuncoveragedate MATERIALSHORTAGESTARTDATE Shortage Start
matmaxcoveragedurninworkdays DAYSOFSUPPLYDURATION Days' Supply (Working Days)
materialfirstuncoveragedateqty PPH_DEC_20_3 DEC 20 3
numberofshortagespersegment INT4 INT4
daysofsupplydurdaysdigit2 DAYSOFSUPPLYDURDAYSDIGIT2 Intraday Supply (Working Days)
materialshortagedurninworkdays MATERIALSHORTAGEDURNINWORKDAYS Shortage Duration (Working Days)
receiptdayssupply RECEIPTDAYSSUPPLY Rec.Days'Supply
receiptdayssupplycriticality RECEIPTDAYSSUPPLYCRITICALITY Critical. Indicator
daysofsupplycriticality DAYSOFSUPPLYCRITICALITY Critical. Indicator
stockdayssupply STOCKDAYSSUPPLY Stock Days' Supply (Working Days)
stockdayssupplycriticality STOCKDAYSSUPPLYCRITICALITY Critical. Indicator
stockintradayssupply STOCKINTRADAYSSUPPLY Stock Intraday Supply (Working Days)

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 Shortage Statistics
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPH_CACHE_SHRTST (
    MANDT,                           -- Client [MANDT]
    MRPPLANT,                        -- Plant [WERKS_D]
    MATERIAL,                        -- Material [MATNR]
    MRPAREA,                         -- MRP Area [BERID]
    MRPPLANNINGSEGMENTTYPE,          -- MRP Segment [MRP_BUF_PLAAB]
    MRPPLANNINGSEGMENTNUMBER,        -- Plng Segmnt No. [PLANR]
    MATERIALSHORTAGEPROFILE,         -- Shortage Prf. [MATERIALSHORTAGEPROFILE]
    MATERIALSHORTAGEPROF_CNT,        -- Counter [SDM_COUNTER]
    MATERIALSHORTAGESTARTDATE,       -- Shortage Start [MATERIALSHORTAGESTARTDATE]
    MATERIALSHORTAGEENDDATE,         -- Shortage End [MATERIALSHORTAGEENDDATE]
    MATERIALSHORTAGEQUANTITY,        -- DEC 20 3 [PPH_DEC_20_3]
    MATERIALSHORTAGEDURATION,        -- Shortage Duration (Calendar Days) [MATERIALSHORTAGEDURATION]
    DAYSOFSUPPLYDURATION,            -- Days' Supply (Working Days) [DAYSOFSUPPLYDURATION]
    DAYSOFSUPPLYCOVERAGEPERCENT,     -- Dec 5,2 data element [PPH_DEC_5_2]
    MINAVAILABLEQTYATSHORTAGE,       -- DEC 20 3 [PPH_DEC_20_3]
    MINAVAILABLEQTYOVERCOMPLHRZN,    -- DEC 20 3 [PPH_DEC_20_3]
    MATERIALFIRSTUNCOVERAGEDATE,     -- Shortage Start [MATERIALSHORTAGESTARTDATE]
    MATMAXCOVERAGEDURNINWORKDAYS,    -- Days' Supply (Working Days) [DAYSOFSUPPLYDURATION]
    MATERIALFIRSTUNCOVERAGEDATEQTY,  -- DEC 20 3 [PPH_DEC_20_3]
    NUMBEROFSHORTAGESPERSEGMENT,     -- INT4 [INT4]
    DAYSOFSUPPLYDURDAYSDIGIT2,       -- Intraday Supply (Working Days) [DAYSOFSUPPLYDURDAYSDIGIT2]
    MATERIALSHORTAGEDURNINWORKDAYS,  -- Shortage Duration (Working Days) [MATERIALSHORTAGEDURNINWORKDAYS]
    RECEIPTDAYSSUPPLY,               -- Rec.Days'Supply [RECEIPTDAYSSUPPLY]
    RECEIPTDAYSSUPPLYCRITICALITY,    -- Critical. Indicator [RECEIPTDAYSSUPPLYCRITICALITY]
    DAYSOFSUPPLYCRITICALITY,         -- Critical. Indicator [DAYSOFSUPPLYCRITICALITY]
    STOCKDAYSSUPPLY,                 -- Stock Days' Supply (Working Days) [STOCKDAYSSUPPLY]
    STOCKDAYSSUPPLYCRITICALITY,      -- Critical. Indicator [STOCKDAYSSUPPLYCRITICALITY]
    STOCKINTRADAYSSUPPLY,            -- Stock Intraday Supply (Working Days) [STOCKINTRADAYSSUPPLY]
    PRIMARY KEY (MANDT, MRPPLANT, MATERIAL, MRPAREA, MRPPLANNINGSEGMENTTYPE, MRPPLANNINGSEGMENTNUMBER, MATERIALSHORTAGEPROFILE, MATERIALSHORTAGEPROF_CNT)
);

Learn More