I_MKT_PROGRAM

CDS View
18 Fields 11 CDS Views

Marketing: Program

I_MKT_PROGRAM is a CDS View in S/4HANA. Marketing: Program. It contains 18 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
A_MKT_Program view from Marketing Program
A_MKT_ProgramText view from BASIC Marketing: Program Name
C_MKT_CmpgnAggrgdSpnd view from CONSUMPTION Marketing: Campaign Aggregated Spend
CUAN_MKTPL_CAMPAIGN_SEARCH view from Marketing Plan Campaign Search
CUAN_Mktpl_Cmpgn_Search view from Marketing Plan Campaign Search
CUAN_OVH_MKTPLN_RelatedObjects view from Related Objects Marketing Plan
CUAN_PROGRAM_QUICK_SEARCH view from View for program search
CUAN_PROGRAM_SEARCH view from Marketing Program search
I_MKT_MarketingPlanCampaign view from COMPOSITE Marketing Campaign in a Marketing Plan
I_MKT_PgmCampaignForMktgPlan view union_all COMPOSITE Marketing Pgm/Campaign For a Mktg Plan
I_MKT_ProgramSpend view from COMPOSITE Marketing: Program Proposed Spend

Fields (18)

KeyField CDS FieldsUsed in Views
KEY MarketingPlanUUID DB_KEY,Marketing_Plan_Guid,MarketingPlanUUID 6
KEY MarketingProgram DB_KEY,GUID,MarketingProgram,Object_Guid,PROGRAM_KEY 9
_MarketingProgramMktgArea _MarketingProgramMktgArea 1
_MKT_StatusForBusObj _MarketingProgramStatus 1
MarketingArea MarketingArea,MarketingProgramMarketingArea,MKT_AREA 7
MarketingProgramDescription Description 1
MarketingProgramID ID,MarketingProgramID 6
MarketingProgramName MarketingProgramName,NAME,PROGRAM_NAME 8
MarketingProgramStatus MarketingProgramStatus,Status 4
MarketingProgramValidFromDate MarketingProgramValidFromDate,Valid_From 5
MarketingProgramValidToDate MarketingProgramValidToDate,Valid_To 4
MktgObjVersHdrUUID MktgObjVersHdrUUID,OBJECT_VERSION_HEADER_GUID 4
MktgProgramCreatedByUser Created_By,MktgProgramCreatedByUser 3
MktgProgramCreationDateTime Created_On,MktgProgramCreationDateTime 2
MktgProgramDetailDimension Detail_Dimension,MktgProgramDetailDimension 2
MktgProgramLastChgdByUser Changed_By,MktgProgramLastChgdByUser 2
MktgProgramLastChgdDateTime Changed_On 1
MktgProgramTimeDimension MktgProgramTimeDimension 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: Program
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MKT_PROGRAM (
    MARKETINGPLANUUID,
    MARKETINGPROGRAM,
    _MARKETINGPROGRAMMKTGAREA,
    _MKT_STATUSFORBUSOBJ,
    MARKETINGAREA,
    MARKETINGPROGRAMDESCRIPTION,
    MARKETINGPROGRAMID,
    MARKETINGPROGRAMNAME,
    MARKETINGPROGRAMSTATUS,
    MARKETINGPROGRAMVALIDFROMDATE,
    MARKETINGPROGRAMVALIDTODATE,
    MKTGOBJVERSHDRUUID,
    MKTGPROGRAMCREATEDBYUSER,
    MKTGPROGRAMCREATIONDATETIME,
    MKTGPROGRAMDETAILDIMENSION,
    MKTGPROGRAMLASTCHGDBYUSER,
    MKTGPROGRAMLASTCHGDDATETIME,
    MKTGPROGRAMTIMEDIMENSION,
    PRIMARY KEY (MARKETINGPLANUUID, MARKETINGPROGRAM)
);

Learn More