1. SAP Tutorial
  2. FI Module

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

    • DFKKPRNH related tables

    • DFKKPRND : SEPA: Direct Debit Pre-Notification (FI-CA) Deleted Items
    • TFKSEPA_V : SEPA: Visibility of Mandate Fields
    • DFKKPRNH : SEPA: Direct Debit Pre-Notifications (FI-CA)

    DFKKPRNH related transaction codes under SAP package FKK_SEPA

    • FPPRN3 : Display SEPA Direct Debit Pre-Notif.
    • FPPRN2 : Change SEPA Pre-Notifications
    • FPPRNL : List of Direct Debit Pre-Notif.
    • FPN11 : Number Range Maint: FKKPRENOT
    • S_P7I_74002808 : IMG Activity
    • FPYP : Direct Debit Pre-Notification (SEPA)
    • FPPRN8 : Reverse SEPA Direct Debit Pre-Notif.
    • FPPRN8M : Mass Reversal of Pre-Notifications

    Related References

    Related Tutorials

    DFKKPRND SAP table for – SEPA: Direct Debit Pre-Notification (FI-CA) Deleted Items

    DFKKPRND table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    FPYP SAP tcode for – Direct Debit Pre-Notification (SEPA)

    FPYP tcode in SAP FI (Contract Accounts Receivable and Payable in FI) module. This transaction code is used for Direct...

    FPPRN3 SAP tcode for – Display SEPA Direct Debit Pre-Notif.

    FPPRN3 tcode in SAP FI (Contract Accounts Receivable and Payable in FI) module. This transaction code is used for Display...

    FPPRN8 SAP tcode for – Reverse SEPA Direct Debit Pre-Notif.

    FPPRN8 tcode in SAP FI (Contract Accounts Receivable and Payable in FI) module. This transaction code is used for Reverse...

    FPPRN2 SAP tcode for – Change SEPA Pre-Notifications

    FPPRN2 tcode in SAP FI (Contract Accounts Receivable and Payable in FI) module. This transaction code is used for Change...

    FPPRNL SAP tcode for – List of Direct Debit Pre-Notif.

    FPPRNL tcode in SAP FI (Contract Accounts Receivable and Payable in FI) module. This transaction code is used for List...

    FPPRN8M SAP tcode for – Mass Reversal of Pre-Notifications

    FPPRN8M tcode in SAP FI (Contract Accounts Receivable and Payable in FI) module. This transaction code is used for Mass...

    «
    »