Technical Name: 0CRM_MKTELM5_ATTR
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 |
This DataSource is used to extract all marketing elements (marketing plans, marketing plan elements, campaigns and so on).
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) |