SAP Table T5ITDG (Settlement request for deductions)

SAP table T5ITDG has 3 primary key fields being MANDT,CDCOD,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
CDCOD Deduction settlement indicator CHAR 2 0 P15_CDCOD
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
TPC1 Settlement request for dependent family members NUMC 2 0 T5ITDS P15_TPCMP
TPC2 Settlement request for dependent family members NUMC 2 0 T5ITDS P15_TPCMP
TPC3 Settlement request for dependent family members NUMC 2 0 T5ITDS P15_TPCMP
TPC4 Settlement request for dependent family members NUMC 2 0 T5ITDS P15_TPCMP
TPC5 Settlement request for dependent family members NUMC 2 0 T5ITDS P15_TPCMP
TPC6 Settlement request for dependent family members NUMC 2 0 T5ITDS P15_TPCMP
TPC7 Settlement request for dependent family members NUMC 2 0 T5ITDS P15_TPCMP
TPC8 Settlement request for dependent family members NUMC 2 0 T5ITDS P15_TPCMP
TPC9 Settlement request for dependent family members NUMC 2 0 T5ITDS P15_TPCMP
TPC10 Settlement request for dependent family members NUMC 2 0 T5ITDS P15_TPCMP
TPD1 Settlement request for direct employment NUMC 2 0 T5ITDR P15_TPDER
TPD2 Settlement request for direct employment NUMC 2 0 T5ITDR P15_TPDER
TPD3 Settlement request for direct employment NUMC 2 0 T5ITDR P15_TPDER
TPD4 Settlement request for direct employment NUMC 2 0 T5ITDR P15_TPDER
TPD5 Settlement request for direct employment NUMC 2 0 T5ITDR P15_TPDER
TPO1 Settlement request for allowable expenses NUMC 2 0 T5ITDQ P15_TPONR
TPO2 Settlement request for allowable expenses NUMC 2 0 T5ITDQ P15_TPONR
TPO3 Settlement request for allowable expenses NUMC 2 0 T5ITDQ P15_TPONR
TPO4 Settlement request for allowable expenses NUMC 2 0 T5ITDQ P15_TPONR
TPO5 Settlement request for allowable expenses NUMC 2 0 T5ITDQ P15_TPONR

T5ITDG foreign key relationships

Table Field Check Table Check Field
0 T5ITDG TPC1 T5ITDS Family member type MANDT
0 T5ITDG TPC1 T5ITDS Family member type ENDDA
1 T5ITDG TPC10 T5ITDS Family member type MANDT
1 T5ITDG TPC10 T5ITDS Family member type ENDDA
0 T5ITDG TPC2 T5ITDS Family member type MANDT
0 T5ITDG TPC2 T5ITDS Family member type ENDDA
1 T5ITDG TPC3 T5ITDS Family member type MANDT
1 T5ITDG TPC3 T5ITDS Family member type ENDDA
0 T5ITDG TPC4 T5ITDS Family member type MANDT
0 T5ITDG TPC4 T5ITDS Family member type ENDDA
1 T5ITDG TPC5 T5ITDS Family member type MANDT
1 T5ITDG TPC5 T5ITDS Family member type ENDDA
0 T5ITDG TPC6 T5ITDS Family member type MANDT
0 T5ITDG TPC6 T5ITDS Family member type ENDDA
1 T5ITDG TPC7 T5ITDS Family member type MANDT
1 T5ITDG TPC7 T5ITDS Family member type ENDDA
0 T5ITDG TPC8 T5ITDS Family member type MANDT
0 T5ITDG TPC8 T5ITDS Family member type ENDDA
1 T5ITDG TPC9 T5ITDS Family member type MANDT
1 T5ITDG TPC9 T5ITDS Family member type ENDDA
0 T5ITDG TPD1 T5ITDR Employment deduction expenses type MANDT
0 T5ITDG TPD1 T5ITDR Employment deduction expenses type TPDET
0 T5ITDG TPD1 T5ITDR Employment deduction expenses type ENDDA
1 T5ITDG TPD2 T5ITDR Employment deduction expenses type MANDT
1 T5ITDG TPD2 T5ITDR Employment deduction expenses type TPDET
1 T5ITDG TPD2 T5ITDR Employment deduction expenses type ENDDA
0 T5ITDG TPD3 T5ITDR Employment deduction expenses type MANDT
0 T5ITDG TPD3 T5ITDR Employment deduction expenses type TPDET
0 T5ITDG TPD3 T5ITDR Employment deduction expenses type ENDDA
1 T5ITDG TPD4 T5ITDR Employment deduction expenses type MANDT
1 T5ITDG TPD4 T5ITDR Employment deduction expenses type TPDET
1 T5ITDG TPD4 T5ITDR Employment deduction expenses type ENDDA
0 T5ITDG TPD5 T5ITDR Employment deduction expenses type MANDT
0 T5ITDG TPD5 T5ITDR Employment deduction expenses type TPDET
0 T5ITDG TPD5 T5ITDR Employment deduction expenses type ENDDA
1 T5ITDG TPO1 T5ITDQ Allowable expense type MANDT
1 T5ITDG TPO1 T5ITDQ Allowable expense type TPONE
1 T5ITDG TPO1 T5ITDQ Allowable expense type ENDDA
0 T5ITDG TPO2 T5ITDQ Allowable expense type MANDT
0 T5ITDG TPO2 T5ITDQ Allowable expense type TPONE
0 T5ITDG TPO2 T5ITDQ Allowable expense type ENDDA
1 T5ITDG TPO3 T5ITDQ Allowable expense type MANDT
1 T5ITDG TPO3 T5ITDQ Allowable expense type TPONE
1 T5ITDG TPO3 T5ITDQ Allowable expense type ENDDA
0 T5ITDG TPO4 T5ITDQ Allowable expense type MANDT
0 T5ITDG TPO4 T5ITDQ Allowable expense type TPONE
0 T5ITDG TPO4 T5ITDQ Allowable expense type ENDDA
1 T5ITDG TPO5 T5ITDQ Allowable expense type MANDT
1 T5ITDG TPO5 T5ITDQ Allowable expense type TPONE
1 T5ITDG TPO5 T5ITDQ Allowable expense type ENDDA