SAP table T51RH (HR payee derived link to FI vendor)

SAP table T51RH has 3 primary key fields being MANDT,CRETY,CRENR.

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
CRETY HR payee type CHAR 1 0 CRETY
1 Other payee(s)
2 Tax payee(s)
3 Benefits payee(s) (V0 split type 'B')
4 Garnishment and Child Support payee(s) (V0 split type 'G')
5 Other payee(s) (ZIP code) (US only)
6 Other payee(s) (org. assignment) (US only)
7 Other payee(s) (V0 split type 'T')
8 Workers Compensation payee(s) (CA only)
CRENR HR payee number NUMC 8 0 CRENR
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
LIFSG Vendor subgroup NUMC 5 0 ACSUB
ACCUM HR accumulator for transfers NUMC 5 0 T51RM ACCUH
HRPER Indicator needed for data at employee level CHAR 1 0 HRPER
COMPCODE Company Code CHAR 4 0 T001 BUKRS

T51RH foreign key relationships

Table Field Check Table Check Field
0 T51RH ACCUM T51RM HR accumulator definition MANDT
1 T51RH COMPCODE T001 Company Codes BUKRS
0 T51RH LIFNR LFA1 Supplier Master (General Section) MANDT
0 T51RH LIFNR LFA1 Supplier Master (General Section) LIFNR