DFKKZP SAP table for – Payment lot: Data for payment

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

SAP DFKKZP table

Table DFKKZP technical data

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

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • KEYZ1 : Payment Lot
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • POSZA : Item number in a payment lot
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • SELT1 : 1. Selection Category
    Its data type is CHAR (Character String) with field length 1
  • SELT2 : 2. Selection Category
    Its data type is CHAR (Character String) with field length 1
  • SELT3 : 3. Selection Category
    Its data type is CHAR (Character String) with field length 1
  • SELW1 : First Field Value to be Selected
    Its data type is CHAR (Character String) with field length 35
  • SELW2 : Second Field Value to be Selected
    Its data type is CHAR (Character String) with field length 35
  • SELW3 : Third Field Value to be Selected
    Its data type is CHAR (Character String) with field length 35
  • BETRZ : Payment amount in transaction currency
    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
  • BETRK : Assigned Amount in Transaction Currency
    Its data type is CURR (Currency Field) with field length 13
  • BETRL : Clarified Amount In Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • XTKLA : Partial Clarifications Exist For Payment
    Its data type is CHAR (Character String) with field length 1
  • TBETR : Partial Amount that Refers to the Specified Selection
    Its data type is CURR (Currency Field) with field length 13
  • FIKEY : Reconciliation Key for General Ledger
    Its data type is CHAR (Character String) with field length 12
  • BVRKO : Bank clearing account
    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
  • 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
  • AUGRD : Clearing Reason
    Its data type is CHAR (Character String) with field length 2
  • 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
  • XRUES : Check was or will be sent back
    Its data type is CHAR (Character String) with field length 1
  • XAKON : Post Payment on Account
    Its data type is CHAR (Character String) with field length 1
  • XKLAE : Clarify Payment Transaction
    Its data type is CHAR (Character String) with field length 1
  • KLAEB : Number of Clarification Document
    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 : Posting date of clarif. doc
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • KLAEC : Clarification Company Code
    Its data type is CHAR (Character String) with field length 4
  • OPBEL : Number of Contract Accts Rec. & Payable Doc.
    Its data type is CHAR (Character String) with field length 12
  • UPOSZ : Allocation key for payment item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • UPOSV : Allocation key for payment item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • TXTVW : Note to Payee in Payment
    Its data type is CHAR (Character String) with field length 80
  • CHCKN : Check number
    Its data type is CHAR (Character String) with field length 13
  • BANKS : Bank country key
    Its data type is CHAR (Character String) with field length 3
  • BANKL : Bank Number of Other Bank Key
    Its data type is CHAR (Character String) with field length 15
  • BANKN : Bank account number
    Its data type is CHAR (Character String) with field length 18
  • BKONT : Bank Control Key
    Its data type is CHAR (Character String) with field length 2
  • KOINH : Name of Holder of Bank Account/Check Issuer/Cardholder
    Its data type is CHAR (Character String) with field length 60
  • XPGRO : Post Office Bank Current Account
    Its data type is CHAR (Character String) with field length 1
  • XDAUB : Payment by Standing Order
    Its data type is CHAR (Character String) with field length 1
  • NRZAA : Repayment request
    Its data type is CHAR (Character String) with field length 10
  • REPYM : Payment Method for Repayment
    Its data type is CHAR (Character String) with field length 1
  • XCLAR : Line item included in clarification worklist
    Its data type is CHAR (Character String) with field length 1
  • INFOF : Additional information
    Its data type is CHAR (Character String) with field length 50
  • KUKON : Short Account Assignment for Transfer Postings
    Its data type is CHAR (Character String) with field length 4
  • CCINS : Payment card type
    Its data type is CHAR (Character String) with field length 4
  • CCNUM : Payment cards: Card number
    Its data type is CHAR (Character String) with field length 25
  • RUEBL : Number of the resetting document
    Its data type is CHAR (Character String) with field length 12
  • RUEAR : Type of resetting document
    Its data type is CHAR (Character String) with field length 1
  • BKREF : Reference specifications for bank details
    Its data type is CHAR (Character String) with field length 20
  • TXTRZ : Text For Payment on Account, Repayment, or Transfer Posting
    Its data type is CHAR (Character String) with field length 50
  • HZUON : Assignment Number in G/L Document
    Its data type is CHAR (Character String) with field length 18
  • DATAB : Payment cards: Valid from
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATBI : Payment Cards: Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AUNUM : Payment cards: Authorization number
    Its data type is CHAR (Character String) with field length 25
  • AUDAT : Payment cards: Authorization date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AUTIM : Payment cards: Authorization time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • XATTS : Move Attachments of UPOSZ from PSOZA
    Its data type is CHAR (Character String) with field length 1
  • CGUID : GUID of a Payment Card
    Its data type is RAW (Byte string) with field length 16
  • ENCTP : Type of Encryption
    Its data type is CHAR (Character String) with field length 1
  • IBAN : IBAN (International Bank Account Number)
    Its data type is CHAR (Character String) with field length 34
  • SWIFT : SWIFT/BIC for International Payments
    Its data type is CHAR (Character String) with field length 11
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes