SAP ABAP Table CRMS_MKTPL_IB_QUERY_RESULT_MPT (Attributes of Node Marketing Plan Element (IBOM MKTPL))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MKT-MPL (Application Component) Marketing Planner
⤷ CRM_MKTPL_IB_MPL (Package) CRM Marketing: iBom for Marketing Plan
⤷ CRM-MKT-MPL (Application Component) Marketing Planner
⤷ CRM_MKTPL_IB_MPL (Package) CRM Marketing: iBom for Marketing Plan
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMS_MKTPL_IB_QUERY_RESULT_MPT | Table Relationship Diagram |
Short Description | Attributes of Node Marketing Plan Element (IBOM MKTPL) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Include for Basic Data MPL (IBOM MKTPL) | |||||
2 | GUID | CRM_MKTPL_IB_MPL_GUID | RAW | 16 | 0 | Marketing Plan | |||
3 | EXTERNAL_ID | CRM_MKTPL_CAMPAIGNID | CGPL_EXTID | CHAR | 24 | 0 | Campaign | ||
4 | CAMP_TYPE | CRM_MKTPL_CAMPTYPE | CRM_MKTPL_CAMPTYPE | CHAR | 4 | 0 | Type | * | |
5 | PRIORITY | CGPL_PRIORITY | NUMC3 | NUMC | 3 | 0 | Priority | * | |
6 | RESPONSIBLE | BU_PARTNER_GUID | SYSUUID | RAW | 16 | 0 | Business Partner GUID | ||
7 | CURRENCY | CRM_MKTPL_CUKY | WAERS | CUKY | 5 | 0 | MKTPL: Currency Object | * | |
8 | CALENDAR_ID | WFCID | WFCID | CHAR | 2 | 0 | Factory Calendar | * | |
9 | COMPLETION | CGPL_COMPLETION | CGPL_COMPLETION | NUMC | 3 | 0 | Percentage of Completion | ||
10 | STSMA | J_STSMA | J_STSMA | CHAR | 8 | 0 | Status Profile | * | |
11 | PARENT_GUID | CRM_MKTPL_IB_MKTPROJECT_GUID | RAW | 16 | 0 | Marketing Project | |||
12 | BWIDENTIFIER | CGPL_BWIDENTIFIER | CGPL_BWIDENTIFIER | NUMC | 8 | 0 | Project Planning - BW Identification | ||
13 | NO_R3_INT | CRM_MKTPL_NO_R3_INT | CHAR1 | CHAR | 1 | 0 | Marketing Planning: Object Not Integrated into ERP PS | ||
14 | INACTIVE | CRMT_MKTPL_INACTIVE | CHAR1 | CHAR | 1 | 0 | Inactive Marketing Project | ||
15 | .INCLUDE | 0 | 0 | Include for Dates and Time of MPL (IBOM MKTPL) | |||||
16 | PLANSTART | CGPL_PLANSTART | BCOS_TSTMP | DEC | 15 | 0 | Planned start date | ||
17 | PLANFINISH | CGPL_PLANFINISH | BCOS_TSTMP | DEC | 15 | 0 | Planned Finish Date | ||
18 | ACTUALSTART | CGPL_ACTUALSTART | BCOS_TSTMP | DEC | 15 | 0 | Actual Start Date | ||
19 | ACTUALFINISH | CGPL_ACTUALFINISH | BCOS_TSTMP | DEC | 15 | 0 | Actual Finish Date | ||
20 | .INCLUDE | 0 | 0 | Include for OrgData of MPL (IBOM MKTPL) | |||||
21 | MKT_ORG | CRM_MKTPL_MORG | HROBJEC_14 | CHAR | 14 | 0 | Marketing Organization | ||
22 | .INCLUDE | 0 | 0 | Include for Basic Data MPL (external) - (IBOM MKTPL) | |||||
23 | CAMP_TYPETX | CRM_MKTPL_CAMPTYPETX | TEXT40 | CHAR | 40 | 0 | Description of Type | ||
24 | CAMP_PRIOTX | CRM_MKTPL_CAMPPRIOTX | TEXT40 | CHAR | 40 | 0 | Description of Priority | ||
25 | RESPONSIBLE_NAME | CRM_MKTPL_RESPONSIBLE | BU_PARTNER | CHAR | 10 | 0 | Employee Responsible for Marketing Project | * | |
26 | RESPONSIBLE_TEXT | BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
27 | CURRENCY_TEXT | LTEXT | TEXT40 | CHAR | 40 | 0 | Long Text | ||
28 | FACTORY_CAL_TEXT | FKTEXT | TEXT60 | CHAR | 60 | 0 | Object Text | ||
29 | PSP_CREATION | CRMT_MKTPL_IB_R3_INT | CRM_BOOLEAN | CHAR | 1 | 0 | Transfer to ERP (boolean) | ||
30 | ACTIVE | CRMT_MKTPL_ACTIVE | XFELD | CHAR | 1 | 0 | Active Marketing Project | ||
31 | STSMA_TEXT | TEXT30 | TEXT30 | CHAR | 30 | 0 | Text (30 Characters) | ||
32 | .INCLUDE | 0 | 0 | Include for Dates and Time MPL (external) - (IBOM MKTPL) | |||||
33 | PLANSTARTDATE | CRM_MKTPL_PLANSTARTDATE | DATUM | DATS | 8 | 0 | Planned Start Date | ||
34 | PLANSTARTTIME | CRM_MKTPL_PLANSTARTTIME | TIME | TIMS | 6 | 0 | Planned Start (Time) | ||
35 | PLANFINISHDATE | CRM_MKTPL_PLANFINISHDATE | DATUM | DATS | 8 | 0 | Planned Finish Date | ||
36 | PLANFINISHTIME | CRM_MKTPL_PLANFINISHTIME | TIME | TIMS | 6 | 0 | Planned Finish (Time) | ||
37 | ACTUALSTARTDATE | CRM_MKTPL_ACTUALSTARTDATE | DATUM | DATS | 8 | 0 | Actual Start Date | ||
38 | ACTUALSTARTTIME | CRM_MKTPL_ACTUALSTARTTIME | TIME | TIMS | 6 | 0 | Actual Start (Time) | ||
39 | ACTUALFINISHDATE | CRM_MKTPL_ACTUALFINISHDATE | DATUM | DATS | 8 | 0 | Actual Finish (Date) | ||
40 | ACTUALFINISHTIME | CRM_MKTPL_ACTUALFINISHTIME | TIME | TIMS | 6 | 0 | Actual Finish (time) | ||
41 | .INCLUDE | 0 | 0 | Include for OrgData of MPL (external) - (IBOM MKTPL) | |||||
42 | MKT_ORG_DESC | CRM_MKTPL_MORG_DESC | CRM_MKTPL_MORG_DESC | CHAR | 40 | 0 | Marketing Organization Description | ||
43 | .INCLUDE | 0 | 0 | Include for Change History MPL (IBOM MKTPL) | |||||
44 | CREATED_BY | CGPL_CREATED_BY | USNAM | CHAR | 12 | 0 | Name of Person Who Created Object | ||
45 | CREATED_BY_DESC | CRM_MKTPL_IB_CREATED_BY_DESC | CHAR65 | CHAR | 65 | 0 | Description of Person Who Created Object | ||
46 | CREATED_ON | CGPL_CREATED_ON | DATUM | DATS | 8 | 0 | Date on Which the Object was Created | ||
47 | CHANGED_BY | CGPL_CHANGED_BY | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
48 | CHANGED_BY_DESC | CRM_MKTPL_IB_CHANGED_BY_DESC | CHAR65 | CHAR | 65 | 0 | Description of Person Who Changed Object | ||
49 | CHANGED_ON | CGPL_CHANGED_ON | DATUM | DATS | 8 | 0 | Date on Which Object Was Last Changed | ||
50 | .INCLUDE | 0 | 0 | ||||||
51 | TASK_LEVEL | CRM_MKTPL_LEVEL | CRM_MKTPL_INDEX | INT1 | 3 | 0 | Hierarchy Level | ||
52 | TIMEZONE_CREATED | CRM_MKTPL_TIMEZONE_CREATED | TZNZONE | CHAR | 6 | 0 | Time Zone of User Who Created the Marketing Project | * | |
53 | OBJECT_TYPE | CGPL_OBJECT_TYPE | CHAR3 | CHAR | 3 | 0 | Object Type in Project Planning | ||
54 | STATUS_TEXT | TEXT40 | TEXT40 | CHAR | 40 | 0 | Text, 40 Characters Long |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 510 |