SAP ABAP Table CRM_MRS_T_APPOINTMENT (Appointments)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-RPL-SRV (Application Component) Service Resource Planning
     ⤷ CRM_WFD_MRS (Package) CRM MRS Integration

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_MRS_T_APPOINTMENT	Table Relationship Diagram
Short Description	Appointments

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	EXT_KEY	☐	CRM_MRS_T_DEM_KEY_EXT	CHAR60	CHAR	60	0	External Demand Key
2	RESOURCE_KEY	☐	CRM_MRS_T_GUID	SYSUUID	RAW	16	0	GUID
3	RESOURCE_NAME	☐	CRM_MRS_T_FULL_NAME	TEXT40	CHAR	40	0	First and Last Names
4	RESOURCE_NUMBER	☐	CRM_MRS_T_RESOURCE_ID	CHAR12	CHAR	12	0	Business Partner ID
5	IS_EXTERNAL	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
6	IS_PREFERRED_TECH	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
7	SERVICE_AREA_KEY	☐	CRM_MRS_T_GUID	SYSUUID	RAW	16	0	GUID
8	SERVICE_AREA_NAME	☐	CRM_MRS_T_SRVA_SERVICE_AREA	CHAR30	CHAR	30	0	Service Area Name
9	RESOURCE_PRIORITY	☐	CRM_MRS_T_RESOURCE_PRIORITY	NUMC2	NUMC	2	0	Resource Priority
10	BEG_TSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
11	END_TSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
12	DEMAND_DURATION	☐	CRM_MRS_T_DEMAND_DURATION	MENG13	QUAN	13	3	Demand Duration
13	DEMAND_DURATION_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
14	WEEKDAY	☐	SC_DAY_TXT	WEEKDAY	CHAR	15	0	Weekdays (text)
15	NUMBER_OF_SLOTS_REQUIRED	☐	NUMC3	NUMC3	NUMC	3	0	Numc3, internal use
16	CAPACITY_LIMIT	☐	INT4	INT4	INT4	10	0	Natural number
17	OVERBOOK_LIMIT	☐	INT4	INT4	INT4	10	0	Natural number
18	CONSUMED_CAPACITY	☐	INT4	INT4	INT4	10	0	Natural number
19	REMAINING_CAPACITY	☐	INT4	INT4	INT4	10	0	Natural number
20	TOTAL	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
21	QUALIF	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
22	IS_MAND_QUALIF_OK	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
23	ROUGH_DISTANCE	☐	CRM_MRS_T_ROUGH_DISTANCE	DEC_10	DEC	10	0	Rough Distance
24	ROUGH_DISTANCE_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
25	ROUGH_TRAVEL_DURATION	☐	CRM_MRS_T_ROUGH_DIST_DURATION	DEC_10	DEC	10	0	Rough Distance Duration
26	ROUGH_TRAVEL_DURATION_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
27	SOLUTION_ID	☐	INT4	INT4	INT4	10	0	Natural number
28	OVERBOOKED	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable

History

Last changed by/on	SAP	20141013
SAP Release Created in	702