SAP TUNEHDWQ Table in S/4 HANA - Statistical data re. SAP buffer & quality/hit ratios
TUNEHDWQ is a standard SAP Table which is used to store Statistical data re. SAP buffer & quality/hit ratios data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the TUNEHDWQ table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Cannot Be Enhanced
Dictionary Type: Structure
Database Table: TUNEHDWQ
TUNEHDWQ table structure field list
Below is the full TUNEHDWQ field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| ALLOC_SIZE | Size of allocated address space | MEMALLOCSZ | INT4 | 10(0) | INT4 | |||||
| AVAIL_SIZE | Storage space available | MEMAVAILSZ | INT4 | 10(0) | INT4 | |||||
| FRAME_SIZE | Length of the buffer frames | BFRAMESIZE | INT4 | 10(0) | INT4 | |||||
| MAX_OBJCTS | Maximum no. of objects | MAXOBJECTS | INT4 | 10(0) | INT4 | |||||
| HASH_WIDTH | Width of hashing values used | HASHWIDTH | INT4 | 10(0) | INT4 | |||||
| CUT_VALUE | Cut value | CUTVALUE | INT4 | 10(0) | INT4 | |||||
| ACT_OBJCTS | No. of active objects | ACTOBJECTS | INT4 | 10(0) | INT4 | |||||
| CON_OBJCTS | No. of known objects | CONOBJECTS | INT4 | 10(0) | INT4 | |||||
| USED_SPACE | Storage space used by active objects | ACTUSEDSPC | INT4 | 10(0) | INT4 | |||||
| MAX_FRMES | Max. no. of frames available | MAXFRAMES | INT4 | 10(0) | INT4 | |||||
| ALLOC_FRMS | Number of frames used | ALLOCFRMS | INT4 | 10(0) | INT4 | |||||
| REQUEST | No. of object requests to the buffer | BUFREQUEST | INT4 | 10(0) | INT4 | |||||
| HIT | No. of successful request | HITCOUNT | INT4 | 10(0) | INT4 | |||||
| OBJ_N_FND | No. of failed requests | BUFOBJNFND | INT4 | 10(0) | INT4 | |||||
| INSERT | Number of buffer inserts | BUFINSERTS | INT4 | 10(0) | INT4 | |||||
| UPDATE | No. of object changes | BUFUPDATES | INT4 | 10(0) | INT4 | |||||
| REQ_DELETE | No. of delete requests for an object from the buffer | BUFREQDEL | INT4 | 10(0) | INT4 | |||||
| DELETE | No. of invalidated objects | BUFDELETES | INT4 | 10(0) | INT4 | |||||
| FREE_OBJCT | No. of objects released from the buffer | BUFFREES | INT4 | 10(0) | INT4 | |||||
| DB_ACCESS | No. of database accesses | NODBACCESS | INT4 | 10(0) | INT4 | |||||
| DB_ACC_SVD | No. of database accesses saved | NODBACCSVD | INT4 | 10(0) | INT4 | |||||
| REORG | No. of buffer compact./reorg. | REORGCNT | INT4 | 10(0) | INT4 | |||||
| SWAP | No. of objects swapped | SWAPCNT | INT4 | 10(0) | INT4 | |||||
| SWAP_FRAME | No. of frames swapped | SWAPFRMCNT | INT4 | 10(0) | INT4 | |||||
| SEARCH | No. of search operations | BUFSEARCH | INT4 | 10(0) | INT4 | |||||
| SEARCH_INS | No. of search operations during roll-in | BUFSEARCHI | INT4 | 10(0) | INT4 | |||||
| SUM_SIZE | Sum of the sizes of the rolled-in objects | BUFOBJSUSZ | INT4 | 10(0) | INT4 | |||||
| SUM_SIZE2 | Sum of sizes of rolled-in objects (power of 2) | BUFOBJSQSZ | INT4 | 10(0) | INT4 | |||||
| MAX_SIZE | Maximum objet size | BUFMAXOBJS | INT4 | 10(0) | INT4 | |||||
| MIN_SIZE | Minimum object size | BUFMINOBJS | INT4 | 10(0) | INT4 | |||||
| REFRESH | Counter for the number of buffer refreshes | BUFREFRCNT | INT4 | 10(0) | INT4 | |||||
| SIZE_UNIT | Unit used if # kB | BUFSZUNIT | INT4 | 10(0) | INT4 | |||||
| RESERVE | 4 Byte Signed Integer | INT4 | INT4 | 10(0) | INT4 | |||||
| ALLOC | Storage class | BUFMEMCLS | CHAR | 1(0) | BUFMEMCLS | |||||
| SMODE | Search procedure | BUFSMODE | CHAR | 1(0) | BUFSMODE | |||||
| UP_TIME | Start time for statistics | BUFUPTIME | CHAR | 14(0) | CHAR14 | |||||
| LAST_REFR | Time of Last Buffer Refresh | BUFLSTREFR | CHAR | 14(0) | CHAR14 | |||||
| NAME | Area name | BUFNAME | CHAR | 5(0) | BUFNAME | |||||
| HITRATIO | Hit rate SAP buffer | BUFQUAL_HR | DEC | 7(4) | BUFQUAL | |||||
| DB_QUALITY | Quality of the SAP buffer (DB interface) | BUFQUAL_DB | DEC | 7(4) | BUFQUAL |
Search for further information about these or an SAP related objects