SAP ABAP View CUSSTAT2 (Customizing project status)

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	CUSSTAT2
Short Description	Customizing project status
Root table	TNODEIMGR	References for the new IMG

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TNODEIMGR	TNODEIMGR
2	TSTAHPR
3	TSTAFPR

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	TNODEIMGR	REF_TYPE		EQ	'STAT'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	ID	TSTAHPR	ID		☐	STATUS_ID	☐	Unique identifier for status information
2	STATUS	TSTAHPR	STATUS		☐	STAT_STAT	☐	Processing status
3	PLANSTART	TSTAHPR	PLANSTART		☐	STAT_PLSTA	☐	Planned Start
4	PLANEND	TSTAHPR	PLANEND		☐	STAT_PLEND	☐	Planned end
5	PLANDUR	TSTAHPR	PLANDUR		☐	STAT_PLDUR	☐	Planned work
6	ACTULSTART	TSTAHPR	ACTULSTART		☐	STAT_ACSTA	☐	Actual start
7	ACTULEND	TSTAHPR	ACTULEND		☐	STAT_ACEND	☐	Actual end
8	ACTULDUR	TSTAHPR	ACTULDUR		☐	STAT_ACDUR	☐	Actual work
9	RESTWORK	TSTAHPR	RESTWORK		☐	STAT_REST	☐	Remaining work
10	DONE	TSTAHPR	DONE		☐	STAT_DONE	☐	Percent complete
11	FDATE	TSTAHPR	FDATE		☐	STAT_FDATE	☐	Date created
12	FUSER	TSTAHPR	FUSER		☐	STAT_FUSER	☐	Created By
13	LDATE	TSTAHPR	LDATE		☐	STAT_LDATE	☐	Changed On
14	LUSER	TSTAHPR	LUSER		☐	STAT_LUSER	☐	Changed by
15	FILTER	TSTAFPR	FILTER		☐	HIER_GUID	☐	Unique ID - 32 characters
16	NODE_ID	TNODEIMGR	NODE_ID		☐	HIER_GUID	☐	Unique ID - 32 characters

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	20100421
SAP Release Created in