SAP table TFK045E (Returns Activities (Returns Lot))

SAP table TFK045E has 7 primary key fields being MANDT,OPBUK,RLGRD,HBKID,RLANZ,BONIT,TOGRU.

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
OPBUK Company Code CHAR 4 0 T001 BUKRS
RLGRD Return Reason CHAR 3 0 TFK045A RLGRD_KK
HBKID Short Key for a House Bank CHAR 5 0 HBKID
RLANZ Number Of Returns That Occurred over The Observation Period NUMC 2 0 RLANZ_KK
BONIT Creditworthiness NUMC 4 0 BONIT_KK
TOGRU Tolerance group for contract account CHAR 4 0 TFK043 TOGRU_KK
XGEBV Pass On Bank Charges CHAR 1 0 XGEBV_KK
XGEBS Calculate Graduated Charges CHAR 1 0 XGEBS_KK
XEZSP Field is obsolete CHAR 1 0 XEZSP_KK
XEZSB Field is obsolete CHAR 1 0 XEZSB_KK
STUNT Deferral days NUMC 3 0 STUNT_KK
MSPOP Dunning Lock Reason for Line Item CHAR 1 0 TFK047S MSPOP_KK
MSPOP_DAYS Item dunning lock: days INT4 10 0 MSPOP_DAYS_KK
PSPOP Payment lock reason for item CHAR 1 0 TFK008 PSPOP_KK
PSPOP_DAYS Payment lock for incoming payments: Duration in days INT4 10 0 PSPOP_DAYS_KK
MSPKO Dunning lock reason for contract account CHAR 1 0 TFK047S MSPKO_KK
MSPKO_DAYS Contract acct dunn. lock: days INT4 10 0 MSPKO_DAYS_KK
EZSKO Reason for Lock on Incoming Payment for Contract Account CHAR 1 0 TFK008 EZSKO_KK
EZSKO_DAYS Contract account incoming payment lock: Duration in days INT4 10 0 EZSKO_DAYS_KK
AZSKO Reason for Outgoing Payment Lock for Contract Account CHAR 1 0 TFK008 AZSKO_KK
AZSKO_DAYS Contract account outgoing payments lock: Duration in days INT4 10 0 AZSKO_DAYS_KK
EZAWE Incoming Payment Method CHAR 1 0 EZAWE_KK
GEBST Post Charges Statistically CHAR 1 0 GEBST_KK
MACHG Activate Event for Changing Master Data CHAR 1 0 MACHG_KK
BSNTE Inform Specialist CHAR 1 0 BSNTE_KK
BCORR Activate Event for Creating Correspondence CHAR 1 0 BCORR_KK
XDELEZAWE Delete payment method with account instead of changing CHAR 1 0 XDELEZAWE_KK
Do not delete payment method
X Delete payment method; sets it to space
XDELAZAWE Returns Activity: Delete Outgoing Payment Method in Account CHAR 1 0 XDELAZAWE_KK
EZVTG Incoming Payment Lock in Contract CHAR 1 0 TFK008 EZVTG_KK
EZVTG_DAYS Incoming Payment Lock in Contract: Duration in Days INT4 10 0 EZVTG_DAYS_KK
AZVTG Outgoing Payment Lock Reason for Contract CHAR 1 0 TFK008 AZVTG_KK
AZVTG_DAYS Outgoing Payment Lock Contract: Duration in Days INT4 10 0 AZVTG_DAYS_KK
MSVTG Dunning Lock Reason for Contract CHAR 1 0 TFK047S MSVTG_KK
MSVTG_DAYS Dunning Lock in Contract: Duration in Days INT4 10 0 MSVTG_DAYS_KK
XDELPZAWE Delete Payment Method in Item CHAR 1 0 XDELPZAWE_KK
Do Not Delete Payment Method in Item
X Delete Payment Method in Item
XCORPZAWE Change Pymt Meth. in Item CHAR 1 0 XCORPZAWE_KK
Do Not Change Payment Method in Item
X Change Pymt Meth. in Item
XNEWBV Reaction to Changed Bank Details Returns CHAR 1 0 XNEWBV_KK
<SPACE> Check Changed Bank Details
X Do not check
XRLGRD Return Reason CHAR 3 0 TFK045A RLGRD_KK
INFCON Write Entry in Information Container CHAR 1 0 INFCON_KK
XPPRV Reverse Prepaid Refill CHAR 1 0 XPPRV_KK
XCHPP Debit Charges to Prepaid Account CHAR 1 0 XCHPP_KK
DELMANDUSE Delete Use in Mandate CHAR 1 0 DELMANDUSE_KK
<SPACE> Do Not Remove Use
X Remove Use in Mandate
NEWMANDSTAT SEPA: Mandate Status CHAR 1 0 SEPA_STATUS
0 Entered
1 Active
2 To Be Confirmed
3 Locked
4 Canceled
5 Obsolete
6 Completed
LOCKIBAN_DAYS Duration of Lock for Mandate in Days NUMC 3 0 LOCKIBAN_DAYS_KK
XSTOR_RANF Reverse Repayment Request CHAR 1 0 XSTOR_RANF_KK

TFK045E foreign key relationships

Table Field Check Table Check Field
0 TFK045E AZSKO TFK008 Locking Reasons for Automatic Payment Transactions ZAHLS
1 TFK045E AZVTG TFK008 Locking Reasons for Automatic Payment Transactions ZAHLS
0 TFK045E EZSKO TFK008 Locking Reasons for Automatic Payment Transactions ZAHLS
1 TFK045E EZVTG TFK008 Locking Reasons for Automatic Payment Transactions ZAHLS
0 TFK045E OPBUK T001 Company Codes BUKRS
1 TFK045E PSPOP TFK008 Locking Reasons for Automatic Payment Transactions ZAHLS
0 TFK045E RLGRD TFK045A Returns table MANDT
0 TFK045E RLGRD TFK045A Returns table RLGRD
0 TFK045E RLGRD TFK045A Returns table HBKID
1 TFK045E TOGRU TFK043 Tolerances for Payment Differences, Payment Notices MANDT
1 TFK045E TOGRU TFK043 Tolerances for Payment Differences, Payment Notices TOGRU
0 TFK045E XRLGRD TFK045A Returns table MANDT
0 TFK045E XRLGRD TFK045A Returns table RLGRD
0 TFK045E XRLGRD TFK045A Returns table HBKID