Show TOC

  Marketing Element Attributes

Technical Name: 0CRM_MKTELM5_ATTR

Technical Data

DataSource Type

Attributes (Master Data)

Application Components

0CRM_MKT-IO

Available as from OLTP Release

CRM 4.0 SP03, enhanced with CRM 5.0

Available as from PlugIn Release

Not applicable

RemoteCube-Capable

No

Use

This DataSource is used to extract all marketing elements (marketing plans, marketing plan elements, campaigns and so on).

Fields of Origin for the Extract Structure

Fields in the Extract Structure

Description of the Field in the Extract Structure

Table of Origin

Field in the Table of Origin

ACTION_PROFILE

PPF: Name of Action Profile

CRM_MKTPL_ATTR

ACTION_PROFILE

CLIENT

Client

CRM_MKTPL_ATTR

CLIENT

GUID

Project Planning: 16-Character GUID for Projects and Activts

CRM_MKTPL_ATTR

CLIENT

EXTERNAL_ID

Project Planning: External Identifier of an Element

CGPL_PROJECT or CGPL_TASK

EXTERNAL_ID

PROJECT_ID

Project Planning: External Identifier of an Element

CGPL_PROJECT or CGPL_TASK

EXTERNAL_ID

OBJECT_TYPE

Object Type in Project Planning

CGPL_PROJECT or CGPL_TASK

EXTERNAL_ID

DELFLAG

BW Deletion Indicator

PRIORITY

Priority

CGPL_PROJECT or CGPL_TASK

PRIORITY

PLANSTARTDATE

Planned Start (Date)

CGPL_PROJECT or CGPL_TASK

PLANSTART

PLANFINISHDATE

Planned Finish Date

CGPL_PROJECT or CGPL_TASK

PLANFINISH

ACTUALSTARTDATE

Actual Start (Date)

CGPL_PROJECT or CGPL_TASK

ACTUALSTART

ACTUALFINISHDATE

Actual Finish (Date)

CGPL_PROJECT or CGPL_TASK

ACTUALFINISH

COMPLETION

Degree of Processing in Percent

CGPL_PROJECT or CGPL_TASK

COMPLETION

MILESTONE

Milestone indicator

CGPL_PROJECT or CGPL_TASK

MILESTONE

CONSTRAINT_TYPE

Type of Scheduling Constraint

CGPL_PROJECT or CGPL_TASK

CONSTRAINT_TYPE

CONSTRAINTDATE

Constraint Date (Date)

CGPL_PROJECT or CGPL_TASK

CONSTRAINTDATE

CREATED_BY

Name of Person Who Created Object

CGPL_PROJECT or CGPL_TASK

CREATED_BY

CREATED_ON

Date When the Object Was Created

CGPL_PROJECT or CGPL_TASK

CREATED_ON

CHANGED_BY

Name of Person Who Changed Object

CGPL_PROJECT or CGPL_TASK

CHANGED_BY

CHANGED_ON

Date on which object was last changed

CGPL_PROJECT or CGPL_TASK

CHANGED_ON

POSID

Work Breakdown Structure Element (WBS Element)

CGPL_R3_ATTRIBUT

POSID

CAMP_TYPE

CRM Marketing Planning - Campaign Type

CRM_MKTPL_ATTR

CAMP_TYPE

CHANNEL

Communication Medium

CRM_MKTPL_ATTR

CHANNNEL

RESPONSIBLE_NAME

Business Partner Number

CRM_MKTPL_ATTR

RESPONSIBLE

SMARTFORM

Form for E-mail

CRM_MKTPL_ATTR

SMARTFORM

MAIL_FORM

Form for letter

CRM_MKTPL_ATTR

MAIL_FORM

FAX_FORM

Form for Fax

CRM_MKTPL_ATTR

FAX_FORM

SMS_FORM

Form for SMS

CRM_MKTPL_ATTR

SMS_FORM

ADDRESS_ID

E-mail Address ID

CRM_MKTPL_ATTR

ADRESS_ID

SHORTCUT

Campaign Code

CRM_MKTPL_ATTR

SHORTCUT

PRINT_ID

Profile for Print Parameters

CRM_MKTPL_ATTR

PRINT_ID

SEND_PARTNER

Business partner for Sender Address Determination

CRM_MKTPL_ATTR

SEND_PARTNER

BWSTMKTSYS0

BW Status

CRM_JEST

STAT

BWSTMKTSYS1

BW Status

CRM_JEST

STAT

BWSTMKTSYS2

BW Status

CRM_JEST

STAT

BWSTMKTSYS3

BW Status

CRM_JEST

STAT

PLANGROUP

Planning Profile Group

CGPL_PROJECT or CGPL_TASK

PLANGROUP

TACTICS

Tactic

CRM_MKTPL_ATTR

TACTICS

OBJECTIVE

Objective(s)

CRM_MKTPL_ATTR

