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

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_DIR	Table Relationship Diagram
Short Description	Data file log (replaced by txw_dir2, use of guids)

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	EXTRACT_ID	☑	TXW_EXT_ID	NUM4	NUMC	4	0	Data extract ID (to be replaced in release 99 by txw_uuid)
3	VOL_ID	☑	TXW_VOL_ID	TXW_VOL_ID	NUMC	2	0	Volume ID
4	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
5	ISOURCE	☐	TXW_ISRC	CHAR30	CHAR	30	0	Info Source (should be overwritten with RSISOURCE from BRS)
6	FISC_YEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
7	REQUSER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
8	SELDATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
9	SELTIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
10	SAPRL	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
11	TXTLG	☐	TXW_TXTLG	TXT60	CHAR	60	0	Description
12	DIRSEG_VOL	☐	TXW_DIRVOL	TXW_VOL_ID	NUMC	2	0	Volume id of segment directory
13	DIRSEG_ADR	☐	TXW_DIRADR	TXW_ADDR	NUMC	10	0	Segment directory address
14	FIRST_REC	☐	TXW_FIRSTD	TXW_ADDR	NUMC	10	0	Address of first data record in file (volume)
15	LAST_REC	☐	TXW_LASTD	TXW_ADDR	NUMC	10	0	Address of last data record in file (volume)
16	FILE_SIZE	☐	TXW_FSIZE	TXW_ADDR	NUMC	10	0	File size in bytes
17	FILE_NAME	☐	TXW_FILE	TEXT132	CHAR	132	0	Physical file name
18	NEXT_VOL	☐	TXW_NEXT_V	TXW_VOL_ID	NUMC	2	0	Id of next volume
19	X_COMPRESS	☐	TXW_X_CMPR	XFELD	CHAR	1	0	Flag: Compress data records
20	L_FILE	☐	TXW_LFILE	TEXT30	CHAR	30	0	Data File Name
21	VOL_SET	☐	TXW_VOLSET	TXW_VOLSET	CHAR	10	0	Data file directory set	TXW_C_VOL
22	CHECK_SUM	☐	TXW_CHECKS	TXW_CHECKS	NUMC	32	0	Byte-level check sum
23	DELIMITER	☐	TXW_FLDDEL	CHAR1	CHAR	1	0	Field delimiter for compressed records
24	EOL_BYTES	☐	TXW_EOLBYT	NUM1	NUMC	1	0	Number of bytes for end-of-line mark
25	TIME_SECS	☐	TXW_TIMSEC	NUM5	NUMC	5	0	Elapsed time in seconds
26	HOST	☐	SYHOST	HOST_ID	CHAR	32	0	Application Server
27	DART_RL	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
28	X_ISO9660	☐	TXW_X_ISO	XFELD	CHAR	1	0	Flag: Require filenames following ISO 9660 CD-ROM format
29	DELUSER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
30	DELDATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
31	DELTIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
32	ALEUSER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
33	ALEDATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
34	ALETIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
35	ALESTAT	☐	SAEREQSTAT	SADC4	CHAR	4	0	SAP ArchiveLink: Request status
36	ALIUSER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
37	ALIDATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
38	ALITIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
39	ALISTAT	☐	SAEREQSTAT	SADC4	CHAR	4	0	SAP ArchiveLink: Request status
40	X_ALE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
41	X_ALI	☐	XFELD	XFELD	CHAR	1	0	Checkbox

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in