SAP ABAP Table DB6PMADVWL (DB6 CCMS: ADVISE_WORKLOAD explain table structure)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     ⤷ STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)

Basic Data

Table Category	INTTAB	Structure
Structure	DB6PMADVWL	Table Relationship Diagram
Short Description	DB6 CCMS: ADVISE_WORKLOAD explain table structure

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	WORKLOAD_NAME	☐			CHAR	128	0
2	STATEMENT_NO	☐			INT4	10	0
3	STATEMENT_TEXT	☐			STRG	0	0
4	FREQUENCY	☐			INT4	10	0
5	IMPORTANCE	☐	DBAFLTP16		FLTP	16	16	Floating Point 16
6	WEIGHT	☐	DBAFLTP16		FLTP	16	16	Floating Point 16
7	COST_BEFORE	☐	DBAFLTP16		FLTP	16	16	Floating Point 16
8	COST_AFTER	☐	DBAFLTP16		FLTP	16	16	Floating Point 16
9	COMPILABLE	☐			CHAR	17	0
10	SAVING	☐			INT2	5	0
11	FMT_COST_BEFORE	☐			STRG	0	0
12	FMT_COST_AFTER	☐			STRG	0	0

History

Last changed by/on	SAP	20110908
SAP Release Created in	712