I_MKT_MARKETINGPLAN

CDS View
12 Fields 4 CDS Views

Marketing: Plan

I_MKT_MARKETINGPLAN is a CDS View in S/4HANA. Marketing: Plan. It contains 12 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_MKT_MarketingPlanSearch view from CONSUMPTION Marketing Plan Search
CUAN_MKT_MARKETING_PLAN_SEARCH view from Marketing Plan Search
I_MKT_MktgPlanTeamMemberCube view from COMPOSITE Mktg: Marketing Plan Team Member - Cube
I_MKT_ProgramSpendByMktgPlan view from COMPOSITE Marketing Proposed Spend By Mktg Plan

Fields (12)

KeyField CDS FieldsUsed in Views
KEY MarketingPlanUUID DB_KEY,MarketingPlanUUID 3
MarketingArea MarketingArea,MKT_AREA 2
MarketingPlan ID,MarketingPlan 2
MarketingPlanCreatedByUser CREATED_BY,MarketingPlanCreatedByUser 2
MarketingPlanEndDate MarketingPlanEndDate,VALID_TO 2
MarketingPlanLastChangedByUser CHANGED_BY,MarketingPlanLastChangedByUser 2
MarketingPlanName MarketingPlanName,NAME 2
MarketingPlanStartDate MarketingPlanStartDate,VALID_FROM 2
MarketingPlanStatus MarketingPlanStatus,STATUS 2
MktgObjVersHdrUUID MktgObjVersHdrUUID,OBJECT_VERSION_HEADER_GUID 3
MktgPlanCreationDateTime CREATED_ON,MktgPlanCreationDateTime 2
MktgPlanLastChangedDateTime CHANGED_ON,MktgPlanLastChangedDateTime 2

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: Plan
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MKT_MARKETINGPLAN (
    MARKETINGPLANUUID,
    MARKETINGAREA,
    MARKETINGPLAN,
    MARKETINGPLANCREATEDBYUSER,
    MARKETINGPLANENDDATE,
    MARKETINGPLANLASTCHANGEDBYUSER,
    MARKETINGPLANNAME,
    MARKETINGPLANSTARTDATE,
    MARKETINGPLANSTATUS,
    MKTGOBJVERSHDRUUID,
    MKTGPLANCREATIONDATETIME,
    MKTGPLANLASTCHANGEDDATETIME,
    PRIMARY KEY (MARKETINGPLANUUID)
);

Learn More