PPH_PEGGING

Transparent Table Temporary Data
43 Fields 3 CDS Views

dynamic Pegging Relations

PPH_PEGGING is an SAP database table in S/4HANA. dynamic Pegging Relations. It contains 43 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_MatlSupplyDemandPeggingBasic view_entity from BASIC Pegging on Matl Supply And Demand Area
PPH_PEGGING_MinNode view_entity from Minimum Node ID per root object
PPH_PeggingWithTimestamp view_entity from DBVM Timestamp for Pegging Table

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY root PPH_DEL12 Common type for delnr and del12
KEY nodeid PPH_PEGGING_NODE Pegging Node
root_item CHAR22 x
parent PPH_PARENT_NODE Tree Parent Node
node_agg PPH_PEGGING_NODE Pegging Node
parent_agg PPH_PARENT_NODE Tree Parent Node
matnr MATNR Material
werks WERKS_D Plant
berid BERID MRP Area
plaab PLAAB MRP Segment
planr PLANR Plng Segmnt No.
meins MEINS Base Unit
req_delkz DELKZ MRP Elmnt Ind.
req_delnr PPH_DEL12 Common type for delnr and del12
req_delps DELPS MRP elemnt item
req_delet DELET Scheduling
stk_delkz DELKZ MRP Elmnt Ind.
stk_delnr PPH_DEL12 Common type for delnr and del12
stk_delps DELPS MRP elemnt item
stk_delet DELET Scheduling
parent_delps DELPS MRP elemnt item
parent_matnr MATNR Material
delay INT4 INT4
total_delay INT4 INT4
proposed_delay INT4 INT4
prop_req_date DATS Date
missing_qty PPH_DEC_20_3 DEC 20 3
pegged_qty PPH_PEGGING_QTY Quantity pegged via a Pegging Edge
all_issues INT4 INT4
firstissuedate DATS Date
stk_date DATS Date
req_date DATS Date
req_lgort LGORT_D Location
matlcomprequirementdate MBDAT Mat.Avail.Date
mrprequiredquantityinbaseunit ORDQTY Open Quantity
mrpelementavailyorrqmtdate PEDTR Order End Date
mrpelementstartdate PSTTR Order Start
peggingmessage SKSORT Key
issuedate PEDTR Order End Date
mrpavailablequantity VFMNG Committed Qty
numberofpeggingwarnings INT4 INT4
numberofpeggingerrors INT4 INT4

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.

-- dynamic Pegging Relations
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPH_PEGGING (
    MANDT,                          -- Client [MANDT]
    ROOT,                           -- Common type for delnr and del12 [PPH_DEL12]
    NODEID,                         -- Pegging Node [PPH_PEGGING_NODE]
    ROOT_ITEM,                      -- x [CHAR22]
    PARENT,                         -- Tree Parent Node [PPH_PARENT_NODE]
    NODE_AGG,                       -- Pegging Node [PPH_PEGGING_NODE]
    PARENT_AGG,                     -- Tree Parent Node [PPH_PARENT_NODE]
    MATNR,                          -- Material [MATNR]
    WERKS,                          -- Plant [WERKS_D]
    BERID,                          -- MRP Area [BERID]
    PLAAB,                          -- MRP Segment [PLAAB]
    PLANR,                          -- Plng Segmnt No. [PLANR]
    MEINS,                          -- Base Unit [MEINS]
    REQ_DELKZ,                      -- MRP Elmnt Ind. [DELKZ]
    REQ_DELNR,                      -- Common type for delnr and del12 [PPH_DEL12]
    REQ_DELPS,                      -- MRP elemnt item [DELPS]
    REQ_DELET,                      -- Scheduling [DELET]
    STK_DELKZ,                      -- MRP Elmnt Ind. [DELKZ]
    STK_DELNR,                      -- Common type for delnr and del12 [PPH_DEL12]
    STK_DELPS,                      -- MRP elemnt item [DELPS]
    STK_DELET,                      -- Scheduling [DELET]
    PARENT_DELPS,                   -- MRP elemnt item [DELPS]
    PARENT_MATNR,                   -- Material [MATNR]
    DELAY,                          -- INT4 [INT4]
    TOTAL_DELAY,                    -- INT4 [INT4]
    PROPOSED_DELAY,                 -- INT4 [INT4]
    PROP_REQ_DATE,                  -- Date [DATS]
    MISSING_QTY,                    -- DEC 20 3 [PPH_DEC_20_3]
    PEGGED_QTY,                     -- Quantity pegged via a Pegging Edge [PPH_PEGGING_QTY]
    ALL_ISSUES,                     -- INT4 [INT4]
    FIRSTISSUEDATE,                 -- Date [DATS]
    STK_DATE,                       -- Date [DATS]
    REQ_DATE,                       -- Date [DATS]
    REQ_LGORT,                      -- Location [LGORT_D]
    MATLCOMPREQUIREMENTDATE,        -- Mat.Avail.Date [MBDAT]
    MRPREQUIREDQUANTITYINBASEUNIT,  -- Open Quantity [ORDQTY]
    MRPELEMENTAVAILYORRQMTDATE,     -- Order End Date [PEDTR]
    MRPELEMENTSTARTDATE,            -- Order Start [PSTTR]
    PEGGINGMESSAGE,                 -- Key [SKSORT]
    ISSUEDATE,                      -- Order End Date [PEDTR]
    MRPAVAILABLEQUANTITY,           -- Committed Qty [VFMNG]
    NUMBEROFPEGGINGWARNINGS,        -- INT4 [INT4]
    NUMBEROFPEGGINGERRORS,          -- INT4 [INT4]
    PRIMARY KEY (MANDT, ROOT, NODEID)
);

Learn More