SAP ABAP Table CRM_MRS_T_ASS_KEY_EXT_DET (Internal Format of Assignment)

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_ASS_KEY_EXT_DET	Table Relationship Diagram
Short Description	Internal Format of Assignment

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	ASSIGNMENT_KEY	☐	GUID		RAW	16	0	Globally Unique Identifier
2	DEMAND_KEY_EXT	☐	CRM_MRS_T_DEM_KEY_EXT	CHAR60	CHAR	60	0	External Demand Key
3	DEMAND_LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
4	RESOURCE_KEY	☐	GUID		RAW	16	0	Globally Unique Identifier
5	BEG_TSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
6	END_TSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
7	DURATION	☐	INT4	INT4	INT4	10	0	Natural number
8	UTIL	☐	CRM_MRS_T_UITLISATION	CRM_MRS_UITLISATION	DEC	3	0	Resource Utilization
9	APPL_STATUS	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status	*
10	STATUS_TAB	☐	CRM_MRS_T_STATUS_TAB		TTYP	0	0
11	DESCRIPTION	☐	TEXT120	TEXT120	CHAR	120	0	Text (Length 120)
12	ASS_PROB	☐	NUMC3	NUMC3	NUMC	3	0	Numc3, internal use
13	NO_TRAVEL_COST	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
14	MOBILE_INDICATOR	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
15	ASS_SUPERVISOR	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
16	RES_UTIL_RAT	☐	CRM_MRS_T_WFM_UTILISATION		FLTP	16	16	Capacity Level
17	RES_UTIL_RAT_ORG	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
18	PART_CONC_ATTR	☐	CRM_MRS_T_ASG_INFX_TAB		TTYP	0	0
19	TRAVEL_TIME_MODE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
20	TRV_DISPLAY_TO	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
21	TRV_DISPLAY_FROM	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
22	IS_RES_FIXED	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
23	IS_DATE_FIXED	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
24	UTILIZ	☐	CRM_MRS_T_UITLISATION	CRM_MRS_UITLISATION	DEC	3	0	Resource Utilization
25	PARENT_GUID	☐	GUID		RAW	16	0	Globally Unique Identifier
26	TIME_RULE_ID	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
27	IS_CHILD	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
28	SETTLEMENT_TYPE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
29	SPLIT_NUMBER	☐	INT1	INT1	INT1	3	0	Dummy for B20 int1 (Local Everywhere)
30	TEXT	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
31	ASSIGNMENT_TYPE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
32	DEMAND	☐	CRM_MRS_T_SGE_INH_ASS_FROM_DEM		STRU	0	0
33	STATUS_TAB	☐	CRM_MRS_T_STATUS_TAB		TTYP	0	0
34	SUPERVISOR	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
35	TRV_TO_BEGIN	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
36	TRV_TO_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
37	TRV_TO_DURATION	☐	INT4	INT4	INT4	10	0	Natural number
38	TRV_TO_DUR_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
39	TRV_TO_DISTANCE	☐	CRM_MRS_T_TRV_FROM_DISTANCE	GEODIST	DEC	15	6	Departure Distance
40	TRV_TO_DIS_UNIT	☐	CRM_MRT_TRV_FROM_DISTANCE_UNIT		UNIT	3	0	Travel-from distance unit
41	TRV_TO_MANU_SET	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
42	TRV_TO_PROFILE	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
43	TRV_FRM_BEGIN	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
44	TRV_FRM_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
45	TRV_FRM_DURATION	☐	INT4	INT4	INT4	10	0	Natural number
46	TRV_FRM_DUR_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
47	TRV_FRM_DISTANCE	☐	CRM_MRS_T_TRV_FROM_DISTANCE	GEODIST	DEC	15	6	Departure Distance
48	TRV_FRM_DIS_UNIT	☐	CRM_MRT_TRV_FROM_DISTANCE_UNIT		UNIT	3	0	Travel-from distance unit
49	TRV_FRM_MANU_SET	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
50	TRV_FRM_PROFILE	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6

History

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