CUAN_CPG_MCRELEVANTFORSUCCESS

DDL: CUAN_CPG_MCRELEVANTFORSUCCESS SQL: CUAN_CPGMCSUCC Type: view Package: CUAN_CAMPAIGN_SUCCESS_DATA
19 Fields 3 Data Sources

Identifying relevant external campaigns for MultiChannel

CUAN_CPG_MCRELEVANTFORSUCCESS is a CDS View that provides data about "Identifying relevant external campaigns for MultiChannel" in SAP S/4HANA. It reads from 3 data sources (I_MKT_CampaignActionParameter, I_MKT_ExternalCampaign, I_Mkt_Initiative) and exposes 19 fields with key fields Campaign, ExternalCampaignUUID. Part of development package CUAN_CAMPAIGN_SUCCESS_DATA.

Data Sources (3)

SourceAliasJoin Type
I_MKT_CampaignActionParameter _MKT_CampaignActionParameter inner
I_MKT_ExternalCampaign _MKT_ExternalCampaign inner
I_Mkt_Initiative I_Mkt_Initiative from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CUAN_CPGMCSUCC view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Campaign I_Mkt_Initiative Campaign Mktg Campaign
KEY ExternalCampaignUUID I_MKT_ExternalCampaign ExternalCampaignUUID UUID
CampaignOwner _MKT_CampaignOwner CampaignOwner
Advertiser I_MKT_ExternalCampaign Advertiser
ExternalCmpgnManagingParty I_MKT_ExternalCampaign ExternalCmpgnManagingParty
ExternalCampaignOrigin I_MKT_ExternalCampaign ExternalCampaignOrigin
CampaignSuccessPullEndDate I_MKT_ExternalCampaign CampaignSuccessPullEndDate
CampaignAutomationActionUUID I_MKT_ExternalCampaign CampaignAutomationActionUUID UUID
Channel I_MKT_CampaignActionParameter CampaignActionParameterValue Value
CampaignActionParameterName I_MKT_CampaignActionParameter CampaignActionParameterName Parameter ID
ExternalCampaignID I_MKT_ExternalCampaign ExternalCampaignID
ExternalCampaignURL
AdvertiserName I_MKT_ExternalCampaign AdvertiserName
ExternalCampaignName I_MKT_ExternalCampaign ExternalCampaignName
ExternalCmpgnManagingPartyName
CampaignID I_Mkt_Initiative CampaignID WorklistID
CampaignLifecycleStatus I_Mkt_Initiative CampaignLifecycleStatus Life Cycle
CampaignStartDate I_Mkt_Initiative CampaignStartDate Valn start date
CampaignEndDate I_Mkt_Initiative CampaignEndDate Valn End date

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_CPG_MCRELEVANTFORSUCCESS.
-- 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: CUAN_CPGMCSUCC

CREATE VIEW CUAN_CPG_MCRELEVANTFORSUCCESS AS
SELECT
  I_Mkt_Initiative.Campaign AS Campaign,
  _MKT_ExternalCampaign.ExternalCampaignUUID AS ExternalCampaignUUID,
  _MKT_CampaignOwner.CampaignOwner AS CampaignOwner,
  _MKT_ExternalCampaign.Advertiser AS Advertiser,
  _MKT_ExternalCampaign.ExternalCmpgnManagingParty AS ExternalCmpgnManagingParty,
  _MKT_ExternalCampaign.ExternalCampaignOrigin AS ExternalCampaignOrigin,
  _MKT_ExternalCampaign.CampaignSuccessPullEndDate AS CampaignSuccessPullEndDate,
  _MKT_ExternalCampaign.CampaignAutomationActionUUID AS CampaignAutomationActionUUID,
  _MKT_CampaignActionParameter.CampaignActionParameterValue AS Channel,
  _MKT_CampaignActionParameter.CampaignActionParameterName AS CampaignActionParameterName,
  _MKT_ExternalCampaign.ExternalCampaignID AS ExternalCampaignID,
  _MKT_ExternalCampaign.AdvertiserName AS AdvertiserName,
  _MKT_ExternalCampaign.ExternalCampaignName AS ExternalCampaignName,
  I_Mkt_Initiative.CampaignID AS CampaignID,
  I_Mkt_Initiative.CampaignLifecycleStatus AS CampaignLifecycleStatus,
  I_Mkt_Initiative.CampaignStartDate AS CampaignStartDate,
  I_Mkt_Initiative.CampaignEndDate AS CampaignEndDate
FROM I_Mkt_Initiative
INNER JOIN I_MKT_ExternalCampaign AS _MKT_ExternalCampaign ON /* join condition not captured in parsed metadata */
INNER JOIN I_MKT_CampaignActionParameter AS _MKT_CampaignActionParameter ON /* join condition not captured in parsed metadata */
;

Learn More