SDM_MRP_RUN_PRMS
MRP Run Parameters
SDM_MRP_RUN_PRMS is an SAP database table in S/4HANA. MRP Run Parameters. It contains 10 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MRPRunParameters | view | from | BASIC | MRP Run Parameters |
Fields (10)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | uname | xubname | User | |||
| material_scope | pph_mrp_scope | Material Scope | ||||
| scheduling | trmpl | Scheduling | ||||
| changed_bom_components | pph_mrp_bom_components | Components | ||||
| all_order_bom_components | pph_plall | Order BOM Comp. | ||||
| stock_transfer_materials | pph_mrp_stock_transfer | StkTransf Matls | ||||
| regenerative_planning | pph_mrp_regenerative | Regenerat. Pln. | ||||
| planning_mode | pph_mrp_plmod | Planning Mode | ||||
| date_for_planning | datum | Date |
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 Run Parameters
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SDM_MRP_RUN_PRMS (
MANDT, -- Client [mandt]
UNAME, -- User [xubname]
MATERIAL_SCOPE, -- Material Scope [pph_mrp_scope]
SCHEDULING, -- Scheduling [trmpl]
CHANGED_BOM_COMPONENTS, -- Components [pph_mrp_bom_components]
ALL_ORDER_BOM_COMPONENTS, -- Order BOM Comp. [pph_plall]
STOCK_TRANSFER_MATERIALS, -- StkTransf Matls [pph_mrp_stock_transfer]
REGENERATIVE_PLANNING, -- Regenerat. Pln. [pph_mrp_regenerative]
PLANNING_MODE, -- Planning Mode [pph_mrp_plmod]
DATE_FOR_PLANNING, -- Date [datum]
PRIMARY KEY (MANDT, UNAME)
);
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