SAP ABAP Table PRP_TS_VACANT_PART_DETAILS (Detail Data of Vacant Roles)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PRO-RES (Application Component) Resources
     ⤷ PRP_RESOURCE (Package) Resource Management

Basic Data

Table Category	INTTAB	Structure
Structure	PRP_TS_VACANT_PART_DETAILS	Table Relationship Diagram
Short Description	Detail Data of Vacant Roles

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	Vacant Roles
2	PROJECT_GUID	☐	DPR_TV_ENTITY_GUID	DPR_ENTITY_GUID	RAW	16	0	Application Object GUID (Entity with Conversion Exit)
3	OBJECT_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
4	EXTERNAL_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
5	PRO_TYPE	☐	DPR_TV_PRO_TYPE	DPR_TYPE	CHAR	15	0	Project Type	*
6	PRO_TYPE_TEXT	☐	DPR_TV_TYPE_TEXT	DPR_TEXT	CHAR	40	0	Short Text for Type
7	PLANSTART	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
8	PLANFINISH	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
9	CONSTRAINT_TYPE	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
10	CONSTRAINT_TIME	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
11	CONSTR_TYPE_FIN	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
12	CONSTR_TIME_FIN	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
13	LATEST_START	☐	CGPL_LATEST_START	BCOS_TSTMP	DEC	15	0	Latest start
14	LATEST_FINISH	☐	CGPL_LATEST_FINISH	BCOS_TSTMP	DEC	15	0	Latest finish date
15	CUSTOMER	☐	DPR_TV_CUSTOMER_GUID	SYSUUID	RAW	16	0	Business Partner GUID of Customer
16	SOLD_TO_PARTY	☐	DPR_TV_SOLDTOPARTY_GUID	SYSUUID	RAW	16	0	Business Partner GUID of Sold-to Party
17	PROC_STATUS_OWN	☐	DPR_TV_PROC_STATUS_OWN	DPR_PROC_STATUS	CHAR	2	0	Object Processing Status
18	PARTICIPANT_ROLE	☐	DPR_TV_PARTICIPANT_ROLE	DPR_PARTICIPANT_ROLE	CHAR	15	0	Role Type for Projects	*
19	PARTICIPANT_GUID	☐	DPR_TV_PARTICIPANT_GUID	DPR_PARTICIPANT_GUID	RAW	16	0	GUID for Role	*
20	PROJECT_TEXT	☐	DPR_PROJECT_NAME	DPR_TEXT	CHAR	40	0	Project Name
21	PLANSTART_DATE	☐	DPR_TV_PLANSTARTDATE		DATS	8	0	Planned Start
22	PLANFINISH_DATE	☐	DPR_TV_PLANFINISHDATE		DATS	8	0	Planned Finish
23	START_DATE_FIX	☐	DPR_TV_START_DATE_FIX		DATS	8	0	Fixed Start Date
24	FINISH_DATE_FIX	☐	DPR_TV_FINISH_DATE_FIX		DATS	8	0	Fixed Predefined Finish Date
25	LATEST_START_DATE	☐	DPR_TV_LATEST_STARTDATE		DATS	8	0	Latest Start Date
26	LATEST_FINISH_DATE	☐	DPR_TV_LATEST_FINISHDATE		DATS	8	0	Latest Finish Date
27	PARTICIPANT_ROLE_TEXT	☐	DPR_TV_PARTICIPANT_ROLE_TEXT	DPR_TEXT	CHAR	40	0	Name of Role Type
28	PARTICIPANT_ROLE_DESCRIPTION	☐	DPR_TV_PART_ROLE_DESCRIPTION	TEXT40	CHAR	40	0	Language-Dependent Short Text for Role (Participant)
29	PARTICIPANT_BEG_DATE	☐	PRP_TV_START_DATE	DATS	DATS	8	0	Start Date
30	PARTICIPANT_END_DATE	☐	PRP_TV_FINISH_DATE	DATS	DATS	8	0	Finish Date
31	PARTICIPANT_BEG_TMSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
32	PARTICIPANT_END_TMSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
33	PARTICIPANT_WORK_EFFORT	☐	DPR_TV_EFFORT	DPR_WORK	QUAN	9	2	Demand or Assigned Effort
34	PARTICIPANT_WORK_UNIT	☐	DPR_TV_UNIT	MEINS	UNIT	3	0	Unit	*
35	CONTACT	☐	DPR_TV_CONTACT_GUID	SYSUUID	RAW	16	0	Business Partner GUID of Contact Person
36	RESP_ORG_PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	*
37	RESP_ORG_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
38	RESP_ORG_UNIT	☐	DPR_TV_RESP_ORGANIZATION	HROBJID	NUMC	8	0	Organization Responsible	*
39	RESP_ORG_TEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
40	PROJECT_ID	☐	DPR_TV_PROJECT_ID	CGPL_EXTID	CHAR	24	0	Project Number
41	LOCATION	☐	DPR_TV_LOCATION	DPR_LOCATION	CHAR	4	0	Location	*
42	LOCATION_TEXT	☐	DPR_TV_LOCATION_TEXT	TEXT30	CHAR	30	0	Location Text
43	AREA	☐	DPR_TV_AREA	DPR_AREA	CHAR	4	0	Area	*
44	ROLE_FUNCTION_NAME	☐	DPR_TV_ROLE_FUNCTION_NAME	DPR_TEXT	CHAR	40	0	Name of Role Function of a Role
45	ROLE_FUNCTION_ID	☐	DPR_TV_ROLE_FUNCTION_ID	DPR_ROLE_FUNCTION_ID	CHAR	15	0	ID of Role Function	*
46	PROJECT_NUMBER	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
47	.INCLUDE	☐				0	0	Business Partner Data
48	FULLNAME	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
49	EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
50	PSTCD	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
51	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
52	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
53	HSNM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
54	TLNMBR	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
55	.INCLUDE	☐				0	0	Role Documents
56	FILENAME	☐	EDMS_URL	SADC4096	CHAR	4096	0	EDMS: URL
57	URL	☐	EDMS_URL	SADC4096	CHAR	4096	0	EDMS: URL
58	SOLD_PARTY_NAME	☐	DPR_TV_SOLD_TO_PARTY_NAME	TEXT80	CHAR	80	0	Sold-to Party
59	CUSTOMER_NAME	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
60	PART_UNIT_TEXT	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
61	MIMETYPE	☐	W3CONTTYPE	W3_CONTTYP	CHAR	128	0	HTML content type
62	AREA_TEXT	☐	DPR_TV_AREA_TEXT	TEXT30	CHAR	30	0	Area Text

History

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