DFKKRP SAP table for – Returns lot: Data for payment

Here we would like to draw your attention to DFKKRP 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). DFKKRP is a SAP standard transp table used for storing Returns lot: Data for payment related data in SAP. It comes under the package FKKB.

SAP DFKKRP table

Table DFKKRP technical data

TableDFKKRP
Data storingReturns lot: Data for payment
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DFKKRP 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 DFKKRP table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • KEYR1 : Returns Lot
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • POSRA : Item number in a returns lot
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • SELT1 : Selection Category
    Its data type is CHAR (Character String) with field length 1
  • SELW1 : Field value to be selected
    Its data type is CHAR (Character String) with field length 20
  • BETRR : Return amount
    Its data type is CURR (Currency Field) with field length 13
  • BETRH : Amount In Local Currency With +/- Signs
    Its data type is CURR (Currency Field) with field length 13
  • BETRU : Input Amount For Returns in Transaction Currency
    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
  • 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
  • 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
  • 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
  • SKZB1 : Tax Code: Bank Charge 1
    Its data type is CHAR (Character String) with field length 2
  • SKZB2 : Tax Code from Bank 2
    Its data type is CHAR (Character String) with field length 2
  • SKZV1 : Tax Code: Returns Charge 1
    Its data type is CHAR (Character String) with field length 2
  • SKZV2 : Tax Code for Return Fees 2
    Its data type is CHAR (Character String) with field length 2
  • FIKEY : Reconciliation Key for General Ledger
    Its data type is CHAR (Character String) with field length 12
  • RLSKO : Bank clearing account for returns
    Its data type is CHAR (Character String) with field length 10
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • BLART : Document Type
    Its data type is CHAR (Character String) with field length 2
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • WAERU : Foreign Currency For Returns Amount
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • KURSF : Exchange rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • 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
  • XEIPH : Create Line Item in General Ledger
    Its data type is CHAR (Character String) with field length 1
  • RLGRD : Return reason
    Its data type is CHAR (Character String) with field length 3
  • RLHBK : House bank’s return reason
    Its data type is CHAR (Character String) with field length 6
  • AENAM : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • AEDAT : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AETIM : Time at Which the Object Was Last Changed
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • OPBEL : Payment document for returns
    Its data type is CHAR (Character String) with field length 12
  • RLBEL : Number of the return document
    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
  • TXTVW : Note to Payee in Payment
    Its data type is CHAR (Character String) with field length 80
  • 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
  • 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
  • CHECF : Number of a returned check
    Its data type is CHAR (Character String) with field length 16
  • XACCEPTCHARGES : Returns: Accepting Charges over Tolerance Limit
    Its data type is CHAR (Character String) with field length 1
  • RLMOD : Returns Posting Type
    Its data type is CHAR (Character String) with field length 1
  • FLAGS : Status marker
    Its data type is CHAR (Character String) with field length 32
  • XERWR : Enhanced Returns Processing
    Its data type is CHAR (Character String) with field length 1
  • XKLAE : Posting to Clarification Account
    Its data type is CHAR (Character String) with field length 1
  • KLAEB : Number of Document Posted to Clarification Account
    Its data type is CHAR (Character String) with field length 12
  • KLAEH : Clarification Account
    Its data type is CHAR (Character String) with field length 10
  • KLAED : Date of Posting to Clarification Account
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XVOID : Returns: Invalid Items
    Its data type is CHAR (Character String) with field length 1
  • .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