SAP ABAP Table TXW_VWLOG (View query log (replaced by txw_vwlog2: uuids))

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_VWLOG	Table Relationship Diagram
Short Description	View query log (replaced by txw_vwlog2: uuids)

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	FISC_YEAR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
3	TAX_VIEW	☑	TXW_TXVIEW	TXW_TXVIEW	CHAR	10	0	Data file view	TXW_C_V0
4	FILE_ID	☑	TXW_FILEID	NUM6	NUMC	6	0	View query file id
5	VOL_ID	☑	TXW_VOL_ID	TXW_VOL_ID	NUMC	2	0	Volume ID
6	EXTRACT_ID	☐	TXW_EXT_ID	NUM4	NUMC	4	0	Data extract ID (to be replaced in release 99 by txw_uuid)
7	L_FILE	☐	TXW_LFILE	TEXT30	CHAR	30	0	Data File Name
8	VOL_SET	☐	TXW_VOLSET	TXW_VOLSET	CHAR	10	0	Data file directory set	TXW_C_VOL
9	HOST	☐	SYHOST	HOST_ID	CHAR	32	0	Application Server
10	TXTLG	☐	TXW_TXTLG	TXT60	CHAR	60	0	Description
11	SELUSER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
12	SELDATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
13	SELTIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
14	DELUSER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
15	DELDATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
16	DELTIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
17	RECORDS	☐	TXW_RCDCNT	NUMC8	NUMC	8	0	Number of records (counter)
18	TIME_SECS	☐	TXW_TIMSEC	NUM5	NUMC	5	0	Elapsed time in seconds
19	FILE_SIZE	☐	TXW_FSIZE	TXW_ADDR	NUMC	10	0	File size in bytes
20	X_ALE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
21	ALEUSER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
22	ALEDATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
23	ALETIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
24	ALESTAT	☐	SAEREQSTAT	SADC4	CHAR	4	0	SAP ArchiveLink: Request status
25	X_ALI	☐	XFELD	XFELD	CHAR	1	0	Checkbox
26	ALIUSER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
27	ALIDATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
28	ALITIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
29	ALISTAT	☐	SAEREQSTAT	SADC4	CHAR	4	0	SAP ArchiveLink: Request status

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in