SAP table TXW_VWLOG2 (View query log)

SAP table TXW_VWLOG2 has 3 primary key fields being MANDT,FILE_UUID,VOL_ID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

TXW_VWLOG2 foreign key relationships

Table Field Check Table Check Field
0 TXW_VWLOG2 TAX_VIEW TXW_C_V0 Data view: Header MANDT
0 TXW_VWLOG2 TAX_VIEW TXW_C_V0 Data view: Header TAX_VIEW
1 TXW_VWLOG2 VOL_SET TXW_C_VOL Data file directory sets VOL_SET