PPH_DD_BUFPOS

Transparent Table Application Table
13 Fields 2 CDS Views

Caching Table for DLT and ADU User Triggered Calculations

PPH_DD_BUFPOS is an SAP database table in S/4HANA. Caching Table for DLT and ADU User Triggered Calculations. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ProdBufPositioningCache view from BASIC Cache View
P_ProdBufPositioning view from BASIC

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY werks WERKS_D Plant
KEY berid BERID MRP Area
avgdailyusage PPH_AVERAGE_DAILY_USAGE Average Daily Usage
adu_unit MEINS Base Unit
aduchanged_by PPH_ADU_CHANGED_BY ADU Changed By
aduchanged_time PPH_ADU_CHANGED_ON ADU Changed On
decoupled_lead_time PPH_DECOUPLED_LEADTIME Decoupled Lead Time
dltchanged_by PPH_DLT_CHANGED_BY DLT Changed By
dltchanged_time PPH_DLT_CHANGED_ON DLT Changed On
created_by ERNAM Created By
created_time TIMESTAMP Time Stamp

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.

-- Caching Table for DLT and ADU User Triggered Calculations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPH_DD_BUFPOS (
    MANDT,                -- Client [MANDT]
    MATNR,                -- Material [MATNR]
    WERKS,                -- Plant [WERKS_D]
    BERID,                -- MRP Area [BERID]
    AVGDAILYUSAGE,        -- Average Daily Usage [PPH_AVERAGE_DAILY_USAGE]
    ADU_UNIT,             -- Base Unit [MEINS]
    ADUCHANGED_BY,        -- ADU Changed By [PPH_ADU_CHANGED_BY]
    ADUCHANGED_TIME,      -- ADU Changed On [PPH_ADU_CHANGED_ON]
    DECOUPLED_LEAD_TIME,  -- Decoupled Lead Time [PPH_DECOUPLED_LEADTIME]
    DLTCHANGED_BY,        -- DLT Changed By [PPH_DLT_CHANGED_BY]
    DLTCHANGED_TIME,      -- DLT Changed On [PPH_DLT_CHANGED_ON]
    CREATED_BY,           -- Created By [ERNAM]
    CREATED_TIME,         -- Time Stamp [TIMESTAMP]
    PRIMARY KEY (MANDT, MATNR, WERKS, BERID)
);

Learn More