I_MKT_MktgCntntDeployment

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_MktgCntntDeployment.
-- 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_MktgCntntDeployment AS
SELECT
  Deployment.marketingcontentdeploymentuuid AS MarketingContentDeploymentUUID,
  Deployment.marketingcontentuuid AS MarketingContentUUID,
  Deployment.marketingcontenttarget AS MarketingContentTarget,
  Deployment.marketingcontentdeployment AS MarketingContentDeployment,
  Deployment.marketingcontentdeployedurl AS MarketingContentDeployedURL,
  Deployment.marketingcontenthtmlstring AS MarketingContentHTMLString,
  Deployment.creationdatetime AS CreationDateTime,
  Deployment.createdbyuser AS CreatedByUser,
  cast(Deployment.lastchangedatetime as cuan_last_changed_date_time preserving type) AS LastChangeDateTime,
  Deployment.lastchangedbyuser AS LastChangedByUser,
  cast(_LastChangedByUser._UserAddress._PersonName.PersonFullName as cuan_changed_by preserving type) AS LastChangedByUserName,
  _MarketingContent.CommunicationArea AS CommunicationArea,
  _MarketingContent.ReferencedOrgStructure AS ReferencedOrgStructure
FROM cuand_mc_dplmnt AS Deployment
LEFT OUTER JOIN I_MKT_MarketingContent AS _MarketingContent ON MarketingContentUUID = _MarketingContent.MarketingContentUUID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_AuthorizedCommunicationArea AS _AuthCommArea ON communicationarea = _AuthCommArea.CommunicationArea AND referencedorgstructure = _AuthCommArea.ReferencedOrgStructure  -- association [0..*]
;