TXW_VWLOG - View query log (replaced by txw_vwlog2: uuids)
View query log (replaced by txw_vwlog2: uuids) information is stored in SAP table TXW_VWLOG.
It is part of development package FTW1 in software component CA-GTF-DRT. This development package consists of objects that can be grouped under "Data Retention Tool".
It is part of development package FTW1 in software component CA-GTF-DRT. This development package consists of objects that can be grouped under "Data Retention Tool".
Fields for table TXW_VWLOG
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 3 | * |
| FISC_YEAR | Fiscal Year | X | GJAHR | NUMC | 4 | |
| TAX_VIEW | Data file view | X | TXW_TXVIEW | CHAR | 10 | TXW_C_V0 |
| FILE_ID | View query file id | X | TXW_FILEID | NUMC | 6 | |
| VOL_ID | Volume ID | X | TXW_VOL_ID | NUMC | 2 | |
| EXTRACT_ID | Data extract ID (to be replaced in release 99 by txw_uuid) | TXW_EXT_ID | NUMC | 4 | ||
| L_FILE | Data File Name | TXW_LFILE | CHAR | 30 | ||
| VOL_SET | Data file directory set | TXW_VOLSET | CHAR | 10 | TXW_C_VOL | |
| HOST | Application Server | SYHOST | CHAR | 32 | ||
| TXTLG | Description | TXW_TXTLG | CHAR | 60 | ||
| SELUSER | User Name | SYUNAME | CHAR | 12 | ||
| SELDATE | System Date | SYDATUM | DATS | 8 | ||
| SELTIME | System Time | SYUZEIT | TIMS | 6 | ||
| DELUSER | User Name | SYUNAME | CHAR | 12 | ||
| DELDATE | System Date | SYDATUM | DATS | 8 | ||
| DELTIME | System Time | SYUZEIT | TIMS | 6 | ||
| RECORDS | Number of records (counter) | TXW_RCDCNT | NUMC | 8 | ||
| TIME_SECS | Elapsed time in seconds | TXW_TIMSEC | NUMC | 5 | ||
| FILE_SIZE | File size in bytes | TXW_FSIZE | NUMC | 10 | ||
| X_ALE | Checkbox | XFELD | CHAR | 1 | ||
| ALEUSER | User Name | SYUNAME | CHAR | 12 | ||
| ALEDATE | System Date | SYDATUM | DATS | 8 | ||
| ALETIME | System Time | SYUZEIT | TIMS | 6 | ||
| ALESTAT | SAP ArchiveLink: Request status | SAEREQSTAT | CHAR | 4 | ||
| X_ALI | Checkbox | XFELD | CHAR | 1 | ||
| ALIUSER | User Name | SYUNAME | CHAR | 12 | ||
| ALIDATE | System Date | SYDATUM | DATS | 8 | ||
| ALITIME | System Time | SYUZEIT | TIMS | 6 | ||
| ALISTAT | SAP ArchiveLink: Request status | SAEREQSTAT | CHAR | 4 |