SAP ABAP Table TXW_VWLOG2 (View query 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_VWLOG2	Table Relationship Diagram
Short Description	View query 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	FILE_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	FISC_YEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
5	TAX_VIEW	☐	TXW_TXVIEW	TXW_TXVIEW	CHAR	10	0	Data file view	TXW_C_V0
6	FILE_ID	☐	TXW_FILEID	NUM6	NUMC	6	0	View query file id
7	XTRCT_UUID	☐	TXW_UUID	SYSUUID_C	CHAR	32	0	UUID identifier
8	L_FILE	☐	TXW_LFILE	TEXT30	CHAR	30	0	Data File Name
9	VOL_SET	☐	TXW_VOLSET	TXW_VOLSET	CHAR	10	0	Data file directory set	TXW_C_VOL
10	HOST	☐	SYHOST	HOST_ID	CHAR	32	0	Application Server
11	TXTLG	☐	TXW_TXTLG	TXT60	CHAR	60	0	Description
12	DART_RL	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
13	SELUSER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
14	SELDATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
15	SELTIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
16	DELUSER	☐	TXW_DELNAME	SYCHAR12	CHAR	12	0	Deletion: User
17	DELDATE	☐	TXW_DELDATE	SYDATS	DATS	8	0	Deletion: Date
18	DELTIME	☐	TXW_DELTIME	SYTIME	TIMS	6	0	Deletion: Time
19	RECORDS	☐	TXW_RCDCNT10	NUMC10	NUMC	10	0	Number of records (counter)
20	TIME_SECS	☐	TXW_TIMSEC	NUM5	NUMC	5	0	Elapsed time in seconds
21	FILE_SIZE	☐	TXW_FSIZE	TXW_ADDR	NUMC	10	0	File size in bytes
22	X_ALE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
23	ALEUSER	☐	TXW_ALENAME	SYCHAR12	CHAR	12	0	ArchiveLink export: User name
24	ALEDATE	☐	TXW_ALEDATE	SYDATS	DATS	8	0	ArchiveLink export: Date
25	ALETIME	☐	TXW_ALETIME	SYTIME	TIMS	6	0	ArchiveLink export: Time
26	ALESTAT	☐	SAEREQSTAT	SADC4	CHAR	4	0	SAP ArchiveLink: Request status
27	X_ALI	☐	XFELD	XFELD	CHAR	1	0	Checkbox
28	ALIUSER	☐	TXW_ALINAME	SYCHAR12	CHAR	12	0	ArchiveLink import: User name
29	ALIDATE	☐	TXW_ALIDATE	SYDATS	DATS	8	0	ArchiveLink import: Date
30	ALITIME	☐	TXW_ALITIME	SYTIME	TIMS	6	0	ArchiveLink import: Time
31	ALISTAT	☐	SAEREQSTAT	SADC4	CHAR	4	0	SAP ArchiveLink: Request status
32	NEXT_VOL	☐	TXW_NEXT_V	TXW_VOL_ID	NUMC	2	0	Id of next volume

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TXW_VWLOG2	TAX_VIEW	TXW_C_V0	TAX_VIEW	KEY	1	CN
2	TXW_VWLOG2	VOL_SET	TXW_C_VOL	VOL_SET	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in