OBJECTIVE

AUTH_GROUP

Authorization Group

CRM_MKTPL_ATTR

AUTH_GROUP

SCRIPT_TREEID

Name of Interaction Center (IC) WinClient Script

CRM_MKTPL_ATTR

SCRIPT

SURVEYID

CRM Surveys: Survey ID

CRM_MKTPL_ATTR

SURVEYID

SURVEYVERSION

CRM Surveys: Survey Version

CRM_MKTPL_ATTR

SURVEYVERSION

RECURRING

Indicator Recurring Campaign for Camp. Automation

CRM_MKTPL_ATTR

RECURRING

CAMP_PERIOD

Period for Campaign

CRM_MKTPL_ATTR

CAMP_PERIOD

N_CAMP_PERIODS

No. of Processing Periods

CRM_MKTPL_ATTR

N_CAMP_PERIODS

CALENDAR_ID

Factory calendar

CGPL_PROJECT or CGPL_TASK

CALENDAR_ID

SALES_ORG

Sales Organization

CRM_MKTPL_TPATTR

SALES_ORG

DIS_CHANNEL

Distribution channel

CRM_MKTPL_TPATTR

DIS_CHANNEL

DIVISION

Division

CRM_MKTPL_TPATTR

DIVISION

BP_ID

Business Partner Number

CRM_MKTPL_TPATTR

BP_GUID

BP_NODE

UUID in character form

CRM_MKTPL_TPATTR

NODE_GUID

TARGETGRP_GUID

CRM Marketing: Target Group ID

CAMP_LINK_EXTID

Project Planning: External Indentifier of an Element

CRM_MKTPL_TPATTR

CAMPAIGN_LINK

CURRENCY

MKTPL: Currency object

CRM_MKTPL_TPATTR

CURRENCY

TERR_PATH_GUID

Territory Path GUID

CRM_MKTPL_TPATTR

TERR_PATH_GUID

TERR_PATH_ID

Territory Hierarchy ID

CRM_MKTPL_TPATTR

TERR_PATH_ID

TERR_GUID

Territory GUID 32

CPT_TYPE

Type of Campaign Element Used

CRM_MKTPL_TPATTR

CPT_TYPE

BP_NODE

UUID in character form

CRM_MKTPL_TPATTR

NODE_GUID

CAMP_LINK_EXTID

Project Planning: External Identifier of an Element

CRM_MKTPL_ATTR

CAMPAIGN_LINK

CURRENCY

MKTPL: Currency object

CRM_MKTPL_ATTR

CURRENCY

TERR_PATH_GUID

Territory Path GUID

CRM_MKTPL_ATTR

TERR_PATH_GUID

TERR_PATH_ID

Territory Hierarchy ID

CRM_MKTPL_ATTR

TERR_PATH_ID

CPT_TYPE

Type of Campaign Element Used

CRM_MKTPL_ATTR

CPT_TYPE

APO_ELEM_EXTID

APO Integration: Campaign ID in APO

CRMA_MKTPL_CPGNM

APO_ELEM_EXTID

APO_LOGSYS

Logical destination (specified in function call)

CRMA_MKTPL_CPGNM

APO_LOGSYS

R3_LOGSYS

Marketing Planning: Logical System for R/3 Integration

CRM_MKTPL_R3MAP

R3_LOGSYS

PARTNER01_BP

Business Partner Number

CRMD_MKTPL_PAR

PARSET_GUID

PARTNER02_BP

Business Partner Number

CRMD_MKTPL_PAR

PARSET_GUID

PARTNER03_BP

Business Partner Number

CRMD_MKTPL_PAR

PARSET_GUID

PARTNER04_BP

Business Partner Number

CRMD_MKTPL_PAR

PARSET_GUID

PARTNER05_BP

Business Partner Number

CRMD_MKTPL_PAR

PARSET_GUID

PARTNER06_BP

Business Partner Number

CRMD_MKTPL_PAR

PARSET_GUID

FILE_EXPORT_FORM

File Export Form

DISTMETHOD

Distribution Method for Coupon

EXP_DATE

Expiration Date for Coupon

OFRCODE

Coupon Code

INACTIVE

Inactive Marketing Project

MKT_ORG

Marketing Organization

CLEARING_HOUSE

Business Partner ID

FCO_COUNTRY

Country of the Family Code for a Coupon

FAMCODE

Family Code for Coupon

DATE_RANGE_ST1

From Date (Search)

DATE_RANGE_ST2

From Date (Search)

DATE_RANGE_ST3

From Date (Search)

DATE_RANGE_ST4

From Date (Search)

DATE_RANGE_ST5

From Date (Search)

DATE_RANGE_END1

To Date (Search)

DATE_RANGE_END2

To Date (Search)

DATE_RANGE_END3

To Date (Search)

DATE_RANGE_END4

To Date (Search)

DATE_RANGE_END5

To Date (Search)