SAP table TFK045A (Returns table)

SAP table TFK045A has 3 primary key fields being MANDT,RLGRD,HBKID.

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
RLGRD Return Reason CHAR 3 0 RLGRD_KK
HBKID Short Key for a House Bank CHAR 5 0 * HBKID
RLTYP Type of returns NUMC 2 0 RLTYP_KK
01 Bank returns
02 Check Returns (Incoming Checks)
03 Payment card returns
04 Check Returns (Outgoing Checks)
05 External Payment Collector
06 Payment Service Provider Returns
07 Collection Agency Returns
HISTT History days NUMC 3 0 HISTT_KK
BONIG Creditworthiness number NUMC 2 0 BONIZ_KK
FORMKEY Application form CHAR 30 0 EFRM FORMKEY
KLAEH Clarification Account CHAR 10 0 * KLAEH_KK
VOIDR Reason for Check Voiding CHAR 2 0 TFKVOID VOIDREAS_KK

TFK045A foreign key relationships

Table Field Check Table Check Field
0 TFK045A FORMKEY EFRM Print Workbench: Application Forms FORMKEY
1 TFK045A VOIDR TFKVOID Reasons for Check Voiding MANDT
1 TFK045A VOIDR TFKVOID Reasons for Check Voiding VOIDRS