SAP table T5ITDS (Family member type)

SAP table T5ITDS has 3 primary key fields being MANDT,TPCOM,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
TPCOM Family member type NUMC 2 0 P15_TPCOM
01 Admitted element types
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
AA Annual value
GG Daily value
MM Monthly value
TPERO Disburs. type CHAR 4 0 P15_TPERO
CONG Settlement
MESE Monthly payment
WTDET Wage type: days of absence for deductions CHAR 4 0 T512W P15_WTDET
WTRDI Wage type: tax return CHAR 4 0 T512W P15_WTRDI
WTRED Wage type: income CHAR 4 0 T512W P15_WTRED
WTCCF Wage type: settlement for family members CHAR 4 0 T512W P15_WTCCF
WTRCO Taxable income for deduction settlement CHAR 4 0 T512W P15_WTRCO
TCFAM Family member type sorting NUMC 2 0 P15_TCFAM
01 Husband/wife
02 Children
03 Children < 3 years old
WTFMATEORMENS WT for fam. allow. planned monthly ded. per fam. member CHAR 4 0 T512W P15_WTFMATEORMENS
WTFMAEFFMENS WT family allowance actual monthly deduction for fam. memb. CHAR 4 0 T512W P15_WTFMAEFFMENS
WTFMAEFFCONG WT actual deduction for fam. all. settl. per family member CHAR 4 0 T512W P15_WMFMAEFFCONG
WTDSC Wage-type for deduction in case of spouse replacement CHAR 4 0 T512W P15_WTDSC
TXTCO Family member type description CHAR 25 0 P15_TXTCO

T5ITDS foreign key relationships

Table Field Check Table Check Field
0 T5ITDS WTCCF T512W Wage Type Valuation MANDT
0 T5ITDS WTCCF T512W Wage Type Valuation MOLGA
0 T5ITDS WTCCF T512W Wage Type Valuation ENDDA
1 T5ITDS WTDET T512W Wage Type Valuation MANDT
1 T5ITDS WTDET T512W Wage Type Valuation MOLGA
1 T5ITDS WTDET T512W Wage Type Valuation ENDDA
0 T5ITDS WTDSC T512W Wage Type Valuation MANDT
0 T5ITDS WTDSC T512W Wage Type Valuation MOLGA
0 T5ITDS WTDSC T512W Wage Type Valuation ENDDA
1 T5ITDS WTFMAEFFCONG T512W Wage Type Valuation MANDT
1 T5ITDS WTFMAEFFCONG T512W Wage Type Valuation MOLGA
1 T5ITDS WTFMAEFFCONG T512W Wage Type Valuation ENDDA
0 T5ITDS WTFMAEFFMENS T512W Wage Type Valuation MANDT
0 T5ITDS WTFMAEFFMENS T512W Wage Type Valuation MOLGA
0 T5ITDS WTFMAEFFMENS T512W Wage Type Valuation ENDDA
1 T5ITDS WTFMATEORMENS T512W Wage Type Valuation MANDT
1 T5ITDS WTFMATEORMENS T512W Wage Type Valuation MOLGA
1 T5ITDS WTFMATEORMENS T512W Wage Type Valuation ENDDA
0 T5ITDS WTGEN T512W Wage Type Valuation MANDT
0 T5ITDS WTGEN T512W Wage Type Valuation MOLGA
0 T5ITDS WTGEN T512W Wage Type Valuation ENDDA
1 T5ITDS WTRCO T512W Wage Type Valuation MANDT
1 T5ITDS WTRCO T512W Wage Type Valuation MOLGA
1 T5ITDS WTRCO T512W Wage Type Valuation ENDDA
0 T5ITDS WTRDI T512W Wage Type Valuation MANDT
0 T5ITDS WTRDI T512W Wage Type Valuation MOLGA
0 T5ITDS WTRDI T512W Wage Type Valuation ENDDA
1 T5ITDS WTRED T512W Wage Type Valuation MANDT
1 T5ITDS WTRED T512W Wage Type Valuation MOLGA
1 T5ITDS WTRED T512W Wage Type Valuation ENDDA