SAP table V_T5UT1 (Generated Table for View)

SAP table V_T5UT1 has 7 primary key fields being MANDT,TXCMP,WKSIT,TAXAU,TAXTY,PERNR,PAYDT.

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
TXCMP Tax company CHAR 4 0 T5UTL TXCMP
WKSIT Worksite CHAR 2 0 T5UTV WKSIT
TAXAU Tax authority CHAR 4 0 T5UTZ TAXAT
TAXTY Tax form group CHAR 4 0 T51TA TAXKN
PERNR Personnel Number NUMC 8 0 PERNR_D
PAYDT Tax pay date NUMC 6 0 T51T9 P00T_PAYDT
TBETR Taxable amount, wage, number CURR 12 2 TBETR
TAXBT Tax amount, rate CURR 12 2 TAXBT
LTEXT Description CHAR 30 0 DESC30
FRMFG Foreign tax form table entry CHAR 1 0 FRMFG
CDATE Pay date for payroll result DATS 8 0 PAY_DATE
ABKRS Payroll Area CHAR 2 0 T549A ABKRS
FRYER Year, for which tax was retroactivly payed NUMC 4 0 FORYR
FRMON month, for which a tax amount was retroactivly payed NUMC 2 0 FRMON
01 January - December
CMPTX Description CHAR 40 0 DESC40
WKSTX Description CHAR 30 0 DESC30
TTYTX Tax form group text CHAR 40 0 TTYTX

V_T5UT1 foreign key relationships

Table Field Check Table Check Field
0 V_T5UT1 ABKRS T549A Payroll areas MANDT
0 V_T5UT1 ABKRS T549A Payroll areas ABKRS
1 V_T5UT1 MANDT T000 Clients MANDT
0 V_T5UT1 PAYDT T51T9 Tax pay dates MANDT
0 V_T5UT1 PAYDT T51T9 Tax pay dates PAYDT
1 V_T5UT1 TAXTY T51TA Wage or tax form group for tax reporter MANDT
0 V_T5UT1 WKSIT T5UTV Unemployment Insurance Work Sites/NC-9901 Locations TAXAU
0 V_T5UT1 WKSIT T5UTV Unemployment Insurance Work Sites/NC-9901 Locations WKSIT
0 V_T5UT1 WKSIT T5UTV Unemployment Insurance Work Sites/NC-9901 Locations ENDDA