I_MKT_CampaignAssetsDetailAll

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_CampaignAssetsDetailAll.
-- 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_MKT_CampaignAssetsDetailAll AS
SELECT
  CampaignID,
  CampaignUUID,
  CampaignAsset,
  CampaignAssetConverted,
  CampaignAssetType,
  _MKT_ContentRoot.CampaignContentStatus AS CampaignAssetStatus,
  _MKT_ContentRoot.CampaignContentName AS CampaignAssetName,
  _MKT_ContentRoot.CampaignAssetDescription AS CampaignAssetDescription,
  _MKT_ContentRoot.LastChangeDateTime AS CampaignAssetLastChgdDateTime,
  _MKT_ContentRoot.CreationDateTime AS CampaignAssetCreationDateTime,
  _MKT_ContentRoot.SenderName AS SenderName,
  _MKT_ContentRoot.CommunicationArea AS CommFlowCommunicationArea,
  _MKT_ContentRoot.ReferencedOrgStructure AS CommFlowRefcdOrgStructure,
  _MKT_ContentRoot.CommunicationAreaName AS CommFlowCommunicationAreaName,
  _MKT_ContentRoot.CreatedByUser AS CampaignAssetCreatedByUser
FROM I_MKT_CampaignAssetAll AS _CPG_AssetsDetailAll
LEFT OUTER JOIN I_MKT_CampaignContent AS _MKT_ContentRoot ON CampaignAssetConverted = _MKT_ContentRoot.CampaignContent  -- association [*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CampaignAssetCreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_MKT_CmpgnContentStatusText AS _MKT_CpgAssetStatus_Text ON CampaignAssetStatus = _MKT_CpgAssetStatus_Text.CampaignContentStatus AND _MKT_CpgAssetStatus_Text.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AuthorizedCommunicationArea AS _AuthCommArea ON CommFlowCommunicationArea = _AuthCommArea.CommunicationArea AND CommFlowRefcdOrgStructure = _AuthCommArea.ReferencedOrgStructure  -- association [0..*]
;