I_MRPRunParameters

DDL: I_MRPRUNPARAMETERS SQL: IMRPRUNPARAMS Type: view BASIC
9 Fields 1 Data Sources

MRP Run Parameters

I_MRPRunParameters is a Basic CDS View that provides data about "MRP Run Parameters" in SAP S/4HANA. It reads from 1 data source (sdm_mrp_run_prms) and exposes 9 fields with key field UserID.

Data Sources (1)

SourceAliasJoin Type
sdm_mrp_run_prms sdm_mrp_run_prms from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMRPRUNPARAMS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MRP Run Parameters view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY UserID uname User Name
AllOrderBOMCompsAreIncldInPlng all_order_bom_components Order BOM Comp.
BOMComponentIsIncldInPlng changed_bom_components Components
PlanningDate date_for_planning Date
MRPMaterialScope material_scope Material Scope
MRPLivePlanningMode planning_mode Planning Mode
MRPHasRegenerativePlanning regenerative_planning Regenerat. Pln.
PlannedOrderScheduling scheduling Scheduling
StockTransferMatlIsIncldInPlng stock_transfer_materials StkTransf Matls

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MRPRunParameters.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IMRPRUNPARAMS

CREATE VIEW I_MRPRunParameters AS
SELECT
  uname AS UserID,
  all_order_bom_components AS AllOrderBOMCompsAreIncldInPlng,
  changed_bom_components AS BOMComponentIsIncldInPlng,
  date_for_planning AS PlanningDate,
  material_scope AS MRPMaterialScope,
  planning_mode AS MRPLivePlanningMode,
  regenerative_planning AS MRPHasRegenerativePlanning,
  scheduling AS PlannedOrderScheduling,
  stock_transfer_materials AS StockTransferMatlIsIncldInPlng
FROM sdm_mrp_run_prms
;

Learn More