The DFKKRH table in SAP ERP or S/4HANA stores Returns History data. There are total 72 fields in DFKKRH table. The Returns History table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DFKKRH table. It is in FI-CA: Returns (FKK_RETURNS) ABAP package and is part of the Contract Accounts Receivable and Payable (FI-CA) module.
SAP DFKKRH Table Fields
Following is the list of fields that are available in SAP DFKKRH table. The primary key fields of the table are MANDT (Client), GPART (Business Partner Number), VKONT (Contract Account Number), RLBEL (Number of the return document).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| GPART | Business Partner Number | GPART_KK | CHAR (10) | |
| VKONT | Contract Account Number | VKONT_KK | CHAR (12) | |
| RLBEL | Number of the return document | RLBEL_KK | CHAR (12) | |
| KEYR1 | Returns Lot | KEYR1_KK | CHAR (12) | |
| POSRA | Item number in a returns lot | POSRA_KK | NUMC (6) | |
| OPBEL | Number of a FI-CA Document | OPBEL_KK | CHAR (12) | |
| URBEL | Document Number of Receivables Document | URBEL_KK | CHAR (12) | |
| BETRWR | Partial Amount Of Return | BETRWR_KK | CURR (13) | |
| BETRR | Return amount | BETRR_KK | CURR (13) | |
| BTRB1 | Charge amount from bank 1 | BTRB1_KK | CURR (13) | |
| BTRB2 | Charge amount from bank 2 | BTRB2_KK | CURR (13) | |
| STBB1 | Tax Amount: Bank Charge 1 | STBB1_KK | CURR (13) | |
| STBB2 | Tax amount: Bank charge 2 | STBB2_KK | CURR (13) | |
| BTRV1 | Returns Charge 1 | BTRV1_KK | CURR (13) | |
| BTRV2 | Return charge 2 | BTRV2_KK | CURR (13) | |
| STBV1 | Tax amount: Return charges 1 | STBV1_KK | CURR (13) | |
| STBV2 | Tax amount: Return charges 2 | STBV2_KK | CURR (13) | |
| WAERS | Currency Key | WAERS | CUKY (5) | |
| BUDAT | Posting Date in the Document | BUDAT_KK | DATS (8) | |
| BLDAT | Document Date in Document | BLDAT | DATS (8) | |
| VALUT | Value date | VALUT | DATS (8) | |
| RLGRD | Return Reason | RLGRD_KK | CHAR (3) | |
| BANKL | Banking Country of Business Partner | GPBANKS | CHAR (3) | |
| BANKK | Business Partner Bank Number | GPBANKK | CHAR (15) | |
| BANKN | Account Number of Business Partner | GPBANKN | CHAR (18) | |
| IBAN | IBAN (International Bank Account Number) | IBAN | CHAR (34) | |
| CHECF | Number of a returned check | CHECF_KK | CHAR (16) | |
| NRZAS | Payment Form Number | NRZAS_KK | CHAR (12) | |
| HBKID | Short Key for a House Bank | HBKID | CHAR (5) | |
| HKTID | ID for Account Details | HKTID | CHAR (5) | |
| RLMOD | Returns Posting Type | RLMOD_KK | CHAR (1) | |
| STODT | Reversal Document Posting Date | STODT_KK | DATS (8) | |
| STBLG | Number of Reverse Document/Reset Document | STBLG_KK | CHAR (12) | |
| XSTOR | Document Has Been Reversed | XSTOR_KK | CHAR (1) | |
| RLANZ | Number Of Returns That Occurred over The Observation Period | RLANZ_KK | NUMC (2) | |
| BONIT | Creditworthiness | BONIT_KK | NUMC (4) | |
| TOGRU | Tolerance group for contract account | TOGRU_KK | * | CHAR (4) |
| XGEBV | Pass On Bank Charges | XGEBV_KK | CHAR (1) | |
| XGEBS | Calculate Graduated Charges | XGEBS_KK | CHAR (1) | |
| XEZSP | Field is obsolete | XEZSP_KK | CHAR (1) | |
| XEZSB | Field is obsolete | XEZSB_KK | CHAR (1) | |
| XBVBL | Delete bank details | XBVBL_KK | CHAR (1) | |
| STUNT | Deferral days | STUNT_KK | NUMC (3) | |
| STUDT | Deferral to | STUDT_KK | DATS (8) | |
| MSPOP | Dunning Lock Reason for Line Item | MSPOP_KK | * | CHAR (1) |
| MSPOP_DAYS | Item dunning lock: days | MSPOP_DAYS_KK | INT4 (10) | |
| PSPOP | Payment lock reason for item | PSPOP_KK | * | CHAR (1) |
| PSPOP_DAYS | Payment lock for incoming payments: Duration in days | PSPOP_DAYS_KK | INT4 (10) | |
| MSPKO | Dunning lock reason for contract account | MSPKO_KK | * | CHAR (1) |
| MSPKO_DAYS | Contract acct dunn. lock: days | MSPKO_DAYS_KK | INT4 (10) | |
| EZSKO | Reason for Lock on Incoming Payment for Contract Account | EZSKO_KK | * | CHAR (1) |
| EZSKO_DAYS | Contract account incoming payment lock: Duration in days | EZSKO_DAYS_KK | INT4 (10) | |
| AZSKO | Reason for Outgoing Payment Lock for Contract Account | AZSKO_KK | * | CHAR (1) |
| AZSKO_DAYS | Contract account outgoing payments lock: Duration in days | AZSKO_DAYS_KK | INT4 (10) | |
| EZAWE | Incoming Payment Method | EZAWE_KK | CHAR (1) | |
| GEBST | Post Charges Statistically | GEBST_KK | CHAR (1) | |
| XDELEZAWE | Delete payment method with account instead of changing | XDELEZAWE_KK | CHAR (1) | |
| XDELAZAWE | Returns Activity: Delete Outgoing Payment Method in Account | XDELAZAWE_KK | CHAR (1) | |
| MACHG | Activate Event for Changing Master Data | MACHG_KK | CHAR (1) | |
| BSNTE | Inform Specialist | BSNTE_KK | CHAR (1) | |
| BCORR | Activate Event for Creating Correspondence | BCORR_KK | CHAR (1) | |
| EZVTG | Incoming Payment Lock in Contract | EZVTG_KK | * | CHAR (1) |
| AZVTG | Outgoing Payment Lock Reason for Contract | AZVTG_KK | * | CHAR (1) |
| MSVTG | Dunning Lock Reason for Contract | MSVTG_KK | * | CHAR (1) |
| XDELPZAWE | Delete Payment Method in Item | XDELPZAWE_KK | CHAR (1) | |
| XCORPZAWE | Change Pymt Meth. in Item | XCORPZAWE_KK | CHAR (1) | |
| VERSN | Version Number | VERSN_KK | CHAR (3) | |
| INFCON | Write Entry in Information Container | INFCON_KK | CHAR (1) | |
| XSTOR_RANF | Reverse Repayment Request | XSTOR_RANF_KK | CHAR (1) | |
| FORMKEY | Application form | FORMKEY | * | CHAR (30) |
| SWIFT | SWIFT/BIC for International Payments | SWIFT | CHAR (11) |
