SAP table T5UF5 (HR-US: ADP Interface, fields per record type)

SAP table T5UF5 has 5 primary key fields being MANDT,INKEY,INTYP,RCTYP,FLDNO.

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
INKEY HR-US: ADP Interface, Interface Key CHAR 4 0 T5UF0 P10F_INKEY
INTYP HR-US: ADP Interface, Interface Type CHAR 1 0 T5UF0 P10F_INTYP
M Masterdata
P Paydata
RCTYP HR-US: ADP Interface, Record type NUMC 3 0 T5UF4 P10F_RCTYP
FLDNO HR-US: ADP Interface, Field number ? NUMC 3 0 T5UF2 P10F_FLDNO

T5UF5 foreign key relationships

Table Field Check Table Check Field
0 T5UF5 FLDNO T5UF2 HR-US: ADP Interface, used fields per Interface MANDT
0 T5UF5 FLDNO T5UF2 HR-US: ADP Interface, used fields per Interface INKEY
0 T5UF5 FLDNO T5UF2 HR-US: ADP Interface, used fields per Interface INTYP
0 T5UF5 FLDNO T5UF2 HR-US: ADP Interface, used fields per Interface FLDNO
1 T5UF5 INKEY T5UF0 HR-US: ADP Interface MANDT
1 T5UF5 INKEY T5UF0 HR-US: ADP Interface INKEY
1 T5UF5 INKEY T5UF0 HR-US: ADP Interface INTYP
0 T5UF5 INTYP T5UF0 HR-US: ADP Interface MANDT
0 T5UF5 INTYP T5UF0 HR-US: ADP Interface INKEY
0 T5UF5 INTYP T5UF0 HR-US: ADP Interface INTYP
1 T5UF5 RCTYP T5UF4 HR-US: ADP Interface, Record type MANDT
1 T5UF5 RCTYP T5UF4 HR-US: ADP Interface, Record type INKEY
1 T5UF5 RCTYP T5UF4 HR-US: ADP Interface, Record type INTYP