TXW_DIR SAP (Data file log (replaced by txw_dir2, use of guids)) Table details

Dictionary Type: Table
Description: Data file log (replaced by txw_dir2, use of guids)




ABAP Code to SELECT data from TXW_DIR
Related tables to TXW_DIR
Access table TXW_DIR




Table field list including key, data, relationships and ABAP select examples

TXW_DIR is a standard SAP Table which is used to store Data file log (replaced by txw_dir2, use of guids) data and is available within R/3 SAP systems depending on the version and release level.

The TXW_DIR table consists of various fields, each holding specific information or linking keys about Data file log (replaced by txw_dir2, use of guids) data available in SAP. These include EXTRACT_ID (Data extract ID (to be replaced in release 99 by txw_uuid)), VOL_ID (Volume ID), LOGSYS (Logical system), ISOURCE (Info Source (should be overwritten with RSISOURCE from BRS)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP TXW_DIR table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
EXTRACT_IDData extract ID (to be replaced in release 99 by txw_uuid) TXW_EXT_IDNUMC4NUM4
VOL_IDVolume ID TXW_VOL_IDNUMC2TXW_VOL_ID
LOGSYSLogical system LOGSYSCHAR10Assigned to domainALPHALOGSYS
ISOURCEInfo Source (should be overwritten with RSISOURCE from BRS) TXW_ISRCCHAR30CHAR30
FISC_YEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
REQUSERUser Name SYUNAMECHAR12SYCHAR12
SELDATESystem Date SYDATUMDATS8SYDATS
SELTIMESystem Time SYUZEITTIMS6SYTIME
SAPRLRelease of SAP System SYSAPRLCHAR4SYCHAR04
TXTLGDescription TXW_TXTLGCHAR60TXT60
DIRSEG_VOLVolume id of segment directory TXW_DIRVOLNUMC2TXW_VOL_ID
DIRSEG_ADRSegment directory address TXW_DIRADRNUMC10TXW_ADDR
FIRST_RECAddress of first data record in file (volume) TXW_FIRSTDNUMC10TXW_ADDR
LAST_RECAddress of last data record in file (volume) TXW_LASTDNUMC10TXW_ADDR
FILE_SIZEFile size in bytes TXW_FSIZENUMC10TXW_ADDR
FILE_NAMEPhysical file name TXW_FILECHAR132TEXT132
NEXT_VOLId of next volume TXW_NEXT_VNUMC2TXW_VOL_ID
X_COMPRESSFlag: Compress data records TXW_X_CMPRCHAR1XFELD
L_FILEData File Name TXW_LFILECHAR30TEXT30XW2TXW_LFILE
VOL_SETData file directory set TXW_VOLSETCHAR10TXW_C_VOLTXW_VOLSETXW3
CHECK_SUMByte-level check sum TXW_CHECKSNUMC32TXW_CHECKS
DELIMITERField delimiter for compressed records TXW_FLDDELCHAR1CHAR1
EOL_BYTESNumber of bytes for end-of-line mark TXW_EOLBYTNUMC1NUM1
TIME_SECSElapsed time in seconds TXW_TIMSECNUMC5NUM5
HOSTApplication Server SYHOSTCHAR32HOST_ID
DART_RLRelease of SAP System SYSAPRLCHAR4SYCHAR04
X_ISO9660Flag: Require filenames following ISO 9660 CD-ROM format TXW_X_ISOCHAR1XFELD
DELUSERUser Name SYUNAMECHAR12SYCHAR12
DELDATESystem Date SYDATUMDATS8SYDATS
DELTIMESystem Time SYUZEITTIMS6SYTIME
ALEUSERUser Name SYUNAMECHAR12SYCHAR12
ALEDATESystem Date SYDATUMDATS8SYDATS
ALETIMESystem Time SYUZEITTIMS6SYTIME
ALESTATSAP ArchiveLink: Request status SAEREQSTATCHAR4SADC4
ALIUSERUser Name SYUNAMECHAR12SYCHAR12
ALIDATESystem Date SYDATUMDATS8SYDATS
ALITIMESystem Time SYUZEITTIMS6SYTIME
ALISTATSAP ArchiveLink: Request status SAEREQSTATCHAR4SADC4
X_ALECheckbox XFELDCHAR1XFELD
X_ALICheckbox XFELDCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table TXW_DIR using ABAP code

The following ABAP code Example will allow you to do a basic selection on TXW_DIR to SELECT all data from the table
DATA: WA_TXW_DIR TYPE TXW_DIR.

SELECT SINGLE *
FROM TXW_DIR
INTO CORRESPONDING FIELDS OF WA_TXW_DIR
WHERE...

How to access SAP table TXW_DIR

Within an ECC or HANA version of SAP you can also view further information about TXW_DIR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!