I_MKT_INITIATIVE

CDS View
33 Fields 24 CDS Views

Marketing: Campaign

I_MKT_INITIATIVE is a CDS View in S/4HANA. Marketing: Campaign. It contains 33 fields. 24 CDS views read from this table.

CDS Views using this table (24)

ViewTypeJoinVDMDescription
A_MKT_Campaign view from COMPOSITE Marketing: Campaign
A_MKT_CampaignMktgAgency view from Marketing Campaign Agency
A_MKT_MktgAgencyCampaign view from Campaign list per Marketing Agency
C_MKT_CampaignOverview view from CONSUMPTION Marketing: Campaign Overview
C_MKT_CampaignValueHelp view from CONSUMPTION Campaign Value Help
C_MKT_CustJrnyCampaignVH view from CONSUMPTION Marketing:Customer Journey - Campaign Value Help
C_MKT_MarketingOvwGlobalFilter view from CONSUMPTION Marketing: Global Filter
C_MKT_MktgAgencyCampaign view from CONSUMPTION Marketing Agency - Assigned Campaigns
C_MKT_MktgAgencyCampaignTP view from CONSUMPTION Marketing Agency Campaigns
C_Mkt_Sr_Vocabulary view inner CONSUMPTION Suppression Rule: Vocabulary
CUAN_CampaignAssignedToProgram view from Marketing Campaigns assigned to Program
CUAN_CPG_AGGRGDSUCCESS_HELPER view from campaigns relevant for success aggregation on interactions
CUAN_CPG_MCRELEVANTFORSUCCESS view from Identifying relevant external campaigns for MultiChannel
CUAN_MktPlanAndRelatedObjects view union Marketing Plan with related Pgm and Cpg
CUAN_OVH_MKTPLN_RelatedObjects view union Related Objects Marketing Plan
I_MKT_AggrdCmpgnSpndSuccCube view from COMPOSITE Mktg: Spend and Aggrd Cmpgn Success - Cube
I_MKT_CampaignByCmpgnCntntAll view inner COMPOSITE Campaign By Campaign Content All
I_MKT_CampaignByStatus view from COMPOSITE Marketing: Campaigns by Status
I_MKT_ExtCampaignReference view from COMPOSITE Marketing: External Campaign
I_MKT_ExternalCampaignCube view from COMPOSITE Ext. Camp. Data from Different Channels
I_MKT_MktgAgcyCmpgnByEmployee view from COMPOSITE View of Campaign by Employees
I_MKT_PlanCmtmtActlSpendCube view from COMPOSITE Mktg: Planned Committed Actual Spend - Cube
I_MKT_ProgramCmpgnMediaType view union COMPOSITE Marketing: Program and Cmpgn Media Type
R_MKT_MktgCampaignTP view_entity from TRANSACTIONAL Root view entity: Mkt Campaign

Fields (33)

KeyField CDS FieldsUsed in Views
KEY Campaign Campaign,GUID,Object_Key 13
KEY MarketingProgramPhaseUUID MarketingProgramPhaseUUID 2
KEY MediaType MarketingProgramMediaType,MediaType 4
_MKT_CampaignCategory _MKT_CampaignCategory 2
_MKT_CampaignOwner _MKT_CampaignOwner 1
_MKT_CampaignPlanCoordinate _MKT_CampaignPlanCoordinate 1
_MKT_CampaignPriority _MKT_CampaignPriority 1
_MKT_CampaignProcessType _MKT_CampaignProcessType 1
_MKT_CommunicationCategory _MKT_CommunicationCategory 1
_MKT_MarketingArea _MKT_MarketingArea 1
_MKT_MediaType _MKT_MediaType 1
_MKT_Program _MKT_Program 2
_MKT_User _MKT_User 1
CampaignCategory CampaignCategory 8
CampaignCreatedByUser CampaignCreatedByUser 2
CampaignCreationDateTime CampaignCreationDateTime,CREATED_ON 3
CampaignDescription DESCRIPTION 1
CampaignEndDate CampaignEndDate,END_DATE 11
CampaignID CampaignID,ID 12
CampaignLastChgdByUser CampaignLastChgdByUser 2
CampaignLastChgdDateTime CampaignLastChgdDateTime,CHANGED_ON 4
CampaignLifecycleStatus CampaignLifecycleStatus,LIFE_CYCLE_STATUS_ID 9
CampaignName CampaignName,NAME 9
CampaignOwner CampaignOwner 6
CampaignPriority CampaignPriority 3
CampaignProcessType CampaignProcessType,PROCESS_TYPE_ID 7
CampaignStartDate CampaignStartDate,START_DATE 10
CampaignTimeZone CampaignTimeZone 2
CommunicationCategoryUUID CommunicationCategoryUUID 1
MarketingAgencyUUID MarketingAgencyUUID 1
MarketingArea CampaignMktgArea,MarketingArea 7
MarketingProgram MarketingProgram,PROGRAM_GUID 4
TargetGroupUUID TargetGroupUUID 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Marketing: Campaign
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MKT_INITIATIVE (
    CAMPAIGN,
    MARKETINGPROGRAMPHASEUUID,
    MEDIATYPE,
    _MKT_CAMPAIGNCATEGORY,
    _MKT_CAMPAIGNOWNER,
    _MKT_CAMPAIGNPLANCOORDINATE,
    _MKT_CAMPAIGNPRIORITY,
    _MKT_CAMPAIGNPROCESSTYPE,
    _MKT_COMMUNICATIONCATEGORY,
    _MKT_MARKETINGAREA,
    _MKT_MEDIATYPE,
    _MKT_PROGRAM,
    _MKT_USER,
    CAMPAIGNCATEGORY,
    CAMPAIGNCREATEDBYUSER,
    CAMPAIGNCREATIONDATETIME,
    CAMPAIGNDESCRIPTION,
    CAMPAIGNENDDATE,
    CAMPAIGNID,
    CAMPAIGNLASTCHGDBYUSER,
    CAMPAIGNLASTCHGDDATETIME,
    CAMPAIGNLIFECYCLESTATUS,
    CAMPAIGNNAME,
    CAMPAIGNOWNER,
    CAMPAIGNPRIORITY,
    CAMPAIGNPROCESSTYPE,
    CAMPAIGNSTARTDATE,
    CAMPAIGNTIMEZONE,
    COMMUNICATIONCATEGORYUUID,
    MARKETINGAGENCYUUID,
    MARKETINGAREA,
    MARKETINGPROGRAM,
    TARGETGROUPUUID,
    PRIMARY KEY (CAMPAIGN, MARKETINGPROGRAMPHASEUUID, MEDIATYPE)
);

Learn More