SAP Table T5ITDQ (Allowable expense type)

SAP table T5ITDQ has 3 primary key fields being MANDT,TPONE,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
TPONE Type of allowable expense NUMC 2 0 P15_TPONE
01 Deduct.expenses type
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
TPERO Disburs. type CHAR 4 0 P15_TPERO
CONG Settlement
MESE Monthly payment
WTONE Wage type: expenses CHAR 4 0 T512W P15_WTONE
WTGEN Wage-type deduction amount CHAR 4 0 T512W P15_WTGEN
MXDTR Highest rate for deduct.expenses CURR 12 2 P15_MXDTR
PRDTR Deduction percentage DEC 7 4 P15_PRDTR
WTONA Wage Type: Charge for Other Employers CHAR 4 0 T512W P15_WTONA
WTGEA Wage Type: Deduction Amount Other Employers CHAR 4 0 T512W P15_WTGEA
CDONE Tax-deductible charge code - Certificazione Unica NUMC 2 0 HRPAYIT_COD_ONERE
01 Tax-deductible charge code

T5ITDQ foreign key relationships

Table Field Check Table Check Field
0 T5ITDQ WTGEA T512W Wage Type Valuation MANDT
0 T5ITDQ WTGEA T512W Wage Type Valuation MOLGA
0 T5ITDQ WTGEA T512W Wage Type Valuation ENDDA
1 T5ITDQ WTGEN T512W Wage Type Valuation MANDT
1 T5ITDQ WTGEN T512W Wage Type Valuation MOLGA
1 T5ITDQ WTGEN T512W Wage Type Valuation ENDDA
0 T5ITDQ WTONA T512W Wage Type Valuation MANDT
0 T5ITDQ WTONA T512W Wage Type Valuation MOLGA
0 T5ITDQ WTONA T512W Wage Type Valuation ENDDA
1 T5ITDQ WTONE T512W Wage Type Valuation MANDT
1 T5ITDQ WTONE T512W Wage Type Valuation MOLGA
1 T5ITDQ WTONE T512W Wage Type Valuation ENDDA