SAP table TFK045D (Assign return reasons)

SAP table TFK045D has 5 primary key fields being MANDT,BUKRS,HBKID,RLHBK,VZRLG.

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
BUKRS Company Code CHAR 4 0 T001 BUKRS
HBKID Short Key for a House Bank CHAR 5 0 T012 HBKID
RLHBK House bank's return reason CHAR 6 0 RLHBK_KK
VZRLG Plus/Minus Sign for House Bank Return Reason CHAR 1 0 VZRLG_KK
+ Returns for a Preceding Credit Memo
- Returns for a Preceding Debit Memo
RLGRD Return Reason CHAR 3 0 TFK045A RLGRD_KK

TFK045D foreign key relationships

Table Field Check Table Check Field
0 TFK045D BUKRS T001 Company Codes BUKRS
1 TFK045D HBKID T012 House Banks BUKRS
0 TFK045D RLGRD TFK045A Returns table MANDT
0 TFK045D RLGRD TFK045A Returns table RLGRD
0 TFK045D RLGRD TFK045A Returns table HBKID