SAP ABAP Table CRMS_MKTPL_IB_TPM_RESULT_LIST (Trade search result list)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-TPM (Application Component) Trade Promotion Management
     ⤷ CRM_MKTPL_IB_TPM (Package) CRM Marketing: iBom for Trade Promotion and Deal

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_IB_TPM_RESULT_LIST	Table Relationship Diagram
Short Description	Trade search result list

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	GUID	☐	CRM_MKTGS_GUID		RAW	16	0	MKTGS OL: Generic Marketing Guid
2	EXTERNAL_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
3	PLANSTART	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
4	PLANFINISH	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
5	PLANSTARTDATE	☐	CRM_MKTPL_PLANSTARTDATE	DATUM	DATS	8	0	Planned Start Date
6	PLANFINISHDATE	☐	CRM_MKTPL_PLANFINISHDATE	DATUM	DATS	8	0	Planned Finish Date
7	BUYINGSTARTDATE	☐	DATUM	DATUM	DATS	8	0	Date
8	BUYINGENDDATE	☐	DATUM	DATUM	DATS	8	0	Date
9	CAMP_TYPE	☐	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	*
10	TACTICS	☐	CRM_MKTPL_TACTICS	CRM_MKTPL_TACTICS	CHAR	4	0	Tactic
11	OBJECTIVE	☐	CRM_MKTPL_OBJECTIVE	CRM_MKTPL_OBJECTIVE	CHAR	4	0	Objective
12	RESPONSIBLE_TEXT	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
13	RESPONSIBLE_NAME	☐	CRM_MKTPL_RESPONSIBLE	BU_PARTNER	CHAR	10	0	Employee Responsible for Marketing Project	*
14	RESPONSIBLE	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
15	CAMP_TYPETX	☐	CRM_MKTPL_CAMPTYPETX	TEXT40	CHAR	40	0	Description of Type
16	OBJECTIVETX	☐	CRM_MKTPL_OBJECTIVETX	TEXT40	CHAR	40	0	Objective(s) Description
17	TACTICSTX	☐	CRM_MKTPL_TACTICSTX	TEXT40	CHAR	40	0	Tactic Description
18	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
19	SALES_ORG_DESC	☐	CRMT_SALES_ORG_DESC	CRMT_SALES_ORG_DESC	CHAR	40	0	Sales Organization Description
20	DIVISION_DESC	☐	CRMT_DIVISION_DESC	CRMT_DIVISION_DESC	CHAR	40	0	Division Description
21	CHANNEL_DESC	☐	CRMT_CHANNEL_DESC	CRMT_CHANNEL_DESC	CHAR	40	0	Distribution Channel Description
22	CUSTOMER_DESC	☐	CRM_MKTPL_PLANCUST_DESC		CHAR	50	0	Planning Account Description
23	TEXT1	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
24	BP_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
25	NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
26	TARGETGRP_GUID	☐	CRMT_TARGETGRP_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of Target Group
27	OBJECT_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
28	STSMA_TEXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
29	STATUS_TEXT	☐	CRM_MKTPL_IB_STATUS_TEXT	TEXT40	CHAR	40	0	Status of Scope Item (Concatenated)
30	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
31	TERR_PATH_GUID	☐	CRMT_TERRITORY_PATH_GUID	SYSUUID	RAW	16	0	Territory Path GUID
32	TERR_PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
33	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
34	PARENT_GUID	☐	CRM_MKTPL_IB_MKTPROJECT_GUID		RAW	16	0	Marketing Project
35	PLANCUST_TYPE	☐	CRM_MKTPL_PLCUST_TYPE	CRM_MKTPL_PLCUST_TYPE	CHAR	2	0	Type of Account (BP, Hierarchy Node, Target Group)
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	CREATED_BY	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
40	TIMEZONE_CREATED	☐	CRM_MKTPL_TIMEZONE_CREATED	TZNZONE	CHAR	6	0	Time Zone of User Who Created the Marketing Project	*
41	AUTH_GROUP	☐	CRM_MKTPL_AUTH_GROUP	CRM_MKTPL_AUTH_GROUP	CHAR	4	0	Authorization Group
42	ADI_FLAG	☐	CRM_MKTPL_ADI	CRM_MKTPL_ADI	CHAR	1	0	Abnormal Demand Indicator
43	REF_TYPE	☐	CRM_MKTPL_REF_TYPE	CRM_MKTPL_REF_TYPE_DOM	CHAR	4	0	Usage Type
44	.INCLUDE	☐				0	0
45	.INCLUDE	☐				0	0
46	FUND_INDICATOR	☐	CRM_FUND_IND	CRM_MASS_APP_IND	CHAR	4	0	Fund availability indicator
47	PPG_STATUS	☐	CRMT_PPG_STATUS	CRM_PPG_STATUS	CHAR	1	0	PPG Status
48	.INCLUDE	☐				0	0	Attribute structure for Agreements Linked to Trade Promotion
49	AGR_EXTERNAL_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
50	AGR_TEXT1	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
51	.INCLUDE	☐				0	0	TPM IBOM: Include for BI key figures
52	KYFG_VALUE_01	☐	CRM_MKTPL_IB_KEYFIGURE_VALUE	CHAR30	CHAR	30	0	Marketing Planning: Value of BI Key Figure
53	KYFG_VALUE_02	☐	CRM_MKTPL_IB_KEYFIGURE_VALUE	CHAR30	CHAR	30	0	Marketing Planning: Value of BI Key Figure
54	KYFG_VALUE_03	☐	CRM_MKTPL_IB_KEYFIGURE_VALUE	CHAR30	CHAR	30	0	Marketing Planning: Value of BI Key Figure
55	KYFG_VALUE_04	☐	CRM_MKTPL_IB_KEYFIGURE_VALUE	CHAR30	CHAR	30	0	Marketing Planning: Value of BI Key Figure
56	KYFG_VALUE_05	☐	CRM_MKTPL_IB_KEYFIGURE_VALUE	CHAR30	CHAR	30	0	Marketing Planning: Value of BI Key Figure
57	KYFG_VALUE_06	☐	CRM_MKTPL_IB_KEYFIGURE_VALUE	CHAR30	CHAR	30	0	Marketing Planning: Value of BI Key Figure
58	KYFG_VALUE_07	☐	CRM_MKTPL_IB_KEYFIGURE_VALUE	CHAR30	CHAR	30	0	Marketing Planning: Value of BI Key Figure
59	KYFG_VALUE_08	☐	CRM_MKTPL_IB_KEYFIGURE_VALUE	CHAR30	CHAR	30	0	Marketing Planning: Value of BI Key Figure
60	KYFG_VALUE_09	☐	CRM_MKTPL_IB_KEYFIGURE_VALUE	CHAR30	CHAR	30	0	Marketing Planning: Value of BI Key Figure
61	KYFG_VALUE_10	☐	CRM_MKTPL_IB_KEYFIGURE_VALUE	CHAR30	CHAR	30	0	Marketing Planning: Value of BI Key Figure
62	USE_FIX_TZ_UTC	☐	CRM_MKTPL_USE_FIX_TIMEZONE	CRM_BOOLEAN	CHAR	1	0	MKTPL: Use Fix Timezone UTC for Timestamp - Date/Time Conv.
63	.INCLUDE	☐				0	0	Extension Include - Trade Promotion Result
64	MKTPL_RESULT_TPM	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
65	.INCLUDE	☐				0	0	Generic template attributes
66	PLAN_VALID_FROM	☐	CRM_MKTGS_PLAN_VALID_FROM	BCOS_TSTMP	DEC	15	0	Plan Valid From
67	PLAN_VALID_TO	☐	CRM_MKTGS_PLAN_VALID_TO	BCOS_TSTMP	DEC	15	0	Plan Valid To
68	USAGE_VALID_FROM	☐	CRM_MKTGS_USAGE_VALID_FROM	BCOS_TSTMP	DEC	15	0	Usage Valid From
69	USAGE_VALID_TO	☐	CRM_MKTGS_USAGE_VALID_TO	BCOS_TSTMP	DEC	15	0	Usage Valid To
70	.INCLUDE	☐				0	0	External Attributes for Template Assignment
71	PLAN_VALID_FROM_DATE	☐	CRM_MKTGS_PLAN_VALID_FROM_DATE	DATS	DATS	8	0	Plan Valid From Date
72	PLAN_VALID_FROM_TIME	☐	CRM_MKTGS_PLAN_VALID_FROM_TIME	TIME	TIMS	6	0	Plan Valid From Time
73	PLAN_VALID_TO_DATE	☐	CRM_MKTGS_PLAN_VALID_TO_DATE	DATS	DATS	8	0	Plan Valid To Date
74	PLAN_VALID_TO_TIME	☐	CRM_MKTGS_PLAN_VALID_TO_TIME	TIME	TIMS	6	0	Plan Valid To Time
75	USAGE_VALID_FROM_DATE	☐	CRM_MKTGS_USAGE_VALID_FROM_DAT	DATS	DATS	8	0	Usage Valid From Date
76	USAGE_VALID_FROM_TIME	☐	CRM_MKTGS_USAGE_VALID_FROM_TIM	TIME	TIMS	6	0	Usage Valid From Time
77	USAGE_VALID_TO_DATE	☐	CRM_MKTGS_USAGE_VALID_TO_DATE	DATS	DATS	8	0	Usage Valid To Date
78	USAGE_VALID_TO_TIME	☐	CRM_MKTGS_USAGE_VALID_TO_TIME	TIME	TIMS	6	0	Usage Valid To Time

History

Last changed by/on	SAP	20130604
SAP Release Created in	510