SAP ABAP Table RPM_TS_TASK_ARCH_EXT (RPM: extended structure for archived task data)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PFM (Application Component) Portfolio Management
     ⤷ RPM_DATAARCHIVING (Package) RPM Data Archiving

Basic Data

Table Category	INTTAB	Structure
Structure	RPM_TS_TASK_ARCH_EXT	Table Relationship Diagram
Short Description	RPM: extended structure for archived task data

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	TASK_GUID	☐	CGPL_TASK_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Tasks
2	PARENT_GUID	☐	CGPL_TASK_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Tasks
3	LEFT_GUID	☐	CGPL_TASK_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Tasks
4	RIGHT_GUID	☐	CGPL_TASK_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Tasks
5	.INCLUDE	☐				0	0	RPM: Task data that can be changed externally
6	EXTERNAL_ID	☐	RPM_TV_EXTID		CHAR	24	0	ID
7	TASK_DESCRIPTION	☐	RPM_TV_SHARED_DESCRIPTION	TEXT40	CHAR	40	0	Portfolio Management: Application Object Description
8	ACTUALSTART	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
9	ACTUALFINISH	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
10	PLANSTART	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
11	PLANFINISH	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
12	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
13	MILESTONE	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
14	CONSTRAINT_TYPE	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
15	CONSTRAINT_TIME	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
16	LATEST_START	☐	CGPL_LATEST_START	BCOS_TSTMP	DEC	15	0	Latest start
17	LATEST_FINISH	☐	CGPL_LATEST_FINISH	BCOS_TSTMP	DEC	15	0	Latest finish date
18	TOTAL_FLOAT	☐	CGPL_TOTAL_FLOAT	CGPL_FLOAT	DEC	8	2	Total Float
19	DURATION	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
20	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
21	CONSTR_TYPE_FIN	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
22	CONSTR_TIME_FIN	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
23	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority
24	.INCLUDE	☐				0	0	Project Task RPM attributes
25	.INCLUDE	☐				0	0	Project Task RPM attributes
26	STATUS	☐	RPM_TV_TASK_STATUS	RPM_TASK_STATUS	NUMC	4	0	Portfolio Management: Task Status
27	LOCATION	☐	RPM_TV_PROJECT_LOCATION	RPM_PROJECT_LOCATION	CHAR	4	0	Project Location	RPM_PROJ_LOCAT
28	TOP_PROJECT_GUID	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
29	RPM_CHANGED_ON	☐	RPM_TV_TIMESTAMP	RPM_BCOS_TSTMP	DEC	15	0	Time Stamp
30	CRITICAL	☐	RPM_TV_CRITICAL_TASK	BOOLE	CHAR	1	0	Critical
31	SUMMARY	☐	RPM_TV_SUMMARY_TASK	BOOLE	CHAR	1	0	Summary
32	BASELINE_START	☐	RPM_TV_BASELINE_START		DATS	8	0	Baseline Start
33	BASELINE_FINISH	☐	RPM_TV_BASELINE_FINISH		DATS	8	0	Baseline Finish
34	ACTUAL_DURATION	☐	RPM_TV_ACTUAL_DURATION		DEC	10	2	Actual Duration
35	PLANNED_DURATION	☐	RPM_TV_PLANNED_DURATION		DEC	10	2	Planned Duration
36	BASELINEDURATION	☐	RPM_TV_BASELINE_DURATION		DEC	10	2	Baseline Duration
37	ACTUAL_WORK	☐	RPM_TV_ACTUAL_WORK		DEC	10	2	Actual Work
38	PLANNED_WORK	☐	RPM_TV_PLANNED_WORK		DEC	10	2	Planned Work
39	BASELINE_WORK	☐	RPM_TV_BASELINE_WORK		DEC	10	2	Baseline Work
40	WORK_UNITS	☐	RPM_TV_ALLOCATION_UNIT	RPM_ALLOCATION_UNIT	CHAR	3	0	Assignment Unit
41	COSTF	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
42	COSTA	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
43	BUDGT	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
44	CURRENCY	☐	RPM_TV_CURRENCY	WAERS	CUKY	5	0	Currency key	TCURC
45	PHASE	☐	RPM_PROJECT_PHASE	RPM_PROJECT_PHASE	NUMC	4	0	Stage	*
46	.INCLUDE	☐				0	0	RPM Structure : Task - Customer DB attributes
47	DUMMY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
48	.INCLUDE	☐				0	0
49	.INCLUDE	☐				0	0	Derived task attributes
50	ASSIGNED_TO	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
51	ASSIGNED_TO_NAME	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
52	ASSIGNED_BY	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
53	ASSIGNED_BY_NAME	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
54	START_VARIANCE	☐	RPM_TV_DATE_VARIANCE		DEC	8	2	Date Variance
55	END_VARIANCE	☐	RPM_TV_DATE_VARIANCE		DEC	8	2	Date Variance
56	VARIANCE_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
57	DATE_PLANSTART	☐	BEGDA	DATUM	DATS	8	0	Start Date
58	DATE_PLANFINISH	☐	ENDDA	DATUM	DATS	8	0	End Date
59	DATE_ACTUALSTART	☐	BEGDA	DATUM	DATS	8	0	Start Date
60	DATE_ACTUALFINISH	☐	ENDDA	DATUM	DATS	8	0	End Date
61	NUMBER_OF_CHILDREN	☐	RPM_TV_NODE_CARDINALITY	INT4	INT4	10	0	Portfolio Management: Number of Nodes
62	DEPENDENCY_COUNT	☐	RPM_TV_DEPENDENCY_COUNT	NUMC3	NUMC	3	0	Number of Project Dependencies.
63	ICON_TASK_STATUS	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
64	SHADED	☐	RPM_SHADED	CHAR1	CHAR	1	0	Shaded Indicator
65	.INCLUDE	☐				0	0
66	.INCLUDE	☐				0	0	Node neighbor IDs
67	PARENT_ID	☐	RPM_TV_PARENT_EXTID		CHAR	24	0	Parent ID
68	LEFT_ID	☐	RPM_TV_LEFT_EXTID		CHAR	24	0	Left ID
69	RIGHT_ID	☐	RPM_TV_RIGHT_EXTID		CHAR	24	0	Right ID
70	TASK_SHORT_TEXT	☐	RPM_TV_SHORT_TEXT	CHAR255	CHAR	255	0	Portfolio Management: Application Object Short Text
71	DEPENDENCIES	☐	RPM_TT_PROJ_DEPENDENCY		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RPM_TS_TASK_ARCH_EXT	CURRENCY	TCURC	WAERS		1	CN
2	RPM_TS_TASK_ARCH_EXT	LOCATION	RPM_PROJ_LOCAT	LOCATION	REF	1	CN

History

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