SAP Tabel T5ITDR (Employment deduction expenses type)
SAP table T5ITDR has 3 primary key fields being MANDT,TPDET,ENDDA.
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
TPDET
Deduction type
NUMC
2
0
P15_TPDET
Possible values
ENDDA
End Date
DATS
8
0
ENDDA
BEGDA
Start Date
DATS
8
0
BEGDA
WTGEN
Wage-type deduction amount
CHAR
4
0
T512W
P15_WTGEN
CDVAL
Value type indicator
CHAR
2
0
P15_CDVAL
Possible values
AA
Annual value
GG
Daily value
MM
Monthly value
TPERO
Disburs. type
CHAR
4
0
P15_TPERO
Possible values
CONG
Settlement
MESE
Monthly payment
WTRDI
Wage type: tax return
CHAR
4
0
T512W
P15_WTRDI
WTRED
Wage type: income
CHAR
4
0
T512W
P15_WTRED
WTDET
Wage type: days of absence for deductions
CHAR
4
0
T512W
P15_WTDET
WTGPD
Wage-type days of presence for deductions
CHAR
4
0
T512W
P15_WTGPD
WTCLD
Wage type: direct employment settlement
CHAR
4
0
T512W
P15_WTCLD
WTRCO
Taxable income for deduction settlement
CHAR
4
0
T512W
P15_WTRCO
T5ITDR foreign key relationships
Table
Field
Check Table
Check Field
0 T5ITDR
WTCLD
T512W
Wage Type Valuation
MANDT
0 T5ITDR
WTCLD
T512W
Wage Type Valuation
MOLGA
0 T5ITDR
WTCLD
T512W
Wage Type Valuation
ENDDA
1 T5ITDR
WTDET
T512W
Wage Type Valuation
MANDT
1 T5ITDR
WTDET
T512W
Wage Type Valuation
MOLGA
1 T5ITDR
WTDET
T512W
Wage Type Valuation
ENDDA
0 T5ITDR
WTGEN
T512W
Wage Type Valuation
MANDT
0 T5ITDR
WTGEN
T512W
Wage Type Valuation
MOLGA
0 T5ITDR
WTGEN
T512W
Wage Type Valuation
ENDDA
1 T5ITDR
WTGPD
T512W
Wage Type Valuation
MANDT
1 T5ITDR
WTGPD
T512W
Wage Type Valuation
MOLGA
1 T5ITDR
WTGPD
T512W
Wage Type Valuation
ENDDA
0 T5ITDR
WTRCO
T512W
Wage Type Valuation
MANDT
0 T5ITDR
WTRCO
T512W
Wage Type Valuation
MOLGA
0 T5ITDR
WTRCO
T512W
Wage Type Valuation
ENDDA
1 T5ITDR
WTRDI
T512W
Wage Type Valuation
MANDT
1 T5ITDR
WTRDI
T512W
Wage Type Valuation
MOLGA
1 T5ITDR
WTRDI
T512W
Wage Type Valuation
ENDDA
0 T5ITDR
WTRED
T512W
Wage Type Valuation
MANDT
0 T5ITDR
WTRED
T512W
Wage Type Valuation
MOLGA
0 T5ITDR
WTRED
T512W
Wage Type Valuation
ENDDA