SAP Tabel V_T7RUT1 (Generated Table for View)

SAP table V_T7RUT1 has 5 primary key fields being MANDT,LAND,TAXNUM,ENDDA,PRIRR.

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
LAND Country/Region Key CHAR 3 0 T005 LAND1
TAXNUM Tax Class CHAR 2 0 P33_TAXN
ENDDA End Date DATS 8 0 ENDDA
PRIRR Tax Class Priority NUMC 3 0 P33_TCPRIO
BEGDA Start Date DATS 8 0 BEGDA
METOD Tax Method CHAR 1 0 P33_MTD
VALE01 Upper Amount for Cumulative Income CURR 9 2 P33_TAX_INCOME
PROC01 Tax Rate (Percent) DEC 5 2 P33_STEUP
VALS01 Tax Amount (Constant) CURR 9 2 P33_TAX_BETRG
VALE02 Upper Amount for Cumulative Income CURR 9 2 P33_TAX_INCOME
PROC02 Tax Rate (Percent) DEC 5 2 P33_STEUP
VALS02 Tax Amount (Constant) CURR 9 2 P33_TAX_BETRG
VALE03 Upper Amount for Cumulative Income CURR 9 2 P33_TAX_INCOME
PROC03 Tax Rate (Percent) DEC 5 2 P33_STEUP
VALS03 Tax Amount (Constant) CURR 9 2 P33_TAX_BETRG
VALE04 Upper Amount for Cumulative Income CURR 9 2 P33_TAX_INCOME
PROC04 Tax Rate (Percent) DEC 5 2 P33_STEUP
VALS04 Tax Amount (Constant) CURR 9 2 P33_TAX_BETRG
VALE05 Upper Amount for Cumulative Income CURR 9 2 P33_TAX_INCOME
PROC05 Tax Rate (Percent) DEC 5 2 P33_STEUP
VALS05 Tax Amount (Constant) CURR 9 2 P33_TAX_BETRG
VALE06 Upper Amount for Cumulative Income CURR 9 2 P33_TAX_INCOME
PROC06 Tax Rate (Percent) DEC 5 2 P33_STEUP
VALS06 Tax Amount (Constant) CURR 9 2 P33_TAX_BETRG
VALE07 Upper Amount for Cumulative Income CURR 9 2 P33_TAX_INCOME
PROC07 Tax Rate (Percent) DEC 5 2 P33_STEUP
VALS07 Tax Amount (Constant) CURR 9 2 P33_TAX_BETRG
VALE08 Upper Amount for Cumulative Income CURR 9 2 P33_TAX_INCOME
PROC08 Tax Rate (Percent) DEC 5 2 P33_STEUP
VALS08 Tax Amount (Constant) CURR 9 2 P33_TAX_BETRG
VALE09 Upper Amount for Cumulative Income CURR 9 2 P33_TAX_INCOME
PROC09 Tax Rate (Percent) DEC 5 2 P33_STEUP
VALS09 Tax Amount (Constant) CURR 9 2 P33_TAX_BETRG
VALE10 Upper Amount for Cumulative Income CURR 9 2 P33_TAX_INCOME
PROC10 Tax Rate (Percent) DEC 5 2 P33_STEUP
VALS10 Tax Amount (Constant) CURR 9 2 P33_TAX_BETRG
TAXTXT Name of Tax Class CHAR 30 0 P33_TAXTX
LGART1 Wage Type CHAR 4 0 T512W LGART
LGART2 Wage Type CHAR 4 0 T512W LGART
TAXL1 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL2 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL3 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL4 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL5 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL6 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL7 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL8 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL9 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL10 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL11 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL12 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL13 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL14 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL15 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL16 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL17 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL18 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL19 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL20 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL21 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL22 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL23 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL24 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL25 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL26 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL27 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL28 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL29 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL30 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL31 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL32 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL33 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL34 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL35 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL36 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL37 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL38 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL39 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL40 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL41 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL42 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL43 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL44 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL45 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL46 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL47 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL48 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL49 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL50 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL51 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL52 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL53 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL54 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL55 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL56 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL57 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL58 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL59 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL60 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL61 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL62 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL63 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL64 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL65 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL66 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL67 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL68 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL69 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL70 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL71 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL72 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL73 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL74 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL75 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL76 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL77 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL78 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL79 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL80 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL81 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL82 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL83 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL84 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL85 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL86 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL87 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL88 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL89 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL90 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL91 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL92 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL93 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL94 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL95 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL96 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL97 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL98 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL99 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL100 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL101 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL102 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL103 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL104 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL105 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL106 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL107 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL108 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL109 Tax Privilege Class CHAR 2 0 P33_TAXL
TAXL110 Tax Privilege Class CHAR 2 0 P33_TAXL
CYCLB Relevancy test for calculating averages CHAR 4 0 T52CE RELTP
CYCLE Relevancy test for calculating averages CHAR 4 0 T52CE RELTP
PARB2 Second parameter CHAR 4 0 PARM2
PARB3 Third parameter CHAR 4 0 PARM3
PARE2 Second parameter CHAR 4 0 PARM2
PARE3 Third parameter CHAR 4 0 PARM3
AGART1 Wage Type CHAR 4 0 T512W LGART
AGART2 Wage Type CHAR 4 0 T512W LGART
TAXTY Tax Type CHAR 1 0 P33_TAXTYPE
0 Income Tax
1 ESN (Federal Budget)
2 Social Insurance Fund
3 Mandatory Federal Medical Insurance Fund
4 Mandatory Regional Medical Insurance Fund
5 Pension Fund (Insurance Part)
6 Pension Fund (Accumulated Part)
TXSIN Include in Tax Schema Using In-Period Principle CHAR 1 0 P33_TAXSCHEMAIN
WTSEP Process Wage Types Separately CHAR 1 0 P33_TAXWTSEP
LGARTB Wage Types for Tax Bases CHAR 4 0 T512W P33_TAX_LGART_B
ELGA01 Wage Type According to Scale CHAR 4 0 T512W HRPAYRU_ELGAR
ELGA02 Wage Type According to Scale CHAR 4 0 T512W HRPAYRU_ELGAR
ELGA03 Wage Type According to Scale CHAR 4 0 T512W HRPAYRU_ELGAR
ELGA04 Wage Type According to Scale CHAR 4 0 T512W HRPAYRU_ELGAR
ELGA05 Wage Type According to Scale CHAR 4 0 T512W HRPAYRU_ELGAR
ELGA06 Wage Type According to Scale CHAR 4 0 T512W HRPAYRU_ELGAR
ELGA07 Wage Type According to Scale CHAR 4 0 T512W HRPAYRU_ELGAR
ELGA08 Wage Type According to Scale CHAR 4 0 T512W HRPAYRU_ELGAR
ELGA09 Wage Type According to Scale CHAR 4 0 T512W HRPAYRU_ELGAR
ELGA10 Wage Type According to Scale CHAR 4 0 T512W HRPAYRU_ELGAR

