SAP table DBTABPRT (Table of log records for table tupel changes)
SAP table DBTABPRT has 5 primary key fields being TABNAME,AS4DATE,AS4TIME,VKEY,COUNTER.
| Field |
Description |
Data Type |
Length |
Decimals |
Checktable |
Data Element |
|
| TABNAME |
Table Name |
CHAR |
10 |
0 |
|
OLD_TABNAM
|
|
| AS4DATE |
Last Changed On |
DATS |
8 |
0 |
|
AS4DATE
|
|
| AS4TIME |
Last changed at |
TIMS |
6 |
0 |
|
AS4TIME
|
|
| VKEY |
Variable key part of table |
CHAR |
86 |
0 |
|
PTVKEY
|
|
| COUNTER |
Counter for uniqueness of the DBTABPRT key |
INT4 |
10 |
0 |
|
PTCNT
|
|
| HOSTNAME |
Host Name |
CHAR |
20 |
0 |
|
MSHOST
|
|
| AS4USER |
Last Changed By |
CHAR |
12 |
0 |
|
AS4USER
|
|
| TCODE |
Transaction code |
CHAR |
4 |
0 |
|
OLD_TCODE
|
|
| ABAPNAME |
ABAP: Program Name |
CHAR |
8 |
0 |
|
OLD_PROG
|
|
| OPTYPE |
Operation type of SQL statement |
CHAR |
1 |
0 |
|
OPTYPE
|
| D |
Operation type DELETE |
| I |
Operation type INSERT |
| U |
Operation type UPDATE |
|
| DATALN |
Actual length of vardata |
INT2 |
5 |
0 |
|
DATALN
|
|
| VDATA |
Variable data part for non-key fields |
LRAW |
500 |
0 |
|
PTVDATA
|
|