1. Home
  2. Resources
  3. SAP Tables
  4. FKKBEP - Electronic Bank Statement Line Items

SAP Table FKKBEP

Electronic Bank Statement Line Items

FKKBEP (Electronic Bank Statement Line Items) 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 FKKBEP to other SAP tables.

FKKBEP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KUKEY Short key (surrogate) KUKEY_EB NUMC 8 0
ESNUM Single Record Number (Line Item Number in Account Statement) ESNUM_KK NUMC 8 0
EPERL Line item completed EPERL_EB CHAR 1 0
VB1OK Update 1 OK VB1OK_EB CHAR 1 0
VB2BA 2nd update processed VB2BA_EB CHAR 1 0
VB2OK 2nd update OK VB2OK_EB CHAR 1 0
PIPRE Line items were interpreted PIPRE_EB CHAR 1 0
GRPNR Bundle number for grouping line items GRPNR_EB CHAR 2 0
ESTAT Error status ESTAT_EB CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BVDAT Posting date at the bank BVDAT_EB DATS 8 0
BUDAT Posting date in the document BUDAT_EB DATS 8 0
VALUT Value date of the item to be cleared VALUT_EB DATS 8 0
BUTIM Value date time BUTIM_EB CHAR 6 0
VOZEI do not use-> now EPVOZ_EP signs (C,RC,D,RD) VOZEI_EB CHAR 2 0
KWAER Account Currency Key KWAER_EB CUKY 5 0
KWBTR Amount in account currency KWBTR_EB CURR 13 2
SPESK Fees in account currency SPESK_EB CURR 13 2
FWAER Foreign currency key (unequal to account currency) FWAER_EB TCURC CUKY 5 0
FWBTR Foreign currency amount (different from account cuurency) FWBTR_EB CURR 13 2
SPESF Fees in foreign currency (not same as account currency) SPESF_EB CURR 13 2
VORGC Business transaction code VORGC_EB CHAR 3 0
TEXTS Text key TEXTS_EB CHAR 4 0
VGEXT External business transaction VGEXT_EB CHAR 27 0
VGMAN Transaction VGMAN_EB CHAR 4 0
VGINT Posting rule VGINT_EB T028D CHAR 4 0
VGDEF Posting rule determined using standard value VGDEF_EB CHAR 1 0
X TRUE
NULL FALSE
KFMOD Account modification KFMOD_EB CHAR 10 0
VGSAP SAP bank transaction VGSAP_EB CHAR 4 0
BUTXT Bank posting text BUTXT_EB CHAR 50 0
ANZSP Number of collective items ANZSP_EB NUMC 5 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
ZUONR Assignment Number DZUONR CHAR 18 0
PABKS Country key of partner bank PABKS_EB T005 CHAR 3 0
PABLZ Bank number of partner bank PABLZ_EB CHAR 15 0
PASWI SWIFT code of partner bank PASWI_EB CHAR 11 0
PAKTO Account number at the partner bank PAKTO_EB CHAR 18 0
PARTN Business Partner PARTN_EB CHAR 55 0
BUSAB Accounting Clerk BUSAB_EB CHAR 2 0
KOSTL Cost center KOSTL_EB CHAR 10 0
GSBER Business area GSBER_EB CHAR 4 0
PRCTR Profit Center PRCTR CHAR 10 0
VERTN Contract Number RANL CHAR 13 0
VERTT Contract Type RANTYP CHAR 1 0
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
PNOTA Daybook number PNOTA_EB CHAR 10 0
CHECT Check number CHECT CHAR 13 0
STAVV Financial Assets Management status STAVV_EB CHAR 2 0
TXTVV Financial Assets Management Information Field TXTVV_EB CHAR 40 0
EPVOZ Debit/credit key for line items (for bank purposes) EPVOZ_EB CHAR 1 0
INFO1 Additional information 1 INFO1_EB CHAR 30 0
INFO2 Additional information 2 INFO2_EB CHAR 30 0
AVSID Payment Advice Number AVSID CHAR 16 0
INTAG Interpretation algorithm INTAG_EB NUMC 3 0
000 000: No interpretation
001 001: Standard algorithm
011 011:Outgoing Check: Check No. Different from Pymt Doc. No.
012 012: Outgoing check: check number same as payment doc.no.
013 013: Outgoing check: check number = or <> payment doc.no.
015 015: Clearing transaction: selection using assignment
019 019: Reference no. (DME management)
020 020: Document number search
021 021: Reference document number search
022 022: Bank transfer method (Germany only) with doc.numbers
023 023 Bank transfer method (Germany only) with ref.numbers
024 024: Reserved
025 025: Invoice list
026 026: Ref.doc.no. - Search with preceding zeroes if <10
027 027: Reference number (TIT0)
028 028: Reference number using MULTICASH conversion programs
029 029: Payment order number
030 030: Brazilian search using BELNR, GJAHR, and BUZEI
031 031: Document number search (customer number from doc.line)
032 032: Look for EDI payment advice
033 033 Search for Payment Advice Notes
034 034 Finland Reference Number for Payment Order with RFFOFI_A
035 035 Search for structured payment notes -> SAP Note 555352
050 050: REAL ESTATE: First standard, then rental agrmt search
051 051: REAL ESTATE: Rental agreement search, then standard
060 060 Document Number Search for Clearing Documents
120 120 Document Number Search Without Test Read
121 121 Reference Document Number Search Without Test Read
221 221 RefDocNo. as 021 with Payment Service Provider Reconcil.
226 226 RefDocNo. as 026 with Payment Service Provider Reconcil.
901 901: Customer-Specific Interpretation Algorithm 1
902 902: Customer-Specific Interpretation Algorithm 2
903 903: Customer-Specific Interpretation Algorithm 3
904 904: Customer-Specific Interpretation Algorithm 4
905 905: Customer-Specific Interpretation Algorithm 5
906 906: Customer-Specific Interpretation Algorithm 6
907 907: Customer-Specific Interpretation Algorithm 7
908 908: Customer-Specific Interpretation Algorithm 8
909 909 Customer-Specific Interpretation Algorithm 9
NBBLN Subledger document number NBBLN_EB CHAR 10 0
AK1BL Payment on account document number AKBLN_EB CHAR 10 0
AKBLN Payment on account document number AKBLN_EB CHAR 10 0
KNRZA Account number of an alternative payer KNRZA CHAR 10 0
AVKOA Payment Advice Account Type KOART_AV CHAR 1 0
D Customer
K Vendor
S G/L account
AVKON Account Number KTONR_AV CHAR 10 0
BATCH Batch number (bundle number) BATCH_EB CHAR 3 0
ITMNR Batch Item Number for Lockbox ITMNR_FLB NUMC 3 0
KURSF Exchange rate (different from local currency) KURSF_EB DEC 9 5
SGTXT Item Text SGTXT CHAR 50 0
JPDAT Date of failed bills of exchange in Japan JPDAT_EB DATS 8 0
POSAG Posting algorithm (lockbox only) POSAG_EB CHAR 3 0
SDOC2 Number of second subledger document SDOC2_EB CHAR 10 0
VGREF Bank Reference Number REFBK CHAR 35 0
XBENR Reference Key AWKEY CHAR 20 0
XBTYP Reference Transaction AWTYP CHAR 5 0
ARRSK Overdue charges from/to partners in account currency ARRSK_EB CURR 13 2
PFORM Processing Type PFORM_EB NUMC 2 0
00 Dummy entry - not assignable
01 Clearing with check
02 Closing Balance
03 Opening Balance
04 Clearing with allocation no.
05 Bank transfer BACS/ bk collection BACS/ customer cash inflow
06 Bank charges / interest / dividends
07 Total cash outflow per file
08 Total cash inflow per file
09 Refused transfer/ bank collection
11 Brazil: Enter document with Brazilian data
12 Clearing the payment advice completes posting
20 BAI: Total Balance
21 BAI: Early Balance
22 BAI: Later Balance
23 BAI: Adjustment Balance
24 BAI: Other Balance
KIDNO Payment Reference KIDNO CHAR 30 0
KKREF Customer-to-customer reference REFNR_EB CHAR 35 0
KKRF2 Customer-to-customer reference REFNR_EB CHAR 35 0
MANSP Dunning block MANSP CHAR 1 0
FNAM1 BDC field name BDC_FNAM CHAR 132 0
FVAL1 BDC field value BDC_FVAL CHAR 132 0
FKOA1 Payment Advice Account Type KOART_AV CHAR 1 0
D Customer
K Vendor
S G/L account
FNAM2 BDC field name BDC_FNAM CHAR 132 0
FVAL2 BDC field value BDC_FVAL CHAR 132 0
FKOA2 Payment Advice Account Type KOART_AV CHAR 1 0
D Customer
K Vendor
S G/L account
FNAM3 BDC field name BDC_FNAM CHAR 132 0
FVAL3 BDC field value BDC_FVAL CHAR 132 0
FKOA3 Payment Advice Account Type KOART_AV CHAR 1 0
D Customer
K Vendor
S G/L account
IDENR ID number for cash management and forecast IDENR NUMC 10 0
B1APP Application Indicator APPLK_BF CHAR 6 0
B1ERR Error status ESTAT_EB CHAR 4 0
B1STD X - Standard (FI) posting should be suppressed ADDST_EB CHAR 1 0
X Yes
NULL No
B1DOC Doc. no. (IDoc number, application document no., etc.) DOC_NUMBER CHAR 70 0
B1TYP Reference Transaction AWTYP CHAR 5 0
B2APP Application Indicator APPLK_BF CHAR 6 0
B2ERR Error status ESTAT_EB CHAR 4 0
B2STD X - Standard (FI) posting should be suppressed ADDST_EB CHAR 1 0
X Yes
NULL No
B2DOC Doc. no. (IDoc number, application document no., etc.) DOC_NUMBER CHAR 70 0
B2TYP Reference Transaction AWTYP CHAR 5 0
PIBAN Partner Bank Account: IBAN PIBAN_EB CHAR 34 0
XREF1 Business partner reference key XREF1 CHAR 12 0
FIPEX Commitment Item FM_FIPEX CHAR 24 0

FKKBEP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FKKBEP FWAER FKKBEP MANDT TCURC Currency Codes MANDT
FKKBEP FWAER FKKBEP FWAER TCURC Currency Codes WAERS
FKKBEP MANDT FKKBEP MANDT T000 Clients MANDT
FKKBEP PABKS FKKBEP MANDT T005 Countries MANDT
FKKBEP PABKS FKKBEP PABKS T005 Countries LAND1
FKKBEP VGINT FKKBEP MANDT T028D Define Internal Transactions in Electronic Banking MANDT
FKKBEP VGINT FKKBEP VGINT T028D Define Internal Transactions in Electronic Banking VGINT