SWNCSUBDB SAP (SAP Workload NW Collector: DB Statistics Subrecord) Structure details

Dictionary Type: Structure
Description: SAP Workload NW Collector: DB Statistics Subrecord




ABAP Code to SELECT data from SWNCSUBDB
Related tables to SWNCSUBDB
Access table SWNCSUBDB




Structure field list including key, data, relationships and ABAP select examples

SWNCSUBDB 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 "SAP Workload NW Collector: DB Statistics Subrecord" 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_SWNCSUBDB TYPE SWNCSUBDB.

The SWNCSUBDB table consists of various fields, each holding specific information or linking keys about SAP Workload NW Collector: DB Statistics Subrecord data available in SAP. These include READDIRCNT (SAP Workload NW Collector: Counter (Short)), READDIRTI (SAP Workload NW Collector: Time in Microseconds (Long)), READDIRREC (SAP Workload NW Collector: Counter (Short)), READDIRBUF (SAP Workload NW Collector: Counter (Short)).. 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 SWNCSUBDB 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
CONNECTION_NAMESAP Workload NW Collector: Text Field of 30 Characters SWNCTXT30CHAR30SWNCDOMTXT30
READDIRCNTSAP Workload NW Collector: Counter (Short) SWNCSHCNTDEC12SWNCDOMDEC12
READDIRTISAP Workload NW Collector: Time in Microseconds (Long) SWNCTIMUSLDEC24SWNCDOMDEC24
READDIRRECSAP Workload NW Collector: Counter (Short) SWNCSHCNTDEC12SWNCDOMDEC12
READDIRBUFSAP Workload NW Collector: Counter (Short) SWNCSHCNTDEC12SWNCDOMDEC12
READSEQCNTSAP Workload NW Collector: Counter (Short) SWNCSHCNTDEC12SWNCDOMDEC12
READSEQTISAP Workload NW Collector: Time in Microseconds (Long) SWNCTIMUSLDEC24SWNCDOMDEC24
READSEQRECSAP Workload NW Collector: Counter (Short) SWNCSHCNTDEC12SWNCDOMDEC12
READSEQBUFSAP Workload NW Collector: Counter (Short) SWNCSHCNTDEC12SWNCDOMDEC12
PHYREADCNTSAP Workload NW Collector: Counter (Short) SWNCSHCNTDEC12SWNCDOMDEC12
INSCNTSAP Workload NW Collector: Counter (Short) SWNCSHCNTDEC12SWNCDOMDEC12
INSTISAP Workload NW Collector: Time in Microseconds (Long) SWNCTIMUSLDEC24SWNCDOMDEC24
INSRECSAP Workload NW Collector: Counter (Short) SWNCSHCNTDEC12SWNCDOMDEC12
PHYINSCNTSAP Workload NW Collector: Counter (Short) SWNCSHCNTDEC12SWNCDOMDEC12
UPDCNTSAP Workload NW Collector: Counter (Short) SWNCSHCNTDEC12SWNCDOMDEC12
UPDTISAP Workload NW Collector: Time in Microseconds (Long) SWNCTIMUSLDEC24SWNCDOMDEC24
UPDRECSAP Workload NW Collector: Counter (Short) SWNCSHCNTDEC12SWNCDOMDEC12
PHYUPDCNTSAP Workload NW Collector: Counter (Short) SWNCSHCNTDEC12SWNCDOMDEC12
DELCNTSAP Workload NW Collector: Counter (Short) SWNCSHCNTDEC12SWNCDOMDEC12
DELTISAP Workload NW Collector: Time in Microseconds (Long) SWNCTIMUSLDEC24SWNCDOMDEC24
DELRECSAP Workload NW Collector: Counter (Short) SWNCSHCNTDEC12SWNCDOMDEC12
PHYDELCNTSAP Workload NW Collector: Counter (Short) SWNCSHCNTDEC12SWNCDOMDEC12
COMMITTISAP Workload NW Collector: Time in Microseconds (Long) SWNCTIMUSLDEC24SWNCDOMDEC24
DBPROCNTSAP Workload NW Collector: Counter (Short) SWNCSHCNTDEC12SWNCDOMDEC12
DBPROCTISAP Workload NW Collector: Time in Microseconds (Long) SWNCTIMUSLDEC24SWNCDOMDEC24

Key field Non-key field



How do I retrieve data from SAP structure SWNCSUBDB using ABAP code?

As SWNCSUBDB 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 SWNCSUBDB as there is no data to select.

How to access SAP table SWNCSUBDB

Within an ECC or HANA version of SAP you can also view further information about SWNCSUBDB and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!