SAP ABAP Table POWL_QUERY (Query meta 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_QUERY	Table Relationship Diagram
Short Description	Query meta data

Delivery and Maintenance

Pool/cluster
Delivery Class	G	Customizing table, protected against SAP Upd., only INS all.
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
3	TYPE	☐	POWL_TYPE_TY	CHAR30	CHAR	30	0	POWL Type ID	POWL_TYPE
4	MASTERQUERY	☐	POWL_QUERY_TY		CHAR	32	0	Query ID	POWL_QUERY
5	ADMIN	☐	POWL_ADMIN_TY	XFELD	CHAR	1	0	Admin flag
6	CREATOR	☐	XUSER	XUBNAME	CHAR	12	0	User name	USR02
7	SYNC	☐	POWL_SYNC_TY	POWL_XFLAG_DOM	CHAR	1	0	Enforce synchronous query refreshes
8	TEMP_QUERY	☐	POWL_TEMP_TY	POWL_XFLAG_DOM	CHAR	1	0	Temporary query flag
9	CGUID	☐			CHAR	22	0
10	DEFAULT_VIEW	☐	POWL_DEF_VIEW_TY		CHAR	6	0	Default ALV Layout View
11	DEFAULT_Q_CHANGE	☐	POWL_XFLAG_TY	POWL_XFLAG_DOM	CHAR	1	0	X-Flag
12	REFRESH_TYPE	☐	POWL_REFRESH_TY	POWL_REFRESH_TYPE_DOM	CHAR	1	0	Query Refresh Type

Foreign Keys

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

History

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