SAP ABAP Table DPR_TS_UI_STAFFING (UI Data for Role Staffing)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PRO (Application Component) Project Management
     ⤷ DEVELOPMENT_PROJECTS_UI_LOGIC (Package) Project Management UI Data Formatting

Basic Data

Table Category	INTTAB	Structure
Structure	DPR_TS_UI_STAFFING	Table Relationship Diagram
Short Description	UI Data for Role Staffing

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	STAFFINGLINK_GUID	☐	DPR_TV_OBJECT_GUID_CHAR	SYSUUID_C	CHAR	32	0	Unique Object Key
2	PARTICIPANT_GUID	☐	DPR_TV_OBJECT_GUID_CHAR	SYSUUID_C	CHAR	32	0	Unique Object Key
3	PARTNER_GUID	☐	DPR_TV_OBJECT_GUID_CHAR	SYSUUID_C	CHAR	32	0	Unique Object Key
4	SORT_NUMBER	☐	DPR_TV_SORT_NUMBER		NUMC	5	0	Sort Number
5	WORK_EFFORT	☐	DPR_TV_STAFFED_EFFORT	DPR_WORK	QUAN	9	2	Assigned Effort
6	WORK_UNIT	☐	DPR_TV_UNIT	MEINS	UNIT	3	0	Unit	*
7	WORK_UNIT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
8	COMMENTARY	☐	DPR_TV_COMMENTARY		STRG	0	0	Comment
9	COMMENTARY_ICON	☐			STRG	0	0
10	COMMENTARY_ICON_TT	☐			STRG	0	0
11	BEGIN_DATE	☐	BEGDA	DATUM	DATS	8	0	Start Date
12	END_DATE	☐	ENDDA	DATUM	DATS	8	0	End Date
13	BOOKING_TYPE	☐	DPR_TV_BOOKING_TYPE	DPR_BOOKING_TYPE	CHAR	1	0	Booking Type
14	SOFT_BOOKED	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
15	STAFFING_ACTION	☐	PRP_ACTION_ID	CHAR4	CHAR	4	0	Staffing Action
16	PLACEHOLDER_TEXT	☐	DPR_TV_PLACEHOLDER_TEXT	DPR_TEXT	CHAR	40	0	Text for Staffing a Role with a Placeholder
17	CALCULATED_BEGIN	☐	DPR_TV_SCHEDULED_START		DATS	8	0	Calculated Start Date
18	CALCULATED_END	☐	DPR_TV_SCHEDULED_FINISH		DATS	8	0	Calculated Finish Date
19	CREATED_BY	☐	DPR_TV_CREATED_BY	XUBNAME	CHAR	12	0	Created By	*
20	CREATED_ON	☐	DPR_TV_TIMESTAMP	BCOS_TSTMP	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)
21	CHANGED_BY	☐	DPR_TV_CHANGED_BY	XUBNAME	CHAR	12	0	Last Changed By	*
22	CHANGED_ON	☐	DPR_TV_TIMESTAMP	BCOS_TSTMP	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)
23	TEAM_ID	☐	DPR_TV_TEAM_ID	CHAR24	CHAR	24	0	Team ID
24	EXTERNAL_BUPA	☐	DPR_TV_EXT_BUPA	CHAR1	CHAR	1	0	External Business Partner
25	VARIANT_KEY	☐			STRG	0	0
26	DET_DATA_URL	☐			STRG	0	0
27	BUPA_FULLNAME	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
28	RESOURCE_TYPE_IMG	☐			STRG	0	0
29	RESOURCE_TYPE_TT	☐			STRG	0	0
30	TASK_SENT	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
31	ACTION_ICON	☐			STRG	0	0
32	ACTION_TEXT	☐			STRG	0	0
33	AVAILABILITY	☐	PRP_TV_AVAIL_TIME	PRP_AVAIL_TIME	QUAN	9	2	Person's Available Time
34	TOTAL_UTILIZATION	☐	PRP_TV_AVAIL_TIME	PRP_AVAIL_TIME	QUAN	9	2	Person's Available Time
35	SOFTBOOKING_UTILIZATION	☐	PRP_TV_AVAIL_TIME	PRP_AVAIL_TIME	QUAN	9	2	Person's Available Time
36	HARDBOOKING_UTILIZATION	☐	PRP_TV_AVAIL_TIME	PRP_AVAIL_TIME	QUAN	9	2	Person's Available Time
37	TOTAL_AVAILABILITY	☐	DPR_TV_RESOURCE_AVAIL_NUMBER	DPR_AVAILABILITY	DEC	9	2	Provision of Resources for Project
38	OTHER_ALLOCATIONS	☐	DPR_TV_RESOURCE_AVAIL_NUMBER	DPR_AVAILABILITY	DEC	9	2	Provision of Resources for Project
39	UNALLOCATED	☐	DPR_TV_RESOURCE_AVAIL_NUMBER	DPR_AVAILABILITY	DEC	9	2	Provision of Resources for Project
40	.INCLUDE	☐				0	0	Include for Enhanced Attribute: Role (Participant)
41	EA_DUMMY	☐	DPR_TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced Proj. Mgmt Attributes
42	.INCLUDE	☐				0	0
43	.INCLUDE	☐				0	0

History

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