SAP ABAP Table TXW_DIR2 (Data file log)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FTW1 (Package) Data Retention Tool

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TXW_DIR2	Table Relationship Diagram
Short Description	Data file log

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	XTRCT_UUID	☑	TXW_UUID	SYSUUID_C	CHAR	32	0	UUID identifier
3	VOL_ID	☑	TXW_VOL_ID	TXW_VOL_ID	NUMC	2	0	Volume ID
4	DART_RL	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
5	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
6	EXTRACT_ID	☐	TXW_EXT_ID	NUM4	NUMC	4	0	Data extract ID (to be replaced in release 99 by txw_uuid)
7	ISOURCE	☐	TXW_ISRC	CHAR30	CHAR	30	0	Info Source (should be overwritten with RSISOURCE from BRS)
8	FISC_YEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
9	REQUSER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
10	SELDATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
11	SELTIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
12	SAPRL	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
13	TXTLG	☐	TXW_TXTLG	TXT60	CHAR	60	0	Description
14	DIRSEG_VOL	☐	TXW_DIRVOL	TXW_VOL_ID	NUMC	2	0	Volume id of segment directory
15	DIRSEG_ADR	☐	TXW_DIRADR	TXW_ADDR	NUMC	10	0	Segment directory address
16	FIRST_REC	☐	TXW_FIRSTD	TXW_ADDR	NUMC	10	0	Address of first data record in file (volume)
17	LAST_REC	☐	TXW_LASTD	TXW_ADDR	NUMC	10	0	Address of last data record in file (volume)
18	FILE_SIZE	☐	TXW_FSIZE	TXW_ADDR	NUMC	10	0	File size in bytes
19	FILE_NAME	☐	TXW_FILE	TEXT132	CHAR	132	0	Physical file name
20	NEXT_VOL	☐	TXW_NEXT_V	TXW_VOL_ID	NUMC	2	0	Id of next volume
21	X_COMPRESS	☐	TXW_X_CMPR	XFELD	CHAR	1	0	Flag: Compress data records
22	L_FILE	☐	TXW_LFILE	TEXT30	CHAR	30	0	Data File Name
23	VOL_SET	☐	TXW_VOLSET	TXW_VOLSET	CHAR	10	0	Data file directory set	TXW_C_VOL
24	CHECK_SUM	☐	TXW_CHECKS	TXW_CHECKS	NUMC	32	0	Byte-level check sum
25	DELIMITER	☐	TXW_FLDDEL	CHAR1	CHAR	1	0	Field delimiter for compressed records
26	EOL_BYTES	☐	TXW_EOLBYT	NUM1	NUMC	1	0	Number of bytes for end-of-line mark
27	TIME_SECS	☐	TXW_TIMS6	NUM6	NUMC	6	0	Elapsed time in seconds
28	HOST	☐	SYHOST	HOST_ID	CHAR	32	0	Application Server
29	X_ISO9660	☐	TXW_X_ISO	XFELD	CHAR	1	0	Flag: Require filenames following ISO 9660 CD-ROM format
30	DELUSER	☐	TXW_DELNAME	SYCHAR12	CHAR	12	0	Deletion: User
31	DELDATE	☐	TXW_DELDATE	SYDATS	DATS	8	0	Deletion: Date
32	DELTIME	☐	TXW_DELTIME	SYTIME	TIMS	6	0	Deletion: Time
33	ALEUSER	☐	TXW_ALENAME	SYCHAR12	CHAR	12	0	ArchiveLink export: User name
34	ALEDATE	☐	TXW_ALEDATE	SYDATS	DATS	8	0	ArchiveLink export: Date
35	ALETIME	☐	TXW_ALETIME	SYTIME	TIMS	6	0	ArchiveLink export: Time
36	ALESTAT	☐	SAEREQSTAT	SADC4	CHAR	4	0	SAP ArchiveLink: Request status
37	ALIUSER	☐	TXW_ALINAME	SYCHAR12	CHAR	12	0	ArchiveLink import: User name
38	ALIDATE	☐	TXW_ALIDATE	SYDATS	DATS	8	0	ArchiveLink import: Date
39	ALITIME	☐	TXW_ALITIME	SYTIME	TIMS	6	0	ArchiveLink import: Time
40	ALISTAT	☐	SAEREQSTAT	SADC4	CHAR	4	0	SAP ArchiveLink: Request status
41	X_ALE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
42	X_ALI	☐	XFELD	XFELD	CHAR	1	0	Checkbox
43	UNICODE_MODE	☐	TXW_UNICODE_MODE	TXW_UNICODE_MODE	CHAR	1	0	Unicode Mode for DART Files
44	INDEX_RECLEN	☐	TXW_INDEX_RECLEN	TXW_INDEX_RECLEN	NUMC	3	0	Index Record Length for Unicode Extracts
45	CODEPAGE	☐	TXW_CODEPAGE	NUMC4	NUMC	4	0	Codepage
46	BUKRS	☐	TXW_BUKRS	BUKRS	CHAR	4	0	Company Code	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TXW_DIR2	VOL_SET	TXW_C_VOL	VOL_SET		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in