SAP ABAP Table CRM_MRS_T_DEM_PLR (Data required for planning-relevant items)

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_DEM_PLR	Table Relationship Diagram
Short Description	Data required for planning-relevant items

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	Object
2	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
3	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
4	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
5	VAL_FROM	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
6	VAL_TO	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
7	PLAN_FROM	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
8	PLAN_TO	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
9	EARL_START	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
10	LAT_START	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
11	EARL_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
12	LAT_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
13	SCHED_FROM	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
14	SCHED_TO	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
15	DURATION	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
16	DURATION_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
17	TOTAL_WORK	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
18	TOTAL_WORK_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
19	UTIL	☐	CRM_MRS_T_UITLISATION	CRM_MRS_UITLISATION	DEC	3	0	Resource Utilization
20	MULT_RES	☐	CRM_MRS_T_SGE_MULT_RES	CRM_MRS_SGE_MULT_RES	NUMC	3	0	CRM_MRS_T_SGE_MULT_RES
21	STAT_REL	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
22	STRATEGY	☐	CRM_MRS_T_SCHEDULE_STRAT	CHAR10	CHAR	10	0	Scheduling strategy
23	PRE_ASSMT	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
24	IS_CAPACITIVE	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
25	IS_FIXED_DATE	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
26	IS_DESIRED_DATE	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
27	IS_ARRANGE_DATE	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
28	IS_RESOURCE_FIX	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable
29	REQ_PROFILE_GUID	☐	GUID		RAW	16	0	Globally Unique Identifier
30	REQ_PROFILE_ID	☐	CRM_MRS_T_REQUID	CHAR10	CHAR	10	0	Profile key
31	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
32	ACTIVITY_TYPE	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
33	TIME_RULE_ID	☐	CRM_MRS_T_TIME_RULE_ID	TEXT25	CHAR	25	0	Time Rule Id
34	RESTR_START_TYPE	☐	CRM_MRS_T_DEM_RESTRICT_START	CRM_MRS_DEM_RESTRICT_START	CHAR	1	0	Demand Start Restriction
35	RESTR_END_TYPE	☐	CRM_MRS_T_DEM_RESTRICT_END	CRM_MRS_DEM_RESTRICT_END	CHAR	1	0	Demand End Restriction
36	RESTRICT_START	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
37	RESTRICT_END	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
38	TEAM_PLANNING	☐	CRM_MRS_T_BOOLEAN	CRM_MRS_BOOLEAN	CHAR	1	0	Boolean Variable

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRM_MRS_T_DEM_PLR	OTYPE	T778O	OTYPE
2	CRM_MRS_T_DEM_PLR	PLVAR	T778P	PLVAR

History

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