FEBEP SAP (Electronic Bank Statement Line Items) Table details
Dictionary Type: Table
Description: Electronic Bank Statement Line Items
Description: Electronic Bank Statement Line Items
Table field list including key, data, relationships and ABAP select examples
FEBEP is a standard SAP Table which is used to store Electronic Bank Statement Line Items data and is available within R/3 SAP systems depending on the version and release level.
The FEBEP table consists of various fields, each holding specific information or linking keys about Electronic Bank Statement Line Items data available in SAP. These include KUKEY (Short key (surrogate)), ESNUM (Memo record number (line item number in bank statement)), EPERL (Line item completed), VB1OK (Update 1 OK).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FEBEP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
KUKEY | Short key (surrogate) | KUKEY_EB | NUMC | 8 | KUKEY_EB | ||||
ESNUM | Memo record number (line item number in bank statement) | ESNUM_EB | NUMC | 5 | NUM5 | ||||
EPERL | Line item completed | EPERL_EB | CHAR | 1 | CHAR1 | ||||
VB1OK | Update 1 OK | VB1OK_EB | CHAR | 1 | CHAR1 | ||||
VB2BA | 2nd update processed | VB2BA_EB | CHAR | 1 | CHAR1 | ||||
VB2OK | 2nd update OK | VB2OK_EB | CHAR | 1 | CHAR1 | ||||
PIPRE | Line items were interpreted | PIPRE_EB | CHAR | 1 | CHAR1 | ||||
GRPNR | Bundle number for grouping line items | GRPNR_EB | CHAR | 2 | CHAR2 | ||||
ESTAT | Error status | ESTAT_EB | CHAR | 4 | CHAR4 | ||||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BVDAT | Posting date at the bank | BVDAT_EB | DATS | 8 | DATEX | DATE_EB | |||
BUDAT | Posting date in the document | BUDAT_EB | DATS | 8 | DATEX | DATE_EB | |||
VALUT | Value date of the item to be cleared | VALUT_EB | DATS | 8 | DATE_EB | ||||
BUTIM | Value date time | BUTIM_EB | CHAR | 6 | TIME6 | ||||
VOZEI | do not use-> now EPVOZ_EP signs (C,RC,D,RD) | VOZEI_EB | CHAR | 2 | CHAR2 | ||||
KWAER | Account Currency Key | KWAER_EB | CUKY | 5 | Assigned to domain | WAERS | |||
KWBTR | Amount in account currency | KWBTR_EB | CURR | 13(2) | WRTV7 | ||||
SPESK | Fees in account currency | SPESK_EB | CURR | 13(2) | WERT7 | ||||
FWAER | Foreign currency key (unequal to account currency) | FWAER_EB | CUKY | 5 | TCURC | WAERS | |||
FWBTR | Foreign currency amount (different from account cuurency) | FWBTR_EB | CURR | 13(2) | WRTV7 | ||||
SPESF | Fees in foreign currency (not same as account currency) | SPESF_EB | CURR | 13(2) | WERT7 | ||||
VORGC | Business transaction code | VORGC_EB | CHAR | 3 | CHAR3 | ||||
TEXTS | Text key | TEXTS_EB | CHAR | 4 | CHAR4 | ||||
VGEXT | External business transaction | VGEXT_EB | CHAR | 27 | Assigned to domain | VGEXT_EB | |||
VGMAN | Transaction | VGMAN_EB | CHAR | 4 | Assigned to domain | VGMAN_EB | |||
VGINT | Posting rule | VGINT_EB | CHAR | 4 | T028D | VGINT_EB | |||
VGDEF | Posting rule determined using standard value | VGDEF_EB | CHAR | 1 | BOOLE | ||||
KFMOD | Account modification | KFMOD_EB | CHAR | 10 | KFMOD_EB | ||||
VGSAP | SAP bank transaction | VGSAP_EB | CHAR | 4 | CHAR4 | ||||
BUTXT | Bank posting text | BUTXT_EB | CHAR | 50 | CHAR50 | ||||
ANZSP | Number of collective items | ANZSP_EB | NUMC | 5 | NUM5 | ||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
PABKS | Country key of partner bank | PABKS_EB | CHAR | 3 | T005 | LAND1 | |||
PABLZ | Bank number of partner bank | PABLZ_EB | CHAR | 15 | BANKK | ||||
PASWI | SWIFT code of partner bank | PASWI_EB | CHAR | 11 | SWIFT | ||||
PAKTO | Account number at the partner bank | PAKTO_EB | CHAR | 18 | BANKN | ||||
PARTN | Business Partner | PARTN_EB | CHAR | 55 | CHAR55 | ||||
BUSAB | Accounting Clerk | BUSAB_EB | CHAR | 2 | CHAR2 | ||||
KOSTL | Cost center | KOSTL_EB | CHAR | 10 | CHAR10 | ||||
GSBER | Business area | GSBER_EB | CHAR | 4 | CHAR4 | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
VERTN | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
VERTT | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
PNOTA | Daybook number | PNOTA_EB | CHAR | 10 | CHAR10 | ||||
CHECT | Check number | CHECT | CHAR | 13 | CHCKN | CHK | |||
STAVV | Financial Assets Management status | STAVV_EB | CHAR | 2 | CHAR2 | ||||
TXTVV | Financial Assets Management Information Field | TXTVV_EB | CHAR | 40 | CHAR40 | ||||
EPVOZ | Debit/credit key for line items (for bank purposes) | EPVOZ_EB | CHAR | 1 | CHAR1 | ||||
INFO1 | Additional information 1 | INFO1_EB | CHAR | 30 | CHAR30 | ||||
INFO2 | Additional information 2 | INFO2_EB | CHAR | 30 | CHAR30 | ||||
AVSID | Payment Advice Number | AVSID | CHAR | 16 | AVSID | AVN | |||
INTAG | Interpretation algorithm | INTAG_EB | NUMC | 3 | INTAG_EB | ||||
NBBLN | Subledger document number | NBBLN_EB | CHAR | 10 | ALPHA | BELNR | |||
AK1BL | Payment on account document number | AKBLN_EB | CHAR | 10 | ALPHA | BELNR | |||
AKBLN | Payment on account document number | AKBLN_EB | CHAR | 10 | ALPHA | BELNR | |||
KNRZA | Account number of an alternative payer | KNRZA | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
AVKOA | Payment Advice Account Type | KOART_AV | CHAR | 1 | KOART_AV | ||||
AVKON | Account Number | KTONR_AV | CHAR | 10 | ALPHA | KTONR | |||
BATCH | Batch number (bundle number) | BATCH_EB | CHAR | 3 | CHAR3 | ||||
ITMNR | Batch Item Number for Lockbox | ITMNR_FLB | NUMC | 3 | NUM3 | ||||
KURSF | Exchange rate (different from local currency) | KURSF_EB | DEC | 9(5) | KURSF | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
JPDAT | Date of failed bills of exchange in Japan | JPDAT_EB | DATS | 8 | DATEX | DATE_EB | |||
POSAG | Posting algorithm (lockbox only) | POSAG_EB | CHAR | 3 | CHAR3 | ||||
SDOC2 | Number of second subledger document | SDOC2_EB | CHAR | 10 | ALPHA | BELNR | |||
VGREF | Bank Reference Number | REFBK | CHAR | 35 | CHAR35 | ||||
XBENR | Reference Key | AWKEY | CHAR | 20 | AWKEY | ||||
XBTYP | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
ARRSK | Overdue charges from/to partners in account currency | ARRSK_EB | CURR | 13(2) | WERT7 | ||||
PFORM | Processing Type | PFORM_EB | NUMC | 2 | PFORM | ||||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
KKREF | Customer-to-customer reference | REFNR_EB | CHAR | 35 | CHAR35 | ||||
KKRF2 | Customer-to-customer reference | REFNR_EB | CHAR | 35 | CHAR35 | ||||
MANSP | Dunning block | MANSP | CHAR | 1 | Assigned to domain | MANSP | |||
FNAM1 | BDC field name | BDC_FNAM | CHAR | 132 | DYNFNAM | ||||
FVAL1 | BDC field value | BDC_FVAL | CHAR | 132 | F4CHAR132 | ||||
FKOA1 | BDC-Account Type | KOART_BDC | CHAR | 1 | BDCFKOA | ||||
FNAM2 | BDC field name | BDC_FNAM | CHAR | 132 | DYNFNAM | ||||
FVAL2 | BDC field value | BDC_FVAL | CHAR | 132 | F4CHAR132 | ||||
FKOA2 | BDC-Account Type | KOART_BDC | CHAR | 1 | BDCFKOA | ||||
FNAM3 | BDC field name | BDC_FNAM | CHAR | 132 | DYNFNAM | ||||
FVAL3 | BDC field value | BDC_FVAL | CHAR | 132 | F4CHAR132 | ||||
FKOA3 | BDC-Account Type | KOART_BDC | CHAR | 1 | BDCFKOA | ||||
IDENR | ID number for cash management and forecast | IDENR | NUMC | 10 | IDENR | FFI | |||
B1APP | Application Indicator | APPLK_BF | CHAR | 6 | Assigned to domain | APPLK_BF | |||
B1ERR | Error status | ESTAT_EB | CHAR | 4 | CHAR4 | ||||
B1STD | X - Standard (FI) posting should be suppressed | ADDST_EB | CHAR | 1 | XFELD | ||||
B1DOC | Doc. no. (IDoc number, application document no., etc.) | DOC_NUMBER | CHAR | 70 | CHAR70 | ||||
B1TYP | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
B2APP | Application Indicator | APPLK_BF | CHAR | 6 | Assigned to domain | APPLK_BF | |||
B2ERR | Error status | ESTAT_EB | CHAR | 4 | CHAR4 | ||||
B2STD | X - Standard (FI) posting should be suppressed | ADDST_EB | CHAR | 1 | XFELD | ||||
B2DOC | Doc. no. (IDoc number, application document no., etc.) | DOC_NUMBER | CHAR | 70 | CHAR70 | ||||
B2TYP | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
PIBAN | Partner Bank Account: IBAN | PIBAN_EB | CHAR | 34 | IBAN | ||||
N2PCH | Note to Payee Has Been Changed Manually | FEB_N2PCHGIND | CHAR | 1 | FEB_N2PCHGIND | ||||
SVBUK | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
SVKOA | Payment Advice Account Type | KOART_AV | CHAR | 1 | KOART_AV | ||||
SVKON | Account Number | KTONR_AV | CHAR | 10 | ALPHA | KTONR | |||
SVAVS | Payment Advice Number | AVSID | CHAR | 16 | AVSID | AVN | |||
REPRO | Indicator: Process Enhancements for Reinterpretation | REPRO_EB | CHAR | 1 | FLAG | ||||
TRNID | Transaction ID | EB_TRANSID | CHAR | 35 | |||||
.INCLU--AP | 0 | ||||||||
TATYP | Transaction | FEB_BSPROC_TATYP | CHAR | 4 | FEB_BSPROC_TATYP | ||||
X_FWBTR_CHG | Status of Changes Regarding Foreign Currency | FEB_X_FWBTR_CHG | CHAR | 1 | FEB_X_FWBTR_CHG | ||||
CURR_RATE | Exchange Rate: Foreign Currency to Account Currency | FEB_CURR_RATE | DEC | 9(5) | EXCRT | KURSF | |||
.INCLU--AP | 0 | ||||||||
XREF1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
FIPEX | Commitment Item | FM_FIPEX | CHAR | 24 | Assigned to domain | FM_FIPEX | FPS |
Key field | Non-key field |
How do I retrieve data from SAP table FEBEP using ABAP code
The following ABAP code Example will allow you to do a basic selection on FEBEP to SELECT all data from the tableDATA: WA_FEBEP TYPE FEBEP.
SELECT SINGLE *
FROM FEBEP
INTO CORRESPONDING FIELDS OF WA_FEBEP
WHERE...
How to access SAP table FEBEP
Within an ECC or HANA version of SAP you can also view further information about FEBEP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects