SAP ABAP Table POWL_QUERY_STY (query definitions)

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	INTTAB	Structure
Structure	POWL_QUERY_STY	Table Relationship Diagram
Short Description	query definitions

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	.INCLUDE	☐				0	0	Query meta data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	QUERY	☐	POWL_QUERY_TY		CHAR	32	0	Query ID
4	TYPE	☐	POWL_TYPE_TY	CHAR30	CHAR	30	0	POWL Type ID	POWL_TYPE
5	MASTERQUERY	☐	POWL_QUERY_TY		CHAR	32	0	Query ID	POWL_QUERY
6	ADMIN	☐	POWL_ADMIN_TY	XFELD	CHAR	1	0	Admin flag
7	CREATOR	☐	XUSER	XUBNAME	CHAR	12	0	User name	USR02
8	SYNC	☐	POWL_SYNC_TY	POWL_XFLAG_DOM	CHAR	1	0	Enforce synchronous query refreshes
9	TEMP_QUERY	☐	POWL_TEMP_TY	POWL_XFLAG_DOM	CHAR	1	0	Temporary query flag
10	CGUID	☐			CHAR	22	0
11	DEFAULT_VIEW	☐	POWL_DEF_VIEW_TY		CHAR	6	0	Default ALV Layout View
12	DEFAULT_Q_CHANGE	☐	POWL_XFLAG_TY	POWL_XFLAG_DOM	CHAR	1	0	X-Flag
13	REFRESH_TYPE	☐	POWL_REFRESH_TY	POWL_REFRESH_TYPE_DOM	CHAR	1	0	Query Refresh Type
14	APPLID	☐	POWL_APPLID_TY	FPB_APPID	CHAR	30	0	Application ID	*
15	USERNAME	☐	XUSER	XUBNAME	CHAR	12	0	User name	*
16	RESULT_COUNT	☐	POWL_COUNT_TY		INT4	10	0	entry counter
17	REFRESH_DATE	☐	POWL_REFRESHD_TY	DATUM	DATS	8	0	Refresh date
18	REFRESH_TIME	☐	POWL_REFRESHT_TY	TIME	TIMS	6	0	Refresh time
19	REFRESH_TZONE	☐	POWL_REFRESHZ_TY	RFCTZONE	CHAR	6	0	Refresh time zone
20	ESTTIME	☐	POWL_ESTTIME_TY		INT4	10	0	Estimated execution time
21	CATEGORY	☐	POWL_CATEGORY_TY		CHAR	32	0	Category
22	CAT_SEQUENCE	☐	POWL_CAT_SEQ_TY		INT4	10	0	sequence number for POWL query category
23	CAT_QUERY_SEQ	☐	POWL_QUERY_SEQ_TY		INT4	10	0	sequence number for a query
24	TABS_QUERY_SEQ	☐	POWL_TAB_SEQ_TY		INT4	10	0	sequence number for a query tabstrip
25	LAYOUT	☐			CHAR	30	0
26	ACTIVE	☐	POWL_ACTIVATION_TY	XFELD	CHAR	1	0	Activation
27	RESULT_CACHE_ID	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
28	DESCRIPTION	☐	POWL_QUERYDESCR_TY	POWL_DESCR_DOM	CHAR	50	0	Query description
29	SPRAS	☐	SYLANGU	SYLANGU	LANG	1	0	Language Key
30	STATUS	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	POWL_QUERY_STY	CREATOR	USR02	BNAME
2	POWL_QUERY_STY	MASTERQUERY	POWL_QUERY	QUERY
3	POWL_QUERY_STY	TYPE	POWL_TYPE	TYPE

History

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