V_T7RUT1 foreign key relationships

Table Field Check Table Check Field
0 V_T7RUT1 AGART1 T512W Wage Type Valuation MANDT
0 V_T7RUT1 AGART1 T512W Wage Type Valuation MOLGA
0 V_T7RUT1 AGART1 T512W Wage Type Valuation ENDDA
1 V_T7RUT1 AGART2 T512W Wage Type Valuation MANDT
1 V_T7RUT1 AGART2 T512W Wage Type Valuation MOLGA
1 V_T7RUT1 AGART2 T512W Wage Type Valuation ENDDA
0 V_T7RUT1 CYCLB T52CE Directory of Personnel Calculation Rules MANDT
1 V_T7RUT1 CYCLE T52CE Directory of Personnel Calculation Rules MANDT
0 V_T7RUT1 ELGA01 T512W Wage Type Valuation MANDT
0 V_T7RUT1 ELGA01 T512W Wage Type Valuation MOLGA
0 V_T7RUT1 ELGA01 T512W Wage Type Valuation ENDDA
1 V_T7RUT1 ELGA02 T512W Wage Type Valuation MANDT
1 V_T7RUT1 ELGA02 T512W Wage Type Valuation MOLGA
1 V_T7RUT1 ELGA02 T512W Wage Type Valuation ENDDA
0 V_T7RUT1 ELGA03 T512W Wage Type Valuation MANDT
0 V_T7RUT1 ELGA03 T512W Wage Type Valuation MOLGA
0 V_T7RUT1 ELGA03 T512W Wage Type Valuation ENDDA
1 V_T7RUT1 ELGA04 T512W Wage Type Valuation MANDT
1 V_T7RUT1 ELGA04 T512W Wage Type Valuation MOLGA
1 V_T7RUT1 ELGA04 T512W Wage Type Valuation ENDDA
0 V_T7RUT1 ELGA05 T512W Wage Type Valuation MANDT
0 V_T7RUT1 ELGA05 T512W Wage Type Valuation MOLGA
0 V_T7RUT1 ELGA05 T512W Wage Type Valuation ENDDA
1 V_T7RUT1 ELGA06 T512W Wage Type Valuation MANDT
1 V_T7RUT1 ELGA06 T512W Wage Type Valuation MOLGA
1 V_T7RUT1 ELGA06 T512W Wage Type Valuation ENDDA
0 V_T7RUT1 ELGA07 T512W Wage Type Valuation MANDT
0 V_T7RUT1 ELGA07 T512W Wage Type Valuation MOLGA
0 V_T7RUT1 ELGA07 T512W Wage Type Valuation ENDDA
1 V_T7RUT1 ELGA08 T512W Wage Type Valuation MANDT
1 V_T7RUT1 ELGA08 T512W Wage Type Valuation MOLGA
1 V_T7RUT1 ELGA08 T512W Wage Type Valuation ENDDA
0 V_T7RUT1 ELGA09 T512W Wage Type Valuation MANDT
0 V_T7RUT1 ELGA09 T512W Wage Type Valuation MOLGA
0 V_T7RUT1 ELGA09 T512W Wage Type Valuation ENDDA
1 V_T7RUT1 ELGA10 T512W Wage Type Valuation MANDT
1 V_T7RUT1 ELGA10 T512W Wage Type Valuation MOLGA
1 V_T7RUT1 ELGA10 T512W Wage Type Valuation ENDDA
0 V_T7RUT1 LAND T005 Countries MANDT
0 V_T7RUT1 LAND T005 Countries LAND1
1 V_T7RUT1 LGART1 T512W Wage Type Valuation MANDT
1 V_T7RUT1 LGART1 T512W Wage Type Valuation MOLGA
1 V_T7RUT1 LGART1 T512W Wage Type Valuation ENDDA
0 V_T7RUT1 LGART2 T512W Wage Type Valuation MANDT
0 V_T7RUT1 LGART2 T512W Wage Type Valuation MOLGA
0 V_T7RUT1 LGART2 T512W Wage Type Valuation ENDDA
1 V_T7RUT1 LGARTB T512W Wage Type Valuation MANDT
1 V_T7RUT1 LGARTB T512W Wage Type Valuation MOLGA
1 V_T7RUT1 LGARTB T512W Wage Type Valuation ENDDA
0 V_T7RUT1 MANDT T000 Clients MANDT