WLBWEXPTMP SAP (BW Workload: Reporting - WEB Template Level (All Data)) Structure details
Description: BW Workload: Reporting - WEB Template Level (All Data)
Structure field list including key, data, relationships and ABAP select examples
WLBWEXPTMP is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "BW Workload: Reporting - WEB Template Level (All Data)" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_WLBWEXPTMP TYPE WLBWEXPTMP.
The WLBWEXPTMP table consists of various fields, each holding specific information or linking keys about BW Workload: Reporting - WEB Template Level (All Data) data available in SAP. These include NRSESSIONS (Number of Web Template Sessions), NRQUERY (Number of Queries), NAVSTEP (Number of Navigation Steps), TIMETOTAL (Total Runtime (s)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP WLBWEXPTMP structure fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| TEMPLATE | Description of Web Template or Workbook | WLBWTEMPL | CHAR | 40 | WLBWCHAR40 | ||||
| NRSESSIONS | Number of Web Template Sessions | WLBWSESSNR | DEC | 15 | WLBWDEC15 | ||||
| NRQUERY | Number of Queries | WLBWQRYNR | DEC | 15 | WLBWDEC15 | ||||
| NAVSTEP | Number of Navigation Steps | WLBWNAVSTP | DEC | 15 | WLBWDEC15 | ||||
| TIMETOTAL | Total Runtime (s) | WLBWTIMTOT | DEC | 15(1) | WLBWTIME15 | ||||
| AVTOTNAVST | Average Total Runtime per Navigation Step (s) | WLBWAVTOTS | DEC | 15(1) | WLBWTIME15 | ||||
| MEDTOTAL | Median of Total Runtime (s) | WLBWMETOTS | DEC | 15(1) | WLBWTIME15 | ||||
| TIMEOLAP | OLAP Runtime (s) | WLBWTIMOL | DEC | 15(1) | WLBWTIME15 | ||||
| PCTTIMOLAP | Share of Total Runtime that is OLAP Runtime (%) | WLBWPTIMOL | DEC | 5(2) | WLBWPCENT1 | ||||
| AVOLPNAVST | Average OLAP Runtime per Navigation Step (s) | WLBWAVOLPS | DEC | 15(1) | WLBWTIME15 | ||||
| TIMEDB | Database Runtime (s) | WLBWTIMDB | DEC | 15(1) | WLBWTIME15 | ||||
| PCTTIMEDB | Share of Total Runtime that is Database Runtime (%) | WLBWPTIMDB | DEC | 5(2) | WLBWPCENT1 | ||||
| AVDBNAVST | Average Database Runtime per Navigation Step (s) | WLBWAVDBS | DEC | 15(1) | WLBWTIME15 | ||||
| TIMECLIENT | Frontend Runtime (s) | WLBWTIMCL | DEC | 15(1) | WLBWTIME15 | ||||
| PCTTIMECLI | Share of Total Runtime that is Frontend Runtime (%) | WLBWPTIMCL | DEC | 5(2) | WLBWPCENT1 | ||||
| AVCLINAVST | Average Frontend Runtime per Navigation Step (s) | WLBWAVCLIS | DEC | 15(1) | WLBWTIME15 | ||||
| TIMEPLAN | Runtime of the Planning Function (s) | WLBWTIMPLN | DEC | 15(1) | WLBWTIME15 | ||||
| PCTTIMPLAN | Proportion of Total Runtime for Planning Functions (%) | WLBWPTIMPL | DEC | 5(2) | WLBWPCENT1 | ||||
| AVPLNNAVST | Average Planning Runtime per Navigation Step (s) | WLBWAVPLN | DEC | 15(1) | WLBWTIME15 | ||||
| TIME_NA | Unassigned Runtime (s) | WLBWTIMNA | DEC | 15(1) | WLBWTIME15 | ||||
| PCTTIMNA | Proportion of Total Runtime that is Unassigned Time (%) | WLBWPTIMNA | DEC | 5(2) | WLBWPCENT1 | ||||
| AVNANAVST | Average Unassigned Time per Navigation Step (s) | WLBWAVNA | DEC | 15(1) | WLBWTIME15 | ||||
| DBSEL | Number of records selected | WLBWDBSEL | DEC | 15 | WLBWDEC15 | ||||
| DBTRANS | Number of Transferred Records | WLBWDBTRNS | DEC | 15 | WLBWDEC15 | ||||
| DBTRANSSEL | Ratio of Selected to Transferred Records | WLBWTRSEL | DEC | 15(1) | WLBWRATIO1 | ||||
| DBTIMSEL | Database Runtime per Selected Record (ms) | WLBWDBTSEL | DEC | 15(1) | WLBWRATIO1 | ||||
| LINECOLOR | BI Workload: Color Specification | WLBILINECOL | CHAR | 4 |
| Key field | Non-key field |
How do I retrieve data from SAP structure WLBWEXPTMP using ABAP code?
As WLBWEXPTMP is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on WLBWEXPTMP as there is no data to select.How to access SAP table WLBWEXPTMP
Within an ECC or HANA version of SAP you can also view further information about WLBWEXPTMP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects