CUAN_LPG_VH

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 CUAN_LPG_VH.
-- 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 CUAN_LPG_VH AS
SELECT
  cuand_mc_content.marketingcontentuuid AS CP_KEY,
  cuand_mc_content.marketingcontent AS ID,
  cuand_mc_content.marketingcontentname AS NAME,
  cuand_mc_content.marketingcontenttype AS TYPE,
  _MKT_Type.ddtext AS TYPE_T,
  cuand_mc_content.marketingcontentstatus AS STATUS_INT,
  case when cuand_mc_content.marketingcontentstatus = '15' and _MKT_MC_Depl.createdbyuser > '' then '70' else cuand_mc_content.marketingcontentstatus end as STATUS AS marketingcontentstatusendasSTATUS,
  case when cuand_mc_content.marketingcontentstatus = '15' and _MKT_MC_Depl.createdbyuser > '' then _MKT_StatDepl.ddtext else _MKT_Status.ddtext end as STATUS_T AS ddtextendasSTATUS_T,
  cuand_mc_content.creationdatetime AS CREA_DATE_TIME,
  cuand_mc_content.createdbyuser AS CREA_UNAME,
  _CreationUser._UserAddress._PersonName.PersonFullName AS CREA_UNAME_TEXT,
  cuand_mc_content.lastchangedatetime AS LCHG_DATE_TIME,
  cuand_mc_content.lastchangedbyuser AS LCHG_UNAME,
  _ChangeUser._UserAddress._PersonName.PersonFullName AS LCHG_UNAME_TEXT,
  cuand_mc_content.comm_area_id AS COMM_AREA_ID,
  cuand_mc_content.ref_org_struc AS REF_ORG_STRUC,
  _CommArea.comm_area_desc AS COMM_AREA_ID_T,
  cuand_mc_content.mktgcntntdefaultlanguage AS LANGUAGE_DEFAULT,
  _T002T_LANG.sptxt AS LANGUAGE_DEFAULT_T,
  _MKT_MC_Depl.marketingcontentdeployedurl AS DEPLOYED_URL,
  _MKT_MC_Depl.creationdatetime AS DEPL_CREA_TIME,
  cuand_mc_content.marketingcontentsource AS SOURCE,
  _MKT_Source.ddtext AS SOURCE_T,
  '' AS STYLESHEET_URL
FROM cuand_mc_content
LEFT OUTER JOIN I_User AS _CreationUser ON _CreationUser.UserID = cuand_mc_content.createdbyuser  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangeUser ON _ChangeUser.UserID = cuand_mc_content.lastchangedbyuser  -- association [0..1]
LEFT OUTER JOIN I_AuthorizedCommunicationArea AS _AuthCommArea ON COMM_AREA_ID = _AuthCommArea.CommunicationArea AND REF_ORG_STRUC = _AuthCommArea.ReferencedOrgStructure  -- association [0..*]
;