SAP ABAP Table POWL_QUERY_USR (Query - User assignment by admin)

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_USR	Table Relationship Diagram
Short Description	Query - User assignment by admin

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	APPLID	☑	POWL_APPLID_TY	FPB_APPID	CHAR	30	0	Application ID	FPB_PERSAPPL
3	USERNAME	☑	XUSER	XUBNAME	CHAR	12	0	User name	*
4	QUERY	☑	POWL_QUERY_TY		CHAR	32	0	Query ID	POWL_QUERY
5	ACTIVE	☐	POWL_ACTIVATION_TY	XFELD	CHAR	1	0	Activation
6	CATEGORY	☐	POWL_CATEGORY_TY		CHAR	32	0	Category	POWL_CATEGORY
7	CAT_SEQUENCE	☐	POWL_CAT_SEQ_TY		INT4	10	0	sequence number for POWL query category
8	CAT_QUERY_SEQ	☐	POWL_QUERY_SEQ_CAT_TY		INT4	10	0	sequence number for a query
9	TABS_QUERY_SEQ	☐	POWL_QUERY_SEQ_TAB_TY		INT4	10	0	sequence number for a query

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	POWL_QUERY_USR	APPLID	FPB_PERSAPPL	APPLID
2	POWL_QUERY_USR	CATEGORY	POWL_CATEGORY	CATEGORY
3	POWL_QUERY_USR	QUERY	POWL_QUERY	QUERY

History

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