PPH_CACHE_SUPPL

Transparent Table Temporary Data
9 Fields 2 CDS Views

Cache Table Supplier

PPH_CACHE_SUPPL is an SAP database table in S/4HANA. Cache Table Supplier. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
e_mrp_supplier view inner
I_CacheSupplier view_entity from BASIC MRP Cache Supplier

Fields (9)

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 supplier LIFNR Supplier
sequencenumber INT4 INT4
mrpelementenddate DATS Date

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 Supplier
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPH_CACHE_SUPPL (
    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]
    SUPPLIER,                  -- Supplier [LIFNR]
    SEQUENCENUMBER,            -- INT4 [INT4]
    MRPELEMENTENDDATE,         -- Date [DATS]
    PRIMARY KEY (MANDT, MRPPLANT, MATERIAL, MRPAREA, MRPPLANNINGSEGMENTTYPE, MRPPLANNINGSEGMENTNUMBER, SUPPLIER)
);

Learn More