FEBKO

Transparent Table Application Table
72 Fields 16 CDS Views

Electronic Bank Statement Header Records

FEBKO is an SAP database table in S/4HANA. Electronic Bank Statement Header Records. It contains 72 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
E_ARBankStatement view from
I_BankAccountMainLinkage view left_outer BASIC Bank Account Main Linkage
I_SAFTBankStatement view from BASIC SAF-T Bank Statement
I_SK_BankStatementHeader view_entity from BASIC Bank Statement Header
P_Arbanktransactiondoc_01 view from COMPOSITE
P_Arbanktransactiondoc_02 view from COMPOSITE
P_ARBSITMBANKSTMT01 view inner BASIC
P_BankStatementDetail view from BASIC
P_FEBKO view from BASIC
P_FEBKOTIME view from BASIC
P_Fqmbankstatement view inner BASIC
P_HIST_ARBANKTRANSACTION view from BASIC
P_LatestBankStatement01 view from COMPOSITE
VFCLM_BAM_DDL_BSM_FR1 view from First Rank View on FEBKO
VFCLM_BAM_DDL_BSM_FR2 view inner Second Rank View on FEBKO
VFCP_DDL_BS view inner

Fields (72)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY anwnd ANWND_EBKO Application
KEY absnd ABSND_EB Sending Bank
KEY azidt AZIDT_EB Statement ID
KEY emkey EMKEY_EB Recipient Key
kukey KUKEY_EB Short Key
astat ASTAT_EB Stmt Status
dstat DSTAT_EB Print Status
vb1ok VB1OK_EBKO Post Area 1 OK
vb2ok VB2OK_EBKO Area 2 OK
kipre KIPRE_EB Interpreted
vfdat VFDAT_EB Expiration Date
grp01 GRP01_EB Bank Session
xkep1 XKEP1_EB Keep_session_1
grp02 GRP02_EB Subldgr Session
xkep2 XKEP2_EB Keep_session_2
wvdat WVDAT_EB Processing Date
wvtim WVTIM_EB Processing Time
wvart WVART_EB Processing Type
hkont HKONT G/L Acct
ktonr BANKN Bank Account
ktoih KTOIH_EB Account Holder
ktosb KTOSB_EB Spec Acct Name
aznum AZNUM_LG_EB Bank Statement No.
azsnr AZSNR_EB Page Number
azdat AZDAT_EB Statement Date
bukrs BUKRS Company Code
ktopl KTOPL Chart of Accts
waers WAERS Currency
sstyp SSTYP_EB Open. Bal. Type
ssvoz SSVOZ_EB Start. Bal +/-
ssbtr SSBTR_EB Opening Balance
sumso SUMSO_EB Total Debit
sumha SUMHA_EB Total Credit
estyp ESTYP_EB End. Bal. Type
esvoz ESVOZ_EB Closing Bal +/-
esbtr ESBTR_EB Ending Bal. Amt
esdmb ESDMB_EB Local Crcy Amt
blauf BLAUF_EB Life Start
elauf ELAUF_EB Life End
hzins HZINS_EB Credit Interest
teiln TEILN_EB C/V EB Number
bktoa BKTOA_EB Bank acct type
anzes ANZES_EB No. of Memo Rec
vgtyp VGTYP_EB Trans. Type
efart EFART_EB Input Type
hbkid HBKID House Bank
hktid HKTID Account ID
euser EUSER_EB EB User
edate EDATE_EB Import Date
etime ETIME_EB Import Time
bkref BKREF Reference
xfdis XFDIS_EB CM Payt Advice
dsart DSART Memo Recd Type
xverd FFDISXVERD Summarization
xbenr AWKEY Reference Key
xbtyp AWTYP Ref. procedure
seq_number SEQ_NUMBER Sequential No.
seq_status SEQ_STATUS Sequence Status
input_format INPUT_FORMAT Input Format
siban SIBAN_EB Sender IBAN
azpgno AZPGNO_EB PageNo.:5Digits
filehash FILEHASH_EB SHA1 on File
closing_available_balance FEB_CLOSING_AVAILABLE_BALANCE Clsg Avail Balance
dummy_febko DUMMY Dummy function in length 1
bsimp_psetid FAR_BSIMP_PSETID Parameter Set ID
supfincor SUPFINCOR Posting Category
cashupd CASHUPD CashPosUpdInd
cashupdok CASHUPDOK CashPUpdStat
file_format FEBFORMAT Electronic Bank Statement Format
file_format_mapping FEBFORMAT_LONG Format
azdattim FAR_BS_TIMESTAMP_ON Bank Statement On

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Electronic Bank Statement Header Records
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FEBKO (
    MANDT,                      -- Client [MANDT]
    ANWND,                      -- Application [ANWND_EBKO]
    ABSND,                      -- Sending Bank [ABSND_EB]
    AZIDT,                      -- Statement ID [AZIDT_EB]
    EMKEY,                      -- Recipient Key [EMKEY_EB]
    KUKEY,                      -- Short Key [KUKEY_EB]
    ASTAT,                      -- Stmt Status [ASTAT_EB]
    DSTAT,                      -- Print Status [DSTAT_EB]
    VB1OK,                      -- Post Area 1 OK [VB1OK_EBKO]
    VB2OK,                      -- Area 2 OK [VB2OK_EBKO]
    KIPRE,                      -- Interpreted [KIPRE_EB]
    VFDAT,                      -- Expiration Date [VFDAT_EB]
    GRP01,                      -- Bank Session [GRP01_EB]
    XKEP1,                      -- Keep_session_1 [XKEP1_EB]
    GRP02,                      -- Subldgr Session [GRP02_EB]
    XKEP2,                      -- Keep_session_2 [XKEP2_EB]
    WVDAT,                      -- Processing Date [WVDAT_EB]
    WVTIM,                      -- Processing Time [WVTIM_EB]
    WVART,                      -- Processing Type [WVART_EB]
    HKONT,                      -- G/L Acct [HKONT]
    KTONR,                      -- Bank Account [BANKN]
    KTOIH,                      -- Account Holder [KTOIH_EB]
    KTOSB,                      -- Spec Acct Name [KTOSB_EB]
    AZNUM,                      -- Bank Statement No. [AZNUM_LG_EB]
    AZSNR,                      -- Page Number [AZSNR_EB]
    AZDAT,                      -- Statement Date [AZDAT_EB]
    BUKRS,                      -- Company Code [BUKRS]
    KTOPL,                      -- Chart of Accts [KTOPL]
    WAERS,                      -- Currency [WAERS]
    SSTYP,                      -- Open. Bal. Type [SSTYP_EB]
    SSVOZ,                      -- Start. Bal +/- [SSVOZ_EB]
    SSBTR,                      -- Opening Balance [SSBTR_EB]
    SUMSO,                      -- Total Debit [SUMSO_EB]
    SUMHA,                      -- Total Credit [SUMHA_EB]
    ESTYP,                      -- End. Bal. Type [ESTYP_EB]
    ESVOZ,                      -- Closing Bal +/- [ESVOZ_EB]
    ESBTR,                      -- Ending Bal. Amt [ESBTR_EB]
    ESDMB,                      -- Local Crcy Amt [ESDMB_EB]
    BLAUF,                      -- Life Start [BLAUF_EB]
    ELAUF,                      -- Life End [ELAUF_EB]
    HZINS,                      -- Credit Interest [HZINS_EB]
    TEILN,                      -- C/V EB Number [TEILN_EB]
    BKTOA,                      -- Bank acct type [BKTOA_EB]
    ANZES,                      -- No. of Memo Rec [ANZES_EB]
    VGTYP,                      -- Trans. Type [VGTYP_EB]
    EFART,                      -- Input Type [EFART_EB]
    HBKID,                      -- House Bank [HBKID]
    HKTID,                      -- Account ID [HKTID]
    EUSER,                      -- EB User [EUSER_EB]
    EDATE,                      -- Import Date [EDATE_EB]
    ETIME,                      -- Import Time [ETIME_EB]
    BKREF,                      -- Reference [BKREF]
    XFDIS,                      -- CM Payt Advice [XFDIS_EB]
    DSART,                      -- Memo Recd Type [DSART]
    XVERD,                      -- Summarization [FFDISXVERD]
    XBENR,                      -- Reference Key [AWKEY]
    XBTYP,                      -- Ref. procedure [AWTYP]
    SEQ_NUMBER,                 -- Sequential No. [SEQ_NUMBER]
    SEQ_STATUS,                 -- Sequence Status [SEQ_STATUS]
    INPUT_FORMAT,               -- Input Format [INPUT_FORMAT]
    SIBAN,                      -- Sender IBAN [SIBAN_EB]
    AZPGNO,                     -- PageNo.:5Digits [AZPGNO_EB]
    FILEHASH,                   -- SHA1 on File [FILEHASH_EB]
    CLOSING_AVAILABLE_BALANCE,  -- Clsg Avail Balance [FEB_CLOSING_AVAILABLE_BALANCE]
    DUMMY_FEBKO,                -- Dummy function in length 1 [DUMMY]
    BSIMP_PSETID,               -- Parameter Set ID [FAR_BSIMP_PSETID]
    SUPFINCOR,                  -- Posting Category [SUPFINCOR]
    CASHUPD,                    -- CashPosUpdInd [CASHUPD]
    CASHUPDOK,                  -- CashPUpdStat [CASHUPDOK]
    FILE_FORMAT,                -- Electronic Bank Statement Format [FEBFORMAT]
    FILE_FORMAT_MAPPING,        -- Format [FEBFORMAT_LONG]
    AZDATTIM,                   -- Bank Statement On [FAR_BS_TIMESTAMP_ON]
    PRIMARY KEY (MANDT, ANWND, ABSND, AZIDT, EMKEY)
);

Learn More