SAP Table TXW_VWLOG2
View query log
TXW_VWLOG2 (View query log) 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 TXW_VWLOG2 to other SAP tables.
TXW_VWLOG2 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||
| FILE_UUID | UUID identifier | TXW_UUID | CHAR | 32 | 0 | |||||||
| VOL_ID | Volume ID | TXW_VOL_ID | NUMC | 2 | 0 | |||||||
| FISC_YEAR | Fiscal Year | GJAHR | NUMC | 4 | 0 | |||||||
| TAX_VIEW | Data file view | TXW_TXVIEW | TXW_C_V0 | CHAR | 10 | 0 | ||||||
| FILE_ID | View query file id | TXW_FILEID | NUMC | 6 | 0 | |||||||
| XTRCT_UUID | UUID identifier | TXW_UUID | CHAR | 32 | 0 | |||||||
| L_FILE | Data File Name | TXW_LFILE | CHAR | 30 | 0 | |||||||
| VOL_SET | Data file directory set | TXW_VOLSET | TXW_C_VOL | CHAR | 10 | 0 | ||||||
| HOST | Application Server | SYHOST | CHAR | 32 | 0 | |||||||
| TXTLG | Description | TXW_TXTLG | CHAR | 60 | 0 | |||||||
| DART_RL | Release of SAP System | SYSAPRL | CHAR | 4 | 0 | |||||||
| SELUSER | User Name | SYUNAME | CHAR | 12 | 0 | |||||||
| SELDATE | System Date | SYDATUM | DATS | 8 | 0 | |||||||
| SELTIME | System Time | SYUZEIT | TIMS | 6 | 0 | |||||||
| DELUSER | Deletion: User | TXW_DELNAME | CHAR | 12 | 0 | |||||||
| DELDATE | Deletion: Date | TXW_DELDATE | DATS | 8 | 0 | |||||||
| DELTIME | Deletion: Time | TXW_DELTIME | TIMS | 6 | 0 | |||||||
| RECORDS | Number of records (counter) | TXW_RCDCNT10 | NUMC | 10 | 0 | |||||||
| TIME_SECS | Elapsed time in seconds | TXW_TIMSEC | NUMC | 5 | 0 | |||||||
| FILE_SIZE | File size in bytes | TXW_FSIZE | NUMC | 10 | 0 | |||||||
| X_ALE | Checkbox | XFELD | CHAR | 1 | 0 |
Possible values
|
||||||
| ALEUSER | ArchiveLink export: User name | TXW_ALENAME | CHAR | 12 | 0 | |||||||
| ALEDATE | ArchiveLink export: Date | TXW_ALEDATE | DATS | 8 | 0 | |||||||
| ALETIME | ArchiveLink export: Time | TXW_ALETIME | TIMS | 6 | 0 | |||||||
| ALESTAT | SAP ArchiveLink: Request status | SAEREQSTAT | CHAR | 4 | 0 | |||||||
| X_ALI | Checkbox | XFELD | CHAR | 1 | 0 |
Possible values
|
||||||
| ALIUSER | ArchiveLink import: User name | TXW_ALINAME | CHAR | 12 | 0 | |||||||
| ALIDATE | ArchiveLink import: Date | TXW_ALIDATE | DATS | 8 | 0 | |||||||
| ALITIME | ArchiveLink import: Time | TXW_ALITIME | TIMS | 6 | 0 | |||||||
| ALISTAT | SAP ArchiveLink: Request status | SAEREQSTAT | CHAR | 4 | 0 | |||||||
| NEXT_VOL | Id of next volume | TXW_NEXT_V | NUMC | 2 | 0 | |||||||
TXW_VWLOG2 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TXW_VWLOG2 | TAX_VIEW | TXW_VWLOG2 | MANDT | TXW_C_V0 | Data view: Header | MANDT |
| TXW_VWLOG2 | TAX_VIEW | TXW_VWLOG2 | TAX_VIEW | TXW_C_V0 | Data view: Header | TAX_VIEW |
| TXW_VWLOG2 | VOL_SET | TXW_VWLOG2 | MANDT | TXW_C_VOL | Data file directory sets | MANDT |
| TXW_VWLOG2 | VOL_SET | TXW_VWLOG2 | VOL_SET | TXW_C_VOL | Data file directory sets | VOL_SET |
