PPH_CACHE_PLSEG

Transparent Table Temporary Data
18 Fields 2 CDS Views

Cache Table Planning Segment

PPH_CACHE_PLSEG is an SAP database table in S/4HANA. Cache Table Planning Segment. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MRPPlanningSegment view from BASIC MRP Planning Segment
v_mrp_plan_segments view from Fiori MRP App Planning Segments CDS View

Fields (18)

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.
mrpavailablestockquantity pph_dec_20_3 DEC 20 3
timestamp_set mrp_buffer_timestamp_set Timestamp
date_plant_set dats Date
mrpplanningsegmentnumberext mrpindividualsegment Individual Segment
pastdueopeningdateelements pastdueopeningdateelements Opening Date in Past
pastduestartdateelements pastduestartdateelements Start Date in Past
pastduefinishdateelements pastduefinishdateelements End Date in Past
materialhasmrpnote materialhasmrpnote Material Note
reschedulein reschedulein Reschedule In
rescheduleout rescheduleout Reschedule Out
cancelprocess cancelprocess Cancel Process

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 Planning Segment
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPH_CACHE_PLSEG (
    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]
    MRPAVAILABLESTOCKQUANTITY,    -- DEC 20 3 [pph_dec_20_3]
    TIMESTAMP_SET,                -- Timestamp [mrp_buffer_timestamp_set]
    DATE_PLANT_SET,               -- Date [dats]
    MRPPLANNINGSEGMENTNUMBEREXT,  -- Individual Segment [mrpindividualsegment]
    PASTDUEOPENINGDATEELEMENTS,   -- Opening Date in Past [pastdueopeningdateelements]
    PASTDUESTARTDATEELEMENTS,     -- Start Date in Past [pastduestartdateelements]
    PASTDUEFINISHDATEELEMENTS,    -- End Date in Past [pastduefinishdateelements]
    MATERIALHASMRPNOTE,           -- Material Note [materialhasmrpnote]
    RESCHEDULEIN,                 -- Reschedule In [reschedulein]
    RESCHEDULEOUT,                -- Reschedule Out [rescheduleout]
    CANCELPROCESS,                -- Cancel Process [cancelprocess]
    PRIMARY KEY (MANDT, MRPPLANT, MATERIAL, MRPAREA, MRPPLANNINGSEGMENTTYPE, MRPPLANNINGSEGMENTNUMBER, MATERIALSHORTAGEPROFILE)
);

Learn More