SAP Table FEBEP

Electronic Bank Statement Line Items

FEBEP (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 FEBEP to other SAP tables.

FEBEP 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 Memo record number (line item number in bank statement) ESNUM_EB NUMC 5 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 BDC-Account Type KOART_BDC CHAR 1 0
0 1. Line Posting Area 1
1 1. Line Posting Area 2
2 2. Line Posting Area 1
3 2. Line Posting Area 2
FNAM2 BDC field name BDC_FNAM CHAR 132 0
FVAL2 BDC field value BDC_FVAL CHAR 132 0
FKOA2 BDC-Account Type KOART_BDC CHAR 1 0
0 1. Line Posting Area 1
1 1. Line Posting Area 2
2 2. Line Posting Area 1
3 2. Line Posting Area 2
FNAM3 BDC field name BDC_FNAM CHAR 132 0
FVAL3 BDC field value BDC_FVAL CHAR 132 0
FKOA3 BDC-Account Type KOART_BDC CHAR 1 0
0 1. Line Posting Area 1
1 1. Line Posting Area 2
2 2. Line Posting Area 1
3 2. Line Posting Area 2
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
N2PCH Note to Payee Has Been Changed Manually FEB_N2PCHGIND CHAR 1 0
X True
NULL False
SVBUK Company Code BUKRS CHAR 4 0
SVKOA Payment Advice Account Type KOART_AV CHAR 1 0
D Customer
K Vendor
S G/L account
SVKON Account Number KTONR_AV CHAR 10 0
SVAVS Payment Advice Number AVSID CHAR 16 0
REPRO Indicator: Process Enhancements for Reinterpretation REPRO_EB CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
TRNID Transaction ID EB_TRANSID CHAR 35 0
TATYP Transaction FEB_BSPROC_TATYP CHAR 4 0
X_FWBTR_CHG Status of Changes Regarding Foreign Currency FEB_X_FWBTR_CHG CHAR 1 0
1 Foreign Currency Amount not Predefined, To Date Unchanged
2 Foreign Currency Amount not Predefined, Manually Changed
3 Foreign Currency Amount Predefined, To Date Unchanged
4 Foreign Currency Amount Predefined, Manually Changed
NULL Bank Statement Item Has Not Been Processed Manually
CURR_RATE Exchange Rate: Foreign Currency to Account Currency FEB_CURR_RATE DEC 9 5
XREF1 Business partner reference key XREF1 CHAR 12 0
FIPEX Commitment Item FM_FIPEX CHAR 24 0

FEBEP foreign key relationships

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