SAP ABAP Table CRMS_WFD_AVAILABILITY (Availability Template Link data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-RPL-SRV (Application Component) Service Resource Planning
     ⤷ CRM_WFD_COMMON (Package) CRM WFD Common Dictionary Objects

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_WFD_AVAILABILITY	Table Relationship Diagram
Short Description	Availability Template Link data

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	TEMPLATE_LINK_ID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
2	TEMPLATE_KEY	☐	CRME_WFD_AVL_TEMPLATE		CHAR	12	0	Availability Template Key
3	TEMPLATE_DESCRIPTION	☐	CRME_WFD_DESCR		CHAR	40	0	Description field
4	RULE_ID	☐	CRME_WFD_RULE_ID	CHAR10	CHAR	10	0	WFD Rule ID
5	RULE_DESCRIPTION	☐	CRME_WFD_RULE_DESCR		CHAR	40	0	Rule Description field
6	VALID_FROM	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
7	VALID_TO	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
8	TIMESPEC_GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
9	TIMESPECTYPE	☐	CRME_WFD_TIME_ALLOC_TYPE		CHAR	10	0	Time Allocation Type
10	RULE_TYPE	☐	CRME_WFD_RULE_TYPE	CRM_WFD_RULE_TYPE	CHAR	2	0	WFD type of recurrence for a rule
11	FACTORY_CALENDAR	☐	SC_FACID	WFCID	CHAR	2	0	Factory calendar	*
12	START_DATE	☐	CRME_WFD_RULE_START	DATUM	DATS	8	0	Rule Start
13	END_DATE	☐	CRME_WFD_RULE_END	DATUM	DATS	8	0	Rule End
14	TIME_FROM	☐	BEGUZ	UZEIT	TIMS	6	0	Start Time
15	TIME_TO	☐	ENDUZ	UZEIT	TIMS	6	0	End Time
16	TZONE	☐	CRME_WFD_TIMEZONE	TZNZONE	CHAR	6	0	Timezone	*
17	.INCLUDE	☐				0	0	Week rule customizing
18	WEEKS	☐	CRME_WFD_WEEKS	CHAR2	CHAR	2	0	number of weeks
19	MONDAY	☐	CRME_WFD_MONDAY	BOOLE	CHAR	1	0	Monday
20	TUESDAY	☐	CRME_WFD_TUESDAY	BOOLE	CHAR	1	0	Tuesday
21	WEDNESDAY	☐	CRME_WFD_WEDNESDAY	BOOLE	CHAR	1	0	Wednesday
22	THURSDAY	☐	CRME_WFD_THURSDAY	BOOLE	CHAR	1	0	Thursday
23	FRIDAY	☐	CRME_WFD_FRIDAY	BOOLE	CHAR	1	0	Friday
24	SATURDAY	☐	CRME_WFD_SATURDAY	BOOLE	CHAR	1	0	Saturday
25	SUNDAY	☐	CRME_WFD_SUNDAY	BOOLE	CHAR	1	0	Sunday
26	.INCLUDE	☐				0	0	Month rule customizing M1
27	R_DAYS	☐	CRME_WFD_DAYS	CHAR2	CHAR	2	0	Number of day in month
28	R_MONTH	☐	CRME_WFD_MONTH	CHAR2	CHAR	2	0	number of months
29	.INCLUDE	☐				0	0	Month rule customizing M3
30	DAY_NR	☐	CRME_WFD_DAY_NR	CRM_WFD_DAY_NR	INT2	5	0	day in month
31	WEEKDAY_NR	☐	CRME_WFD_WEEKDAY_NR	CRM_WFD_WEEKDAY_NR	CHAR	1	0	weekday
32	R_MONTHS	☐	CRME_WFD_MONTHS	CHAR2	CHAR	2	0	number of months

History

Last changed by/on	SAP	20070911
SAP Release Created in	510