SAP ABAP View PROJSTAT (Project Status Information Selection View)

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	PROJSTAT
Short Description	Project Status Information Selection View
Root table	TNODEPR	Node Table for General Structure Storage

Table

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

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			AND	0	0
7	TPROJECT	PROJECT_ID	JL	EQ				0	0
8	TOBJECTP	PROJECT_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	NODE_TYPE	TNODEPR	NODE_TYPE		☐	HIER_NODET	☐	Valid Node Types in Structure Repository
5	*	TSTAHPR	*		☐		☐
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	STAT_REL	TSTAHPR	STAT_REL		☐	STAT_REL	☐	Activity Release
21	ISP_CODE2	TSTAHPR	ISP_CODE2		☐	ISP_CODE	☐	Value Field
22	ISP_CODE3	TSTAHPR	ISP_CODE3		☐	ISP_CODE	☐	Value Field
23	FDATE	TSTAHPR	FDATE		☐	STAT_FDATE	☐	Date created
24	FUSER	TSTAHPR	FUSER		☐	STAT_FUSER	☐	Created By
25	LDATE	TSTAHPR	LDATE		☐	STAT_LDATE	☐	Changed On
26	LUSER	TSTAHPR	LUSER		☐	STAT_LUSER	☐	Changed by
27	FTIME	TSTAHPR	FTIME		☐	STAT_FTIME	☐	Created at
28	LTIME	TSTAHPR	LTIME		☐	STAT_LTIME	☐	Changed At
29	CLASS	TPROJECT	CLASS		☐	PROJ_CLASS	☐	Possible Project Type
30	PROJ_LANG	TPROJECT	PROJ_LANG		☐	SPRAS	☐	Language Key
31	RESPONSIBL	TPROJECT	RESPONSIBL		☐	PROJ_RESP	☐	Project manager
32	APP_COMP	TPROJECT	APP_COMP		☐	UFFCTR	☐	Application Component
33	REF_PROJ	TPROJECT	REF_PROJ		☐	PROJECT_ID	☐	Project name
34	BEGIN_DATE	TPROJECT	BEGIN_DATE		☐	STAT_FDATE	☐	Date created
35	END_DATE	TPROJECT	END_DATE		☐	STAT_FDATE	☐	Date created
36	RELEASE	TPROJECT	RELEASE		☐	PROJ_REL	☐	Project Release
37	KENN1	TPROJECT	KENN1		☐	PROJ_K1	☐	Project flag
38	PFDATE	TPROJECT	FDATE		☐	STAT_FDATE	☐	Date created
39	PFUSER	TPROJECT	FUSER		☐	STAT_FUSER	☐	Created By
40	PLDATE	TPROJECT	LDATE		☐	STAT_LDATE	☐	Changed On
41	PLUSER	TPROJECT	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