SAP ABAP Table CRMS_MKTPL_DATE_ATTRIBUTES (Additional date ranges related to a marketing project)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL_DATES (Package) CRM Marketing Planning: Dates Assignments

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_DATE_ATTRIBUTES	Table Relationship Diagram
Short Description	Additional date ranges related to a marketing project

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

History

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