SAP table FEBEP (Electronic Bank Statement Line Items)

SAP table FEBEP has 3 primary key fields being MANDT,KUKEY,ESNUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KUKEY Short Key for Bank Statement (Surrogate Key) NUMC 8 0 KUKEY_EB
ESNUM Memo Record Number (Line Item Number in Bank Statement) NUMC 5 0 ESNUM_EB
EPERL Line Item Completed CHAR 1 0 EPERL_EB
VB1OK Update 1 OK CHAR 1 0 VB1OK_EB
VB2BA 2nd Update Processed CHAR 1 0 VB2BA_EB
VB2OK 2nd Update OK CHAR 1 0 VB2OK_EB
PIPRE Line Items Were Interpreted CHAR 1 0 PIPRE_EB
GRPNR Bundle Number for Grouping Line Items CHAR 2 0 GRPNR_EB
ESTAT Error Status CHAR 4 0 ESTAT_EB
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
BVDAT Posting Date at the Bank DATS 8 0 BVDAT_EB
BUDAT Posting Date in the Document DATS 8 0 BUDAT_EB
VALUT Value Date of the Item to Be Cleared DATS 8 0 VALUT_EB
BUTIM Value Date Time CHAR 6 0 BUTIM_EB
VOZEI Do Not Use-> Now EPVOZ_EP Signs (C,RC,D,RD) CHAR 2 0 VOZEI_EB
KWAER Account Currency Key CUKY 5 0 KWAER_EB
KWBTR Amount in Account Currency CURR 23 2 KWBTR_EB
SPESK Fees in Account Currency CURR 23 2 SPESK_EB
FWAER Foreign Currency Key (Not Account Currency) CUKY 5 0 TCURC FWAER_EB
FWBTR Foreign Currency Amount (Different from Account Currency) CURR 23 2 FWBTR_EB
SPESF Fees in Foreign Currency (Not Same as Account Currency) CURR 23 2 SPESF_EB
VORGC Business Transaction Code CHAR 3 0 VORGC_EB
TEXTS Text Key CHAR 4 0 TEXTS_EB
VGEXT External Business Transaction CHAR 27 0 VGEXT_EB
VGMAN Transaction CHAR 4 0 VGMAN_EB
VGINT Posting Rule CHAR 4 0 T028D VGINT_EB
VGDEF Posting Rule Determined Using Standard Value CHAR 1 0 VGDEF_EB
KFMOD Account modification CHAR 10 0 KFMOD_EB
VGSAP SAP Bank Transaction CHAR 4 0 VGSAP_EB
BUTXT Bank Posting Text CHAR 50 0 BUTXT_EB
ANZSP Number of Collective Items NUMC 5 0 ANZSP_EB
XBLNR Reference Document Number CHAR 16 0 XBLNR1
ZUONR Assignment number CHAR 18 0 DZUONR
PABKS Country/Region Key of Partner Bank CHAR 3 0 T005 PABKS_EB
PABLZ Bank Number of Partner Bank CHAR 15 0 PABLZ_EB
PASWI SWIFT Code of Partner Bank CHAR 11 0 PASWI_EB
PAKTO Account Number at the Partner Bank CHAR 18 0 PAKTO_EB
PARTN Business Partner CHAR 55 0 PARTN_EB
BUSAB Accounting Clerk CHAR 2 0 BUSAB_EB
KOSTL Cost Center CHAR 10 0 KOSTL_EB
GSBER Business Area CHAR 4 0 GSBER_EB
PRCTR Profit Center CHAR 10 0 PRCTR
VERTN Contract Number CHAR 13 0 RANL
VERTT Contract Type CHAR 1 0 RANTYP
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
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
PNOTA Daybook Number CHAR 10 0 PNOTA_EB
CHECT Check number CHAR 13 0 CHECT
STAVV Financial Assets Management Status CHAR 2 0 STAVV_EB
TXTVV Financial Assets Management Information Field CHAR 40 0 TXTVV_EB
EPVOZ Debit/Credit Key for Line Items (for Bank Purposes) CHAR 1 0 EPVOZ_EB
INFO1 Additional Information 1 CHAR 30 0 INFO1_EB
INFO2 Additional Information 2 CHAR 30 0 INFO2_EB
AVSID Payment Advice Number CHAR 16 0 AVSID
INTAG Interpretation Algorithm NUMC 3 0 INTAG_EB
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.
014 014: Outgoing Check: Check Management in FI or HR
015 015: Clearing Transaction: Selection Using Assignment
019 019: Reference Number (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 Line Item)
032 032: Search for EDI Payment Advice
033 033: Search for Payment Advice Notes
034 034: Finland Reference No. for Payment Order with RFFOFI_A
035 035: Search for Structured Payment Notes -> SAP Note 555352
036 036: Extended Search Function for Payment Advices
050 050: REAL ESTATE: First Standard, Then Rental Agreemt 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: Ref.Doc.No. as 021 with Pymt Service Provider Reconcil.
226 226: Ref.Doc.No. as 026 with Pymt Service Provider Reconcil.
411 411: Outgoing Check: Extended Search Function for Check No.
800 800: Switzerland Reference Number for Payment Order
801 801: India Reference Number for Payment Order
802 802: Interpretation Algorithm for Czech Republic + Slovakia
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 CHAR 10 0 NBBLN_EB
AK1BL Payment on account document number CHAR 10 0 AKBLN_EB
AKBLN Payment on account document number CHAR 10 0 AKBLN_EB
KNRZA Account Number of an Alternative Payer CHAR 10 0 KNRZA
AVKOA Payment Advice Account Type CHAR 1 0 KOART_AV
D Customer
K Vendor
S G/L Account
AVKON Account Number CHAR 10 0 KTONR_AV
BATCH Batch Number (Bundle Number) CHAR 3 0 BATCH_EB
ITMNR Batch Item Number for Lockbox NUMC 3 0 ITMNR_FLB
KURSF Exchange Rate (Different from Local Currency) DEC 9 5 KURSF_EB
SGTXT Item Text CHAR 50 0 SGTXT
JPDAT Date of Failed Bills of Exchange in Japan DATS 8 0 JPDAT_EB
POSAG Posting Algorithm (Lockbox only) CHAR 3 0 POSAG_EB
SDOC2 Number of Second Subledger Document CHAR 10 0 SDOC2_EB
VGREF Bank Reference Number CHAR 35 0 REFBK
XBENR Reference Key CHAR 20 0 AWKEY
XBTYP Reference procedure CHAR 5 0 AWTYP
ARRSK Overdue Charges from/to Partners in Account Currency CURR 23 2 ARRSK_EB
PFORM Processing Type NUMC 2 0 PFORM_EB
KIDNO Payment Reference CHAR 30 0 KIDNO
KKREF Customer-to-Customer Reference CHAR 35 0 REFNR_EB
KKRF2 Customer-to-Customer Reference CHAR 35 0 REFNR_EB
MANSP Dunning Block CHAR 1 0 MANSP
FNAM1 BDC field name CHAR 132 0 BDC_FNAM
FVAL1 BDC field value CHAR 132 0 BDC_FVAL
FKOA1 BDC-Account Type CHAR 1 0 KOART_BDC
FNAM2 BDC field name CHAR 132 0 BDC_FNAM
FVAL2 BDC field value CHAR 132 0 BDC_FVAL
FKOA2 BDC-Account Type CHAR 1 0 KOART_BDC
FNAM3 BDC field name CHAR 132 0 BDC_FNAM
FVAL3 BDC field value CHAR 132 0 BDC_FVAL
FKOA3 BDC-Account Type CHAR 1 0 KOART_BDC
IDENR ID number for cash management and forecast NUMC 10 0 IDENR
B1APP Application Indicator CHAR 6 0 APPLK_BF
B1ERR Error Status CHAR 4 0 ESTAT_EB
B1STD X - Standard (FI) Posting Should Be Suppressed CHAR 1 0 ADDST_EB
B1DOC Doc. no. (IDoc number, application document no., etc.) CHAR 70 0 DOC_NUMBER
B1TYP Reference procedure CHAR 5 0 AWTYP
B2APP Application Indicator CHAR 6 0 APPLK_BF
B2ERR Error Status CHAR 4 0 ESTAT_EB
B2STD X - Standard (FI) Posting Should Be Suppressed CHAR 1 0 ADDST_EB
B2DOC Doc. no. (IDoc number, application document no., etc.) CHAR 70 0 DOC_NUMBER
B2TYP Reference procedure CHAR 5 0 AWTYP
PIBAN Partner Bank Account: IBAN CHAR 34 0 PIBAN_EB
N2PCH Note to Payee Has Been Changed Manually CHAR 1 0 FEB_N2PCHGIND
False
X True
SVBUK Company Code CHAR 4 0 BUKRS
SVKOA Payment Advice Account Type CHAR 1 0 KOART_AV
D Customer
K Vendor
S G/L Account
SVKON Account Number CHAR 10 0 KTONR_AV
SVAVS Payment Advice Number CHAR 16 0 AVSID
REPRO Indicator: Process Enhancements for Reinterpretation CHAR 1 0 REPRO_EB
TRNID Transaction ID CHAR 35 0 EB_TRANSID
ACCDOC_TMP_DOC_ID Temporary Accounting Document ID CHAR 22 0 FDC_ACCDOC_TMP_DOC_ID
CHECT_ORIG Check number CHAR 13 0 CHECT
CHECT_TYPE Type of document which is mentioned in CHECT CHAR 1 0 CHECT_TYPE
C Confirmation of Outgoing Check
D Confirmation of Payment File
O Other
ML_STATUS Machine Learning Status of Item CHAR 2 0 FEB_ML_STATUS
10 ML created invalid proposal
15 ML created account proposal
20 ML created proposal
30 ML created proposal which did not match
35 ML posted proposal which was reversed
40 ML created proposal which was cleared manually
50 ML created proposal which was cleared automatically
60 The bank statement item was cleared in the meantime
PR_STATUS Bank Statement Item Posting Rule Status CHAR 2 0 FEB_PR_STATUS
05 Posting Rule Job Scheduled
AK1BL_GJAHR Fiscal Year of Document on Account in Banking Book NUMC 4 0 AK1BL_GJAHR
AKBLN_GJAHR Fiscal Year of Document on Account in Subledger NUMC 4 0 AKBLN_GJAHR
BELNR_GJAHR Fiscal Year of Bank Accounting Document NUMC 4 0 BELNR_GJAHR
NBBLN_GJAHR Fiscal Year of Subledger Accounting Document NUMC 4 0 NBBLN_GJAHR
SDOC2_GJAHR Fiscal Year of Second Subledger Accounting Document NUMC 4 0 SDOC2_GJAHR
POSTINGRULEUUID Posting Rule Node Key RAW 16 0 FAR_PSTRL_NODE_KEY
DUMMY_FEBEP Dummy function in length 1 CHAR 1 0 DUMMY
BP_ID_CATEGORY BP Identification Category CHAR 6 0 BU_ID_CATEGORY
BP_ID_NUMBER Identification Number CHAR 60 0 BU_ID_NUMBER
ADDITIONAL_INFO Additional information from file CHAR 100 0 ADDITIONAL_INFO_EB
KEYPP Subarea for Parallelization in Mass Processing NUMC 3 0 KEYPP_EB
ML_STATUS_ACCDET Machine Learning Status for Account Determination of Item CHAR 2 0 FEB_ML_STATUS_AD
10 ML created invalid account proposal
20 ML created account proposal
30 ML created account proposal which did not match
35 ML posted account proposal which was reversed
40 ML created account proposal which was posted manually
50 ML created account proposal which was posted automatically
60 The bank statement item was cleared in the meantime
PART_APPL_STATUS Partial Application Status CHAR 1 0 FEB_PART_APPL_STATUS
1 Partially applied
ADVCASSIGNMENTREPETITIONSTATUS Advice assignment repetition status CHAR 2 0 FEB_ADV_ASSIGNMENT_REP_STATUS
AA Advice Assigned
RE Repetition Exceeded
RP Repetition in Progress
REPETITIONSTARTDATE Start date for repetition of payment advice assgn job DATS 8 0 REPETITIONSTARTDATE
REPETITIONENDDATE The end date for the repetition of payment advice assgn job DATS 8 0 REPETITIONENDDATE
REPETITIONJOBLASTRUNDATETIME The datetime for the last run of AVIS assign repetition DEC 15 0 REPETITIONJOBLASTRUNDATETIME
TATYP Transaction CHAR 4 0 FEB_BSPROC_TATYP
X_FWBTR_CHG Status of Changes Regarding Foreign Currency CHAR 1 0 FEB_X_FWBTR_CHG
Bank Statement Item Has Not Been Processed Manually
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
CURR_RATE Exchange Rate: Foreign Currency to Account Currency DEC 9 5 FEB_CURR_RATE
REPROCREASONCODE Reprocessing Reason Code CHAR 2 0 FEB_REPRO_RRC FEB_REPRO_REASON_CODE
XREF1 Business Partner Reference Key CHAR 12 0 XREF1
FIPEX Commitment Item CHAR 24 0 * FM_FIPEX

FEBEP foreign key relationships

Table Field Check Table Check Field
0 FEBEP FWAER TCURC Currency Codes MANDT
0 FEBEP FWAER TCURC Currency Codes WAERS
1 FEBEP MANDT T000 Clients MANDT
0 FEBEP PABKS T005 Countries MANDT
0 FEBEP PABKS T005 Countries LAND1
1 FEBEP REPROCREASONCODE FEB_REPRO_RRC Reprocessing Reason Code REPROCREASONCODE