The BKK_OPD_IT_EXT table in SAP ERP or S/4HANA stores External Item Selection Table – Outgoing Payment Dispatcher data. There are total 53 fields in BKK_OPD_IT_EXT table. The External Item Selection Table – Outgoing Payment Dispatcher 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 BKK_OPD_IT_EXT table. It is in Bank Customer Accounts: OPD Persistency Layer (BKK_OPD_PERSISTENCY) ABAP package and is part of the Interface to Payment Transaction System (IS-B-BCA-PTS) module.
SAP BKK_OPD_IT_EXT Table Fields
Following is the list of fields that are available in SAP BKK_OPD_IT_EXT table. The primary key fields of the table are MANDT (Client), BKKRS (Bank Area), PAORN (Payment order number), POSNO (Item in Payment Order).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| BKKRS | Bank Area | BKK_BKKRS | * | CHAR (4) |
| PAORN | Payment order number | BKK_PAORN | NUMC (12) | |
| POSNO | Item in Payment Order | BKK_POPOS | NUMC (5) | |
| ITEM_STATUS | Item Status | BKK_OPD_DTE_ITEM_STATUS | CHAR (1) | |
| PRIORITY | Processing Priority of Payment Item in OPD | BKK_OPD_DTE_PRIORITY | BKK_OPD_PRIO | NUMC (2) |
| POST_DATE | Posting date | BKK_PSTDAT | DATS (8) | |
| CURRENCY | Transaction Currency | BKK_TCUR | TCURC | CUKY (5) |
| GUID | GUID | BKK_OPD_DTE_GUID | RAW (16) | |
| XCREDIT | Transaction Type Initiates a Credit | BKK_INPMNT | CHAR (1) | |
| COLL_PO_REF_NO | Collective Payment Order Reference Number | BKK_OPD_DTE_COL_PO_REF_NO | CHAR (32) | |
| COM_AMOUNT | Compensation Amount | BKK_OPD_DTE_COM_AMOUNT | CURR (17) | |
| COM_CUR | Compensation Amount Currency | BKK_OPD_DTE_COM_CURR | * | CUKY (5) |
| SND_BANK_COUNTRY | Bank country key | BANKS | * | CHAR (3) |
| SND_BANKKEY | Bank Keys | BANKK | CHAR (15) | |
| SND_BIC | SWIFT/BIC for International Payments | SWIFT | CHAR (11) | |
| SND_ACC_NO_EXT | Account number for current account | BKK_ACEXT | CHAR (35) | |
| SND_IBAN | International Bank Account Number | BKK_ACIBAN | CHAR (35) | |
| SND_ACC_HOLDER | Account holder name | BKK_NAME | CHAR (70) | |
| SND_ACC_CRCY | Account Currency | BKK_ACUR | * | CUKY (5) |
| SND_STREET_NAME | Street | AD_STREET | CHAR (60) | |
| SND_HOUSE_NO | House Number | AD_HSNM1 | CHAR (10) | |
| SND_POSTAL_CODE | City postal code | AD_PSTCD1 | CHAR (10) | |
| SND_CITY | City | AD_CITY1 | CHAR (40) | |
| SND_REGION | Region (State, Province, County) | REGIO | * | CHAR (3) |
| SND_COUNTRY | Country Key | BKK_OPD_DTE_COUNTRY_KEY | * | CHAR (3) |
| REFNO_CR | Reference Number of Creation | BKK_CRNO | CHAR (20) | |
| REFNO_PAYM | Reference Number from Payment Transactions | BKK_PAYMNO | CHAR (20) | |
| REFNO_PN | Daybook number | BKK_PNNO | CHAR (12) | |
| RECONC_SYSTEM | Originating System for Payment Orders and Payment Items | BKK_DTE_PXPO_SYSTEM_FROM | * | CHAR (10) |
| RECONC_APPL | Originating Application for Payment Orders and Payment Items | BKK_DTE_PXPO_APPLICATION_FROM | CHAR (5) | |
| RECONC_NO | Reconciliation Number | BKK_DTE_PXPO_RECONC_NO | CHAR (15) | |
| REF_SND_BANK_COUNTRY | Bank country key | BANKS | * | CHAR (3) |
| REF_SND_BANKKEY | Bank Keys | BANKK | CHAR (15) | |
| REF_SND_BIC | SWIFT/BIC for International Payments | SWIFT | CHAR (11) | |
| REF_SND_ACC_NO_EXT | Account number for current account | BKK_ACEXT | CHAR (35) | |
| REF_SND_IBAN | International Bank Account Number | BKK_ACIBAN | CHAR (35) | |
| REF_SND_ACC_HOLDER | Account holder name | BKK_NAME | CHAR (70) | |
| REF_SND_ACC_CRCY | Account Currency | BKK_ACUR | * | CUKY (5) |
| XSDD | SEPA Direct Debit Order | BKK_DTE_FLG_XSDD | CHAR (1) | |
| PAY_TYPE | SEPA: Payment Type | SEPA_PAY_TYPE | CHAR (1) | |
| MAND_FREQ | Mandate Frequency | BKK_MAND_FREQ | CHAR (1) | |
| DATE_DUE | Due Date | BKK_DTE_DATE_DUE | DATS (8) | |
| SIGN_DATE | Date of Signature | SEPA_SIGN_DATE | DATS (8) | |
| CRUSR | User who created the object | BKK_CRUSR | CHAR (12) | |
| CRDAT | Date on which the object was created | BKK_CRDAT | DATS (8) | |
| CRTIM | Time at which the object was created | BKK_CRTIM | TIMS (6) | |
| CHUSR | Last user to change object | BKK_CHUSR | CHAR (12) | |
| CHDAT | Date on which the object was last changed | BKK_CHDAT | DATS (8) | |
| CHTIM | Time at Which Object was Last Changed | BKK_CHTIM | TIMS (6) | |
| RLUSR | User who released object | BKK_RLUSR | CHAR (12) | |
| RLDAT | Date on which object was released | BKK_RLDAT | DATS (8) | |
| RLTIM | Time at Which Object Was Released | BKK_RLTIM | TIMS (6) |
