I_MRPGroupControlParameter

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_MRPGroupControlParameter.
-- 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.

CREATE VIEW I_MRPGroupControlParameter AS
SELECT
  mtart AS MRPGroup,
  werks AS MRPPlant,
  strgr AS PlanningStrategyGroup,
  cast(umthz as vdm_umthz preserving type) AS ReschedulingHorizonInWorkdays,
  cast(plahz as vdm_plahz preserving type) AS PlanningHorizonInWorkdays,
  fixhz AS PlanningTimeFenceInDays,
  lifkz AS ScheduleLinesCreationCode,
  cast(prreg as bmg_prreg preserving type) AS ATPCheckingRule,
  cast(vrmod as /sapapo/vrmod preserving type) AS ProdRqmtsConsumptionMode,
  cast(vint1 as vdm_vint1 preserving type) AS BackwardCnsmpnPeriodInWorkDays,
  cast(vint2 as vdm_vint2 preserving type) AS FwdConsumptionPeriodInWorkDays,
  cast(andis as vdm_andis preserving type) AS NmbrOfDaysAfterMatlMustBePlnd,
  auart AS OrderType,
  cast(shflg as pph_shflg preserving type) AS ProductSafetyTimeMRPRelevance,
  shzet AS SafetyTimeInWorkDays,
  mdach AS PlndOrdProcessingActionControl,
  cast(resvp as vdm_resvp preserving type) AS PlndIndepRqmtAdjmtTimePeriod,
  preqapproval AS PurReqnHandoverIsRequired
FROM t438m
LEFT OUTER JOIN I_Plant AS _MRPPlant ON MRPPlant = _MRPPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_MRPGroup AS _MRPGroup ON MRPGroup = _MRPGroup.MRPGroup AND MRPPlant = _MRPGroup.MRPPlant  -- association [1..1]
LEFT OUTER JOIN I_PlannedOrderActionControl AS _PlannedOrderActionControl ON PlndOrdProcessingActionControl = _PlannedOrderActionControl.PlannedOrderActionControl  -- association [0..1]
LEFT OUTER JOIN I_PlanningStrategyGroup AS _PlanningStrategyGroup ON PlanningStrategyGroup = _PlanningStrategyGroup.PlanningStrategyGroup  -- association [0..1]
LEFT OUTER JOIN I_ProdConsumptionMode AS _ProductConsumptionMode ON ProdRqmtsConsumptionMode = _ProductConsumptionMode.ProdRqmtsConsumptionMode  -- association [0..1]
LEFT OUTER JOIN I_ProdSafetyTimeMRPRelevance AS _SafetyTimeMRPRelevance ON ProductSafetyTimeMRPRelevance = _SafetyTimeMRPRelevance.ProductSafetyTimeMRPRelevance  -- association [0..1]
LEFT OUTER JOIN I_OrderType AS _OrderType ON OrderType = _OrderType.OrderType  -- association [0..1]
;