The DBTABPRT table in SAP ERP or S/4HANA stores Table of log records for table tupel changes data. There are total 12 fields in DBTABPRT table. The Table of log records for table tupel changes table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DBTABPRT table. It is in BASIS System Tables (SBAT) ABAP package and is part of the ABAP Runtime Environment – ABAP Language Issues Only (BC-ABA) module.
SAP DBTABPRT Table Fields
Following is the list of fields that are available in SAP DBTABPRT table. The primary key fields of Table of log records for table tupel changes table in SAP are TABNAME (Table Name), AS4DATE (Last Changed On), AS4TIME (Last changed at), VKEY (Variable key part of table), COUNTER (Counter for uniqueness of the DBTABPRT key).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| TABNAME | Table Name | OLD_TABNAM | CHAR (10) | |
| AS4DATE | Last Changed On | AS4DATE | DATS (8) | |
| AS4TIME | Last changed at | AS4TIME | TIMS (6) | |
| VKEY | Variable key part of table | PTVKEY | CHAR (86) | |
| COUNTER | Counter for uniqueness of the DBTABPRT key | PTCNT | INT4 (10) | |
| HOSTNAME | Host Name | MSHOST | CHAR (20) | |
| AS4USER | Last Changed By | AS4USER | CHAR (12) | |
| TCODE | Transaction code | OLD_TCODE | CHAR (4) | |
| ABAPNAME | ABAP: Program Name | OLD_PROG | CHAR (8) | |
| OPTYPE | Operation type of SQL statement | OPTYPE | CHAR (1) | |
| DATALN | Actual length of vardata | DATALN | INT2 (5) | |
| VDATA | Variable data part for non-key fields | PTVDATA | LRAW (500) |
