SAP ABAP View CUSSTATR (Customizing status information selection view)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CUS-TOL-IMG (Application Component) Implementation Guide
     ⤷ SCS4 (Package) R/3 Customizing Tools 4.0

Basic Data

View Type	D	Database View
Database View	CUSSTATR
Short Description	Customizing status information selection view
Root table	TPROJECT	SPROJECT: Project Table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TPROJECT	TPROJECT
2	TNODEIMGR
3	TOBJECTP
4	TSTAHPR
5	TSTAFPR
6	TPR_INDEX
7	TNODEIMG

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TNODEIMGR	REF_OBJECT	JL	EQ				0	0
2	TSTAFPR	ID	JR	EQ			AND	0	0
3	TSTAFPR	STATUS_ID	JL	EQ				0	0
4	TSTAHPR	ID	JR	EQ			AND	0	0
5	TPROJECT	PROJECT_ID	JL	EQ				0	0
6	TOBJECTP	PROJECT_ID	JR	EQ			AND	0	0
7	TPROJECT	PROJECT_ID	JL	EQ				0	0
8	TPR_INDEX	PROJECT_ID	JR	EQ			AND	0	0
9	TPR_INDEX	NODE_ID	JL	EQ				0	0
10	TNODEIMG	NODE_ID	JR	EQ			AND	0	0
11	TOBJECTP	OBJECT_ID	JL	EQ				0	0
12	TSTAFPR	FILTER	JR	EQ			AND	0	0
13	TNODEIMG	REFNODE_ID	JL	EQ				0	0
14	TNODEIMGR	NODE_ID	JR	EQ			AND	0	0
15	TNODEIMGR	REF_TYPE		EQ	'STAT'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	PROJECT_ID	TPROJECT	PROJECT_ID		☐	PROJECT_ID	☐	Project name
2	OBJ_TYPE	TOBJECTP	OBJ_TYPE		☐	OBJE_TYPE	☐	Project management object type
3	CLASS	TPROJECT	CLASS		☐	PROJ_CLASS	☐	Possible Project Type
4	PROJ_LANG	TPROJECT	PROJ_LANG		☐	SPRAS	☐	Language Key
5	RESPONSIBL	TPROJECT	RESPONSIBL		☐	PROJ_RESP	☐	Project manager
6	BEGIN_DATE	TPROJECT	BEGIN_DATE		☐	STAT_FDATE	☐	Date created
7	END_DATE	TPROJECT	END_DATE		☐	STAT_FDATE	☐	Date created
8	PFDATE	TPROJECT	FDATE		☐	STAT_FDATE	☐	Date created
9	PFUSER	TPROJECT	FUSER		☐	STAT_FUSER	☐	Created By
10	PLDATE	TPROJECT	LDATE		☐	STAT_LDATE	☐	Changed On
11	PLUSER	TPROJECT	LUSER		☐	STAT_LUSER	☐	Changed by
12	ID	TSTAHPR	ID		☐	STATUS_ID	☐	Unique identifier for status information
13	STATUS	TSTAHPR	STATUS		☐	STAT_STAT	☐	Processing status
14	PLANSTART	TSTAHPR	PLANSTART		☐	STAT_PLSTA	☐	Planned Start
15	PLANEND	TSTAHPR	PLANEND		☐	STAT_PLEND	☐	Planned end
16	PLANDUR	TSTAHPR	PLANDUR		☐	STAT_PLDUR	☐	Planned work
17	ACTULSTART	TSTAHPR	ACTULSTART		☐	STAT_ACSTA	☐	Actual start
18	ACTULEND	TSTAHPR	ACTULEND		☐	STAT_ACEND	☐	Actual end
19	ACTULDUR	TSTAHPR	ACTULDUR		☐	STAT_ACDUR	☐	Actual work
20	RESTWORK	TSTAHPR	RESTWORK		☐	STAT_REST	☐	Remaining work
21	DONE	TSTAHPR	DONE		☐	STAT_DONE	☐	Percent complete
22	FDATE	TSTAHPR	FDATE		☐	STAT_FDATE	☐	Date created
23	FUSER	TSTAHPR	FUSER		☐	STAT_FUSER	☐	Created By
24	LDATE	TSTAHPR	LDATE		☐	STAT_LDATE	☐	Changed On
25	LUSER	TSTAHPR	LUSER		☐	STAT_LUSER	☐	Changed by
26	NODE_ID	TPR_INDEX	NODE_ID		☐	HIER_GUID	☐	Unique ID - 32 characters
27	REFNODE_ID	TNODEIMG	REFNODE_ID		☐	HIER_GUID	☐	Unique ID - 32 characters
28	NODE_TYPE	TNODEIMG	NODE_TYPE		☐	HIER_NODET	☐	Valid Node Types in Structure Repository
29	REF_TYPE	TNODEIMGR	REF_TYPE		☐	HIER_RTYPE	☐	Valid Reference Types in Structure Repository
30	REF_OBJECT	TNODEIMGR	REF_OBJECT		☐	HIER_ROBJE	☐	Referenced object for node
31	COUNTER	TPR_INDEX	COUNTER		☐	SYTABIX	☐	Row Index of Internal Tables
32	NODE_LEVEL	TPR_INDEX	NODE_LEVEL		☐	SEU_LEVEL	☐	Node level

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