The FEBKO table in SAP ERP or S/4HANA stores Electronic Bank Statement Header Records data. There are total 65 fields in FEBKO table. The Electronic Bank Statement Header Records table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of FEBKO table. It is in Bank accounting: External payment information (FTE) ABAP package and is part of the Basic Functions (FIN-FSCM-CLM-CM-CM) module.
SAP FEBKO Table Fields
Following is the list of fields that are available in SAP FEBKO table. The primary key fields of the table are MANDT (Client), ANWND (Application Using Bank Data Storage), ABSND (Sending Bank (Electronic Bank Statement)), AZIDT (Bank Statement Identification), EMKEY (Payee Keys).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| ANWND | Application Using Bank Data Storage | ANWND_EBKO | CHAR (4) | |
| ABSND | Sending Bank (Electronic Bank Statement) | ABSND_EB | CHAR (50) | |
| AZIDT | Bank Statement Identification | AZIDT_EB | CHAR (20) | |
| EMKEY | Payee Keys | EMKEY_EB | CHAR (20) | |
| KUKEY | Short Key (Surrogate) | KUKEY_EB | NUMC (8) | |
| ASTAT | Statement Status | ASTAT_EB | CHAR (1) | |
| DSTAT | Print Status | DSTAT_EB | CHAR (1) | |
| VB1OK | All Postings in Area 1 Are OK | VB1OK_EBKO | CHAR (1) | |
| VB2OK | All Postings in Area 2 Are OK | VB2OK_EBKO | CHAR (1) | |
| KIPRE | All Items on Header Record Were Interpreted | KIPRE_EB | CHAR (1) | |
| VFDAT | Data Expiry Date | VFDAT_EB | DATS (8) | |
| GRP01 | Session Name for Bank Postings | GRP01_EB | CHAR (12) | |
| XKEP1 | Keep Session 1 After Processing | XKEP1_EB | CHAR (1) | |
| GRP02 | Session Name for Subledger Accounting | GRP02_EB | CHAR (12) | |
| XKEP2 | Keep Session 2 After Processing | XKEP2_EB | CHAR (1) | |
| WVDAT | Further Processing Date | WVDAT_EB | DATS (8) | |
| WVTIM | Further Processing Time | WVTIM_EB | TIMS (6) | |
| WVART | Further Processing Type | WVART_EB | CHAR (1) | |
| HKONT | General Ledger Account | HKONT | SKB1 | CHAR (10) |
| KTONR | Bank account number | BANKN | CHAR (18) | |
| KTOIH | Bank Account Holder | KTOIH_EB | CHAR (35) | |
| KTOSB | Special Account Name | KTOSB_EB | CHAR (35) | |
| AZNUM | Statement Number | AZNUM_EB | NUMC (5) | |
| AZSNR | Statement Page Number | AZSNR_EB | NUMC (3) | |
| AZDAT | Statement Date | AZDAT_EB | DATS (8) | |
| BUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| KTOPL | Chart of Accounts | KTOPL | T004 | CHAR (4) |
| WAERS | Currency Key | WAERS | TCURC | CUKY (5) |
| SSTYP | Beginning Balance Type (F=Begin Balance, M=Interim Balance) | SSTYP_EB | CHAR (1) | |
| SSVOZ | Starting Balance +/- Sign | SSVOZ_EB | CHAR (1) | |
| SSBTR | Opening Balance Amount | SSBTR_EB | CURR (23) | |
| SUMSO | Total Debit | SUMSO_EB | CURR (23) | |
| SUMHA | Total Credit | SUMHA_EB | CURR (23) | |
| ESTYP | Ending Balance Type (F=Ending Balance, M=Interim Balance) | ESTYP_EB | CHAR (1) | |
| ESVOZ | Closing Balance +/- Sign | ESVOZ_EB | CHAR (1) | |
| ESBTR | Ending Balance Amount | ESBTR_EB | CURR (23) | |
| ESDMB | Ending Balance Equivalent in Local Currency | ESDMB_EB | CURR (23) | |
| BLAUF | Life Start | BLAUF_EB | DATS (8) | |
| ELAUF | Life End | ELAUF_EB | DATS (8) | |
| HZINS | Credit Interest | HZINS_EB | DEC (9) | |
| TEILN | Customer/Vendor EB Number | TEILN_EB | CHAR (20) | |
| BKTOA | Bank Account Type | BKTOA_EB | CHAR (23) | |
| ANZES | Number of Memo Records from the Bank Statement | ANZES_EB | NUMC (5) | |
| VGTYP | Transaction Type | VGTYP_EB | CHAR (8) | |
| EFART | Input Type | EFART_EB | CHAR (1) | |
| HBKID | Short Key for a House Bank | HBKID | CHAR (5) | |
| HKTID | ID for Account Details | HKTID | CHAR (5) | |
| EUSER | User Who Fills the Bank Data Buffer | EUSER_EB | CHAR (12) | |
| EDATE | Import Date into Bank Data Buffer | EDATE_EB | DATS (8) | |
| ETIME | Import Time into Bank Data Buffer | ETIME_EB | TIMS (6) | |
| BKREF | Reference specifications for bank details | BKREF | CHAR (20) | |
| XFDIS | X – Cash Management Payment Advice Notes Were Created | XFDIS_EB | CHAR (1) | |
| DSART | Planning type | DSART | CHAR (2) | |
| XVERD | Summarize Bank Statement Items | FFDISXVERD | CHAR (1) | |
| XBENR | Object key | AWKEY | CHAR (20) | |
| XBTYP | Reference procedure | AWTYP | CHAR (5) | |
| SEQ_NUMBER | Bank Statement Sequential Number | SEQ_NUMBER | NUMC (4) | |
| SEQ_STATUS | Sequence Status | SEQ_STATUS | CHAR (1) | |
| INPUT_FORMAT | Input Format | INPUT_FORMAT | CHAR (2) | |
| SIBAN | Sender Bank Account: IBAN | SIBAN_EB | CHAR (34) | |
| AZPGNO | Page Number of Statement (5 Digits) | AZPGNO_EB | NUMC (5) | |
| FILEHASH | SHA1 Hash Value on File Content After Split | FILEHASH_EB | CHAR (40) | |
| CLOSING_AVAILABLE_BALANCE | Closing Available Balance | FEB_CLOSING_AVAILABLE_BALANCE | CURR (23) | |
| DUMMY_FEBKO | Dummy function in length 1 | DUMMY | CHAR (1) |
