SAP Table SAPWLNDBCON
SAP Workload: Database Connections
SAPWLNDBCON (SAP Workload: Database Connections) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link SAPWLNDBCON to other SAP tables.
Source: SAPWLNDBCON (SAP Workload: Database Connections)
SAPWLNDBCON table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| TCODE | SAP Workload: Report or Transaction Name | SWLTCODE | CHAR | 40 | 0 | |||
| CONNECTION_NAME | SAP Workload: Logical Name of Database Connection | SWLDBCONN | CHAR | 30 | 0 | |||
| COUNTER | SAP Workload: Number of Dialog Steps per DB Connection | SWLDBCCNT | DEC | 24 | 0 | |||
| DBTIME | SAP Workload: Total Database Time (s) | SWLDBTI | DEC | 31 | 0 | |||
| DBTIME_AVG | SAP Workload: Average DB Time (ms) | SWLDBTIAVG | DEC | 25 | 1 | |||
| READSEQCNT | SAP Workload: Number of Sequential Reads | SWLSREADCN | DEC | 15 | 0 | |||
| READSEQST | SAP Workload: Total Logical Sequential Read Time (s) | SWLSREADST | DEC | 31 | 0 | |||
| READSEQMT | SAP Workload: Ø Logical Sequential Read Time (ms) | SWLSREADMT | DEC | 31 | 1 | |||
| READSEQREC | Number of Records Read with Sequential Read Access | SWLSREADREC | DEC | 30 | 0 | |||
| READDIRCNT | SAP Workload: Number of Direct Reads | SWLDREADCN | DEC | 15 | 0 | |||
| READDIRST | SAP Workload: Total Time for Logical Direct Reads (s) | SWLDREADST | DEC | 15 | 0 | |||
| READDIRMT | SAP Workload: Average Time for Logical Direct Reads (ms) | SWLDREADMT | DEC | 31 | 1 | |||
| READDIRREC | Number of Records Read in the Type "Direct Read" | SWLDREADREC | DEC | 30 | 0 | |||
| READSEQBUF | SAP Workload: Number of Sequential Read Accesses in Buffer | SWLSREADBUF | DEC | 30 | 0 | |||
| CHNGCNT | SAP Workload: Number of Logical Database Changes | SWLCHNGCN | DEC | 15 | 0 | |||
| CHNGST | SAP Workload: Total Time for Logical DB Changes (s) | SWLCHNGST | DEC | 15 | 0 | |||
| CHNGMT | SAP Workload: Average Change Time (ms) | SWLCHNGMT | DEC | 31 | 1 | |||
| CHNGREC | SAP Workload: Number of Changed DB Records | SWLCHNGREC | DEC | 30 | 0 | |||
| DBREQUCNT | SAP Workload: Logical Database Calls from ABAP | SWLDBREQCN | DEC | 15 | 0 | |||
| DBREQMTI | SAP Workload: Average Time per Logical Database Call (ms) | SWLDBREQMT | DEC | 31 | 1 | |||
| PHYREADCNT | SAP Workload: Number of Physical Database Read Accesses | SWLPHYRDCN | DEC | 15 | 0 | |||
| PHYCHNGREC | SAP Workload: Number of Modified Database Records | SWLPHYCHCN | DEC | 15 | 0 | |||
| PHYDBCALLS | SAP Workload: Number of Physical Database Accesses | SWLPHYDBCN | DEC | 30 | 0 | |||
| DBUFREADCN | SAP Workload: No. of Records Read from the Single Rec.Buffer | SWLDBUFRCN | DEC | 15 | 0 | |||
| DBPCOUNT | SAP Workload: Number of Database Procedure Calls | SWLDBCOUNT | DEC | 15 | 0 | |||
| DBPTIME | SAP Workload: Time for DB Accesses by DB Procedures (ms) | SWLDBPRTI1 | DEC | 15 | 1 | |||
| DBPTI_AVG | SAP Workload: Average Time per DB Procedure Call (ms) | SWLDBPRAV1 | DEC | 15 | 1 | |||
| COMMITTI | SAP Workload: Total COMMIT Time (s) | SWLDBCOMTI | DEC | 24 | 0 | |||
| COMMITTI_AVG | SAP Workload: COMMIT Time per Dialog Step (ms) | SWLDBCOMTIAVG | DEC | 25 | 1 | |||
