SAP ABAP Table CRMS_MKTPL_BRF_PLNDATE_ATT_VER (MKTPL OL: mkt prj plan date for Versioning)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-TPM (Application Component) Trade Promotion Management
     ⤷ CRM_MKTPL_BRF_FRX (Package) Business Rules for Marketing Objects (TPMs)

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_BRF_PLNDATE_ATT_VER	Table Relationship Diagram
Short Description	MKTPL OL: mkt prj plan date for Versioning

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	Additional date ranges related to a marketing project
2	PROJECT_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
3	TASK_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
4	DESCRIPTION	☐	CRM_MKTPL_DATE_LABEL	CRM_MKTPL_DATE_LABEL	CHAR	20	0	Label for Additional Date Ranges
5	.INCLUDE	☐				0	0	Additional date ranges related to a marketing project
6	CAMP_GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
7	GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
8	DATE_ID	☐	CRM_MKTPL_DATE_ID	CRM_MKTPL_DATE_ID	NUMC	2	0	Unique Identifier for Additional Date Ranges
9	START_DATE	☐	CRM_MKTPL_START_DATE_RANGES	BCOS_TSTMP	DEC	15	0	Additional Start Date Range
10	END_DATE	☐	CRM_MKTPL_END_DATE_RANGES	BCOS_TSTMP	DEC	15	0	Additional End Date Range
11	DURATION	☐	CRM_MKTPL_DEF_DUR	CRM_MKTPL_DEF_DUR	DEC	10	2	Duration
12	UNIT_OF_DUR	☐	CRM_MKTPL_UNIT_OF_DUR		CHAR	1	0	Unit of Duration
13	OFFSET_INI	☐	CRM_MKTPL_DEF_OFFSET	CRM_MKTPL_DEF_OFFSET	INT4	10	0	Offset used to Determine Date from Reference
14	REF_DATE_INI	☐	CRM_MKTPL_DEF_REFDATE	CRM_MKTPL_DEF_REFDATE	CHAR	1	0	Reference Date
15	OFFSET_FIN	☐	CRM_MKTPL_DEF_OFFSET	CRM_MKTPL_DEF_OFFSET	INT4	10	0	Offset used to Determine Date from Reference
16	REF_DATE_FIN	☐	CRM_MKTPL_DEF_REFDATE	CRM_MKTPL_DEF_REFDATE	CHAR	1	0	Reference Date
17	TEXT	☐	CRM_MKTPL_DATE_LABEL	CRM_MKTPL_DATE_LABEL	CHAR	20	0	Label for Additional Date Ranges
18	PERIOD_TYPE	☐	CRM_MKTPL_Y_PERTYPE		NUMC	2	0	Period Type for Planning (0PERIOD_TYP)
19	BUY_PAT	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
20	OBJECT_CLASS	☐	CRM_MKTPL_OBJ_CLASS	CRM_MKTPL_OBJECT_CLASS	CHAR	3	0	Category of Marketing Project	*
21	DATE_TYPE	☐	CRM_MKTPL_DATE_TYPE		CHAR	10	0	Date Type (Start, End)
22	DATE_NUMBER	☐	CRM_MKTPL_DATE_NUMBER		INT1	3	0	Sequence Date Number for Date Range
23	.INCLUDE	☐				0	0	Extension Include - Date Range Assignment
24	MKTPL_DATERANGE	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
25	START_DATE_DATS	☐	CRM_MKTPL_START_DATE	DATS	DATS	8	0	Start Date
26	END_DATE_DATS	☐	CRM_MKTPL_END_DATE	DATS	DATS	8	0	End Date
27	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
28	START_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
29	END_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
30	.INCLUDE	☐				0	0	Structure for date attributes on template
31	REL_START	☐	CRM_MKTPL_DATE_RELATION	CRM_MKTPL_DATE_RELATION	CHAR	2	0	Additional Date Ranges Relation
32	REL_START_OFFSET	☐	CRM_MKTPL_DATE_REL_DURATION	CRM_MKTPL_DATE_REL_DURATION	DEC	8	2	Duration of Date Range
33	REL_START_UNIT	☐	CRM_MKTPL_DATE_REL_UNIT	CRM_MKTPL_DATE_REL_UNIT	CHAR	2	0	Unit of Duration of Date Range
34	REL_RANGE_DUR	☐	CRM_MKTPL_DATE_REL_DURATION	CRM_MKTPL_DATE_REL_DURATION	DEC	8	2	Duration of Date Range
35	REL_RANGE_UNIT	☐	CRM_MKTPL_DATE_REL_UNIT	CRM_MKTPL_DATE_REL_UNIT	CHAR	2	0	Unit of Duration of Date Range
36	INACTIVE	☐	CRM_MKTPL_DATE_BOOL	CRM_MKTPL_DATE_BOOL	CHAR	1	0	Boolean
37	SINGLE_DATE	☐	CRM_MKTPL_DATE_SINGLE_IND	CRM_MKTPL_DATE_BOOL	CHAR	1	0	Single Date Indicator
38	REF_DATE_GUID	☐	CRM_MKTPL_DATE_REF_GUID	SYSUUID	RAW	16	0	Referenced Date Range Guid
39	REF_DATE_OBJECT_ID	☐	CRM_MKTGS_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	MKTGS OL: Generic Marketing External ID
40	VERSION_NO	☐	CRM_MKTGS_VERSION_NO	CRM_MKTGS_VERSION_NO	NUMC	10	0	Version Number

History

Last changed by/on	SAP	20110908
SAP Release Created in	600