SAP ABAP View AISUGEN_V_EFFORT (AISUGEN Effort View)

Hierarchy

☛ ST (Software Component) SAP Solution Manager Tool
   ⤷ SV-SMG-IMP (Application Component) Solution Manager Implementation
     ⤷ AI_SUGEN_KPI_EN (Package) Tools for SUGEN KPIs

Basic Data

View Type	D	Database View
Database View	AISUGEN_V_EFFORT
Short Description	AISUGEN Effort View
Root table	AISUGEN_EFFORT_0	Effort Object

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AISUGEN_EFFORT_0	AISUGEN_EFFORT_0
2	AISUGEN_EFFORT_1
3	AISUGEN_EFFORT_2

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	AISUGEN_EFFORT_0	ID	JL	EQ				0	0
2	AISUGEN_EFFORT_1	EFFORT_OBJ_ID	JR	EQ			AND	0	0
3	AISUGEN_EFFORT_0	ID	JL	EQ				0	0
4	AISUGEN_EFFORT_2	EFFORT_OBJ_ID	JR	EQ			AND	0	0
5	AISUGEN_EFFORT_1	CATEGORY_ID	JL	EQ				0	0
6	AISUGEN_EFFORT_2	CATEGORY_ID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	EFFORT_OBJ_ID	AISUGEN_EFFORT_0	ID		☐	AISUGEN_GUID	☐	GUID
2	OBJECT_ID	AISUGEN_EFFORT_0	OBJECT_ID		☐	AISUGEN_OBJECT_ID	☐	Object ID
3	OBJECT_TYPE	AISUGEN_EFFORT_0	OBJECT_TYPE		☐	AISUGEN_OBJECT_TYPE	☐	Object Type
4	CATEGORY_ID	AISUGEN_EFFORT_1	CATEGORY_ID		☐	AISUGEN_CATEGORY_ID	☐	Effort Category ID
5	FIGURE_ID	AISUGEN_EFFORT_2	FIGURE_ID		☐	AISUGEN_FIGURE_ID	☐	Effort Reference Figure ID
6	EFFORT	AISUGEN_EFFORT_1	EFFORT		☐	AISUGEN_EFFORT	☐	Effort Value
7	EFF_UNIT	AISUGEN_EFFORT_1	UNIT		☐	AISUGEN_TIME_UNIT	☐	Time Unit
8	REF_FIG_VALUE	AISUGEN_EFFORT_2	VALUE		☐	AISUGEN_VALUE	☐	Reference Figure Value
9	REF_FIG_UNIT	AISUGEN_EFFORT_2	UNIT		☐	AISUGEN_UNIT	☐	Unit
10	REMARK	AISUGEN_EFFORT_1	REMARK		☐	AISUGEN_REMARK	☐	Remark/Comment
11	FSTUSEREFF	AISUGEN_EFFORT_1	FSTUSER		☐	UDFUSER	☐	Created by
12	FSTDATEEFF	AISUGEN_EFFORT_1	FSTDATE		☐	UDFDATE	☐	Date on which the record was created
13	FSTTIMEEFF	AISUGEN_EFFORT_1	FSTTIME		☐	UDFTIME	☐	Creation Time
14	LSTUSEREFF	AISUGEN_EFFORT_1	LSTUSER		☐	UDLUSER	☐	Changed by
15	LSTDATEEFF	AISUGEN_EFFORT_1	LSTDATE		☐	UDLDATE	☐	Changed on
16	LSTTIMEEFF	AISUGEN_EFFORT_1	LSTTIME		☐	UDLTIME	☐	Last changed at
17	FSTUSERREF	AISUGEN_EFFORT_2	FSTUSER		☐	UDFUSER	☐	Created by
18	FSTDATEREF	AISUGEN_EFFORT_2	FSTDATE		☐	UDFDATE	☐	Date on which the record was created
19	FSTTIMEREF	AISUGEN_EFFORT_2	FSTTIME		☐	UDFTIME	☐	Creation Time
20	LSTUSERREF	AISUGEN_EFFORT_2	LSTUSER		☐	UDLUSER	☐	Changed by
21	LSTDATEREF	AISUGEN_EFFORT_2	LSTDATE		☐	UDLDATE	☐	Changed on
22	LSTTIMEREF	AISUGEN_EFFORT_2	LSTTIME		☐	UDLTIME	☐	Last changed at

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