SAP ABAP Table POWL_QUERY_ROL (Query - Role assignment)

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_ROL	Table Relationship Diagram
Short Description	Query - Role assignment

Delivery and Maintenance

Pool/cluster
Delivery Class	G	Customizing table, protected against SAP Upd., only INS all.
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	ROLE	☑	AGR_NAME	AGR_NAME	CHAR	30	0	Role Name	AGR_DEFINE
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_TY		INT4	10	0	sequence number for a query
9	TABS_QUERY_SEQ	☐	POWL_TAB_SEQ_TY		INT4	10	0	sequence number for a query tabstrip

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	POWL_QUERY_ROL	APPLID	FPB_PERSAPPL	APPLID
2	POWL_QUERY_ROL	CATEGORY	POWL_CATEGORY	CATEGORY	KEY	1	CN
3	POWL_QUERY_ROL	QUERY	POWL_QUERY	QUERY
4	POWL_QUERY_ROL	ROLE	AGR_DEFINE	AGR_NAME	KEY	1	CN

History

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