PPHMRPLOG

Transparent Table Temporary Data

MRP Live Log Header

PPHMRPLOG is an SAP database table in S/4HANA. MRP Live Log Header. It contains 24 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_MRPRun view_entity from BASIC Technical details of one MRP Run
Pph_Ddl_Perflog_Header view_entity from Aggregated MRP Performance data per Log
Pphmrp_Perf_Log_Help1 view from Help View for PPHMRP_PERF_LOG_KEY_FIGURES: Max Starttime
Pphmrp_Perf_Log_Help2 view from Help View for PPHMRP_PERF_LOG_KEY_FIGURES

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY uuid uuid UUID
start_time pph_mrp_start_ts Start Time Stamp
end_time pph_mrp_end_ts End Time Stamp
uname uname User Name
regen pph_mrp_regenerative Regenerat. Pln.
comps pph_mrp_bom_components Components
plall pph_plall Order BOM Comp.
trans pph_mrp_stock_transfer StkTransf Matls
plmod pph_mrp_plmod Planning Mode
vertr vertr Start in Past
scope pph_mrp_scope Material Scope
trmpl trmpl Scheduling
dispd dispd Planning date
wo_auth pph_wo_auth Not Authorized
not_locked pph_not_locked No. Not Locked
selstring pph_selstring Selection
mrp_comment pph_comment Log Name
error_string pph_error_text Error Text
jobcount btcjobcnt Job No.
jobname btcjob Job Name
stepcount btcstepcnt Step no.
time_overall_hdr abap.int4 Elapsed Time in Seconds (Wallclock)
transaction_id vbkey_d Update key

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.

-- MRP Live Log Header
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPHMRPLOG (
    MANDT,             -- Client [mandt]
    UUID,              -- UUID [uuid]
    START_TIME,        -- Start Time Stamp [pph_mrp_start_ts]
    END_TIME,          -- End Time Stamp [pph_mrp_end_ts]
    UNAME,             -- User Name [uname]
    REGEN,             -- Regenerat. Pln. [pph_mrp_regenerative]
    COMPS,             -- Components [pph_mrp_bom_components]
    PLALL,             -- Order BOM Comp. [pph_plall]
    TRANS,             -- StkTransf Matls [pph_mrp_stock_transfer]
    PLMOD,             -- Planning Mode [pph_mrp_plmod]
    VERTR,             -- Start in Past [vertr]
    SCOPE,             -- Material Scope [pph_mrp_scope]
    TRMPL,             -- Scheduling [trmpl]
    DISPD,             -- Planning date [dispd]
    WO_AUTH,           -- Not Authorized [pph_wo_auth]
    NOT_LOCKED,        -- No. Not Locked [pph_not_locked]
    SELSTRING,         -- Selection [pph_selstring]
    MRP_COMMENT,       -- Log Name [pph_comment]
    ERROR_STRING,      -- Error Text [pph_error_text]
    JOBCOUNT,          -- Job No. [btcjobcnt]
    JOBNAME,           -- Job Name [btcjob]
    STEPCOUNT,         -- Step no. [btcstepcnt]
    TIME_OVERALL_HDR,  -- Elapsed Time in Seconds (Wallclock) [abap.int4]
    TRANSACTION_ID,    -- Update key [vbkey_d]
    PRIMARY KEY (MANDT, UUID)
);