SAP ABAP Table CRMS_WFD_ASSIGNMENT_MAIN (Main CRM WFD Assignment + Candidate Structure with Rules)

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_ASSIGNMENT_MAIN	Table Relationship Diagram
Short Description	Main CRM WFD Assignment + Candidate Structure with Rules

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	CRM WFD Assignment Structure
2	.INCLUDE	☐				0	0	CRM WFD Assignment common fields with Candidates
3	.INCLUDE	☐				0	0	CRM WFD Assignment GUIDS of referenced Objects
4	ASGN_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
5	ITEM_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
6	RES_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
7	ASSIGNMENT_NOTE	☐	CRMT_WFDSE_ASSIGNMENT_NOTE		STRG	0	0	WFD: Assignment Note
8	.INCLUDE	☐				0	0	CRM WFD GENIL Assignment Create Structure
9	BEG_TSTMP	☐	CRME_WFD_TIMESTAMP	TZNTSTMPS	DEC	15	0	CRM WFD Time Stamp
10	END_TSTMP	☐	CRME_WFD_TIMESTAMP	TZNTSTMPS	DEC	15	0	CRM WFD Time Stamp
11	DURATION	☐	INT4	INT4	INT4	10	0	Natural number
12	PARENT_KEY	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
13	ROOT_KEY	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
14	BOOKING_TYPE	☐	CRME_WFD_BOOKING_TYPE	CRM_WFD_BOOKING_TYPE	CHAR	1	0	Booking Type
15	CONCRETE	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
16	WTIME_BASED	☐	CRME_WFD_WORKING_TIME_BASED	CRM_WFD_BOOLEAN	CHAR	1	0	Indicates if an Assignment should be based on Working Time
17	RULE_BASED	☐	CRMT_WFDSE_TIME_RULE_BASED	CRM_WFDSE_TIME_RULE_BASED	CHAR	1	0	RPA: Indicator to Identify Date-Rule-Based Assignments
18	APPL_STATUS	☐	J_STATUS	J_STATUS	CHAR	5	0	Object status
19	DESCRIPTION	☐	CRME_WFD_SSTRING	CRM_WFD_SSTRING	SSTR	255	0	CRM WFD Short String
20	REMAINING_DURATION	☐	INT4	INT4	INT4	10	0	Natural number
21	WORK_ISOCODE_UNIT	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
22	REFINED	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
23	CREATED_BY	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
24	CREATED_AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
25	CREATED_LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
26	CREATED	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
27	CHANGED_BY	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
28	CHANGED	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
29	CHANGED_AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
30	CHANGED_LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
31	RES_UTIL_RATIO	☐	CRMT_WFDSE_WFM_UTILISATION		FLTP	16	16	WFD: Capacity Level
32	RES_UTIL_RATIO_ORIGIN	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
33	RES_TYPE	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
34	SEND_GW_MESSAGE	☐	CRME_WFD_SEND_GW_MESSAGE	CRM_WFD_SEND_GW_MESSAGE	CHAR	1	0	Determines If a Groupware Message Should Be Sent
35	GROUPWARE_SEND_ALLOWED	☐	CRME_WFD_BOOLEAN	CRM_WFD_BOOLEAN	CHAR	1	0	CRM WFD Boolean Data Element
36	GROUPWARE_SENT	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
37	GROUPWARE_DESCRIPTION	☐	CRME_WFD_STRING	STRING	STRG	0	0	CRM WFD String
38	.INCLUDE	☐				0	0	CRM WFD - Comprehensive Fields for Rules
39	.INCLUDE	☐				0	0	Recurrence Pattern Daily
40	DAILY_REC_START	☐	CRME_WFD_REC_BEG		DATS	8	0	Recurrence Start Date
41	DAILY_REC_END	☐	CRME_WFD_REC_END		DATS	8	0	Recurrence End Date
42	DAYS	☐	SCDAYS	CHAR3	CHAR	3	0	Number of Days Between Appointments
43	.INCLUDE	☐				0	0	Recurrency Pattern Weekly
44	WEEKLY_REC_START	☐	CRME_WFD_REC_BEG		DATS	8	0	Recurrence Start Date
45	WEEKLY_REC_END	☐	CRME_WFD_REC_END		DATS	8	0	Recurrence End Date
46	WEEKS	☐	CRME_WFD_REC_NUM_WEEKS		INT4	10	0	Recurrence: Number of Weeks
47	MONDAY	☐	CRME_WFD_MONDAY	BOOLE	CHAR	1	0	Monday
48	TUESDAY	☐	CRME_WFD_TUESDAY	BOOLE	CHAR	1	0	Tuesday
49	WEDNESDAY	☐	CRME_WFD_WEDNESDAY	BOOLE	CHAR	1	0	Wednesday
50	THURSDAY	☐	CRME_WFD_THURSDAY	BOOLE	CHAR	1	0	Thursday
51	FRIDAY	☐	CRME_WFD_FRIDAY	BOOLE	CHAR	1	0	Friday
52	SATURDAY	☐	CRME_WFD_SATURDAY	BOOLE	CHAR	1	0	Saturday
53	SUNDAY	☐	CRME_WFD_SUNDAY	BOOLE	CHAR	1	0	Sunday
54	.INCLUDE	☐				0	0	Reccurrence Pattern Monthly
55	MONTHLY_REC_START	☐	CRME_WFD_REC_BEG		DATS	8	0	Recurrence Start Date
56	MONTHLY_REC_END	☐	CRME_WFD_REC_END		DATS	8	0	Recurrence End Date
57	VARIANT	☐			STRG	0	0
58	M1_DAY	☐	CRME_WFD_DAYS	CHAR2	CHAR	2	0	Number of day in month
59	M1_MONTH	☐	CRME_WFD_MONTH	CHAR2	CHAR	2	0	number of months
60	M3_DAY_NR	☐	CRME_WFD_DAY_NR	CRM_WFD_DAY_NR	INT2	5	0	day in month
61	M3_WEEKDAY_NR	☐	CRME_WFD_WEEKDAY_NR	CRM_WFD_WEEKDAY_NR	CHAR	1	0	weekday
62	M3_MONTHS	☐	CRME_WFD_MONTHS	CHAR2	CHAR	2	0	number of months
63	.INCLUDE	☐				0	0	Common Data Time Rules
64	BEG_TIME	☐			TIMS	6	0
65	END_TIME	☐			TIMS	6	0
66	RULE_ZONLO	☐	TIMEZONE	TZNZONE	CHAR	6	0	Time Zone	*
67	RECURRENCE_TYPE	☐	CRME_WFD_RECURRENCE_TYPE	CRM_WFD_REOCCURENCE_TYPE	CHAR	7	0	Recurrence Type
68	.INCLUDE	☐				0	0	WFD Comprehensive Fields for Candidates
69	CANDIDATE_ACTION	☐	CRME_WFD_CANDIDATE_ACTION		CHAR	4	0	RPA Candidate Action
70	.INCLUDE	☐				0	0	CRM WFD Assignment - demand type include
71	IS_ASSIGNMENT	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
72	DEMAND_TYPE	☐	CRME_WFD_DEM_TYPE	CRM_WFD_DEM_TYPE	CHAR	1	0	Demand Type

History

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