POWL_ACT_QUERY - query activation data
query activation data information is stored in SAP table POWL_ACT_QUERY.
It is part of development package GEN_PERSONAL_OBJECT_WORKLIST in software component BC-MUS-POW. This development package consists of objects that can be grouped under "generic worklist".
It is part of development package GEN_PERSONAL_OBJECT_WORKLIST in software component BC-MUS-POW. This development package consists of objects that can be grouped under "generic worklist".
Fields for table POWL_ACT_QUERY
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 3 | * |
| QUERY | Query ID | X | POWL_QUERY_TY | CHAR | 32 | POWL_QUERY |
| APPLID | Application ID | X | POWL_APPLID_TY | CHAR | 30 | FPB_PERSAPPL |
| USERNAME | User Name | X | XUSER | CHAR | 12 | * |
| RESULT_COUNT | entry counter | POWL_COUNT_TY | INT4 | 4 | ||
| REFRESH_DATE | Refresh date | POWL_REFRESHD_TY | DATS | 8 | ||
| REFRESH_TIME | Refresh time | POWL_REFRESHT_TY | TIMS | 6 | ||
| REFRESH_TZONE | Refresh time zone | POWL_REFRESHZ_TY | CHAR | 6 | ||
| ESTTIME | Estimated execution time | POWL_ESTTIME_TY | INT4 | 4 | ||
| CATEGORY | Category | POWL_CATEGORY_TY | CHAR | 32 | ||
| CAT_SEQUENCE | sequence number for POWL query category | POWL_CAT_SEQ_TY | INT4 | 4 | ||
| CAT_QUERY_SEQ | sequence number for a query | POWL_QUERY_SEQ_TY | INT4 | 4 | ||
| TABS_QUERY_SEQ | sequence number for a query tabstrip | POWL_TAB_SEQ_TY | INT4 | 4 | ||
| LAYOUT | Layout variant for WD ALV | CHAR | 30 | |||
| ACTIVE | Activation | POWL_ACTIVATION_TY | CHAR | 1 | ||
| RESULT_CACHE_ID | GUID in 'CHAR' Format in Uppercase | GUID_32 | CHAR | 32 | ||
| LAST_USAGE_DATE | Last usage date of this active query | POWL_LASTUSD_TY | DATS | 8 | ||
| LAST_USAGE_TIME | Last usage time of this active query | POWL_LASTUST_TY | TIMS | 6 | ||
| REFRESH_TYPE | Query Refresh Type | POWL_REFRESH_TY | CHAR | 1 | ||
| STATUS | Status | CHAR | 10 |