SAP ABAP View AISUGEN_V_TPLA (AISUGEN View Testplans)

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_TPLA
Short Description	AISUGEN View Testplans
Root table	AISUGEN_REL_1	Object Relation

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AISUGEN_REL_1	AISUGEN_REL_1
2	AISUGEN_EFFORT_0
3	TNODE02A
4	TTREET

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	AISUGEN_REL_1	EFFORT_OBJ_ID	JL	EQ				0	0
2	AISUGEN_EFFORT_0	ID	JR	EQ			AND	0	0
3	AISUGEN_REL_1	REL_OBJECT_ID	JL	EQ				0	0
4	TTREET	ID	JR	EQ			AND	0	0
5	AISUGEN_REL_1	REL_OBJECT_ID	JL	EQ				0	0
6	TNODE02A	ID	JR	EQ			AND	0	0
7	AISUGEN_REL_1	REL_OBJECT_TYPE	JL	EQ				0	0
8	TNODE02A	TYPE	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	REL_OBJECT_ID	AISUGEN_REL_1	REL_OBJECT_ID		☐	AISUGEN_OBJECT_ID	☐	Object ID
5	REL_OBJECT_TYPE	AISUGEN_REL_1	REL_OBJECT_TYPE		☐	AISUGEN_REL_OBJECT_TYPE	☐	Object Type for related objects
6	REL_OBJECT_TXT	TTREET	TEXT		☐	HIER_TEXT	☐	Explanatory text
7	REL_PROJECT_ID	TNODE02A	PROJECT_ID		☐	PROJECT_ID	☐	Project name
8	REL_SOLUTION_ID	TNODE02A	SOLUTION_ID		☐	TWB_SOLUTION_ID	☐	Solution Identification Number
9	LANGU	TTREET	SPRAS		☐	HIER_LAN	☐	Documentation language

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