SAP ABAP Table CRMT_DATES_DB_WRK (Work Area of Date Management in Database Buffer)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-DAT (Application Component) Date Management
     ⤷ CRM_DATES (Package) CRM Date Details

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_DATES_DB_WRK	Table Relationship Diagram
Short Description	Work Area of Date Management in Database Buffer

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	Work Area of Appointment Processing at Runtime
2	.INCLUDE	☐				0	0	Work Area of Appointment Processing at Runtime
3	.INCLUDE	☐				0	0	Internal identification for a date
4	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	APPT_GUID	☐	SC_APTGUID	SYSUUID	RAW	16	0	GUID of Appointment
6	.INCLUDE	☐				0	0	Externally influential details for a date
7	.INCLUDE	☐				0	0	Shared external attributes in date processing
8	.INCLUDE	☐				0	0	Shared external core attributues in date processing
9	APPT_TYPE	☐	CRMT_APPTYPE	SC_APPTTYP	CHAR	12	0	Technical Name for Date Type	*
10	TIMESTAMP_FROM	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
11	TIMEZONE_FROM	☐	CRMT_TIMEZONE_FROM	TZNZONE	CHAR	6	0	Time Zone for a Start Time	TTZZ
12	TIMESTAMP_TO	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
13	TIMEZONE_TO	☐	CRMT_TIMEZONE_TO	TZNZONE	CHAR	6	0	Time Zone for End Time	TTZZ
14	RULE_ID	☐	SC_RULEID	TEXT25	CHAR	25	0	Internal Identification of Rules of Periodic Appointments
15	.INCLUDE	☐				0	0	External attribute in appointment class CL_APPOINTMENT_FULL
16	SHOW_LOCAL	☐	SC_SHOWLOC	FLAG	CHAR	1	0	Display appointment in the local time of the appointment
17	DOMINANT	☐	CRMT_DATES_DOMINANT	CRM_DATES_DOMINANT	CHAR	1	0	All Day Event
18	.INCLUDE	☐				0	0	Shared external attributes in date processing
19	RULE_GUID	☐	CRMT_DATES_RULE_GUID	TIMERULEID	RAW	16	0	Rule GUID to Calculate a Date	TIMERULEH
20	RULE_NAME	☐	CRMT_DATES_RULE_NAME	TIMENAME	CHAR	12	0	Semantic Name of a Date Rule
21	.INCLUDE	☐				0	0	Durations in date processing
22	DURATION	☐	TIMEDURA	TIMEDURA	DEC	13	0	Numerical Value of Duration
23	TIME_UNIT	☐	TIMEUNITDU	TIMEUNITNA	CHAR	12	0	Default Value for Time Unit	*
24	IS_DURATION	☐	CRMT_IS_DURATION	CRM_BOOLEAN	CHAR	1	0	Indicates a Date as Duration in Date Definition
25	.INCLUDE	☐				0	0	Internal controlling fields in date processing
26	.INCLUDE	☐				0	0	Link GUID for date set
27	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
28	.INCLUDE	☐				0	0	Internal appointment attributes in date processing
29	DESCRIPTION	☐	SC_TXTSHOR	TEXT120	CHAR	120	0	Short text
30	CLASS_ID	☐	SC_CLASSID	SC_CLASSID	CHAR	1	0	Visibility for Other Users
31	PRIORITY	☐	SC_PRIOIND	SC_PRIO	NUMC	1	0	Appointment priority	SCPRIO
32	STATUS_TYPE	☐	SC_STATIND	SC_STATIND	CHAR	1	0	Appointment Management: Status of an Appointment
33	EXIT_INFO	☐	SC_EXITINF	CHAR60	CHAR	60	0	User exit information
34	OWNER	☐	SC_OWNER	SC_OWNER	CHAR	12	0	Owner of an Appointment Calendar	*
35	BUSY	☐	SC_BUSYIND	SC_BUSYIND	CHAR	1	0	Status for Search for Times Without Appointments
36	.INCLUDE	☐				0	0	Internal shared attributes in date processing
37	SEOCLSNAME	☐	SEOCLSNAME	SEOCLSNAME	CHAR	30	0	Object Type Name
38	APPT_ID	☐	SC_APPTID	TEXT25	CHAR	25	0	General appointment ID
39	.INCLUDE	☐				0	0	Dynamic attributes for runtime in CRM date processing
40	.INCLUDE	☐				0	0	Dynamic Attributes for Runtime of an Appointment
41	DATE_FROM	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
42	DATE_TO	☐	SC_DATETO	DATUM	DATS	8	0	End Date
43	TIME_FROM	☐	SC_TIMEFRO	SYTIME	TIMS	6	0	From Time
44	TIME_TO	☐	SC_TIMETO	SYTIME	TIMS	6	0	To Time
45	CALENDAR	☐	CRMT_CALENDAR	CRM_BOOLEAN	CHAR	1	0	Include Activity in Calendar
46	.INCLUDE	☐				0	0	Dynamic attributes for runtime in CRM date processing
47	IS_MILESTONE	☐	TIMEFLMIL	FLAG	CHAR	1	0	Date is a Milestone
48	IS_EXTERNAL	☐	CRMT_EXTERNAL_PERSISTENCE	CRMT_EXTERNAL_PERSISTENCE	CHAR	1	0	Folder is Taken Over by Initiator (not in date set)
49	MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
50	DELETED_FLAG	☐	CRMT_DELETED_FLAG	CRM_BOOLEAN	CHAR	1	0	Indicator whether the object is marked for deletion

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_DATES_DB_WRK	CLIENT	T000	MANDT	KEY	1	CN
2	CRMT_DATES_DB_WRK	PRIORITY	SCPRIO	PRIORITY	KEY	1	CN
3	CRMT_DATES_DB_WRK	RULE_GUID	TIMERULEH	RULE_ID	KEY	1	CN
4	CRMT_DATES_DB_WRK	TIMEZONE_FROM	TTZZ	TZONE	KEY	1	CN
5	CRMT_DATES_DB_WRK	TIMEZONE_TO	TTZZ	TZONE	KEY	1	CN

History

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