I_ProductionCampaign

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_ProductionCampaign.
-- 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_ProductionCampaign AS
SELECT
  pcmh.pcmnr AS ProductionCampaign,
  pcmh.erdat AS CreationDate,
  pcmh.ernam AS CreatedByUser,
  pcmh.aedat AS LastChangeDate,
  pcmh.aenam AS LastChangedByUser,
  cast(pcmh.pcstd as vdm_v_validity_start_date preserving type) AS ValidityStartDate,
  pcmh.pcstt AS ValidityStartTime,
  cast(pcmh.pcend as vdm_v_validity_end_date preserving type) AS ValidityEndDate,
  pcmh.pcent AS ValidityEndTime,
  pcmh.pctxt AS ProductionCampaignText,
  cast(pcmh.pcart as vdm_pcart preserving type) AS ProductionCampaignCategory,
  pcmh.uom AS ProductionCampaignTaktUnit,
  pcmh.takt AS ProductionCampaignTaktDuration,
  pcmh.gproznr AS BusinessProcess,
  pcmh.gprozgr AS BusinessProcessGroupName,
  cast(pcmo.matnr as productnumber preserving type) AS Product,
  pcmo.werks AS Plant,
  pcmo.gemein AS BaseUnit,
  pcmo.menge AS ProductionCampaignQuantity
FROM pcmh
LEFT OUTER JOIN I_ProductionCampaignItem AS _ProductionCampaignItem ON ProductionCampaign = _ProductionCampaignItem.ProductionCampaign  -- association [0..*]
LEFT OUTER JOIN I_ProductionCampaignCategory AS _ProductionCampaignCategory ON ProductionCampaignCategory = _ProductionCampaignCategory.ProductionCampaignCategory  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlant ON Plant = _ProductPlant.Plant AND Product = _ProductPlant.Product  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TaktUnit ON ProductionCampaignTaktUnit = _TaktUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
;