SAP ABAP Table MKTCRM_MKTPL_COA_CD (Change Document Structure; Generated by RSSCD000)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL (Package) CRM Marketing Planning - User Interfaces

Basic Data

Table Category	INTTAB	Structure
Structure	MKTCRM_MKTPL_COA_CD	Table Relationship Diagram
Short Description	Change Document Structure; Generated by RSSCD000

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	Marketing Planning: Change Doc. Struct. for CRMD_MKTPL_COSTA
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
4	PROJECT_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts	CGPL_PROJECT
5	TASK_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts	CGPL_TASK
6	.INCLUDE	☐				0	0	CRM Marketing Planning: Include Structure Trade Spend
7	COST_TYPE	☐	CRM_MKTPL_COST_TYPE	CRM_MKTPL_COST_TYPE	CHAR	4	0	Spend Type	CRMC_MKTPL_COST
8	COST_CATEGORY	☐	CRM_MKTPL_COST_CAT	CRM_MKTPL_COST_CAT	CHAR	30	0	Spend Category	CRMC_MKTPL_COS0
9	SPEND_METHOD	☐	CRM_MKTPL_SPEND_METHOD	CRM_MKTPL_SPEND_METHOD	CHAR	10	0	Spend Method for Key Figure Planning	CRMC_MKTPL_COS1
10	PMNT_TYPE	☐	CRMT_BUAG_PAYMETH	CRM_BUAG_PAYMETH	CHAR	1	0	Payment Method	CRMC_BUAG_PAYM
11	DISC_METHOD	☐	CRM_MKTPL_DISC_METH	CRM_MKTPL_DISC_METH	CHAR	4	0	Discount Method	CRMC_MKTPL_DISC
12	VOLUME	☐	CRM_MKTPL_VOLUME	CRM_MKTPL_VOLUME	CHAR	4	0	Related Volume	CRMC_MKTPL_COS5
13	PARTICIP_RATE	☐	CRM_MKTPL_PARTICIP_RATE	CRM_MKTPL_PARTICIP_RATE	CHAR	3	0	Participation Rate (0-100%)
14	START_DATE	☐	CRM_MKTPL_TSPEND_STARTDATE	BCOS_TSTMP	DEC	15	0	Trade Spend Start Date
15	END_DATE	☐	CRM_MKTPL_TSPEND_ENDDATE	BCOS_TSTMP	DEC	15	0	Trade Spend End Date
16	COND_GENERATED	☐	CRM_MKTPL_COND_GENERATED	CRM_MKTPL_COND_GENERATED	CHAR	1	0	Condition Generated (Indicator)
17	REBATE_STAT	☐	CRM_MKTPL_REBATE_STAT	CRM_MKTPL_REBATE_STAT	CHAR	1	0	Rebate Status
18	DATES_MODIFIED	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
19	TAKE_RATE	☐	CRM_MKTGS_TAKE_RATE	CRM_MKTGS_TAKE_RATE	NUMC	3	0	Take Rate
20	SPEND_VALUE	☐	CRM_MKTGS_SPEND_VALUE	CRM_MKTGS_SPEND_VALUE	CURR	20	2	Spend Value
21	OI_CAP	☐	CRM_MKTGS_OI_CAP	CRM_MKTGS_OI_CAP	CURR	20	2	Off Invoice Cap
22	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	*
23	OI_CAP_CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	*
24	DATE_RANGE_TYPE	☐	CRM_MKTGS_IB_DATE_TYPE		CHAR	10	0	Date type for the IBOM layer
25	DATE_RANGE_ID	☐	CRM_MKTPL_DATE_ID	CRM_MKTPL_DATE_ID	NUMC	2	0	Unique Identifier for Additional Date Ranges
26	.INCLUDE	☐				0	0	Extensibility Include - Trade Spend
27	MKTPL_TRADESPEND	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
28	.INCLUDE	☐				0	0	Extensibility table for QE Trade Spend Overview
29	MKTPL_QE_TSPEND	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
30	.INCLUDE	☐				0	0	Structures for generating change document update programs
31	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MKTCRM_MKTPL_COA_CD	CLIENT	T000	MANDT
2	MKTCRM_MKTPL_COA_CD	COST_CATEGORY	CRMC_MKTPL_COS0	COST_CATEGORY
3	MKTCRM_MKTPL_COA_CD	COST_TYPE	CRMC_MKTPL_COST	COST_TYPE
4	MKTCRM_MKTPL_COA_CD	DISC_METHOD	CRMC_MKTPL_DISC	DISC_METHOD
5	MKTCRM_MKTPL_COA_CD	PMNT_TYPE	CRMC_BUAG_PAYM	PAYM_METH
6	MKTCRM_MKTPL_COA_CD	PROJECT_GUID	CGPL_PROJECT	GUID
7	MKTCRM_MKTPL_COA_CD	SPEND_METHOD	CRMC_MKTPL_COS1	SPEND_METHOD
8	MKTCRM_MKTPL_COA_CD	TASK_GUID	CGPL_TASK	GUID
9	MKTCRM_MKTPL_COA_CD	VOLUME	CRMC_MKTPL_COS5	VOLUME

History

Last changed by/on	SAP	20130604
SAP Release Created in