SAP ABAP Table COMT_BSP_TDAR_LINE (Rule Line With All Rule Types)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP-TDA (Application Component) Periodically Valid Appointment Rules
     ⤷ CRM_BUPA_TDAR (Package) CRM BP Time-Dependent Appointment Rules

Basic Data

Table Category	INTTAB	Structure
Structure	COMT_BSP_TDAR_LINE	Table Relationship Diagram
Short Description	Rule Line With All Rule Types

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	Rule Line with All Rule Types
2	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
3	OBJECT_TYPE	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
4	TITLE	☐	STRINGVAL		STRG	0	0	String
5	.INCLUDE	☐				0	0	Rules for Regular Appointments
6	TYPE	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
7	START_DATE	☐	COMT_BSP_TIME_SC_STARTDAT	DATUM	DATS	8	0	Start Date for Rule Period
8	END_DATE	☐	COMT_BSP_TIME_SC_ENDDATE	DATUM	DATS	8	0	End Date for Rule Period
9	CONFLICTS	☐	COMT_BSP_TIME_SC_CONFLICT	CHAR1	CHAR	1	0	Exception Rule for Non-Working Days
10	FACTORY_CALENDAR	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
11	HOLIDAY_CALENDAR	☐	HIDENT	HIDENT	CHAR	2	0	Public Holiday Calendar	*
12	NO_CALENDAR	☐	COMT_BSP_TIME_SC_GREINDI	CHAR1	CHAR	1	0	Gregorian Calendar
13	RULE	☐	CHAR200	CHAR200	CHAR	200	0	Text field length 200
14	INFO_DEL	☐	SC_MAINTID	CHAR1	CHAR	1	0	Maintenance identifier
15	RULE_INDEX	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
16	RULE_REF	☐	SCREFCNT		INT4	10	0	Reference counter
17	.INCLUDE	☐				0	0	Regular Weekly Appointments
18	WEEKS	☐	COMT_BSP_TIME_SC_RULEWNO	CHAR2	CHAR	2	0	Number of Weeks in the Week Rule
19	MONDAY	☐	COMT_BSP_TIME_MO_RULEWD	CHAR1	CHAR	1	0	Monday Active?
20	TUESDAY	☐	COMT_BSP_TIME_TU_RULEWD	CHAR1	CHAR	1	0	Tuesday Active?
21	WEDNESDAY	☐	COMT_BSP_TIME_WE_RULEWD	CHAR1	CHAR	1	0	Wednesday Active?
22	THURSDAY	☐	COMT_BSP_TIME_TH_RULEWD	CHAR1	CHAR	1	0	Thursday Active?
23	FRIDAY	☐	COMT_BSP_TIME_FR_RULEWD	CHAR1	CHAR	1	0	Friday Active?
24	SATURDAY	☐	COMT_BSP_TIME_SA_RULEWD	CHAR1	CHAR	1	0	Saturday Active?
25	SUNDAY	☐	COMT_BSP_TIME_SU_RULEWD	CHAR1	CHAR	1	0	Sunday Active?
26	MONDA_FROM	☐	COMT_BSP_SC_RULEWFR	TIME	TIMS	6	0	Start Time on this Weekday
27	TUESD_FROM	☐	COMT_BSP_SC_RULEWFR	TIME	TIMS	6	0	Start Time on this Weekday
28	WEDNE_FROM	☐	COMT_BSP_SC_RULEWFR	TIME	TIMS	6	0	Start Time on this Weekday
29	THURS_FROM	☐	COMT_BSP_SC_RULEWFR	TIME	TIMS	6	0	Start Time on this Weekday
30	FRIDA_FROM	☐	COMT_BSP_SC_RULEWFR	TIME	TIMS	6	0	Start Time on this Weekday
31	SATUR_FROM	☐	COMT_BSP_SC_RULEWFR	TIME	TIMS	6	0	Start Time on this Weekday
32	SUNDA_FROM	☐	COMT_BSP_SC_RULEWFR	TIME	TIMS	6	0	Start Time on this Weekday
33	MONDAY_TO	☐	COMT_BSP_SC_RULEWTO	TIME	TIMS	6	0	Finish Time on This Weekday
34	TUESDAY_TO	☐	COMT_BSP_SC_RULEWTO	TIME	TIMS	6	0	Finish Time on This Weekday
35	WEDNESD_TO	☐	COMT_BSP_SC_RULEWTO	TIME	TIMS	6	0	Finish Time on This Weekday
36	THURSDA_TO	☐	COMT_BSP_SC_RULEWTO	TIME	TIMS	6	0	Finish Time on This Weekday
37	FRIDAY_TO	☐	COMT_BSP_SC_RULEWTO	TIME	TIMS	6	0	Finish Time on This Weekday
38	SATURDA_TO	☐	COMT_BSP_SC_RULEWTO	TIME	TIMS	6	0	Finish Time on This Weekday
39	SUNDAY_TO	☐	COMT_BSP_SC_RULEWTO	TIME	TIMS	6	0	Finish Time on This Weekday
40	MOND_TZONE	☐	COMT_BSP_SC_RULEWTZ	TZNZONE	CHAR	6	0	Time Zone for This Weekday	*
41	TUES_TZONE	☐	COMT_BSP_SC_RULEWTZ	TZNZONE	CHAR	6	0	Time Zone for This Weekday	*
42	WEDN_TZONE	☐	COMT_BSP_SC_RULEWTZ	TZNZONE	CHAR	6	0	Time Zone for This Weekday	*
43	THUR_TZONE	☐	COMT_BSP_SC_RULEWTZ	TZNZONE	CHAR	6	0	Time Zone for This Weekday	*
44	FRID_TZONE	☐	COMT_BSP_SC_RULEWTZ	TZNZONE	CHAR	6	0	Time Zone for This Weekday	*
45	SATU_TZONE	☐	COMT_BSP_SC_RULEWTZ	TZNZONE	CHAR	6	0	Time Zone for This Weekday	*
46	SUND_TZONE	☐	COMT_BSP_SC_RULEWTZ	TZNZONE	CHAR	6	0	Time Zone for This Weekday	*
47	MONDY_OVER	☐	SC_RULEWOV	INT1	INT1	3	0	Number of skipped days for this weekday
48	TUESD_OVER	☐	SC_RULEWOV	INT1	INT1	3	0	Number of skipped days for this weekday
49	WEDNE_OVER	☐	SC_RULEWOV	INT1	INT1	3	0	Number of skipped days for this weekday
50	THURS_OVER	☐	SC_RULEWOV	INT1	INT1	3	0	Number of skipped days for this weekday
51	FRIDA_OVER	☐	SC_RULEWOV	INT1	INT1	3	0	Number of skipped days for this weekday
52	SATUR_OVER	☐	SC_RULEWOV	INT1	INT1	3	0	Number of skipped days for this weekday
53	SUNDA_OVER	☐	SC_RULEWOV	INT1	INT1	3	0	Number of skipped days for this weekday
54	MONTH_N	☐	COMT_BSP_SC_MONTH_N	CHAR2	CHAR	2	0	Month in Year
55	OVER_M1	☐	SC_RULEWOV	INT1	INT1	3	0	Number of skipped days for this weekday
56	DAY_NR	☐	COMT_BSP_DAYNR	INT2	INT2	5	0	Frequency in Days
57	WEEKDAY_NR	☐	WOTNR	CHAR1	CHAR	1	0	Calendar: Number of day
58	MONTHS_N	☐	COMT_BSP_SC_MONTH_N	CHAR2	CHAR	2	0	Month in Year
59	OVER_M3	☐	SC_RULEWOV	INT1	INT1	3	0	Number of skipped days for this weekday
60	YEAR_FROM	☐	COMT_BSP_TIME_SC_YEAR	CHAR4	CHAR	4	0	Year
61	MONTH_FROM	☐	COMT_BSP_TIME_SC_MONTH	CHAR2	CHAR	2	0	Month in Year
62	DAY_FROM	☐	COMT_BSP_TIME_SC_DAY	CHAR2	CHAR	2	0	Day in Month
63	ZONE_FROM	☐	COMT_BSP_SC_RULEWTZ	TZNZONE	CHAR	6	0	Time Zone for This Weekday	*
64	YEAR_TO	☐	COMT_BSP_TIME_SC_YEAR	CHAR4	CHAR	4	0	Year
65	MONTH_TO	☐	COMT_BSP_TIME_SC_MONTH	CHAR2	CHAR	2	0	Month in Year
66	DAY_TO	☐	COMT_BSP_TIME_SC_DAY	CHAR2	CHAR	2	0	Day in Month
67	ZONE_TO	☐	COMT_BSP_SC_RULEWTZ	TZNZONE	CHAR	6	0	Time Zone for This Weekday	*
68	DAYS	☐	SCDAYS	CHAR3	CHAR	3	0	Number of Days Between Appointments
69	OVER	☐	SC_RULEWOV	INT1	INT1	3	0	Number of skipped days for this weekday
70	TIME_FROM	☐	COMT_BSP_SC_RULEWFR	TIME	TIMS	6	0	Start Time on this Weekday
71	TIME_TO	☐	COMT_BSP_SC_RULEWTO	TIME	TIMS	6	0	Finish Time on This Weekday
72	TZONE	☐	COMT_BSP_SC_RULEWTZ	TZNZONE	CHAR	6	0	Time Zone for This Weekday	*
73	.INCLUDE	☐				0	0	Calendar Control
74	FACTORY_CALENDAR_ACTIV	☐	DDBOOL_D	DDBOOL	CHAR	1	0	DD: truth value
75	HOLIDAY_CALENDAR_ACTIV	☐	DDBOOL_D	DDBOOL	CHAR	1	0	DD: truth value
76	.INCLUDE	☐				0	0	Monthly Rule Control
77	M1_ACTIV	☐	DDBOOL_D	DDBOOL	CHAR	1	0	DD: truth value
78	M2_ACTIV	☐	DDBOOL_D	DDBOOL	CHAR	1	0	DD: truth value
79	.INCLUDE	☐				0	0	Time-Dependent Appt. Rules: Structure of the Field Catalog
80	PERIOD_TYPE	☐	CRMT_BU_TDAR_PERIOD_TYPE	CRM_BU_TDAR_PERIOD_TYPE	CHAR	8	0	Time-Dependent Appointment Rules: Validity Period Category
81	DATE_FROM	☐	CRMT_BU_TDAR_DATE_FROM	DATUM	DATS	8	0	Time-Dependent Appointment Rules: Valid From (YYYYMMDD)
82	DATE_TO	☐	CRMT_BU_TDAR_DATE_TO	DATUM	DATS	8	0	Time-Dependent Appointment Rules: Valid To (YYYYMMDD)
83	CW_FROM	☐	CRMT_BU_TDAR_CW_YEAR_FROM	CRM_BU_TDAR_CW_YEAR	CHAR	7	0	Time-Dependent Appt. Rules: Calendar Week and Year (WW/YYYY)
84	CW_TO	☐	CRMT_BU_TDAR_CW_YEAR_TO	CRM_BU_TDAR_CW_YEAR	CHAR	7	0	Time-Dependent Appt. Rules: Calendar Week and Year (WW/YYYY)
85	PERIOD_ID	☐	CRMT_BU_TDAR_PP_YEAR	CRM_BU_TDAR_PP_YEAR	CHAR	9	0	Time-Dep. Appt. Rules: Predef. Period and Year (PPPP/YYYY)
86	RECURRING_END	☐	CRMT_BU_TDAR_YEAR	BU_YEAR	NUMC	4	0	Time-Dependent Appointment Rules: Year YYYY
87	PERIOD_PP	☐	CRMT_BU_TDAR_PP	CRM_BU_TDAR_PP	CHAR	4	0	Time-Dependent Appt. Rules: Predefined Period (Indicator)
88	PERIOD_YEAR	☐	CRMT_BU_TDAR_PERIODYEAR	BU_YEAR	NUMC	4	0	Time-Dependent Appointment Rules: Year YYYY
89	PROC_TIME	☐	CRMT_BU_TDAR_PROC_TIME	CRM_BU_TDAR_PROC_TIME	INT4	10	0	Time-Dependent Appointment Rules: Processing Time

History

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