C_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 C_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: CMKT_CPGBYCPGCNT

CREATE VIEW C_MKT_CampaignByCmpgnContent AS
SELECT
  CampaignByCmpgnContent.CampaignContent AS CampaignContent,
  CampaignByCmpgnContent.CampaignID AS CampaignID,
  IsCampaignTemplate,
  CampaignByCmpgnContent.Campaign AS Campaign,
  CampaignByCmpgnContent.CampaignName AS CampaignName,
  CampaignByCmpgnContent.CampaignLifecycleStatus AS CampaignLifecycleStatus,
  _LifeCycleStatusText.CampaignLifecycleStatusName AS CampaignLifecycleStatusName,
  CampaignByCmpgnContent.CampaignPriority AS CampaignPriority,
  _PriorityText.CampaignPriorityName AS CampaignPriorityName,
  CampaignByCmpgnContent.CampaignCategory AS CampaignCategory,
  _CategoryText.CampaignCategoryName AS CampaignCategoryName,
  CampaignByCmpgnContent.CampaignProcessType AS CampaignProcessType,
  _ProcessTypeText.CampaignProcessTypeName AS CampaignProcessTypeName,
  CampaignByCmpgnContent.MediaType AS MediaType,
  _MediaTypeText.MediaTypeName AS MediaTypeName,
  CampaignByCmpgnContent.CampaignStartDate AS CampaignStartDate,
  CampaignByCmpgnContent.CampaignEndDate AS CampaignEndDate,
  CampaignByCmpgnContent.CampaignLastChgdDateTime AS CampaignLastChgdDateTime,
  cast('' as hpa_sapui5_icon_name ) AS CampaignIconName,
  cast('' as abap.char(1333) ) AS CampaignIconURL,
  CampaignByCmpgnContent.CampaignMktgArea AS MarketingArea,
  _MarketingAreaText.MarketingAreaName AS MarketingAreaName
LEFT OUTER JOIN I_MKT_CampaignLifeCycleStsText AS _LifeCycleStatusText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MKT_CampaignContentUsgeTypeT AS _UsageTypeText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MKT_CampaignPriorityText AS _PriorityText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MKT_CampaignCategoryText AS _CategoryText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MKT_CampaignProcessTypeText AS _ProcessTypeText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MKT_MediaTypeText AS _MediaTypeText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MKT_MarketingAreaText AS _MarketingAreaText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MKT_CampaignTeamMember AS _MKT_CampaignTeamMember ON Campaign = _MKT_CampaignTeamMember.Campaign  -- association [0..*]
LEFT OUTER JOIN I_MKT_CmpgnTmplTeamMember AS _MKT_CmpgnTmplTeamMember ON Campaign = _MKT_CmpgnTmplTeamMember.CampaignTemplateUUID  -- association [0..*]
;