SAP ABAP View STATPROP (View to Read Specific Status Information)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CUS-TOL-IMG (Application Component) Implementation Guide
     ⤷ SPROJECT (Package) General project management

Basic Data

View Type	D	Database View
Database View	STATPROP
Short Description	View to Read Specific Status Information
Root table	TOBJECTP	Objects assigned to a project

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TOBJECTP	TOBJECTP
2	TNODEPR
3	TNODEPRR
4	TSTAHPR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TOBJECTP	OBJECT_ID	JL	EQ				0	0
2	TNODEPR	TREE_ID	JR	EQ			AND	0	0
3	TNODEPR	NODE_ID	JL	EQ				0	0
4	TNODEPRR	NODE_ID	JR	EQ			AND	0	0
5	TNODEPRR	REF_OBJECT	JL	EQ				0	0
6	TSTAHPR	ID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	PROJECT_ID	TOBJECTP	PROJECT_ID		☐	PROJECT_ID	☐	Project name
2	OBJ_TYPE	TOBJECTP	OBJ_TYPE		☐	OBJE_TYPE	☐	Project management object type
3	NODE_ID	TNODEPR	NODE_ID		☐	HIER_GUID	☐	Unique ID - 32 characters
4	PARENT_ID	TNODEPR	PARENT_ID		☐	HIER_GUID	☐	Unique ID - 32 characters
5	NODE_TYPE	TNODEPR	NODE_TYPE		☐	HIER_NODET	☐	Valid Node Types in Structure Repository
6	ID	TSTAHPR	ID		☐	STATUS_ID	☐	Unique identifier for status information
7	STATUS	TSTAHPR	STATUS		☐	STAT_STAT	☐	Processing status
8	PLANSTART	TSTAHPR	PLANSTART		☐	STAT_PLSTA	☐	Planned Start
9	PLANEND	TSTAHPR	PLANEND		☐	STAT_PLEND	☐	Planned end
10	PLANDUR	TSTAHPR	PLANDUR		☐	STAT_PLDUR	☐	Planned work
11	ACTULSTART	TSTAHPR	ACTULSTART		☐	STAT_ACSTA	☐	Actual start
12	ACTULEND	TSTAHPR	ACTULEND		☐	STAT_ACEND	☐	Actual end
13	ACTULDUR	TSTAHPR	ACTULDUR		☐	STAT_ACDUR	☐	Actual work
14	RESTWORK	TSTAHPR	RESTWORK		☐	STAT_REST	☐	Remaining work
15	DONE	TSTAHPR	DONE		☐	STAT_DONE	☐	Percent complete
16	PRIORITY	TSTAHPR	PRIORITY		☐	PROJ_PRIO	☐	Activity priority
17	ISP_PLAN	TSTAHPR	ISP_PLAN		☐	CHAR32	☐	Character field, length 32
18	ISP_ELEM	TSTAHPR	ISP_ELEM		☐	ISP_ELE	☐	Process number
19	ISP_CODE	TSTAHPR	ISP_CODE		☐	ISP_CODE	☐	Value Field
20	ISP_CODE2	TSTAHPR	ISP_CODE2		☐	ISP_CODE	☐	Value Field
21	ISP_CODE3	TSTAHPR	ISP_CODE3		☐	ISP_CODE	☐	Value Field
22	FUSER	TSTAHPR	FUSER		☐	STAT_FUSER	☐	Created By
23	LDATE	TSTAHPR	LDATE		☐	STAT_LDATE	☐	Changed On
24	LUSER	TSTAHPR	LUSER		☐	STAT_LUSER	☐	Changed by

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130604
SAP Release Created in