SAP Table FEBKO
Electronic Bank Statement Header Records
FEBKO (Electronic Bank Statement Header Records) 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 FEBKO to other SAP tables.
FEBKO table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||
|
ANWND
Application using bank data storage
|
ANWND_EBKO |
CHAR
|
4 | 0 | ||||||||||||||
|
||||||||||||||||||
|
ABSND
Sending bank (electronic bank statement)
|
ABSND_EB |
CHAR
|
50 | 0 | ||||||||||||||
|
AZIDT
Bank statement identification
|
AZIDT_EB |
CHAR
|
20 | 0 | ||||||||||||||
|
EMKEY
Payee Keys
|
EMKEY_EB |
CHAR
|
20 | 0 | ||||||||||||||
|
KUKEY
Short key (surrogate)
|
KUKEY_EB |
NUMC
|
8 | 0 | ||||||||||||||
|
ASTAT
Statement status
|
ASTAT_EB |
CHAR
|
1 | 0 | ||||||||||||||
|
DSTAT
Print status
|
DSTAT_EB |
CHAR
|
1 | 0 | ||||||||||||||
|
VB1OK
All postings in area 1 are OK
|
VB1OK_EBKO |
CHAR
|
1 | 0 | ||||||||||||||
|
VB2OK
All postings in area 2 are OK
|
VB2OK_EBKO |
CHAR
|
1 | 0 | ||||||||||||||
|
KIPRE
All items on header record were interpreted
|
KIPRE_EB |
CHAR
|
1 | 0 | ||||||||||||||
|
VFDAT
Data expiry date
|
VFDAT_EB |
DATS
|
8 | 0 | ||||||||||||||
|
GRP01
Session name for bank postings
|
GRP01_EB |
CHAR
|
12 | 0 | ||||||||||||||
|
XKEP1
Keep session 1 after processing
|
XKEP1_EB |
CHAR
|
1 | 0 | ||||||||||||||
|
GRP02
Session name for subledger accounting
|
GRP02_EB |
CHAR
|
12 | 0 | ||||||||||||||
|
XKEP2
Keep session 2 after processing
|
XKEP2_EB |
CHAR
|
1 | 0 | ||||||||||||||
|
WVDAT
Further processing date
|
WVDAT_EB |
DATS
|
8 | 0 | ||||||||||||||
|
WVTIM
Further processing time
|
WVTIM_EB |
TIMS
|
6 | 0 | ||||||||||||||
|
WVART
Further processing type
|
WVART_EB |
CHAR
|
1 | 0 | ||||||||||||||
|
HKONT
General Ledger Account
|
HKONT | SKB1 |
CHAR
|
10 | 0 | |||||||||||||
|
KTONR
Bank account number
|
BANKN |
CHAR
|
18 | 0 | ||||||||||||||
|
KTOIH
Bank account holder
|
KTOIH_EB |
CHAR
|
35 | 0 | ||||||||||||||
|
KTOSB
Special account name
|
KTOSB_EB |
CHAR
|
35 | 0 | ||||||||||||||
|
AZNUM
Statement number
|
AZNUM_EB |
NUMC
|
5 | 0 | ||||||||||||||
|
AZSNR
Statement page number
|
AZSNR_EB |
NUMC
|
3 | 0 | ||||||||||||||
|
AZDAT
Statement Date
|
AZDAT_EB |
DATS
|
8 | 0 | ||||||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||||
|
KTOPL
Chart of Accounts
|
KTOPL | T004 |
CHAR
|
4 | 0 | |||||||||||||
|
WAERS
Currency Key
|
WAERS | TCURC |
CUKY
|
5 | 0 | |||||||||||||
|
SSTYP
Beginning balance type (F=begin balance, M=interim balance)
|
SSTYP_EB |
CHAR
|
1 | 0 | ||||||||||||||
|
SSVOZ
Starting balance +/- sign
|
SSVOZ_EB |
CHAR
|
1 | 0 | ||||||||||||||
|
SSBTR
Opening balance amount
|
SSBTR_EB |
CURR
|
17 | 2 | ||||||||||||||
|
SUMSO
Total Debit
|
SUMSO_EB |
CURR
|
17 | 2 | ||||||||||||||
|
SUMHA
Total Credit
|
SUMHA_EB |
CURR
|
17 | 2 | ||||||||||||||
|
ESTYP
Ending balance type (F=ending balance, M=interim balance)
|
ESTYP_EB |
CHAR
|
1 | 0 | ||||||||||||||
|
ESVOZ
Closing balance +/- sign
|
ESVOZ_EB |
CHAR
|
1 | 0 | ||||||||||||||
|
ESBTR
Ending balance amount
|
ESBTR_EB |
CURR
|
17 | 2 | ||||||||||||||
|
ESDMB
Ending balance equivalent in local currency
|
ESDMB_EB |
CURR
|
17 | 2 | ||||||||||||||
|
BLAUF
Life start
|
BLAUF_EB |
DATS
|
8 | 0 | ||||||||||||||
|
ELAUF
Life end
|
ELAUF_EB |
DATS
|
8 | 0 | ||||||||||||||
|
HZINS
Credit interest
|
HZINS_EB |
DEC
|
9 | 3 | ||||||||||||||
|
TEILN
Customer/vendor EB number
|
TEILN_EB |
CHAR
|
20 | 0 | ||||||||||||||
|
BKTOA
Bank account type
|
BKTOA_EB |
CHAR
|
23 | 0 | ||||||||||||||
|
ANZES
Number of memo records from the bank statement
|
ANZES_EB |
NUMC
|
5 | 0 | ||||||||||||||
|
VGTYP
Transaction type
|
VGTYP_EB |
CHAR
|
8 | 0 | ||||||||||||||
|
EFART
Input Type
|
EFART_EB |
CHAR
|
1 | 0 | ||||||||||||||
|
HBKID
Short Key for a House Bank
|
HBKID |
CHAR
|
5 | 0 | ||||||||||||||
|
HKTID
ID for account details
|
HKTID |
CHAR
|
5 | 0 | ||||||||||||||
|
EUSER
User who fills the bank data buffer
|
EUSER_EB |
CHAR
|
12 | 0 | ||||||||||||||
|
EDATE
Import date into bank data puffer
|
EDATE_EB |
DATS
|
8 | 0 | ||||||||||||||
|
ETIME
Import time into bank data buffer
|
ETIME_EB |
TIMS
|
6 | 0 | ||||||||||||||
|
BKREF
Reference specifications for bank details
|
BKREF |
CHAR
|
20 | 0 | ||||||||||||||
|
XFDIS
X - cash management payment advice notes were created
|
XFDIS_EB |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
DSART
Planning type
|
DSART |
CHAR
|
2 | 0 | ||||||||||||||
|
XVERD
Summarize bank statement items
|
FFDISXVERD |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
XBENR
Reference Key
|
AWKEY |
CHAR
|
20 | 0 | ||||||||||||||
|
XBTYP
Reference Transaction
|
AWTYP |
CHAR
|
5 | 0 | ||||||||||||||
|
SEQ_NUMBER
Bank statement sequential number
|
SEQ_NUMBER |
NUMC
|
4 | 0 | ||||||||||||||
|
SEQ_STATUS
Sequence status
|
SEQ_STATUS |
CHAR
|
1 | 0 | ||||||||||||||
|
INPUT_FORMAT
Input format
|
INPUT_FORMAT |
CHAR
|
2 | 0 | ||||||||||||||
|
SIBAN
Sender Bank Account: IBAN
|
SIBAN_EB |
CHAR
|
34 | 0 | ||||||||||||||
FEBKO foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| FEBKO | BUKRS | FEBKO | MANDT |
T001
Company Codes
|
MANDT |
| FEBKO | BUKRS | FEBKO | BUKRS |
T001
Company Codes
|
BUKRS |
| FEBKO | HKONT | FEBKO | MANDT |
SKB1
G/L account master (company code)
|
MANDT |
| FEBKO | HKONT | FEBKO | BUKRS |
SKB1
G/L account master (company code)
|
BUKRS |
| FEBKO | HKONT | FEBKO | HKONT |
SKB1
G/L account master (company code)
|
SAKNR |
| FEBKO | KTOPL | FEBKO | MANDT |
T004
Directory of Charts of Accounts
|
MANDT |
| FEBKO | KTOPL | FEBKO | KTOPL |
T004
Directory of Charts of Accounts
|
KTOPL |
| FEBKO | MANDT | FEBKO | MANDT |
T000
Clients
|
MANDT |
| FEBKO | WAERS | FEBKO | MANDT |
TCURC
Currency Codes
|
MANDT |
| FEBKO | WAERS | FEBKO | WAERS |
TCURC
Currency Codes
|
WAERS |