SAP ABAP Table /MRSS/T_DPR_TS_PROJECT_EXTNSN (Attributes of Project Definition (External))

Hierarchy

☛ MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
   ⤷ PM-WOC (Application Component) Maintenance Processing
     ⤷ /MRSS/DPR (Package) MRS Interface for Cprojects

Basic Data

Table Category	INTTAB	Structure
Structure	/MRSS/T_DPR_TS_PROJECT_EXTNSN	Table Relationship Diagram
Short Description	Attributes of Project Definition (External)

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	Modifiable Project Definition Attributes
2	PROJECT_ID	☐	/MRSS/T_DPR_TV_PROJECT_ID	/MRSS/_DPR_CGPL_EXTID	CHAR	24	0	Project Number
3	PRIORITY	☐	/MRSS/T_DPR_CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority
4	CONSTRAINT_TYPE	☐	/MRSS/T_DPR_START_CONSTRAINT	/MRSS/_DPR_START_CONSTRAINT	CHAR	1	0	Date Restriction for Start Date
5	START_DATE_FIX	☐	/MRSS/T_DPR_START_DATE_FIX		DATS	8	0	Restriction Start Date
6	CALENDAR_ID	☐	/MRSS/T_DPR_CALENDAR_ID	WFCID	CHAR	2	0	Calendar	TFACD
7	CONSTR_TYPE_FIN	☐	/MRSS/T_DPR_FINISH_CONSTRAINT	/MRSS/_DPR_FINISH_CONSTRAINT	CHAR	1	0	Date Restriction for End Date
8	FINISH_DATE_FIX	☐	/MRSS/T_DPR_FINISH_DATE_FIX		DATS	8	0	Fixed Default End Date
9	PRO_TYPE	☐	/MRSS/T_DPR_PRO_TYPE	/MRSS/_DPR_TYPE	CHAR	15	0	Project Type
10	CAUSE	☐	/MRSS/T_DPR_CAUSE	/MRSS/_DPR_CAUSE	CHAR	15	0	Project Reason
11	GROUPING	☐	/MRSS/T_DPR_GROUPING		CHAR	40	0	Grouping
12	SEARCH_FIELD	☐	/MRSS/T_DPR_SEARCH_FIELD		CHAR	40	0	Search Field
13	MASTER_LANGUAGE	☐	/MRSS/T_DPR_LANGU	SPRAS	LANG	1	0	Language Key	T002
14	TEMPLATE_ADMIN_ID	☐	/MRSS/T_DPR_TEMPLATE_ADMIN_ID	BU_PARTNER	CHAR	10	0	Template Administrator	*
15	CUSTOMER_ID	☐	/MRSS/T_DPR_CUSTOMER_ID	BU_PARTNER	CHAR	10	0	Customer Number	BUT000
16	SOLD_TO_PARTY_ID	☐	/MRSS/T_DPR_SOLD_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Sold-to Party Number	*
17	DESCRIPTION	☐	/MRSS/T_DPR_NAME	TEXT40	CHAR	40	0	Name
18	RESP_ORG_UNIT	☐	/MRSS/T_DPR_RESP_ORGANIZATION	HROBJID	NUMC	8	0	Organization Responsible	*
19	STAT_PROFILE_PRO	☐	/MRSS/T_DPR_STAT_PROFILE_PRO	J_STSMA	CHAR	8	0	Status Profile Template	TJ21
20	ACT_WRK_EFFORT_EXT	☐	/MRSS/T_DPR_TV_ACT_WORK_EXT	/MRSS/_DPR_WORK	QUAN	9	2	Confirmation
21	ACT_WRK_UNIT_EXT	☐	/MRSS/T_DPR_TV_ACT_WRK_UNIT	MEINS	UNIT	3	0	Confirmation Unit	*
22	PERIODTYPE	☐	/MRSS/T_DPR_PERIOD_TYPE	/MRSS/_DPR_PERIOD_TYPE	NUMC	2	0	Period Type (Week/Month/Generic Interval)
23	ALLOCATION_UNIT	☐	/MRSS/T_DPR_ALLOCATION_UNIT	MEINS	UNIT	3	0	Allocation Unit	*
24	LOCATION	☐	/MRSS/T_DPR_TV_LOCATION	/MRSS/_DPR_LOCATION	CHAR	4	0	Location
25	FORECASTED_START	☐	/MRSS/T_DPR_TV_FORECAST_START		DATS	8	0	Forecasted Start Date
26	FORECASTED_FINISH	☐	/MRSS/T_DPR_TV_FORECAST_FINISH		DATS	8	0	Forecasted Finish Date
27	SORT_OVERALL	☐	/MRSS/T_DPR_TV_SORT_OVERALL	CHAR1	CHAR	1	0	Sort Mode
28	ACTUAL2PLAN	☐	/MRSS/T_DPR_TV_ACTUAL2PLAN	CHAR1	CHAR	1	0	change of date from planned date to actual Date
29	EXTENDED_ATTRIBUTES	☐	/MRSS/T_DPR_PROJ_EXTENDED_ATT		STRU	0	0
30	EA_DUMMY	☐	/MRSS/T_DPR_TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced Attributes - cProjects
31	.INCLUDE	☐				0	0
32	.INCLUDE	☐				0	0	Non-Modifiable Attributes of Project Definition
33	GUID	☐	/MRSS/T_GUID	SYSUUID	RAW	16	0	GUID
34	VERSION_NUMBER	☐	/MRSS/T_DPR_TV_VERSION	CHAR24	CHAR	24	0	Version Number
35	SCHEDULED_START	☐	/MRSS/T_DPR_TV_SCHEDULED_START		DATS	8	0	Calculated Start Date
36	SCHEDULED_FINISH	☐	/MRSS/T_DPR_TV_SCHEDULED_FIN		DATS	8	0	Calculated End Date
37	CREATED_BY	☐	/MRSS/T_DPR_CREATED_BY	XUBNAME	CHAR	12	0	Created By	*
38	CREATED_BY_NAME	☐	/MRSS/T_DPR_CREATED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Created the Project Element
39	CREATED_ON	☐	/MRSS/T_DPR_CREATED_ON_DATE		DATS	8	0	Created On
40	CHANGED_BY	☐	/MRSS/T_DPR_CHANGED_BY	XUBNAME	CHAR	12	0	Last Changed By	*
41	CHANGED_BY_NAME	☐	/MRSS/T_DPR_CHANGED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Last Changed the Project Element
42	CHANGED_ON	☐	/MRSS/T_DPR_CHANGED_ON_DATE		DATS	8	0	Change Date
43	PRO_CATEGORY	☐	/MRSS/T_DPR_PRO_CATEGORY	/MRSS/_DPR_PROJECT_CATEGORY	CHAR	1	0	Project Category
44	TEMPLATE_ADMIN_NAME	☐	/MRSS/T_DPR_TEMPLATE_ADMIN_NME	TEXT80	CHAR	80	0	Name of Person Who Is Responsible for the Template
45	TEMPLATE_ID	☐	/MRSS/T_DPR_PRO_TEMPLATE_ID	/MRSS/_DPR_CGPL_EXTID	CHAR	24	0	Project Template Number
46	RELEASE_DATE	☐	/MRSS/T_DPR_RELEASE_DATE	DATS	DATS	8	0	Release Date
47	RESCHEDULE	☐	/MRSS/T_DPR_RESCHEDULE	/MRSS/_DPR_BOOLEAN	CHAR	1	0	Rescheduling Required
48	LAST_CHANGE_DATE	☐	/MRSS/T_DPR_LAST_CHANGE_DATE		DATS	8	0	Last Changed On
49	LAST_CHANGE_TIME	☐	/MRSS/T_DPR_LAST_CHANGE_TIME		TIMS	6	0	Last Changed At
50	LAST_CHANGED_BY	☐	/MRSS/T_DPR_TV_LAST_CHANGED_BY	USNAM	CHAR	12	0	User Who Last Changed Data in the Project
51	LAST_CHANGED_BY_NAME	☐	/MRSS/T_DPR_LAST_CHANGE_BY_NME	TEXT80	CHAR	80	0	Name of Person Who Last Changed Data in the Project
52	PRO_TYPE_TEXT	☐	/MRSS/T_DPR_PRO_TYPE_TEXT	/MRSS/_DPR_TEXT	CHAR	40	0	Project Type Text
53	CAUSE_TEXT	☐	/MRSS/T_DPR_CAUSE_TEXT	/MRSS/_DPR_TEXT	CHAR	40	0	Description of Project Reason
54	.INCLUDE	☐				0	0	Development Projects: Status (External)
55	OBJNR	☐	/MRSS/T_DPR_GUID	SYSUUID	RAW	16	0	GUID
56	ISTAT	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status	*
57	ESTAT	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
58	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
59	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
60	TXT04	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
61	TXT30	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
62	STATTXT	☐	/MRSS/T_DPR_TV_STATUS_TXT		STRG	0	0	Concatenated Status Text of Object
63	CUSTOMER_NAME	☐	/MRSS/T_DPR_CUSTOMER_NAME	TEXT80	CHAR	80	0	Customer
64	SOLD_TO_PARTY_NAME	☐	/MRSS/T_DPR_SOLD_TO_PARTY_NAME	TEXT80	CHAR	80	0	Sold-To Party
65	GUID_CHAR	☐	/MRSS/T_DPR_OBJECT_GUID_CHAR	SYSUUID_C	CHAR	32	0	Unique Object Key
66	CALENDER_TEXT	☐	SC_TXTFAC	TEXT40	CHAR	40	0	Factory calendar name
67	.INCLUDE	☐				0	0	Abbreviation and Description for Responsible Organization
68	RESP_ORG_U_SHORT	☐	/MRSS/T_DPR_ORG_UNIT	CHAR12	CHAR	12	0	Responsible Organizational Unit
69	RESP_ORG_U_STEXT	☐	/MRSS/T_DPR_TEXT	/MRSS/_DPR_TEXT	CHAR	40	0	Object Description
70	ACT_WRK_UNIT_EXT_MSEHT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
71	ACT_WRK_UNIT_EXT_MSEHL	☐	/MRSS/T_DPR_ACT_WRK_UNIT_MSEHL	TEXT30	CHAR	30	0	Description of Unit for Complete Confirmation
72	THRESHOLD_TEXT	☐	/MRSS/T_DPR_THRESHOLD_DESCR	/MRSS/_DPR_DESCRIPTION	CHAR	40	0	Description of Threshold Value
73	SEVERITY_TEXT	☐	/MRSS/T_DPR_SEVERITY_DESCRIP	/MRSS/_DPR_DESCRIPTION	CHAR	40	0	Description of Severity Level of Threshold Value
74	AREA	☐	/MRSS/T_DPR_TV_AREA	/MRSS/_DPR_AREA	CHAR	4	0	Area
75	AREA_TEXT	☐	/MRSS/T_DPR_TV_AREA_TEXT	TEXT30	CHAR	30	0	Area Text
76	LOCATION_TEXT	☐	/MRSS/T_DPR_LOCATION_TEXT	TEXT30	CHAR	30	0	Location Text
77	DURATION	☐			QUAN	4	0
78	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
79	DURATION_UNIT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/MRSS/T_DPR_TS_PROJECT_EXTNSN	CALENDAR_ID	TFACD	IDENT	KEY	1	CN
2	/MRSS/T_DPR_TS_PROJECT_EXTNSN	CUSTOMER_ID	BUT000	PARTNER	KEY	1	CN
3	/MRSS/T_DPR_TS_PROJECT_EXTNSN	MASTER_LANGUAGE	T002	SPRAS	KEY	1	CN
4	/MRSS/T_DPR_TS_PROJECT_EXTNSN	STAT_PROFILE_PRO	TJ21	STSMA	REF	1	CN

History

Last changed by/on	SAP	20141109
SAP Release Created in	800