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
NULL No
X Yes
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
01 January - December
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