SAP ABAP Table CRMS_MKTPL_IB_QUERY_INI (Query Attributes of Node Initiative (IBOM MKTPL))
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-MKT-MPL (Application Component) Marketing Planner
     CRM_MKTPL_IB_MDF_INI (Package) IBOM Package for MDF Initiatives
Basic Data
Table Category INTTAB    Structure 
Structure CRMS_MKTPL_IB_QUERY_INI   Table Relationship Diagram
Short Description Query Attributes of Node Initiative (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 EXTERNAL_ID CRM_MKTPL_MDFINITIATIVEID CGPL_EXTID CHAR 24   0   Initiative ID  
2 TEXT1 CRM_MKTPL_IB_INI_TEXT TEXT40 CHAR 40   0   Initiative Description  
3 RESPONSIBLE_NO CRM_MKTPL_RESPONSIBLE BU_PARTNER CHAR 10   0   Employee Responsible for Marketing Project *
4 RESP_NAME_FIRST CRM_MKTPL_IB_RESP_NAME_FIRST BU_NAME CHAR 40   0   Person Responsible: First Name  
5 RESP_NAME_LAST CRM_MKTPL_IB_RESP_NAME_LAST BU_NAME CHAR 40   0   Person Responsible: Last Name  
6 PRIORITY CRM_MKTPL_IB_PRIORITY NUMC3 NUMC 3   0   Priority String Element (iBom MKTPL)  
7 STATUS_KEY CRM_MKTPL_IB_STATUS_KEY CRM_MKTPL_IB_STATUS_KEY CHAR 23   0   Key for Status Node (iBom MKTPL)  
8 STSMA J_STSMA J_STSMA CHAR 8   0   Status Profile *
9 CAMP_TYPE CRM_MKTPL_INITYPE CRM_MKTPL_CAMPTYPE CHAR 4   0   Initiative type *
10 OBJECTIVE CRM_MKTPL_OBJECTIVE CRM_MKTPL_OBJECTIVE CHAR 4   0   Objective  
11 TACTICS CRM_MKTPL_TACTICS CRM_MKTPL_TACTICS CHAR 4   0   Tactic  
12 MDF_CAMPAIGNDESC CRM_MKTPL_IB_SPG_TEXT CHAR40 CHAR 40   0   MDF Special Program Description  
13 MDF_PROGRAMDESC CRM_MKTPL_IB_PGM_TEXT CHAR40 CHAR 40   0   MDF Program Description  
14 MDF_CAMPAIGNID CRM_MKTPL_MDFCAMPAIGNID CGPL_EXTID CHAR 24   0   MDF Special Program ID  
15 MDF_PROGRAMID CRM_MKTPL_MDFPROGRAMID CGPL_EXTID CHAR 24   0   MDF Program ID  
16 MKT_ORG CRM_MKTPL_MORG HROBJEC_14 CHAR 14   0   Marketing Organization  
17 TERR_PATH_ID CRMT_TERRITORY_PATH_ID CRM_TERRITORY_PATH_ID CHAR 30   0   Territory Hierarchy ID  
18 PRODUCT_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
19 PLANSTARTDATE CRM_MKTPL_PLANSTARTDATE DATUM DATS 8   0   Planned Start Date  
20 PLANFINISHDATE CRM_MKTPL_PLANFINISHDATE DATUM DATS 8   0   Planned Finish Date  
21 PARENT_ID CRM_MKTPL_EXTERNAL_ID CGPL_EXTID CHAR 24   0   External Identification  
22 CREATED_BY CGPL_CREATED_BY USNAM CHAR 12   0   Name of Person Who Created Object  
23 CREATED_ON CGPL_CREATED_ON DATUM DATS 8   0   Date on Which the Object was Created  
24 CHANGED_BY CGPL_CHANGED_BY USNAM CHAR 12   0   Name of Person Who Changed Object  
25 CHANGED_ON CGPL_CHANGED_ON DATUM DATS 8   0   Date on Which Object Was Last Changed  
26 R3_INT CRMT_MKTPL_R3_INT CHAR1 CHAR 1   0   Marketing Planning: Object Replicated in ERP  
27 INACTIVE CHAR10 CHAR10 CHAR 10   0   Character Field Length = 10  
28 ACTION_PROFILE CRM_MKTPL_ACTION_PROFILE PPFDCNTXT CHAR 30   0   ID of Action Profile *
29 CURRENCY CRM_MKTPL_CUKY WAERS CUKY 5   0   MKTPL: Currency Object *
30 CALENDAR_ID WFCID WFCID CHAR 2   0   Factory Calendar *
31 CHM_RELEVANT CRMT_MKTPL_CHM_RELEVANT XFELD CHAR 1   0   Open to Partners  
32 COMPLETION CGPL_COMPLETION CGPL_COMPLETION NUMC 3   0   Percentage of Completion  
33 ACTUALSTARTDATE CRM_MKTPL_ACTUALSTARTDATE DATUM DATS 8   0   Actual Start Date  
34 ACTUALFINISHDATE CRM_MKTPL_ACTUALFINISHDATE DATUM DATS 8   0   Actual Finish (Date)  
35 PRODUCT_CATEGORY COMT_CATEGORY_ID COM_CATEGORY_ID CHAR 20   0   Category ID  
36 SALES_ORG CRMT_SALES_ORG HROBJEC_14 CHAR 14   0   Sales Organization ID  
37 DIS_CHANNEL CRMT_DISTRIBUTION_CHANNEL CRM_DISTRIBUTION_CHANNEL CHAR 2   0   Distribution Channel *
38 DIVISION CRMT_DIVISION CRM_DIVISION CHAR 2   0   Division *
39 EXTERNAL_ID_TASK CRM_MKTPL_EXTERNAL_ID CGPL_EXTID CHAR 24   0   External Identification  
40 MY_ORGS CRM_MKTPL_IB_BELONGING_TO TEXT50 CHAR 50   0   Belonging To  
41 REF_TYPE CRM_MKTPL_REF_TYPE CRM_MKTPL_REF_TYPE_DOM CHAR 4   0   Usage Type  
42 .INCLUDE       0   0    
43 .INCLUDE       0   0    
44 .INCLUDE       0   0    
45 PARTNER_COMB CRMT_UIU_PARTNER_TO_PARTNERFCT CHAR40 CHAR 40   0   Partner In Partner Function  
46 .INCLUDE       0   0   Additional Date Ranges for MKTPL Search  
47 ADD_DT_RANGE_01_STARTDATE CRM_MKTPL_START_DATE DATS DATS 8   0   Start Date  
48 ADD_DT_RANGE_01_ENDDATE CRM_MKTPL_END_DATE DATS DATS 8   0   End Date  
49 ADD_DT_RANGE_02_STARTDATE CRM_MKTPL_START_DATE DATS DATS 8   0   Start Date  
50 ADD_DT_RANGE_02_ENDDATE CRM_MKTPL_END_DATE DATS DATS 8   0   End Date  
51 ADD_DT_RANGE_03_STARTDATE CRM_MKTPL_START_DATE DATS DATS 8   0   Start Date  
52 ADD_DT_RANGE_03_ENDDATE CRM_MKTPL_END_DATE DATS DATS 8   0   End Date  
53 ADD_DT_RANGE_04_STARTDATE CRM_MKTPL_START_DATE DATS DATS 8   0   Start Date  
54 ADD_DT_RANGE_04_ENDDATE CRM_MKTPL_END_DATE DATS DATS 8   0   End Date  
55 ADD_DT_RANGE_05_STARTDATE CRM_MKTPL_START_DATE DATS DATS 8   0   Start Date  
56 ADD_DT_RANGE_05_ENDDATE CRM_MKTPL_END_DATE DATS DATS 8   0   End Date  
57 ADD_DT_RANGE_06_STARTDATE CRM_MKTPL_START_DATE DATS DATS 8   0   Start Date  
58 ADD_DT_RANGE_06_ENDDATE CRM_MKTPL_END_DATE DATS DATS 8   0   End Date  
59 ADD_DT_RANGE_07_STARTDATE CRM_MKTPL_START_DATE DATS DATS 8   0   Start Date  
60 ADD_DT_RANGE_07_ENDDATE CRM_MKTPL_END_DATE DATS DATS 8   0   End Date  
61 ADD_DT_RANGE_08_STARTDATE CRM_MKTPL_START_DATE DATS DATS 8   0   Start Date  
62 ADD_DT_RANGE_08_ENDDATE CRM_MKTPL_END_DATE DATS DATS 8   0   End Date  
63 .INCLUDE       0   0   Extensive Include for MDF Initiative search  
64 MKTPL_QUERY_INI DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
History
Last changed by/on SAP  20130604 
SAP Release Created in 520