DFKKPRNH SAP table for – SEPA: Direct Debit Pre-Notifications (FI-CA)

Here we would like to draw your attention to DFKKPRNH 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). DFKKPRNH is a SAP standard transp table used for storing SEPA: Direct Debit Pre-Notifications (FI-CA) related data in SAP. It comes under the package FKK_SEPA.

SAP DFKKPRNH table

Table DFKKPRNH technical data

TableDFKKPRNH
Data storingSEPA: Direct Debit Pre-Notifications (FI-CA)
ModuleFI
Sub ModuleFI-CA
SAP PackageFKK_SEPA
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PNNUM : SEPA: Number of Direct Debit Pre-Notification
    Its a key field. Its data type is CHAR (Character String) with field length 16
  • PNHKF : SEPA: Origin of Direct Debit Pre-Notification
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • GPART : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • ORI_GPART : Alternative Business Partner from Posting Doocument
    Its data type is CHAR (Character String) with field length 10
  • PNEXD : SEPA: Date of Execution of Direct Debit Pre-Notifcation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PNSTA : SEPA: Status of Direct Debit Pre-Notification
    Its data type is CHAR (Character String) with field length 1
  • MNDID : Unique Referene to Mandate per Payment Recipient
    Its data type is CHAR (Character String) with field length 35
  • BETRW : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • BETRW_ACT : Current Amount of Direct Debit Pre-Notification
    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
  • LAUFD_CRE : Date ID
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAUFI_CRE : Additional Identification Characteristic
    Its data type is CHAR (Character String) with field length 6
  • PAYNO : Sequential payment number
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DOC1R : Reference to Payment Document
    Its data type is CHAR (Character String) with field length 24
  • DOC1T : Payment document category
    Its data type is CHAR (Character String) with field length 2
  • CPUDT : Accounting document entry date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CPUTM : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • COTYP : Correspondence Type
    Its data type is CHAR (Character String) with field length 4
  • COKEY : Correspondence key
    Its data type is CHAR (Character String) with field length 36
  • PNXREF : SEPA: Reference to Direct Debit Pre-Notification
    Its data type is CHAR (Character String) with field length 16
  • PYBUK : Company Code for Automatic Payment Transactions
    Its data type is CHAR (Character String) with field length 4
  • ERNAM : Created by
    Its data type is CHAR (Character String) with field length 12
  • AENAM : Last changed by
    Its data type is CHAR (Character String) with field length 12
  • AEDAT : Date of Last Change
    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
  • ZIBAN : IBAN (International Bank Account Number)
    Its data type is CHAR (Character String) with field length 34
  • EMBVT : Bank Details ID of Payee
    Its data type is CHAR (Character String) with field length 4
  • .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
  • .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