TXW_VWLOG2 - View query log
View query log information is stored in SAP table TXW_VWLOG2.
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_VWLOG2
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| FILE_UUID | UUID identifier | X | TXW_UUID | CHAR | 64 | |
| VOL_ID | Volume ID | X | TXW_VOL_ID_C | CHAR | 4 | |
| FISC_YEAR | Fiscal Year | GJAHR | NUMC | 8 | ||
| TAX_VIEW | Data file view | TXW_TXVIEW | CHAR | 20 | TXW_C_V0 | |
| FILE_ID | View query file id | TXW_FILEID | NUMC | 12 | ||
| XTRCT_UUID | UUID identifier | TXW_UUID | CHAR | 64 | ||
| L_FILE | Data File Name | TXW_LFILE | CHAR | 60 | ||
| VOL_SET | Data file directory set | TXW_VOLSET | CHAR | 20 | TXW_C_VOL | |
| HOST | Application Server | SYHOST | CHAR | 64 | ||
| TXTLG | Description | TXW_TXTLG | CHAR | 120 | ||
| DART_RL | Release of SAP System | SYSAPRL | CHAR | 8 | ||
| SELUSER | User Name | SYUNAME | CHAR | 24 | ||
| SELDATE | System Date | SYDATUM | DATS | 16 | ||
| SELTIME | System Time | SYUZEIT | TIMS | 12 | ||
| DELUSER | Deletion: User | TXW_DELNAME | CHAR | 24 | ||
| DELDATE | Deletion: Date | TXW_DELDATE | DATS | 16 | ||
| DELTIME | Deletion: Time | TXW_DELTIME | TIMS | 12 | ||
| RECORDS | Number of records (counter) | TXW_RCDCNT10 | NUMC | 20 | ||
| TIME_SECS | Elapsed time in seconds | TXW_TIMSEC | NUMC | 10 | ||
| FILE_SIZE | File size in bytes | TXW_FSIZE15 | NUMC | 30 | ||
| X_ALE | Checkbox | XFELD | CHAR | 2 | ||
| ALEUSER | ArchiveLink export: User name | TXW_ALENAME | CHAR | 24 | ||
| ALEDATE | ArchiveLink export: Date | TXW_ALEDATE | DATS | 16 | ||
| ALETIME | ArchiveLink export: Time | TXW_ALETIME | TIMS | 12 | ||
| ALESTAT | SAP ArchiveLink: Request status | SAEREQSTAT | CHAR | 8 | ||
| X_ALI | Checkbox | XFELD | CHAR | 2 | ||
| ALIUSER | ArchiveLink import: User name | TXW_ALINAME | CHAR | 24 | ||
| ALIDATE | ArchiveLink import: Date | TXW_ALIDATE | DATS | 16 | ||
| ALITIME | ArchiveLink import: Time | TXW_ALITIME | TIMS | 12 | ||
| ALISTAT | SAP ArchiveLink: Request status | SAEREQSTAT | CHAR | 8 | ||
| NEXT_VOL | Id of next volume | TXW_NEXT_V_C | CHAR | 4 | ||
| AL_ZIP | Compress file during archiving | TXW_ZIP | CHAR | 2 | ||
| PREFIX | File name: prefix | TXW_PREFIX | CHAR | 40 | ||
| SUFFIX | File name: suffix | TXW_SUFFIX | CHAR | 6 | ||
| USE_DB | use DB for file storage | TXW_USE_DB | CHAR | 2 |