- Home
- Resources
- SAP Tables
- V_T5UT1 - Generated Table for View
SAP Table V_T5UT1
Generated Table for View
V_T5UT1 (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link V_T5UT1 to other SAP tables.
Source: V_T5UT1 (Generated Table for View)
V_T5UT1 table fields
Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
TXCMP |
Tax company |
TXCMP |
T5UTL
|
CHAR |
|
4 |
0 |
|
WKSIT |
Worksite |
WKSIT |
T5UTV
|
CHAR |
|
2 |
0 |
|
TAXAU |
Tax authority |
TAXAT |
T5UTZ
|
CHAR |
|
4 |
0 |
|
TAXTY |
Tax form group |
TAXKN |
T51TA
|
CHAR |
|
4 |
0 |
|
PERNR |
Personnel Number |
PERNR_D |
|
NUMC |
|
8 |
0 |
|
PAYDT |
Tax pay date |
P00T_PAYDT |
T51T9
|
NUMC |
|
6 |
0 |
|
TBETR |
Taxable amount, wage, number |
TBETR |
|
CURR |
|
12 |
2 |
|
TAXBT |
Tax amount, rate |
TAXBT |
|
CURR |
|
12 |
2 |
|
LTEXT |
Description |
DESC30 |
|
CHAR |
|
30 |
0 |
|
FRMFG |
Foreign tax form table entry |
FRMFG |
|
CHAR |
|
1 |
0 |
Possible values
|
CDATE |
Pay date for payroll result |
PAY_DATE |
|
DATS |
|
8 |
0 |
|
ABKRS |
Payroll Area |
ABKRS |
T549A
|
CHAR |
|
2 |
0 |
|
FRYER |
Year, for which tax was retroactivly payed |
FORYR |
|
NUMC |
|
4 |
0 |
|
FRMON |
month, for which a tax amount was retroactivly payed |
FRMON |
|
NUMC |
|
2 |
0 |
Possible values
|
CMPTX |
Description |
DESC40 |
|
CHAR |
|
40 |
0 |
|
WKSTX |
Description |
DESC30 |
|
CHAR |
|
30 |
0 |
|
TTYTX |
Tax form group text |
TTYTX |
|
CHAR |
|
40 |
0 |
|
V_T5UT1 foreign key relationships
Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
V_T5UT1 |
ABKRS |
V_T5UT1 |
ABKRS |
T549A |
Payroll areas |
ABKRS |
V_T5UT1 |
ABKRS |
V_T5UT1 |
MANDT |
T549A |
Payroll areas |
MANDT |
V_T5UT1 |
MANDT |
V_T5UT1 |
MANDT |
T000 |
Clients |
MANDT |
V_T5UT1 |
PAYDT |
V_T5UT1 |
PAYDT |
T51T9 |
Tax pay dates |
PAYDT |
V_T5UT1 |
PAYDT |
'10' |
|
T51T9 |
Tax pay dates |
MOLGA |
V_T5UT1 |
PAYDT |
V_T5UT1 |
MANDT |
T51T9 |
Tax pay dates |
MANDT |
V_T5UT1 |
TAXAU |
V_T5UT1 |
MANDT |
T5UTZ |
Tax Authorities |
MANDT |
V_T5UT1 |
TAXAU |
V_T5UT1 |
TAXAU |
T5UTZ |
Tax Authorities |
TAXAU |
V_T5UT1 |
TAXTY |
V_T5UT1 |
MANDT |
T51TA |
Wage or tax form group for tax reporter |
MANDT |
V_T5UT1 |
TAXTY |
'10' |
|
T51TA |
Wage or tax form group for tax reporter |
MOLGA |
V_T5UT1 |
TAXTY |
V_T5UT1 |
TAXTY |
T51TA |
Wage or tax form group for tax reporter |
TAXTY |
V_T5UT1 |
TXCMP |
V_T5UT1 |
TXCMP |
T5UTL |
Tax Company |
TXCMP |
V_T5UT1 |
TXCMP |
V_T5UT1 |
MANDT |
T5UTL |
Tax Company |
MANDT |
V_T5UT1 |
WKSIT |
* |
|
T5UTV |
Unemployment Insurance Work Sites/NC-9901 Locations |
ENDDA |
V_T5UT1 |
WKSIT |
V_T5UT1 |
WKSIT |
T5UTV |
Unemployment Insurance Work Sites/NC-9901 Locations |
WKSIT |
V_T5UT1 |
WKSIT |
V_T5UT1 |
TAXAU |
T5UTV |
Unemployment Insurance Work Sites/NC-9901 Locations |
TAXAU |
V_T5UT1 |
WKSIT |
V_T5UT1 |
TXCMP |
T5UTV |
Unemployment Insurance Work Sites/NC-9901 Locations |
TXCMP |
V_T5UT1 |
WKSIT |
V_T5UT1 |
MANDT |
T5UTV |
Unemployment Insurance Work Sites/NC-9901 Locations |
MANDT |