DFKKRH SAP (Returns History) Table details
Dictionary Type: Table
Description: Returns History
Description: Returns History
Table field list including key, data, relationships and ABAP select examples
DFKKRH is a standard SAP Table which is used to store Returns History data and is available within R/3 SAP systems depending on the version and release level.
The DFKKRH table consists of various fields, each holding specific information or linking keys about Returns History data available in SAP. These include GPART (Business Partner Number), VKONT (Contract Account Number), RLBEL (Number of the return document), KEYR1 (Returns Lot).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP DFKKRH table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| GPART | Business Partner Number | GPART_KK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | |
| VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | KTO | FKKVKP_F4 |
| RLBEL | Number of the return document | RLBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | ||
| KEYR1 | Returns Lot | KEYR1_KK | CHAR | 12 | KEYR1_KK | 8RS | |||
| POSRA | Item number in a returns lot | POSRA_KK | NUMC | 6 | NUM06 | ||||
| OPBEL | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | 80B | |
| URBEL | Document Number of Receivables Document | URBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | ||
| BETRWR | Partial Amount Of Return | BETRWR_KK | CURR | 13(2) | WRTV7 | ||||
| BETRR | Return amount | BETRR_KK | CURR | 13(2) | WRTV7 | ||||
| BTRB1 | Charge amount from bank 1 | BTRB1_KK | CURR | 13(2) | WRTV7 | ||||
| BTRB2 | Charge amount from bank 2 | BTRB2_KK | CURR | 13(2) | WRTV7 | ||||
| STBB1 | Tax Amount: Bank Charge 1 | STBB1_KK | CURR | 13(2) | WRTV7 | ||||
| STBB2 | Tax amount: Bank charge 2 | STBB2_KK | CURR | 13(2) | WRTV7 | ||||
| BTRV1 | Returns Charge 1 | BTRV1_KK | CURR | 13(2) | WRTV7 | ||||
| BTRV2 | Return charge 2 | BTRV2_KK | CURR | 13(2) | WRTV7 | ||||
| STBV1 | Tax amount: Return charges 1 | STBV1_KK | CURR | 13(2) | WRTV7 | ||||
| STBV2 | Tax amount: Return charges 2 | STBV2_KK | CURR | 13(2) | WRTV7 | ||||
| WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
| BUDAT | Posting Date in the Document | BUDAT_KK | DATS | 8 | DATUM | ||||
| BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
| VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
| RLGRD | Return reason | RLGRD_KK | CHAR | 3 | Assigned to domain | RLGRD_KK | |||
| BANKL | Banking Country of Business Partner | GPBANKS | CHAR | 3 | CHAR3 | ||||
| BANKK | Business Partner Bank Number | GPBANKK | CHAR | 15 | CHAR15 | ||||
| BANKN | Account Number of Business Partner | GPBANKN | CHAR | 18 | CHAR18 | ||||
| IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
| CHECF | Number of a returned check | CHECF_KK | CHAR | 16 | CHECF_KK | ||||
| NRZAS | Payment Form Number | NRZAS_KK | CHAR | 12 | ALPHA | NRZAS_KK | |||
| HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | Assigned to domain | HBKID | |||
| HKTID | ID for account details | HKTID | CHAR | 5 | Assigned to domain | HKTID | |||
| RLMOD | Returns Posting Type | RLMOD_KK | CHAR | 1 | RLMOD_KK | ||||
| STODT | Reversal Document Posting Date | STODT_KK | DATS | 8 | DATUM | ||||
| STBLG | Number of Reverse Document/Reset Document | STBLG_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | ||
| XSTOR | Document Has Been Reversed | XSTOR_KK | CHAR | 1 | XFELD | ||||
| RLANZ | Number Of Returns That Occurred in The Observation Period | RLANZ_KK | NUMC | 2 | RLANZ_KK | ||||
| BONIT | Creditworthiness | BONIT_KK | NUMC | 4 | BONIT_KK | ||||
| TOGRU | Tolerance group for contract account | TOGRU_KK | CHAR | 4 | Assigned to domain | TOGRU_KK | |||
| XGEBV | Pass On Bank Charges | XGEBV_KK | CHAR | 1 | XFELD | ||||
| XGEBS | Calculate Graduated Charges | XGEBS_KK | CHAR | 1 | XFELD | ||||
| XEZSP | Field is obsolete | XEZSP_KK | CHAR | 1 | XFELD | ||||
| XEZSB | Field is obsolete | XEZSB_KK | CHAR | 1 | XFELD | ||||
| XBVBL | Delete bank details | XBVBL_KK | CHAR | 1 | XFELD | ||||
| STUNT | Deferral days | STUNT_KK | NUMC | 3 | STUNT_KK | ||||
| STUDT | Deferral to | STUDT_KK | DATS | 8 | DATUM | ||||
| MSPOP | Dunning Lock Reason for Line Item | MSPOP_KK | CHAR | 1 | Assigned to domain | MANSP_KK | |||
| MSPOP_DAYS | Item dunning lock: days | MSPOP_DAYS_KK | INT4 | 10 | INT4 | ||||
| PSPOP | Payment lock reason for item | PSPOP_KK | CHAR | 1 | Assigned to domain | SPZAH_KK | |||
| PSPOP_DAYS | Payment lock for incoming payments: Duration in days | PSPOP_DAYS_KK | INT4 | 10 | INT4 | ||||
| MSPKO | Dunning lock reason for contract account | MSPKO_KK | CHAR | 1 | Assigned to domain | MANSP_KK | |||
| MSPKO_DAYS | Contract acct dunn. lock: days | MSPKO_DAYS_KK | INT4 | 10 | INT4 | ||||
| EZSKO | Reason for Lock on Incoming Payment for Contract Account | EZSKO_KK | CHAR | 1 | Assigned to domain | SPZAH_KK | |||
| EZSKO_DAYS | Contract account incoming payment lock: Duration in days | EZSKO_DAYS_KK | INT4 | 10 | INT4 | ||||
| AZSKO | Reason for Outgoing Payment Lock for Contract Account | AZSKO_KK | CHAR | 1 | Assigned to domain | SPZAH_KK | |||
| AZSKO_DAYS | Contract account outgoing payments lock: Duration in days | AZSKO_DAYS_KK | INT4 | 10 | INT4 | ||||
| EZAWE | Incoming Payment Method | EZAWE_KK | CHAR | 1 | CHAR1 | ||||
| GEBST | Post Charges Statistically | GEBST_KK | CHAR | 1 | XFELD | ||||
| XDELEZAWE | Delete payment method with account instead of changing | XDELEZAWE_KK | CHAR | 1 | XDELEZAWE_KK | ||||
| XDELAZAWE | Returns Activity: Delete Outgoing Payment Method in Account | XDELAZAWE_KK | CHAR | 1 | XFELD | ||||
| MACHG | Activate Event for Changing Master Data | MACHG_KK | CHAR | 1 | XFELD | ||||
| BSNTE | Inform Specialist | BSNTE_KK | CHAR | 1 | XFELD | ||||
| BCORR | Activate Event for Creating Correspondence | BCORR_KK | CHAR | 1 | XFELD | ||||
| EZVTG | Incoming Payment Lock in Contract | EZVTG_KK | CHAR | 1 | Assigned to domain | SPZAH_KK | |||
| EZVTG_DAYS | Incoming Payment Lock in Contract: Duration in Days | EZVTG_DAYS_KK | INT4 | 10 | |||||
| AZVTG | Outgoing Payment Lock Reason for Contract | AZVTG_KK | CHAR | 1 | Assigned to domain | SPZAH_KK | |||
| AZVTG_DAYS | Outgoing Payment Lock Contract: Duration in Days | AZVTG_DAYS_KK | INT4 | 10 | |||||
| MSVTG | Dunning Lock Reason for Contract | MSVTG_KK | CHAR | 1 | Assigned to domain | MANSP_KK | |||
| MSVTG_DAYS | Dunning Lock in Contract: Duration in Days | MSVTG_DAYS_KK | INT4 | 10 | |||||
| XDELPZAWE | Delete Payment Method in Item | XDELPZAWE_KK | CHAR | 1 | XDELPZAWE_KK | ||||
| XCORPZAWE | Change Pymt Meth. in Item | XCORPZAWE_KK | CHAR | 1 | XCORPZAWE_KK | ||||
| VERSN | Version Number | VERSN_KK | CHAR | 3 | CHAR3 | ||||
| INFCON | Write Entry in Information Container | INFCON_KK | CHAR | 1 | XFELD | ||||
| SWIFT | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT |
| Key field | Non-key field |
How do I retrieve data from SAP table DFKKRH using ABAP code
The following ABAP code Example will allow you to do a basic selection on DFKKRH to SELECT all data from the tableDATA: WA_DFKKRH TYPE DFKKRH.
SELECT SINGLE *
FROM DFKKRH
INTO CORRESPONDING FIELDS OF WA_DFKKRH
WHERE...
How to access SAP table DFKKRH
Within an ECC or HANA version of SAP you can also view further information about DFKKRH and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects