SAP table TXW_C_V0 (Data view: Header)
SAP table TXW_C_V0 has 2 primary key fields being MANDT,TAX_VIEW.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
MANDT
Client
CLNT
3
0
T000
MANDT
TAX_VIEW
Data file view
CHAR
10
0
TXW_TXVIEW
VIEW_PROG
Name of generated view query program
CHAR
40
0
*
TXW_VWPROG
AUTHGRP
Authorization Group
CHAR
4
0
TBRG
BRGRU
SAPRL
Release of SAP System
CHAR
4
0
SYSAPRL
DART_RL
Release of SAP System
CHAR
4
0
SYSAPRL
X_CHANGED
Checkbox
CHAR
1
0
XFELD
Possible values
X_O_JOIN
Checkbox
CHAR
1
0
XFELD
Possible values
X_NO_DUPS
Flag: Eliminate duplicate records
CHAR
1
0
TXW_NODUPS
X_TOT_ONLY
Flag: Limit view output to totals only
CHAR
1
0
TXW_TOTONLY
X_FILTER
Flag: Only filter extract data - no restriction on JOIN
CHAR
1
0
TXW_FILTER
CUSER
User Name
CHAR
12
0
SYUNAME
CDATE
System Date
DATS
8
0
SYDATUM
CTIME
System Time
TIMS
6
0
SYUZEIT
AUTHGRP_VDEF
Authorization Group View definition
CHAR
4
0
*
TXW_BRGRU_VDEF
TXW_C_V0 foreign key relationships
Table
Field
Check Table
Check Field
0 TXW_C_V0
AUTHGRP
TBRG
Authorization groups
MANDT
0 TXW_C_V0
AUTHGRP
TBRG
Authorization groups
BRGRU