PPHMRPLOG
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA