SAP ABAP Table DPR_TS_PART_EXT (Role Attributes (External))

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PRO-RES (Application Component) Resources
     ⤷ DEVELOPMENT_PROJECTS_TEAM (Package) Project Management - Team/Participants/Roles

Basic Data

Table Category	INTTAB	Structure
Structure	DPR_TS_PART_EXT	Table Relationship Diagram
Short Description	Role Attributes (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	Role Attributes
2	GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
3	VERSION_NUMBER	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
4	SCHEDULED_START	☐	DPR_TV_SCHEDULED_START		DATS	8	0	Calculated Start Date
5	SCHEDULED_FINISH	☐	DPR_TV_SCHEDULED_FINISH		DATS	8	0	Calculated Finish Date
6	COST_RATE_DEF	☐	DPR_TV_COST_VALUE	PREIS	CURR	11	2	Cost per Activity Unit
7	REVENUE_RATE_DEF	☐	DPR_TV_REVENUE_VALUE	PREIS	CURR	11	2	Revenues per Activity Unit
8	WORK_UNIT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
9	TIME_UNIT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
10	ACT_WRK_UNIT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
11	CONCRETE_ROLE	☐	DPR_TV_CONCRETE_ROLE	CHAR1	CHAR	1	0	Shadow Role (= Concrete Role)
12	AREA	☐	DPR_TV_AREA	DPR_AREA	CHAR	4	0	Area	*
13	AREA_TEXT	☐	DPR_TV_AREA_TEXT	TEXT30	CHAR	30	0	Area Text
14	.INCLUDE	☐				0	0	Development Projects: Status (External)
15	OBJNR	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
16	ISTAT	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status	*
17	ESTAT	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
18	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
19	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
20	TXT04	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
21	TXT30	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
22	STATTXT	☐	DPR_TV_STATUS_TXT		STRG	0	0	Concatenated Status Text of an Object
23	.INCLUDE	☐				0	0	Role Attributes
24	SORT_NUMBER	☐	DPR_TV_SORT_NUMBER		NUMC	5	0	Sort Number
25	PARTICIPANT_ROLE	☐	DPR_TV_PARTICIPANT_ROLE	DPR_PARTICIPANT_ROLE	CHAR	15	0	Role Type for Projects	DPR_PART_ROLE
26	BEG_TMSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
27	END_TMSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
28	WORK_EFFORT	☐	DPR_TV_EFFORT	DPR_WORK	QUAN	9	2	Demand or Assigned Effort
29	WORK_UNIT	☐	DPR_TV_EFFORT_UNIT	MEINS	UNIT	3	0	Unit for Demand or Effort	*
30	C_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
31	PARTNER_ROLE	☐	DPR_TV_BU_ROLE	BU_RLTYP	CHAR	6	0	BP Role	*
32	VACANT	☐	DPR_TV_VACANT	DPR_BOOLEAN	CHAR	1	0	Vacant Checkbox of Role
33	CAND_IN_WORKLIST	☐	DPR_TV_CANDIDATE_IN_WORKLIST	DPR_BOOLEAN	CHAR	1	0	Role Is Displayed in Candidate Manager's Worklist
34	STAT_PROFILE_PRT	☐	DPR_TV_STAT_PROFILE_PRT	J_STSMA	CHAR	8	0	Status Profile Template	*
35	VC_BUPA_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
36	RATE	☐	DPR_TV_RATE	DPR_RATE_TYPE	CHAR	15	0	Cost Rate/Revenue Rate for Project Costing	*
37	REVENUE_RATE	☐	DPR_TV_REVENUE_RATE_MANUAL	PREIS	CURR	11	2	Different Revenue
38	CURRENCY	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	*
39	COST_RATE	☐	DPR_TV_COST_RATE_MANUAL	PREIS	CURR	11	2	Different Costs
40	CURRENCY_COST	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	*
41	TIME_UNIT	☐	DPR_TV_TIME_UNIT_MANUAL	MEINS	UNIT	3	0	Activity Unit for Deviating Costs and Revenues	*
42	ACT_WRK_EFFORT_EXT	☐	DPR_TV_ACT_WORK_EXT	DPR_WORK	QUAN	9	2	Confirmation
43	ACT_WRK_UNIT_EXT	☐	DPR_TV_ACT_WRK_UNIT	MEINS	UNIT	3	0	Confirmation Unit	*
44	CONF_GUID	☐	DPR_TV_CONF_GUID		RAW	16	0	GUID of a Confirmation Document
45	.INCLUDE	☐				0	0	Include for Enhanced Attribute: Role (Participant)
46	EA_DUMMY	☐	DPR_TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced Proj. Mgmt Attributes
47	.INCLUDE	☐				0	0
48	.INCLUDE	☐				0	0
49	EXTERNAL_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
50	BEG_DATE	☐	BEGDA	DATUM	DATS	8	0	Start Date
51	END_DATE	☐	ENDDA	DATUM	DATS	8	0	End Date
52	DESCRIPTION	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
53	PARTICIPANT_ROLE_TEXT	☐	DPR_TV_PARTICIPANT_ROLE_TEXT	DPR_TEXT	CHAR	40	0	Name of Role Type
54	PARTICIPANT_ID	☐	DPR_TV_PART_ID	CHAR24	CHAR	24	0	Role ID
55	ROLE_FUNCTION_ID	☐	DPR_TV_ROLE_FUNCTION_ID	DPR_ROLE_FUNCTION_ID	CHAR	15	0	ID of Role Function	DPR_ROLE_FUNC
56	LOCATION	☐	DPR_TV_LOCATION	DPR_LOCATION	CHAR	4	0	Location	*
57	URGENCY	☐	DPR_TV_URGENCY	DPR_URGENCY	CHAR	2	0	Urgency

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DPR_TS_PART_EXT	PARTICIPANT_ROLE	DPR_PART_ROLE	PARTICIPANT_ROLE
2	DPR_TS_PART_EXT	ROLE_FUNCTION_ID	DPR_ROLE_FUNC	ROLE_FUNC_ID

History

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