FEBKO

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.

-- Kopfsätze des Elektronischen Kontoauszugs
-- 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]
    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]
    BANKSTATEMENTIMPORTMESSAGEID,    -- Bank Message ID [far_mbc_msg_id]
    BANKSTATEMENTIMPORTMESSAGEUUID,  -- Bank Message UUID [far_mbc_guid]
    PRIMARY KEY (MANDT, ANWND, ABSND, AZIDT, EMKEY)
);