SAP ABAP Table CRMT_BSP_MKTPL_TS (BSP Screenstructure: assignment of Cost + text attributes)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-ST-KFP (Application Component) Key Figure Planning
     ⤷ CRM_MKTPL_KPI_INTEGRATION (Package) CRM Marketing Planner: KPI Integration

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_MKTPL_TS	Table Relationship Diagram
Short Description	BSP Screenstructure: assignment of Cost + text attributes

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	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
2	.INCLUDE	☐				0	0	Trade Spend Assignments table
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
5	PROJECT_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts	CGPL_PROJECT
6	TASK_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts	CGPL_TASK
7	.INCLUDE	☐				0	0	CRM Marketing Planning: Include Structure Trade Spend
8	COST_TYPE	☐	CRM_MKTPL_COST_TYPE	CRM_MKTPL_COST_TYPE	CHAR	4	0	Spend Type	*
9	COST_CATEGORY	☐	CRM_MKTPL_COST_CAT	CRM_MKTPL_COST_CAT	CHAR	30	0	Spend Category	*
10	SPEND_METHOD	☐	CRM_MKTPL_SPEND_METHOD	CRM_MKTPL_SPEND_METHOD	CHAR	10	0	Spend Method for Key Figure Planning	*
11	PMNT_TYPE	☐	CRMT_BUAG_PAYMETH	CRM_BUAG_PAYMETH	CHAR	1	0	Payment Method	*
12	DISC_METHOD	☐	CRM_MKTPL_DISC_METH	CRM_MKTPL_DISC_METH	CHAR	4	0	Discount Method	*
13	VOLUME	☐	CRM_MKTPL_VOLUME	CRM_MKTPL_VOLUME	CHAR	4	0	Related Volume	*
14	PARTICIP_RATE	☐	CRM_MKTPL_PARTICIP_RATE	CRM_MKTPL_PARTICIP_RATE	CHAR	3	0	Participation Rate (0-100%)
15	START_DATE	☐	CRM_MKTPL_TSPEND_STARTDATE	BCOS_TSTMP	DEC	15	0	Trade Spend Start Date
16	END_DATE	☐	CRM_MKTPL_TSPEND_ENDDATE	BCOS_TSTMP	DEC	15	0	Trade Spend End Date
17	COND_GENERATED	☐	CRM_MKTPL_COND_GENERATED	CRM_MKTPL_COND_GENERATED	CHAR	1	0	Condition Generated (Indicator)
18	REBATE_STAT	☐	CRM_MKTPL_REBATE_STAT	CRM_MKTPL_REBATE_STAT	CHAR	1	0	Rebate Status
19	DATES_MODIFIED	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
20	TAKE_RATE	☐	CRM_MKTGS_TAKE_RATE	CRM_MKTGS_TAKE_RATE	NUMC	3	0	Take Rate
21	SPEND_VALUE	☐	CRM_MKTGS_SPEND_VALUE	CRM_MKTGS_SPEND_VALUE	CURR	20	2	Spend Value
22	OI_CAP	☐	CRM_MKTGS_OI_CAP	CRM_MKTGS_OI_CAP	CURR	20	2	Off Invoice Cap
23	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	*
24	OI_CAP_CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	*
25	DATE_RANGE_TYPE	☐	CRM_MKTGS_IB_DATE_TYPE		CHAR	10	0	Date type for the IBOM layer
26	DATE_RANGE_ID	☐	CRM_MKTPL_DATE_ID	CRM_MKTPL_DATE_ID	NUMC	2	0	Unique Identifier for Additional Date Ranges
27	.INCLUDE	☐				0	0	Extensibility Include - Trade Spend
28	MKTPL_TRADESPEND	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
29	.INCLUDE	☐				0	0	Include structure for Claims related data
30	SETTL_CALENDAR	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
31	.INCLUDE	☐				0	0	Extensibility table for QE Trade Spend Overview
32	MKTPL_QE_TSPEND	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
33	INFO_OBJECT_COST	☐	CGPL_SEM_CHANM	RSIOBJNM	CHAR	30	0	SEM-API: Characteristic
34	INFO_OBJECT_VOLUME	☐	CGPL_SEM_CHANM	RSIOBJNM	CHAR	30	0	SEM-API: Characteristic
35	COST_TYPE_TEXT	☐	CRM_MKTPL_COST_TEXT	CRM_MKTPL_COST_TEXT	CHAR	20	0	Spend Type
36	CAT_TYPE_TEXT	☐	CRM_MKTPL_COST_CAT_DESC	CRM_MKTPL_COST_CAT_DESC	CHAR	40	0	Spend Category
37	SPEND_METHOD_TXT	☐	CRM_MKTPL_SPEND_METHOD_TEXT	CRM_MKTPL_SPEND_METHOD_TEXT	CHAR	20	0	Spend Method Description
38	DISC_METHOD_TXT	☐	CRM_MKTPL_DISC_METH_DESC	CRM_MKTPL_DISC_METH_DESC	CHAR	20	0	Discount Method Description
39	COND_GENERATED_TEXT	☐	CRM_MKTPL_COND_GENERATED_TEXT	CRM_MKTPL_COND_GENERATED_TEXT	CHAR	60	0	Cond Generated Text (From The Domain) - Language-Dependent
40	PAYMENT_TYPE_TXT	☐	CRMT_BUAG_PAYM_T	TEXT30	CHAR	30	0	Text for Payment Method
41	VOLUME_TEXT	☐	CRM_MKTPL_VOLUME_TEXT	CRM_MKTPL_VOLUME_TEXT	CHAR	20	0	Related Volume Text
42	REBATE_STAT_TEXT	☐	CRM_MKTPL_REBATE_STAT_TEXT	CRM_MKTPL_REBATE_STAT_TEXT	CHAR	60	0	Rebate Status Text (From the Domain) - Language-Dependent
43	KAPPL	☐	/SAPCND/APPLICATION	/SAPCND/APPLICATION	CHAR	3	0	Application as Condition Technique	/SAPCND/T681A
44	KVEWE	☐	/SAPCND/USAGE	/SAPCND/USAGE	CHAR	2	0	Usage for Condition Technique	/SAPCND/T681V
45	KSCHL	☐	CRM_MKTPL_KSCHL_PR	/SAPCND/COND_TYPE	CHAR	4	0	Conition Type for Pricing	/SAPCND/T685
46	AG_TYPE	☐	/BON/AG_TYPE	CHAR4	CHAR	4	0	Agreement Type	/BON/C_AG_TYPE
47	CELL_STYLES	☐	CRM_MKTPL_CELL_STYLES_TAB		TTYP	0	0
48	START_DATE_D	☐	CRM_BSP_MKTPL_TSPEND_STARTDATE		DATS	8	0	Trade Spend Start Date for BSP Display
49	END_DATE_D	☐	CRM_BSP_MKTPL_TSPEND_ENDDATE		DATS	8	0	Trade Spend End Date for BSP Display

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BSP_MKTPL_TS	AG_TYPE	/BON/C_AG_TYPE	TYPE
2	CRMT_BSP_MKTPL_TS	CLIENT	T000	MANDT
3	CRMT_BSP_MKTPL_TS	KSCHL	/SAPCND/T685	KSCHL
4	CRMT_BSP_MKTPL_TS	PROJECT_GUID	CGPL_PROJECT	GUID
5	CRMT_BSP_MKTPL_TS	TASK_GUID	CGPL_TASK	GUID

History

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