I_MKT_CampaignByCmpgnContent

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_MKT_CampaignByCmpgnContent.
-- 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: IMKT_CPGBYCPGCNT

CREATE VIEW I_MKT_CampaignByCmpgnContent AS
SELECT
  cast( ActionParameter.parameter_value as abap.char(10) ) AS CampaignContent,
  Orchestration.initiative_id AS CampaignID,
  _ini_root.db_key AS CampaignUUID,
  ActionParameter.parameter_value AS CampaignAsset,
  ActionParameter.db_key AS CampaignAssetUUID,
  ActionParameter.parameter_id AS CampaignAssetType,
  Orchestration.mkt_area_id AS CampaignMktgArea
FROM cuan_d_mktorc_ap AS ActionParameter
INNER JOIN cuan_d_mktorc_rt AS Orchestration ON /* join condition not captured in parsed metadata */
INNER JOIN cuan_d_ini_root AS _ini_root ON /* join condition not captured in parsed metadata */
;