DFKKRH SAP table for – Returns History

Here we would like to draw your attention to DFKKRH table in SAP. As we know it is being mainly used with the SAP FI-CA (Contract Accounts Receivable and Payable in FI) component which is coming under FI module (Financial Accounting). DFKKRH is a SAP standard transp table used for storing Returns History related data in SAP. It comes under the package FKKB.

SAP DFKKRH table

Table DFKKRH technical data

TableDFKKRH
Data storingReturns History
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DFKKRH Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in DFKKRH table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GPART : Business Partner Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • VKONT : Contract Account Number
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • RLBEL : Number of the return document
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • KEYR1 : Returns Lot
    Its data type is CHAR (Character String) with field length 12
  • POSRA : Item number in a returns lot
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • OPBEL : Number of Contract Accts Rec. & Payable Doc.
    Its data type is CHAR (Character String) with field length 12
  • URBEL : Document Number of Receivables Document
    Its data type is CHAR (Character String) with field length 12
  • BETRWR : Partial Amount Of Return
    Its data type is CURR (Currency Field) with field length 13
  • BETRR : Return amount
    Its data type is CURR (Currency Field) with field length 13
  • BTRB1 : Charge amount from bank 1
    Its data type is CURR (Currency Field) with field length 13
  • BTRB2 : Charge amount from bank 2
    Its data type is CURR (Currency Field) with field length 13
  • STBB1 : Tax Amount: Bank Charge 1
    Its data type is CURR (Currency Field) with field length 13
  • STBB2 : Tax amount: Bank charge 2
    Its data type is CURR (Currency Field) with field length 13
  • BTRV1 : Returns Charge 1
    Its data type is CURR (Currency Field) with field length 13
  • BTRV2 : Return charge 2
    Its data type is CURR (Currency Field) with field length 13
  • STBV1 : Tax amount: Return charges 1
    Its data type is CURR (Currency Field) with field length 13
  • STBV2 : Tax amount: Return charges 2
    Its data type is CURR (Currency Field) with field length 13
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALUT : Fixed Value Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RLGRD : Return reason
    Its data type is CHAR (Character String) with field length 3
  • BANKL : Banking Country of Business Partner
    Its data type is CHAR (Character String) with field length 3
  • BANKK : Business Partner Bank Number
    Its data type is CHAR (Character String) with field length 15
  • BANKN : Account Number of Business Partner
    Its data type is CHAR (Character String) with field length 18
  • IBAN : IBAN (International Bank Account Number)
    Its data type is CHAR (Character String) with field length 34
  • CHECF : Number of a returned check
    Its data type is CHAR (Character String) with field length 16
  • NRZAS : Payment Form Number
    Its data type is CHAR (Character String) with field length 12
  • HBKID : Short key for a house bank
    Its data type is CHAR (Character String) with field length 5
  • HKTID : ID for account details
    Its data type is CHAR (Character String) with field length 5
  • RLMOD : Returns Posting Type
    Its data type is CHAR (Character String) with field length 1
  • STODT : Reversal Document Posting Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • STBLG : Number of Reverse Document/Reset Document
    Its data type is CHAR (Character String) with field length 12
  • XSTOR : Document Has Been Reversed
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Returns Activities
  • RLANZ : Number Of Returns That Occurred in The Observation Period
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • BONIT : Creditworthiness
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • TOGRU : Tolerance group for contract account
    Its data type is CHAR (Character String) with field length 4
  • XGEBV : Pass On Bank Charges
    Its data type is CHAR (Character String) with field length 1
  • XGEBS : Calculate Graduated Charges
    Its data type is CHAR (Character String) with field length 1
  • XEZSP : Field is obsolete
    Its data type is CHAR (Character String) with field length 1
  • XEZSB : Field is obsolete
    Its data type is CHAR (Character String) with field length 1
  • XBVBL : Delete bank details
    Its data type is CHAR (Character String) with field length 1
  • STUNT : Deferral days
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • STUDT : Deferral to
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MSPOP : Dunning Lock Reason for Line Item
    Its data type is CHAR (Character String) with field length 1
  • MSPOP_DAYS : Item dunning lock: days
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PSPOP : Payment lock reason for item
    Its data type is CHAR (Character String) with field length 1
  • PSPOP_DAYS : Payment lock for incoming payments: Duration in days
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • MSPKO : Dunning lock reason for contract account
    Its data type is CHAR (Character String) with field length 1
  • MSPKO_DAYS : Contract acct dunn. lock: days
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • EZSKO : Reason for Lock on Incoming Payment for Contract Account
    Its data type is CHAR (Character String) with field length 1
  • EZSKO_DAYS : Contract account incoming payment lock: Duration in days
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • AZSKO : Reason for Outgoing Payment Lock for Contract Account
    Its data type is CHAR (Character String) with field length 1
  • AZSKO_DAYS : Contract account outgoing payments lock: Duration in days
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • EZAWE : Incoming Payment Method
    Its data type is CHAR (Character String) with field length 1
  • GEBST : Post Charges Statistically
    Its data type is CHAR (Character String) with field length 1
  • XDELEZAWE : Delete payment method with account instead of changing
    Its data type is CHAR (Character String) with field length 1
  • XDELAZAWE : Returns Activity: Delete Outgoing Payment Method in Account
    Its data type is CHAR (Character String) with field length 1
  • MACHG : Activate Event for Changing Master Data
    Its data type is CHAR (Character String) with field length 1
  • BSNTE : Indicator: Activate Event for Informing Accounting Clerk
    Its data type is CHAR (Character String) with field length 1
  • BCORR : Activate Event for Creating Correspondence
    Its data type is CHAR (Character String) with field length 1
  • EZVTG : Incoming Payment Lock in Contract
    Its data type is CHAR (Character String) with field length 1
  • EZVTG_DAYS : Incoming Payment Lock in Contract: Duration in Days
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • AZVTG : Outgoing Payment Lock Reason for Contract
    Its data type is CHAR (Character String) with field length 1
  • AZVTG_DAYS : Outgoing Payment Lock Contract: Duration in Days
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • MSVTG : Dunning Lock Reason for Contract
    Its data type is CHAR (Character String) with field length 1
  • MSVTG_DAYS : Dunning Lock in Contract: Duration in Days
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • XDELPZAWE : Delete Payment Method in Item
    Its data type is CHAR (Character String) with field length 1
  • XCORPZAWE : Change Pymt Meth. in Item
    Its data type is CHAR (Character String) with field length 1
  • VERSN : Version Number
    Its data type is CHAR (Character String) with field length 3
  • .INCLUDE : IS-U Fields: Returns
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • SWIFT : SWIFT/BIC for International Payments
    Its data type is CHAR (Character String) with field length 11