SAP table FEBKO (Electronic Bank Statement Header Records)

SAP table FEBKO has 5 primary key fields being MANDT,ANWND,ABSND,AZIDT,EMKEY.

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
ANWND Application Using Bank Data Storage CHAR 4 0 ANWND_EBKO
0001 Electronic and manual bank statement
0002 Check deposit transaction
0003 Lockbox
0004 Account balance
0005 Electronic Bank Receipt
0006 Customer Payment Status
ABSND Sending Bank (Electronic Bank Statement) CHAR 50 0 ABSND_EB
AZIDT Bank Statement Identification CHAR 20 0 AZIDT_EB
EMKEY Payee Keys CHAR 20 0 EMKEY_EB
KUKEY Short Key for Bank Statement (Surrogate Key) NUMC 8 0 KUKEY_EB
ASTAT Statement Status CHAR 1 0 ASTAT_EB
DSTAT Print Status CHAR 1 0 DSTAT_EB
VB1OK All Postings in Area 1 Are OK CHAR 1 0 VB1OK_EBKO
VB2OK All Postings in Area 2 Are OK CHAR 1 0 VB2OK_EBKO
KIPRE All Items on Header Record Were Interpreted CHAR 1 0 KIPRE_EB
VFDAT Data Expiry Date DATS 8 0 VFDAT_EB
GRP01 Session Name for Bank Postings CHAR 12 0 GRP01_EB
XKEP1 Keep Session 1 After Processing CHAR 1 0 XKEP1_EB
GRP02 Session Name for Subledger Accounting CHAR 12 0 GRP02_EB
XKEP2 Keep Session 2 After Processing CHAR 1 0 XKEP2_EB
WVDAT Further Processing Date DATS 8 0 WVDAT_EB
WVTIM Further Processing Time TIMS 6 0 WVTIM_EB
WVART Further Processing Type CHAR 1 0 WVART_EB
HKONT General Ledger Account CHAR 10 0 SKB1 HKONT
KTONR Bank account number CHAR 18 0 BANKN
KTOIH Bank Account Holder CHAR 35 0 KTOIH_EB
KTOSB Special Account Name CHAR 35 0 KTOSB_EB
AZNUM Statement Number NUMC 5 0 AZNUM_EB
AZSNR Statement Page Number NUMC 3 0 AZSNR_EB
AZDAT Statement Date DATS 8 0 AZDAT_EB
BUKRS Company Code CHAR 4 0 T001 BUKRS
KTOPL Chart of Accounts CHAR 4 0 T004 KTOPL
WAERS Currency Key CUKY 5 0 TCURC WAERS
SSTYP Beginning Balance Type (F=Begin Balance, M=Interim Balance) CHAR 1 0 SSTYP_EB
SSVOZ Starting Balance +/- Sign CHAR 1 0 SSVOZ_EB
SSBTR Opening Balance Amount CURR 23 2 SSBTR_EB
SUMSO Total Debit CURR 23 2 SUMSO_EB
SUMHA Total Credit CURR 23 2 SUMHA_EB
ESTYP Ending Balance Type (F=Ending Balance, M=Interim Balance) CHAR 1 0 ESTYP_EB
ESVOZ Closing Balance +/- Sign CHAR 1 0 ESVOZ_EB
ESBTR Ending Balance Amount CURR 23 2 ESBTR_EB
ESDMB Ending Balance Equivalent in Local Currency CURR 23 2 ESDMB_EB
BLAUF Life Start DATS 8 0 BLAUF_EB
ELAUF Life End DATS 8 0 ELAUF_EB
HZINS Credit Interest DEC 9 3 HZINS_EB
TEILN Customer/Vendor EB Number CHAR 20 0 TEILN_EB
BKTOA Bank Account Type CHAR 23 0 BKTOA_EB
ANZES Number of Memo Records from the Bank Statement NUMC 5 0 ANZES_EB
VGTYP Transaction Type CHAR 8 0 VGTYP_EB
EFART Input Type CHAR 1 0 EFART_EB
HBKID Short Key for a House Bank CHAR 5 0 HBKID
HKTID ID for Account Details CHAR 5 0 HKTID
EUSER User Who Fills the Bank Data Buffer CHAR 12 0 EUSER_EB
EDATE Import Date into Bank Data Buffer DATS 8 0 EDATE_EB
ETIME Import Time into Bank Data Buffer TIMS 6 0 ETIME_EB
BKREF Reference Details for Bank Details CHAR 20 0 BKREF
XFDIS X - Cash Management Payment Advice Notes Were Created CHAR 1 0 XFDIS_EB
DSART Planning type CHAR 2 0 DSART
XVERD Summarize Bank Statement Items CHAR 1 0 FFDISXVERD
XBENR Reference Key CHAR 20 0 AWKEY
XBTYP Reference procedure CHAR 5 0 AWTYP
SEQ_NUMBER Bank Statement Sequential Number NUMC 4 0 SEQ_NUMBER
SEQ_STATUS Sequence Status CHAR 1 0 SEQ_STATUS
INPUT_FORMAT Input Format CHAR 2 0 INPUT_FORMAT
SIBAN Sender Bank Account: IBAN CHAR 34 0 SIBAN_EB
AZPGNO Page Number of Statement (5 Digits) NUMC 5 0 AZPGNO_EB
FILEHASH SHA1 Hash Value on File Content After Split CHAR 40 0 FILEHASH_EB
CLOSING_AVAILABLE_BALANCE Closing Available Balance CURR 23 2 FEB_CLOSING_AVAILABLE_BALANCE
DUMMY_FEBKO Dummy function in length 1 CHAR 1 0 DUMMY
BSIMP_PSETID Parameter Set ID CHAR 16 0 FAR_BSIMP_PSETID
SUPFINCOR Bank Statement Posting Category CHAR 1 0 SUPFINCOR
Posting to Be Processed
1 No Posting Processing
CASHUPD Cash Position Update Indicator CHAR 1 0 CASHUPD
CASHUPDOK Cash Position Update Status CHAR 1 0 CASHUPDOK

FEBKO foreign key relationships

Table Field Check Table Check Field
0 FEBKO BUKRS T001 Company Codes BUKRS
1 FEBKO HKONT SKB1 G/L account master (company code) MANDT
1 FEBKO HKONT SKB1 G/L account master (company code) BUKRS
0 FEBKO KTOPL T004 Directory of Charts of Accounts MANDT
1 FEBKO MANDT T000 Clients MANDT
0 FEBKO WAERS TCURC Currency Codes MANDT
0 FEBKO WAERS TCURC Currency Codes WAERS