TXW_DIR2 - Data file log
Data file log information is stored in SAP table TXW_DIR2.
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_DIR2
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| XTRCT_UUID | UUID identifier | X | TXW_UUID | CHAR | 64 | |
| VOL_ID | Volume ID | X | TXW_VOL_ID_C | CHAR | 4 | |
| DART_RL | Release of SAP System | SYSAPRL | CHAR | 8 | ||
| LOGSYS | Logical system | LOGSYS | CHAR | 20 | ||
| EXTRACT_ID | Data extract ID (to be replaced in release 99 by txw_uuid) | TXW_EXT_ID | NUMC | 8 | ||
| ISOURCE | Info Source (should be overwritten with RSISOURCE from BRS) | TXW_ISRC | CHAR | 60 | ||
| FISC_YEAR | Fiscal Year | GJAHR | NUMC | 8 | ||
| REQUSER | User Name | SYUNAME | CHAR | 24 | ||
| SELDATE | System Date | SYDATUM | DATS | 16 | ||
| SELTIME | System Time | SYUZEIT | TIMS | 12 | ||
| SAPRL | Release of SAP System | SYSAPRL | CHAR | 8 | ||
| TXTLG | Description | TXW_TXTLG | CHAR | 120 | ||
| DIRSEG_VOL | Volume id of segment directory | TXW_DIRVOL_C | CHAR | 4 | ||
| DIRSEG_ADR | Segment directory address | TXW_DIRADR | NUMC | 20 | ||
| FIRST_REC | Address of first data record in file (volume) | TXW_FIRSTD | NUMC | 20 | ||
| LAST_REC | Address of last data record in file (volume) | TXW_LASTD | NUMC | 20 | ||
| FILE_SIZE | File size in bytes | TXW_FSIZE | NUMC | 20 | ||
| FILE_NAME | Physical file name | TXW_FILE | CHAR | 264 | ||
| NEXT_VOL | Id of next volume | TXW_NEXT_V_C | CHAR | 4 | ||
| X_COMPRESS | Flag: Compress data records | TXW_X_CMPR | CHAR | 2 | ||
| L_FILE | Data File Name | TXW_LFILE | CHAR | 60 | ||
| VOL_SET | Data file directory set | TXW_VOLSET | CHAR | 20 | TXW_C_VOL | |
| CHECK_SUM | Byte-level check sum | TXW_CHECKS | NUMC | 64 | ||
| DELIMITER | Field delimiter for compressed records | TXW_FLDDEL | CHAR | 2 | ||
| EOL_BYTES | Number of bytes for end-of-line mark | TXW_EOLBYT | NUMC | 2 | ||
| TIME_SECS | Elapsed time in seconds | TXW_TIMS6 | NUMC | 12 | ||
| HOST | Application Server | SYHOST | CHAR | 64 | ||
| X_ISO9660 | Flag: Require filenames following ISO 9660 CD-ROM format | TXW_X_ISO | CHAR | 2 | ||
| DELUSER | Deletion: User | TXW_DELNAME | CHAR | 24 | ||
| DELDATE | Deletion: Date | TXW_DELDATE | DATS | 16 | ||
| DELTIME | Deletion: Time | TXW_DELTIME | TIMS | 12 | ||
| 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 | ||
| 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 | ||
| X_ALE | Checkbox | XFELD | CHAR | 2 | ||
| X_ALI | Checkbox | XFELD | CHAR | 2 | ||
| UNICODE_MODE | Unicode Mode for DART Files | TXW_UNICODE_MODE | CHAR | 2 | ||
| INDEX_RECLEN | Index Record Length for Unicode Extracts | TXW_INDEX_RECLEN | NUMC | 6 | ||
| CODEPAGE | Codepage | TXW_CODEPAGE | NUMC | 8 | ||
| BUKRS | Company Code | TXW_BUKRS | CHAR | 8 | ||
| AL_ZIP | Compress file during archiving | TXW_ZIP | CHAR | 2 | ||
| USE_DB | use DB for file storage | TXW_USE_DB | CHAR | 2 |