SAP Table BKKIT

Payment Item

BKKIT (Payment Item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BKKIT to other SAP tables.

BKKIT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BKKRS Bank Area BKK_BKKRS TBKK01 CHAR 4 0
DOCNO Item number in current accounts BKK_DOCNO NUMC 12 0
POSNO Position in Item BKK_POSNO NUMC 3 0
ACNUM_INT Internal Account Number for Current Account BKK_ACCNT CHAR 10 0
BANKS Bank country key BANKS T005 CHAR 3 0
BANKL Bank Keys BANKK CHAR 15 0
SWIFT SWIFT/BIC for International Payments SWIFT CHAR 11 0
ACNUM_EXT Account number for current account BKK_ACEXT CHAR 35 0
BKS Bank Control Key BKK_BKS CHAR 2 0
ACNUM_IBAN International Bank Account Number BKK_ACIBAN CHAR 35 0
ALT_ACEXT Original Account Number BKK_ALTACE CHAR 35 0
ALT_IBAN Original IBAN BKK_ALTIBA CHAR 35 0
BUPA_NO Business Partner Account Holder BKK_ACHOLD CHAR 10 0
BUPA_NAME Account holder name BKK_NAME CHAR 70 0
REFNO_CR Reference Number of Creation BKK_CRNO CHAR 20 0
REFNO_PAYM Reference Number from Payment Transactions BKK_PAYMNO CHAR 20 0
REFNO_PN Daybook number BKK_PNNO CHAR 12 0
DATE_CR Creation Date of the Data Medium BKK_CRDATD DATS 8 0
DATE_VALUE Value date BKK_VALDAT DATS 8 0
DATE_POST Posting date BKK_PSTDAT DATS 8 0
DATE_COL Date of Subject to Final Payment Balance BKK_CDATE DATS 8 0
TCUR Transaction Currency BKK_TCUR TCURC CUKY 5 0
T_AMOUNT Amount in Transaction Currency BKK_TAMNT CURR 17 2
T_CHARGE Charge in Transaction Currency BKK_TCHARG CURR 17 2
NACUR Reporting Account Currency BKK_NACUR CUKY 5 0
NA_AMOUNT Amount in Information Account Currency BKK_NAAMNT CURR 17 2
NA_CHARGE Charge in Reporting Currency BKK_NACHARG CURR 17 2
ACUR Account Currency BKK_ACUR TCURC CUKY 5 0
A_AMOUNT Amount in Account Currency BKK_AAMNT CURR 17 2
A_CHARGE Charge in Account Currency BKK_ACHARG CURR 17 2
EXCHNGRATE Exchange Rate BKK_EXRATE DEC 9 5
MEDIUM Medium BKK_MEDIUM TBKKG1 CHAR 4 0
PAYMETHOD Payment Method BKK_PAYMET CHAR 4 0
TRNSTYPE Transaction Type BKK_TTYPE TBKKG3 CHAR 4 0
S_TRNSTYPE Source Transaction Type BKK_STTYPE CHAR 4 0
RETURNK Return Reason BKK_RKEY CHAR 2 0
COUNTRY Country BKK_CNTRY CHAR 3 0
X_ACTCHK_E Indicator: Error in Check Digits for Account BKK_ACTCHK CHAR 1 0
X Yes
NULL No
CHEQUE_TYP Means of Payment Position Type BKK_CASHBT CHAR 4 0
CHEQUE_NO Check Number (External) BKK_CHEQEX CHAR 20 0
ITEMCNT Number of Processed Items BKK_ITCNT NUMC 5 0
BUTXT Posting Text BKK_BUTXT CHAR 50 0
REMARK Comment on Order/Item BKK_REMARK CHAR 50 0
ITEMTYPE Type of Payment Item BKK_ITTYPE CHAR 2 0
01 Ordering party
02 Recipient
03 Route
04 Turnover
PROCESS Processes in BCA BKK_PROCSS TBKKIPROC CHAR 4 0
ITEMSTATUS Status of Payment Item BKK_ITSTAT CHAR 2 0
01 In Postprocessing
02 In Release Process
03 Posted
04 Posted (Open Item)
05 Deleted
06 Reversed
07 Returned
08 Planned
09 Reversal - In Release Process
10 Deletion - In Release Process
11 Deletion Pstprc.- Release
12 Return - In Release Process
13 Transf. Posting- Release
14 Sent to PTS
REF_ACEXT Reference Account Number BKK_REFACN CHAR 35 0
REF_BKS Bank Control Key BKK_BKS CHAR 2 0
REF_IBAN Reference IBAN BKK_REFIBA CHAR 35 0
REF_NAME Reference Name of Account Holder BKK_REFNAM CHAR 70 0
REF_BANKS Reference Country Key of Bank BKK_REFBKS CHAR 3 0
REF_BANKL Reference Bank Key BKK_REFBKL CHAR 15 0
REF_SWIFT SWIFT/BIC for International Payments SWIFT CHAR 11 0
XNOGLITEM Indicator: No Update in General Ledger BKK_XGLITM CHAR 1 0
X Yes
NULL No
XVALDATSET Indicator: Value Date was Specified BKK_VDTSET CHAR 1 0
X Yes
NULL No
XPOSTPRIOR Indicator: Posting to prior period BKK_PSTPRI CHAR 1 0
X Yes
NULL No
XPRI_PPROC Indicator: Priority in Postprocessing BKK_XPRIPP CHAR 1 0
X Yes
NULL No
XREVERSE Indicator: Reversal Item BKK_XREV CHAR 1 0
X Yes
NULL No
REVERSE_NO Reversal no. BKK_REVNO NUMC 12 0
REVERSE_PS Reversal Item BKK_REVPOS NUMC 3 0
TRNSF_BK_B Reference Bank Area from Transfer Posting (Orig. Docu.) BKK_TRFBKB CHAR 4 0
TRNSF_NO_B Reference Document Number from Transfer Posting (Source Doc) BKK_TRFDCB NUMC 12 0
TRNSF_PS_B Reference Position Number from Trans.Posting (Orig.Document) BKK_TRFPSB NUMC 3 0
TRNSF_BK_F Reference Bank Area from Transfer Posting BKK_TRFBKF CHAR 4 0
TRNSF_NO_F Reference Document Number from Transfer Posting BKK_TRFDCF NUMC 12 0
TRNSF_PS_F Reference Position Number from Transfer Posting BKK_TRFPSF NUMC 3 0
REF_PO_BK Reference Field: Bank Area Generating Payment Order BKK_REFPOB CHAR 4 0
REF_PO_NO Reference Field: Number Generating Payment Order BKK_REFPOD NUMC 12 0
REF_PO_PS Reference Field: Position Generating Payment Order BKK_REFPOP NUMC 5 0
XCHK_CHQUE Indicator: Check for the Check (Cheque) Switched Off? BKK_XCHKCH CHAR 1 0
X Yes
NULL No
XCHK_VALUE Indicator, value date check exluded? BKK_XCHKV CHAR 1 0
X Yes
NULL No
XCHK_LIMIT Indicator, limit check excluded? BKK_XCHKL CHAR 1 0
X Yes
NULL No
XCHK_ACLCK Indicator, account block check excluded? BKK_XCHKAC CHAR 1 0
X Yes
NULL No
XCHK_BPLCK Indicator, business partner check excluded? BKK_XCHKBP CHAR 1 0
X Yes
NULL No
XCHK_MANDATE Exclude Mandate Check BKK_DTE_FLG_EXC_MND_CHK CHAR 1 0
X Yes
NULL No
XCHK_PRENOTE Exclude Prenote Check BKK_DTE_FLG_EXC_PRENOTE_CHK CHAR 1 0
X Yes
NULL No
XCHK_EXTD_MND Indicator: Extended Mandate Check Excluded? BKK_DTE_FLG_EXC_EXTD_MND_CHK CHAR 1 0
X Yes
NULL No
XERR_SYST Indicator, error Customizing/master data? BKK_XSYSRT CHAR 1 0
X Yes
NULL No
XERR_ENQUE Indicator, error in blocking account balance? BKK_XENQRT CHAR 1 0
X Yes
NULL No
XERR_CHQUE Indicator, error in position management check? BKK_XCHQRT CHAR 1 0
X Yes
NULL No
XERR_VALUE Indicator, error in value date check? BKK_XVALRT CHAR 1 0
X Yes
NULL No
XERR_LIMIT Indicator, error in limit check? BKK_XLIMRT CHAR 1 0
X Yes
NULL No
XERR_ACLCK Indicator, error in account check? BKK_XACCRT CHAR 1 0
X Yes
NULL No
XERR_BPLCK Indicator, error in business partner check? BKK_XBUPRT CHAR 1 0
X Yes
NULL No
XERR_CUREX Indicator, error due to block/currency changeover? BKK_XCURRT CHAR 1 0
X Yes
NULL No
XERR_PSTFU Indicator - Posting Date is in the Future BKK_XPFURT CHAR 1 0
X Yes
NULL No
XERR_MANDATE Error in Mandate Lock Check BKK_DTE_FLG_MND_IND CHAR 1 0
X Yes
NULL No
XERR_PRENOTE Error in Prenote Check BKK_DTE_FLG_PRENOTE_IND CHAR 1 0
X Yes
NULL No
XERR_EXTD_MND Indicator - Error in Extended Mandate Checks BKK_DTE_FLG_ERR_EXTD_MND CHAR 1 0
X Yes
NULL No
CRUSR User who created the object BKK_CRUSR CHAR 12 0
CRDAT Date on which the object was created BKK_CRDAT DATS 8 0
CRTIM Time at which the object was created BKK_CRTIM TIMS 6 0
CHUSR Last user to change object BKK_CHUSR CHAR 12 0
CHDAT Date on which the object was last changed BKK_CHDAT DATS 8 0
CHTIM Time at Which Object was Last Changed BKK_CHTIM TIMS 6 0
RLUSR User who released object BKK_RLUSR CHAR 12 0
RLDAT Date on which object was released BKK_RLDAT DATS 8 0
RLTIM Time at Which Object Was Released BKK_RLTIM TIMS 6 0
PUBLIC_CONT_L1 Public Field Length 35 BCA_DTE_CHAR035 CHAR 35 0
PUBLIC_CONT_L2 Public Field Length 35 BCA_DTE_CHAR035 CHAR 35 0
PUBLIC_CONT_L3 Public Field Length 35 BCA_DTE_CHAR035 CHAR 35 0
PUBLIC_CONT_L4 Public Field Length 35 BCA_DTE_CHAR035 CHAR 35 0
PUBLIC_CONT_S1 Public Field Length 20 BCA_DTE_CHAR020 CHAR 20 0
PUBLIC_CONT_S2 Public Field Length 20 BCA_DTE_CHAR020 CHAR 20 0
PRENOTE_REF_NO Prenote Reference ID BKK_DTE_PRENOTE_REF_ID CHAR 40 0
DATE_DUE Due Date BKK_DTE_DATE_DUE DATS 8 0
UCI Creditor Identification BKK_DTE_CRD_ID CHAR 35 0
MANDATE_ID Mandate Reference BKK_DTE_MND_ID CHAR 35 0
RECONC_SYSTEM Identification of Supplying System BKK_DTE_SYST_FROM CHAR 10 0
RECONC_APPL Reconciliation - Supplying Application ID BKK_DTE_APPL_FROM CHAR 5 0
RECONC_NO Reconciliation Unit - Additional ID BKK_DTE_RECONC_NO CHAR 15 0
TAX_YEAR Tax-year RTP_US_TAXYEAR NUMC 4 0
AMOUNT_ID Amount identifier code RTP_US_AMN_ID CHAR 2 0
CONTRIB_ID Contribution identifier RTP_US_CON_ID CHAR 2 0
IRS_DCODE Retirement plan distribution code RTP_US_IRS CHAR 1 0
IRS_SCODE Retirement plan distribution sub-code RTP_US_IRS_SUB CHAR 1 0
WH_AMOUNT_TOTAL Total fed withholding amount for IRA distribution payment RTP_US_WH_AMOUNT_TOTAL CURR 17 2
XMEMO_ITEM Items are memo items BCA_US_XMEMO CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
AI_POST Posting Decision: Interest Penalty BKK_AI_POST CHAR 1 0
0 No Interest Penalty
1 Post Info Items
2 Do not Post Info Items
3 Post Transaction Interest
4 Do not Post Transaction Interest

BKKIT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BKKIT ACUR BKKIT MANDT TCURC Currency Codes MANDT
BKKIT ACUR BKKIT ACUR TCURC Currency Codes WAERS
BKKIT BANKS BKKIT MANDT T005 Countries MANDT
BKKIT BANKS BKKIT BANKS T005 Countries LAND1
BKKIT BKKRS BKKIT MANDT TBKK01 Bank Area Table MANDT
BKKIT BKKRS BKKIT BKKRS TBKK01 Bank Area Table BKKRS
BKKIT MANDT BKKIT MANDT T000 Clients MANDT
BKKIT MEDIUM BKKIT MANDT TBKKG1 Media MANDT
BKKIT MEDIUM BKKIT MEDIUM TBKKG1 Media MEDIUM
BKKIT PROCESS BKKIT PROCESS TBKKIPROC BCA: Processes for Payment Transactions PROCESS
BKKIT TCUR BKKIT MANDT TCURC Currency Codes MANDT
BKKIT TCUR BKKIT TCUR TCURC Currency Codes WAERS
BKKIT TRNSTYPE BKKIT TRNSTYPE TBKKG3 Transaction types TRNSTYPE
BKKIT TRNSTYPE BKKIT MANDT TBKKG3 Transaction types MANDT