SAP table T5ITD3 (Family member indicator for tax deduction)

SAP table T5ITD3 has 3 primary key fields being MANDT,CFDTR,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
CFDTR Family member indicator (FM) for tax deduction (TXD) CHAR 2 0 P15_CFDTR
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
TPCM1 Family member type NUMC 2 0 T5ITDS P15_TPCOM
01 Admitted element types
TPCM2 Family member type NUMC 2 0 T5ITDS P15_TPCOM
01 Admitted element types
TPCM3 Family member type NUMC 2 0 T5ITDS P15_TPCOM
01 Admitted element types
TPCM4 Family member type NUMC 2 0 T5ITDS P15_TPCOM
01 Admitted element types
TPCM5 Family member type NUMC 2 0 T5ITDS P15_TPCOM
01 Admitted element types
TPCM6 Family member type NUMC 2 0 T5ITDS P15_TPCOM
01 Admitted element types
TPCM7 Family member type NUMC 2 0 T5ITDS P15_TPCOM
01 Admitted element types
TPCM8 Family member type NUMC 2 0 T5ITDS P15_TPCOM
01 Admitted element types
TPCM9 Family member type NUMC 2 0 T5ITDS P15_TPCOM
01 Admitted element types
TPCM10 Family member type NUMC 2 0 T5ITDS P15_TPCOM
01 Admitted element types

T5ITD3 foreign key relationships

Table Field Check Table Check Field
0 T5ITD3 TPCM1 T5ITDS Family member type MANDT
0 T5ITD3 TPCM1 T5ITDS Family member type ENDDA
1 T5ITD3 TPCM10 T5ITDS Family member type MANDT
1 T5ITD3 TPCM10 T5ITDS Family member type ENDDA
0 T5ITD3 TPCM2 T5ITDS Family member type MANDT
0 T5ITD3 TPCM2 T5ITDS Family member type ENDDA
1 T5ITD3 TPCM3 T5ITDS Family member type MANDT
1 T5ITD3 TPCM3 T5ITDS Family member type ENDDA
0 T5ITD3 TPCM4 T5ITDS Family member type MANDT
0 T5ITD3 TPCM4 T5ITDS Family member type ENDDA
1 T5ITD3 TPCM5 T5ITDS Family member type MANDT
1 T5ITD3 TPCM5 T5ITDS Family member type ENDDA
0 T5ITD3 TPCM6 T5ITDS Family member type MANDT
0 T5ITD3 TPCM6 T5ITDS Family member type ENDDA
1 T5ITD3 TPCM7 T5ITDS Family member type MANDT
1 T5ITD3 TPCM7 T5ITDS Family member type ENDDA
0 T5ITD3 TPCM8 T5ITDS Family member type MANDT
0 T5ITD3 TPCM8 T5ITDS Family member type ENDDA
1 T5ITD3 TPCM9 T5ITDS Family member type MANDT
1 T5ITD3 TPCM9 T5ITDS Family member type ENDDA