SAP DFKKPNBKH Table – Prenotification data (history)

The DFKKPNBKH table in SAP ERP or S/4HANA stores Prenotification data (history) data. There are total 37 fields in DFKKPNBKH table. The Prenotification data (history) 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 DFKKPNBKH table. It is in FI-CA: Country specific development (FKK_INTDEV) ABAP package and is part of the Contract Accounts Receivable and Payable (FI-LOC-CA) module.

SAP DFKKPNBKH Table Fields

Following is the list of fields that are available in SAP DFKKPNBKH table. The primary key fields of the table are MANDT (Client), GPART (Business Partner Number), MASTY (Master Record Type), MASRF (Master Record Reference Number), BKVID (Bank details ID), AEDAT (Date of Last Change), AETIM (Time changed).

Field Description Data Element Check Table Data Type
MANDT Client MANDT CLNT (3)
GPART Business Partner Number GPART_KK BUT000 CHAR (10)
MASTY Master Record Type MTYPN_KK CHAR (2)
MASRF Master Record Reference Number MASRF_KK CHAR (20)
BKVID Bank details ID BU_BKVID CHAR (4)
AEDAT Date of Last Change AEDAT DATS (8)
AETIM Time changed CDUZEIT TIMS (6)
SRTF1 Prenotification: Format-Specific Sorting SRTF1PN_KK CHAR (30)
PNREF Prenotification Reference Number PNREF_KK CHAR (18)
ZBNKS Bank country key BANKS T005 CHAR (3)
ZBNKL Bank number BANKL CHAR (15)
ZBNKN Bank account number BANKN CHAR (18)
BKONT Bank Control Key BKONT CHAR (2)
BKREF Reference specifications for bank details BKREF CHAR (20)
ZNME1 Account Holder Name BU_KOINH CHAR (60)
STAPN Prenotification Status STAPN_KK CHAR (1)
STAPR Prenotification: Processing Status STAPR_KK CHAR (1)
OPBUK Company Code Group OPBUK_KK CHAR (4)
HBKID Short Key for a House Bank HBKID T012 CHAR (5)
HKTID ID for Account Details HKTID T012K CHAR (5)
BNKID User Number at the Bank BNKID CHAR (14)
FDATE Prenotification Valid-From Date FDAPN_KK DATS (8)
NOBLK Prenotification: No Payment Block by Prenotification NOBLKPN_KK CHAR (1)
LAUFD Date on Which the Program Is to Be Run LAUFD DATS (8)
LAUFI Additional Identification LAUFI CHAR (6)
XVORL Prenotification Simulation Run XVORLPN_KK CHAR (1)
AENAM Name of person who changed object AENAM CHAR (12)
XUPDH Prenotification Was Modified XUPDH_KK CHAR (1)
XEINZ Prenotification Bank Details Used for Incoming Payment XEINZPN_KK CHAR (1)
ABWRE Alternative Payer ABWRE_KK CHAR (10)
ABWRA Alternative Payee ABWRA_KK CHAR (10)
PNORI Prenotification Origin PNORI_KK CHAR (1)
RTDAT Date on Which Return File is Received RTDATPN_KK DATS (8)
RTCOD Prenotification: Return Code RTCOD_KK CHAR (5)
RTTXT Error Text when Reporting Back the Prenotification ERRTXT CHAR (44)
VKONA_BR Contract account number in legacy system VKONA_KK CHAR (20)
PYMET_BR Payment Method PYMET_KK * CHAR (1)