The BKKITREL table in SAP ERP or S/4HANA stores Payment Item data. There are total 122 fields in BKKITREL table. The Payment Item 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 BKKITREL table. It is in Bank Customer Accounts: Payment Item (FKBP_FINSERV) ABAP package and is part of the Payment Item (IS-B-BCA-AM-IT) module.
SAP BKKITREL Table Fields
Following is the list of fields that are available in SAP BKKITREL table. The primary key fields of the table are MANDT (Client), BKKRS (Bank Area), DOCNO (Item number in current accounts), POSNO (Position in Item).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| BKKRS | Bank Area | BKK_BKKRS | TBKK01 | CHAR (4) |
| DOCNO | Item number in current accounts | BKK_DOCNO | NUMC (12) | |
| POSNO | Position in Item | BKK_POSNO | NUMC (3) | |
| ACNUM_INT | Internal Account Number for Current Account | BKK_ACCNT | * | CHAR (10) |
| BANKS | Bank country key | BANKS | T005 | CHAR (3) |
| BANKL | Bank Keys | BANKK | CHAR (15) | |
| SWIFT | SWIFT/BIC for International Payments | SWIFT | CHAR (11) | |
| ACNUM_EXT | Account number for current account | BKK_ACEXT | CHAR (35) | |
| BKS | Bank Control Key | BKK_BKS | CHAR (2) | |
| ACNUM_IBAN | International Bank Account Number | BKK_ACIBAN | CHAR (35) | |
| ALT_ACEXT | Original Account Number | BKK_ALTACE | CHAR (35) | |
| ALT_IBAN | Original IBAN | BKK_ALTIBA | CHAR (35) | |
| BUPA_NO | Business Partner Account Holder | BKK_ACHOLD | * | CHAR (10) |
| BUPA_NAME | Account holder name | BKK_NAME | CHAR (70) | |
| 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) | |
| DATE_CR | Creation Date of the Data Medium | BKK_CRDATD | DATS (8) | |
| DATE_VALUE | Value date | BKK_VALDAT | DATS (8) | |
| DATE_POST | Posting date | BKK_PSTDAT | DATS (8) | |
| DATE_COL | Date of Subject to Final Payment Balance | BKK_CDATE | DATS (8) | |
| TCUR | Transaction Currency | BKK_TCUR | TCURC | CUKY (5) |
| T_AMOUNT | Amount in Transaction Currency | BKK_TAMNT | CURR (17) | |
| T_CHARGE | Charge in Transaction Currency | BKK_TCHARG | CURR (17) | |
| NACUR | Reporting Account Currency | BKK_NACUR | * | CUKY (5) |
| NA_AMOUNT | Amount in Information Account Currency | BKK_NAAMNT | CURR (17) | |
| NA_CHARGE | Charge in Reporting Currency | BKK_NACHARG | CURR (17) | |
| ACUR | Account Currency | BKK_ACUR | TCURC | CUKY (5) |
| A_AMOUNT | Amount in Account Currency | BKK_AAMNT | CURR (17) | |
| A_CHARGE | Charge in Account Currency | BKK_ACHARG | CURR (17) | |
| EXCHNGRATE | Exchange Rate | BKK_EXRATE | DEC (9) | |
| MEDIUM | Medium | BKK_MEDIUM | TBKKG1 | CHAR (4) |
| PAYMETHOD | Payment Method | BKK_PAYMET | CHAR (4) | |
| TRNSTYPE | Transaction Type | BKK_TTYPE | TBKKG3 | CHAR (4) |
| S_TRNSTYPE | Source Transaction Type | BKK_STTYPE | * | CHAR (4) |
| COUNTRY | Country | BKK_CNTRY | * | CHAR (3) |
| X_ACTCHK_E | Indicator: Error in Check Digits for Account | BKK_ACTCHK | CHAR (1) | |
| CHEQUE_TYP | Means of Payment Position Type | BKK_CASHBT | * | CHAR (4) |
| CHEQUE_NO | Check Number (External) | BKK_CHEQEX | CHAR (20) | |
| ITEMCNT | Number of Processed Items | BKK_ITCNT | NUMC (5) | |
| BUTXT | Posting Text | BKK_BUTXT | CHAR (50) | |
| REMARK | Comment on Order/Item | BKK_REMARK | CHAR (50) | |
| ITEMTYPE | Type of Payment Item | BKK_ITTYPE | CHAR (2) | |
| PROCESS | Processes in BCA | BKK_PROCSS | TBKKIPROC | CHAR (4) |
| ITEMSTATUS | Status of Payment Item | BKK_ITSTAT | CHAR (2) | |
| REF_ACEXT | Reference Account Number | BKK_REFACN | CHAR (35) | |
| REF_BKS | Bank Control Key | BKK_BKS | CHAR (2) | |
| REF_IBAN | Reference IBAN | BKK_REFIBA | CHAR (35) | |
| REF_NAME | Reference Name of Account Holder | BKK_REFNAM | CHAR (70) | |
| REF_BANKS | Reference Country Key of Bank | BKK_REFBKS | * | CHAR (3) |
| REF_BANKL | Reference Bank Key | BKK_REFBKL | CHAR (15) | |
| REF_SWIFT | SWIFT/BIC for International Payments | SWIFT | CHAR (11) | |
| XNOGLITEM | Indicator: No Update in General Ledger | BKK_XGLITM | CHAR (1) | |
| XVALDATSET | Indicator: Value Date was Specified | BKK_VDTSET | CHAR (1) | |
| XPOSTPRIOR | Indicator: Posting to prior period | BKK_PSTPRI | CHAR (1) | |
| XPRI_PPROC | Indicator: Priority in Postprocessing | BKK_XPRIPP | CHAR (1) | |
| XREVERSE | Indicator: Reversal Item | BKK_XREV | CHAR (1) | |
| REVERSE_NO | Reversal no. | BKK_REVNO | * | NUMC (12) |
| REVERSE_PS | Reversal Item | BKK_REVPOS | NUMC (3) | |
| TRNSF_BK_B | Reference Bank Area from Transfer Posting (Orig. Docu.) | BKK_TRFBKB | * | CHAR (4) |
| TRNSF_NO_B | Reference Document Number from Transfer Posting (Source Doc) | BKK_TRFDCB | * | NUMC (12) |
| TRNSF_PS_B | Reference Position Number from Trans.Posting (Orig.Document) | BKK_TRFPSB | NUMC (3) | |
| TRNSF_BK_F | Reference Bank Area from Transfer Posting | BKK_TRFBKF | * | CHAR (4) |
| TRNSF_NO_F | Reference Document Number from Transfer Posting | BKK_TRFDCF | * | NUMC (12) |
| TRNSF_PS_F | Reference Position Number from Transfer Posting | BKK_TRFPSF | NUMC (3) | |
| REF_PO_BK | Reference Field: Bank Area Generating Payment Order | BKK_REFPOB | * | CHAR (4) |
| REF_PO_NO | Reference Field: Number Generating Payment Order | BKK_REFPOD | BKKPOHD | NUMC (12) |
| REF_PO_PS | Reference Field: Position Generating Payment Order | BKK_REFPOP | NUMC (5) | |
| XCHK_CHQUE | Indicator: Check for the Check (Cheque) Switched Off? | BKK_XCHKCH | CHAR (1) | |
| XCHK_VALUE | Indicator, value date check exluded? | BKK_XCHKV | CHAR (1) | |
| XCHK_LIMIT | Indicator, limit check excluded? | BKK_XCHKL | CHAR (1) | |
| XCHK_ACLCK | Indicator, account block check excluded? | BKK_XCHKAC | CHAR (1) | |
| XCHK_BPLCK | Indicator, business partner check excluded? | BKK_XCHKBP | CHAR (1) | |
| XCHK_MANDATE | Exclude Mandate Check | BKK_DTE_FLG_EXC_MND_CHK | CHAR (1) | |
| XCHK_PRENOTE | Exclude Prenote Check | BKK_DTE_FLG_EXC_PRENOTE_CHK | CHAR (1) | |
| XCHK_EXTD_MND | Indicator: Extended Mandate Check Excluded? | BKK_DTE_FLG_EXC_EXTD_MND_CHK | CHAR (1) | |
| XERR_SYST | Indicator, error Customizing/master data? | BKK_XSYSRT | CHAR (1) | |
| XERR_ENQUE | Indicator, error in blocking account balance? | BKK_XENQRT | CHAR (1) | |
| XERR_CHQUE | Indicator, error in position management check? | BKK_XCHQRT | CHAR (1) | |
| XERR_VALUE | Indicator, error in value date check? | BKK_XVALRT | CHAR (1) | |
| XERR_LIMIT | Indicator, error in limit check? | BKK_XLIMRT | CHAR (1) | |
| XERR_ACLCK | Indicator, error in account check? | BKK_XACCRT | CHAR (1) | |
| XERR_BPLCK | Indicator, error in business partner check? | BKK_XBUPRT | CHAR (1) | |
| XERR_CUREX | Indicator, error due to block/currency changeover? | BKK_XCURRT | CHAR (1) | |
| XERR_PSTFU | Indicator – Posting Date is in the Future | BKK_XPFURT | CHAR (1) | |
| XERR_MANDATE | Error in Mandate Lock Check | BKK_DTE_FLG_MND_IND | CHAR (1) | |
| XERR_PRENOTE | Error in Prenote Check | BKK_DTE_FLG_PRENOTE_IND | CHAR (1) | |
| XERR_EXTD_MND | Indicator – Error in Extended Mandate Checks | BKK_DTE_FLG_ERR_EXTD_MND | CHAR (1) | |
| 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) | |
| PUBLIC_CONT_L1 | Public Field Length 35 | BCA_DTE_CHAR035 | CHAR (35) | |
| PUBLIC_CONT_L2 | Public Field Length 35 | BCA_DTE_CHAR035 | CHAR (35) | |
| PUBLIC_CONT_L3 | Public Field Length 35 | BCA_DTE_CHAR035 | CHAR (35) | |
| PUBLIC_CONT_L4 | Public Field Length 35 | BCA_DTE_CHAR035 | CHAR (35) | |
| PUBLIC_CONT_S1 | Public Field Length 20 | BCA_DTE_CHAR020 | CHAR (20) | |
| PUBLIC_CONT_S2 | Public Field Length 20 | BCA_DTE_CHAR020 | CHAR (20) | |
| PRENOTE_REF_NO | Prenote Reference ID | BKK_DTE_PRENOTE_REF_ID | CHAR (40) | |
| DATE_DUE | Due Date | BKK_DTE_DATE_DUE | DATS (8) | |
| UCI | Creditor Identifier | BKK_DTE_CRD_ID | CHAR (35) | |
| MANDATE_ID | Mandate Reference | BKK_DTE_MND_ID | CHAR (35) | |
| RECONC_SYSTEM | Identification of Supplying System | BKK_DTE_SYST_FROM | CHAR (10) | |
| RECONC_APPL | Reconciliation – Supplying Application ID | BKK_DTE_APPL_FROM | CHAR (5) | |
| RECONC_NO | Reconciliation Unit – Additional ID | BKK_DTE_RECONC_NO | CHAR (15) | |
| ITEMCNT8 | Extended Number of Processed Items | BKK_ITCNT8 | NUMC (8) | |
| XNO_DEL | Indicator: External Sender/Turnover Item May not Be Deleted | BKK_XNODEL | CHAR (1) | |
| FLG_NEGP | Indicator: Negative Posting | BKK_FLG_NEGP | CHAR (1) | |
| TAX_YEAR | Tax-year | RTP_US_TAXYEAR | NUMC (4) | |
| AMOUNT_ID | Amount identifier code | RTP_US_AMN_ID | CHAR (2) | |
| CONTRIB_ID | Contribution identifier | RTP_US_CON_ID | CHAR (2) | |
| IRS_DCODE | Retirement plan distribution code | RTP_US_IRS | CHAR (1) | |
| IRS_SCODE | Retirement plan distribution sub-code | RTP_US_IRS_SUB | CHAR (1) | |
| WH_AMOUNT_TOTAL | Total fed withholding amount for IRA distribution payment | RTP_US_WH_AMOUNT_TOTAL | CURR (17) | |
| XMEMO_ITEM | Items are memo items | BCA_US_XMEMO | CHAR (1) | |
| AI_POST | Posting Decision: Interest Penalty | BKK_AI_POST | CHAR (1) |
