TXW_DIR - Data file log (replaced by txw_dir2, use of guids)
Data file log (replaced by txw_dir2, use of guids) information is stored in SAP table TXW_DIR.
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_DIR
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 3 | * |
| EXTRACT_ID | Data extract ID (to be replaced in release 99 by txw_uuid) | X | TXW_EXT_ID | NUMC | 4 | |
| VOL_ID | Volume ID | X | TXW_VOL_ID | NUMC | 2 | |
| LOGSYS | Logical system | LOGSYS | CHAR | 10 | * | |
| ISOURCE | Info Source (should be overwritten with RSISOURCE from BRS) | TXW_ISRC | CHAR | 30 | ||
| FISC_YEAR | Fiscal Year | GJAHR | NUMC | 4 | ||
| REQUSER | User Name | SYUNAME | CHAR | 12 | ||
| SELDATE | System Date | SYDATUM | DATS | 8 | ||
| SELTIME | System Time | SYUZEIT | TIMS | 6 | ||
| SAPRL | Release of SAP System | SYSAPRL | CHAR | 4 | ||
| TXTLG | Description | TXW_TXTLG | CHAR | 60 | ||
| DIRSEG_VOL | Volume id of segment directory | TXW_DIRVOL | NUMC | 2 | ||
| DIRSEG_ADR | Segment directory address | TXW_DIRADR | NUMC | 10 | ||
| FIRST_REC | Address of first data record in file (volume) | TXW_FIRSTD | NUMC | 10 | ||
| LAST_REC | Address of last data record in file (volume) | TXW_LASTD | NUMC | 10 | ||
| FILE_SIZE | File size in bytes | TXW_FSIZE | NUMC | 10 | ||
| FILE_NAME | Physical file name | TXW_FILE | CHAR | 132 | ||
| NEXT_VOL | Id of next volume | TXW_NEXT_V | NUMC | 2 | ||
| X_COMPRESS | Flag: Compress data records | TXW_X_CMPR | CHAR | 1 | ||
| L_FILE | Data File Name | TXW_LFILE | CHAR | 30 | ||
| VOL_SET | Data file directory set | TXW_VOLSET | CHAR | 10 | TXW_C_VOL | |
| CHECK_SUM | Byte-level check sum | TXW_CHECKS | NUMC | 32 | ||
| DELIMITER | Field delimiter for compressed records | TXW_FLDDEL | CHAR | 1 | ||
| EOL_BYTES | Number of bytes for end-of-line mark | TXW_EOLBYT | NUMC | 1 | ||
| TIME_SECS | Elapsed time in seconds | TXW_TIMSEC | NUMC | 5 | ||
| HOST | Application Server | SYHOST | CHAR | 32 | ||
| DART_RL | Release of SAP System | SYSAPRL | CHAR | 4 | ||
| X_ISO9660 | Flag: Require filenames following ISO 9660 CD-ROM format | TXW_X_ISO | CHAR | 1 | ||
| DELUSER | User Name | SYUNAME | CHAR | 12 | ||
| DELDATE | System Date | SYDATUM | DATS | 8 | ||
| DELTIME | System Time | SYUZEIT | TIMS | 6 | ||
| 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 | ||
| 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 | ||
| X_ALE | Checkbox | XFELD | CHAR | 1 | ||
| X_ALI | Checkbox | XFELD | CHAR | 1 |