The DFKKPRNH table in SAP ERP or S/4HANA stores SEPA: Direct Debit Pre-Notifications (FI-CA) data. There are total 29 fields in DFKKPRNH table. The SEPA: Direct Debit Pre-Notifications (FI-CA) table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DFKKPRNH table. It is in FI-CA: SEPA (FKK_SEPA) ABAP package and is part of the Contract Accounts Receivable and Payable (FI-CA) module.
SAP DFKKPRNH Table Fields
Following is the list of fields that are available in SAP DFKKPRNH table. The primary key fields of the table are MANDT (Client), PNNUM (SEPA: Number of Direct Debit Pre-Notification), PNHKF (SEPA: Origin of Direct Debit Pre-Notification).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| PNNUM | SEPA: Number of Direct Debit Pre-Notification | PNNUM_KK | CHAR (16) | |
| PNHKF | SEPA: Origin of Direct Debit Pre-Notification | PNHKF_KK | CHAR (2) | |
| GPART | Business Partner Number | GPART_KK | * | CHAR (10) |
| ORI_GPART | Alternative Business Partner from Posting Doocument | ORI_GPART_KK | * | CHAR (10) |
| PNEXD | SEPA: Date of Execution of Direct Debit Pre-Notifcation | PNEXD_KK | DATS (8) | |
| PNSTA | SEPA: Status of Direct Debit Pre-Notification | PNSTA_KK | CHAR (1) | |
| MNDID | Unique Reference to Mandate for each Payee | SEPA_MNDID | CHAR (35) | |
| BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR (13) | |
| BETRW_ACT | Current Amount of Direct Debit Pre-Notification | BETRW_ACT_KK | CURR (13) | |
| WAERS | Currency Key | WAERS | TCURC | CUKY (5) |
| LAUFD_CRE | Date ID | LAUFD_KK | DATS (8) | |
| LAUFI_CRE | Run ID | LAUFI_KK | CHAR (6) | |
| PAYNO | Sequential payment number | PAYNO_PAY | INT4 (10) | |
| DOC1R | Reference to Payment Document | DOC1R_PAY | CHAR (24) | |
| DOC1T | Payment document category | DOC1T_PAY | CHAR (2) | |
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS (8) | |
| CPUTM | Time of Entry | CPUTM | TIMS (6) | |
| COTYP | Correspondence Type | COTYP_KK | * | CHAR (4) |
| COKEY | Correspondence key | COKEY_KK | CHAR (36) | |
| PNXREF | SEPA: Reference to Direct Debit Pre-Notification | PNXREF_KK | CHAR (16) | |
| PYBUK | Company Code for Automatic Payment Transactions | PYBUK_KK | * | CHAR (4) |
| ERNAM | Created by | ERNAM_KK | CHAR (12) | |
| AENAM | Last Changed By | AENAM_KK | CHAR (12) | |
| AEDAT | Date of Last Change | AEDAT_KK | DATS (8) | |
| AETIM | Time at Which the Object Was Last Changed | AETIM_KK | TIMS (6) | |
| ZIBAN | IBAN (International Bank Account Number) | IBAN_KK | CHAR (34) | |
| EMBVT | Bank Details ID of Payee | EMBVT_KK | CHAR (4) | |
| XCREA | Credit Memos Were Offset | XCREA_KK | CHAR (1) |
