SAP ABAP Table POWL_ACT_QUERY (query activation data)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-MUS-POW (Application Component) Personal Object Worklist
     ⤷ GEN_PERSONAL_OBJECT_WORKLIST (Package) generic worklist

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	POWL_ACT_QUERY	Table Relationship Diagram
Short Description	query activation data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	QUERY	☑	POWL_QUERY_TY		CHAR	32	0	Query ID	POWL_QUERY
3	APPLID	☑	POWL_APPLID_TY	FPB_APPID	CHAR	30	0	Application ID	FPB_PERSAPPL
4	USERNAME	☑	XUSER	XUBNAME	CHAR	12	0	User name	*
5	RESULT_COUNT	☐	POWL_COUNT_TY		INT4	10	0	entry counter
6	REFRESH_DATE	☐	POWL_REFRESHD_TY	DATUM	DATS	8	0	Refresh date
7	REFRESH_TIME	☐	POWL_REFRESHT_TY	TIME	TIMS	6	0	Refresh time
8	REFRESH_TZONE	☐	POWL_REFRESHZ_TY	RFCTZONE	CHAR	6	0	Refresh time zone
9	ESTTIME	☐	POWL_ESTTIME_TY		INT4	10	0	Estimated execution time
10	CATEGORY	☐	POWL_CATEGORY_TY		CHAR	32	0	Category
11	CAT_SEQUENCE	☐	POWL_CAT_SEQ_TY		INT4	10	0	sequence number for POWL query category
12	CAT_QUERY_SEQ	☐	POWL_QUERY_SEQ_TY		INT4	10	0	sequence number for a query
13	TABS_QUERY_SEQ	☐	POWL_TAB_SEQ_TY		INT4	10	0	sequence number for a query tabstrip
14	LAYOUT	☐			CHAR	30	0
15	ACTIVE	☐	POWL_ACTIVATION_TY	XFELD	CHAR	1	0	Activation
16	RESULT_CACHE_ID	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
17	LAST_USAGE_DATE	☐	POWL_LASTUSD_TY		DATS	8	0	Last usage date of this active query
18	LAST_USAGE_TIME	☐	POWL_LASTUST_TY		TIMS	6	0	Last usage time of this active query
19	REFRESH_TYPE	☐	POWL_REFRESH_TY	POWL_REFRESH_TYPE_DOM	CHAR	1	0	Query Refresh Type
20	STATUS	☐			CHAR	10	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	POWL_ACT_QUERY	APPLID	FPB_PERSAPPL	APPLID
2	POWL_ACT_QUERY	QUERY	POWL_QUERY	QUERY

History

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