C_AdvncdPlngProdMRPDmndPnlty

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 C_AdvncdPlngProdMRPDmndPnlty.
-- 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: CAPMRPPENALTY

CREATE VIEW C_AdvncdPlngProdMRPDmndPnlty AS
SELECT
  _DemandPenalty.Product AS Product,
  _DemandPenalty.Plant AS Plant,
  _DemandPenalty.MRPArea AS MRPArea,
  _DemandPenalty.DemandType AS DemandType,
  _DemandPenalty.ProductForEdit AS ProductForEdit,
  _DemandPenalty.PlantForEdit AS PlantForEdit,
  _DemandPenalty.MRPAreaForEdit AS MRPAreaForEdit,
  _DemandPenalty.DemandTypeForEdit AS DemandTypeForEdit,
  _DemandPenalty.DelayPenaltyAmount AS DelayPenaltyAmount,
  _DemandPenalty.MaximumDelayInDays AS MaximumDelayInDays,
  _DemandPenalty.NonDeliveryPenaltyAmount AS NonDeliveryPenaltyAmount,
  _Text.DemandTypeText AS DemandTypeText
FROM I_AdvncdPlngProdMRPDmndPnltyTP AS _DemandPenalty
LEFT OUTER JOIN C_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN C_ProductPlantMRP AS _MRPAreaData ON Product = _MRPAreaData.Product AND Plant = _MRPAreaData.Plant AND MRPArea = _MRPAreaData.MRPArea  -- association [1..1]
LEFT OUTER JOIN I_AdvncdPlngStdDemandTypeText AS _Text ON DemandType = _Text.DemandType AND _Text.Language = $session.system_language  -- association [1..1]
;