FEBEP

Transparent Table Application Table
141 Fields 24 CDS Views

Electronic Bank Statement Line Items

FEBEP is an SAP database table in S/4HANA. Electronic Bank Statement Line Items. It contains 141 fields. 24 CDS views read from this table.

CDS Views using this table (24)

ViewTypeJoinVDMDescription
E_ARBankStatementItem view from
farvd_bs_it_02 view_entity from Bank Statement Items
FARVD_POSAR_RECALCULATION view from Posar calculation via data fields
Febvd_Bs_Status_01 view from determine posting status fields from FEBEP
Febvd_Bs_Status_01 view union determine posting status fields from FEBEP
I_BankStatementItemBasic view_entity from BASIC Bk Stmnt Item
I_PL_SAFTBalanceTotalAmount view from COMPOSITE SAFT PL Calculate value to exclude
I_SAFTBankStatementItem view from BASIC SAF-T Bank Statement Item
I_SK_BankStatementItem view_entity from BASIC Bank Statement Item
P_Arbankstatementpostingdate view from BASIC
P_Arbanktransactiondocitem_06 view from COMPOSITE
P_ARBSITMBANKSTMT01 view from BASIC
P_ARBSITMPAYDOC view from BASIC
P_ARBSITMPAYDOC view union_all BASIC
P_Arlockboxbatchitemaggr view from BASIC
P_BankStatementDetail view inner BASIC
P_CN_BKRECNCLN_V02 view inner CONSUMPTION
P_CN_CADEIncgChk view from BASIC
P_CN_CADEINCOMINGCHECK view from BASIC
P_FEBEP view from BASIC
P_Fqmbankstatement view from BASIC
P_HIST_ARBANKTRANSACTIONITEM view from BASIC
R_ARLockboxBatchItmReferenceTP view_entity inner TRANSACTIONAL Lockbox Payment Advice Item
VFCP_DDL_BS view from

Fields (141)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kukey KUKEY_EB Short Key
KEY esnum ESNUM_EB Memo Record No.
eperl EPERL_EB Line Items Cpl
vb1ok VB1OK_EB Update 1 OK
vb2ba VB2BA_EB 2nd Update Proc
vb2ok VB2OK_EB 2nd Update OK
pipre PIPRE_EB Interpreted
grpnr GRPNR_EB Bundle Number
estat ESTAT_EB Error Status
belnr BELNR_D Document Number
gjahr GJAHR Fiscal Year
bvdat BVDAT_EB Bank Pstng Date
budat BUDAT_EB Posting Date
valut VALUT_EB Value Date
butim BUTIM_EB Value Date Time
vozei VOZEI_EB +/- Sign
kwaer KWAER_EB Acct Currency
kwbtr KWBTR_EB Amount
spesk SPESK_EB AC Fees
fwaer FWAER_EB ForeignCurrency
fwbtr FWBTR_EB For. Crcy Amt
spesf SPESF_EB FC Fees
vorgc VORGC_EB Bus Trans Code
texts TEXTS_EB Text Key
vgext VGEXT_EB External Trans
vgman VGMAN_EB Transaction
vgint VGINT_EB Posting Rule
vgdef VGDEF_EB Posting Rule Std
kfmod KFMOD_EB Account Modif.
vgsap VGSAP_EB SAP Bank Trans
butxt BUTXT_EB Posting Text
anzsp ANZSP_EB Coll. Items
xblnr XBLNR1 Reference
zuonr DZUONR Assignment
pabks PABKS_EB Part. Ctry/Rgn
pablz PABLZ_EB Bank Number
paswi PASWI_EB Partner SWIFT
pakto PAKTO_EB Part. Bank Acct
partn PARTN_EB BusPartner
busab BUSAB_EB Acctg Clerk
kostl KOSTL_EB Cost Center
gsber GSBER_EB Business Area
prctr PRCTR Profit Center
vertn RANL Contract Number
vertt RANTYP Contract Type
pnota PNOTA_EB Daybook No.
chect CHECT Check number
stavv STAVV_EB FMA Status
txtvv TXTVV_EB FAM Info
epvoz EPVOZ_EB Deb./Credit Key
info1 INFO1_EB Addit.Info 1
info2 INFO2_EB Addit.Info.2
avsid AVSID Payt Advice No.
intag INTAG_EB Inter.Algorithm
nbbln NBBLN_EB Subl.Doc.No.
ak1bl AKBLN_EB Pyt o.Ac.Doc.No
akbln AKBLN_EB Pyt o.Ac.Doc.No
knrza KNRZA Alternat. Payer
avkoa KOART_AV Account Type
avkon KTONR_AV Account
batch BATCH_EB Batch Number
itmnr ITMNR_FLB Batch Item Number for Lockbox
kursf KURSF_EB Exchange Rate
sgtxt SGTXT Text
jpdat JPDAT_EB Date in Japan
posag POSAG_EB Posting Algthm
sdoc2 SDOC2_EB Subl.Doc.No.
vgref REFBK Bank Reference
xbenr AWKEY Reference Key
xbtyp AWTYP Ref. procedure
arrsk ARRSK_EB Ovrdue Chg AC
pform PFORM_EB Process type
kidno KIDNO Payment Ref.
kkref REFNR_EB Cust.-Cust.Ref.
kkrf2 REFNR_EB Cust.-Cust.Ref.
mansp MANSP Dunn. Block
fnam1 BDC_FNAM BDC FN
fval1 BDC_FVAL BDC FV
fkoa1 KOART_BDC BDC-Acc.Type
fnam2 BDC_FNAM BDC FN
fval2 BDC_FVAL BDC FV
fkoa2 KOART_BDC BDC-Acc.Type
fnam3 BDC_FNAM BDC FN
fval3 BDC_FVAL BDC FV
fkoa3 KOART_BDC BDC-Acc.Type
idenr IDENR ID number
b1app APPLK_BF Application ID
b1err ESTAT_EB Error Status
b1std ADDST_EB No Std Posting
b1doc DOC_NUMBER Doc.no.
b1typ AWTYP Ref. procedure
b2app APPLK_BF Application ID
b2err ESTAT_EB Error Status
b2std ADDST_EB No Std Posting
b2doc DOC_NUMBER Doc.no.
b2typ AWTYP Ref. procedure
piban PIBAN_EB Partner IBAN
n2pch FEB_N2PCHGIND NotetoPayee Chng
svbuk BUKRS Company Code
svkoa KOART_AV Account Type
svkon KTONR_AV Account
svavs AVSID Payt Advice No.
repro REPRO_EB Process Enh.
trnid EB_TRANSID Transaction ID
accdoc_tmp_doc_id FDC_ACCDOC_TMP_DOC_ID Temp. Document ID
chect_orig CHECT Check number
chect_type CHECT_TYPE Type of document which is mentioned in CHECT
ml_status FEB_ML_STATUS Machine Lrn. Status
pr_status FEB_PR_STATUS Posting Rule Status
ak1bl_gjahr AK1BL_GJAHR FY Doc PstgOnAcct BB
akbln_gjahr AKBLN_GJAHR FY Doc on A/c DocNo.
belnr_gjahr BELNR_GJAHR FY Bk Ldgr Acctg Doc
nbbln_gjahr NBBLN_GJAHR FY SL Accounting Doc
sdoc2_gjahr SDOC2_GJAHR FYr2S/LAcctDoc
postingruleuuid FAR_PSTRL_NODE_KEY Rule Key
dummy_febep DUMMY Dummy function in length 1
bp_id_category BU_ID_CATEGORY ID Categ.
bp_id_number BU_ID_NUMBER ID Number
additional_info ADDITIONAL_INFO_EB Add. info.
keypp KEYPP_EB Subarea
ml_status_accdet FEB_ML_STATUS_AD Machn Lrn Status Acc
part_appl_status FEB_PART_APPL_STATUS Partial Appl. Status
advcassignmentrepetitionstatus FEB_ADV_ASSIGNMENT_REP_STATUS Advc. Assgmt RptnSts
repetitionstartdate REPETITIONSTARTDATE Start of Rptn. Date
repetitionenddate REPETITIONENDDATE End of Rptn. Date
repetitionjoblastrundatetime REPETITIONJOBLASTRUNDATETIME Assig. Job Last Run
semobjbyprocessingapplication FAR_BS_ITM_SEM_OBJ_PROC_APP Sem. Obj. App.
refbyprocessingapplication FAR_BS_ITM_REF_BY_PROC_APP Ref. Proc. App.
bankstmntprocessingapplication FAR_BS_ITM_PROCESSING_APP Proc. App.
accountservicerreference FEB_ACCT_SERVICER_REF Account Servicer Reference
processed_kukey FARP_KUKEY_PROCESSED Processed Statement Short Key
processed_esnum FARP_ESNUM_PROCESSED Processed Line Item Number
bank_status_code FAR_BS_ITEM_BANK_STATUS_CODE Bank Status Code
bankstmntitmprocessingcategory FAR_BS_ITEM_PROCESSING_CAT Processing Category
tatyp FEB_BSPROC_TATYP Transaction
x_fwbtr_chg FEB_X_FWBTR_CHG Status of Changes Regarding Foreign Currency
curr_rate FEB_CURR_RATE Exchange Rate
reprocreasoncode FEB_REPRO_REASON_CODE Reproc. Reason Code
xref1 XREF1 Reference Key 1
fipex FM_FIPEX Commitment Item

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 Line Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FEBEP (
    MANDT,                           -- Client [MANDT]
    KUKEY,                           -- Short Key [KUKEY_EB]
    ESNUM,                           -- Memo Record No. [ESNUM_EB]
    EPERL,                           -- Line Items Cpl [EPERL_EB]
    VB1OK,                           -- Update 1 OK [VB1OK_EB]
    VB2BA,                           -- 2nd Update Proc [VB2BA_EB]
    VB2OK,                           -- 2nd Update OK [VB2OK_EB]
    PIPRE,                           -- Interpreted [PIPRE_EB]
    GRPNR,                           -- Bundle Number [GRPNR_EB]
    ESTAT,                           -- Error Status [ESTAT_EB]
    BELNR,                           -- Document Number [BELNR_D]
    GJAHR,                           -- Fiscal Year [GJAHR]
    BVDAT,                           -- Bank Pstng Date [BVDAT_EB]
    BUDAT,                           -- Posting Date [BUDAT_EB]
    VALUT,                           -- Value Date [VALUT_EB]
    BUTIM,                           -- Value Date Time [BUTIM_EB]
    VOZEI,                           -- +/- Sign [VOZEI_EB]
    KWAER,                           -- Acct Currency [KWAER_EB]
    KWBTR,                           -- Amount [KWBTR_EB]
    SPESK,                           -- AC Fees [SPESK_EB]
    FWAER,                           -- ForeignCurrency [FWAER_EB]
    FWBTR,                           -- For. Crcy Amt [FWBTR_EB]
    SPESF,                           -- FC Fees [SPESF_EB]
    VORGC,                           -- Bus Trans Code [VORGC_EB]
    TEXTS,                           -- Text Key [TEXTS_EB]
    VGEXT,                           -- External Trans [VGEXT_EB]
    VGMAN,                           -- Transaction [VGMAN_EB]
    VGINT,                           -- Posting Rule [VGINT_EB]
    VGDEF,                           -- Posting Rule Std [VGDEF_EB]
    KFMOD,                           -- Account Modif. [KFMOD_EB]
    VGSAP,                           -- SAP Bank Trans [VGSAP_EB]
    BUTXT,                           -- Posting Text [BUTXT_EB]
    ANZSP,                           -- Coll. Items [ANZSP_EB]
    XBLNR,                           -- Reference [XBLNR1]
    ZUONR,                           -- Assignment [DZUONR]
    PABKS,                           -- Part. Ctry/Rgn [PABKS_EB]
    PABLZ,                           -- Bank Number [PABLZ_EB]
    PASWI,                           -- Partner SWIFT [PASWI_EB]
    PAKTO,                           -- Part. Bank Acct [PAKTO_EB]
    PARTN,                           -- BusPartner [PARTN_EB]
    BUSAB,                           -- Acctg Clerk [BUSAB_EB]
    KOSTL,                           -- Cost Center [KOSTL_EB]
    GSBER,                           -- Business Area [GSBER_EB]
    PRCTR,                           -- Profit Center [PRCTR]
    VERTN,                           -- Contract Number [RANL]
    VERTT,                           -- Contract Type [RANTYP]
    PNOTA,                           -- Daybook No. [PNOTA_EB]
    CHECT,                           -- Check number [CHECT]
    STAVV,                           -- FMA Status [STAVV_EB]
    TXTVV,                           -- FAM Info [TXTVV_EB]
    EPVOZ,                           -- Deb./Credit Key [EPVOZ_EB]
    INFO1,                           -- Addit.Info 1 [INFO1_EB]
    INFO2,                           -- Addit.Info.2 [INFO2_EB]
    AVSID,                           -- Payt Advice No. [AVSID]
    INTAG,                           -- Inter.Algorithm [INTAG_EB]
    NBBLN,                           -- Subl.Doc.No. [NBBLN_EB]
    AK1BL,                           -- Pyt o.Ac.Doc.No [AKBLN_EB]
    AKBLN,                           -- Pyt o.Ac.Doc.No [AKBLN_EB]
    KNRZA,                           -- Alternat. Payer [KNRZA]
    AVKOA,                           -- Account Type [KOART_AV]
    AVKON,                           -- Account [KTONR_AV]
    BATCH,                           -- Batch Number [BATCH_EB]
    ITMNR,                           -- Batch Item Number for Lockbox [ITMNR_FLB]
    KURSF,                           -- Exchange Rate [KURSF_EB]
    SGTXT,                           -- Text [SGTXT]
    JPDAT,                           -- Date in Japan [JPDAT_EB]
    POSAG,                           -- Posting Algthm [POSAG_EB]
    SDOC2,                           -- Subl.Doc.No. [SDOC2_EB]
    VGREF,                           -- Bank Reference [REFBK]
    XBENR,                           -- Reference Key [AWKEY]
    XBTYP,                           -- Ref. procedure [AWTYP]
    ARRSK,                           -- Ovrdue Chg AC [ARRSK_EB]
    PFORM,                           -- Process type [PFORM_EB]
    KIDNO,                           -- Payment Ref. [KIDNO]
    KKREF,                           -- Cust.-Cust.Ref. [REFNR_EB]
    KKRF2,                           -- Cust.-Cust.Ref. [REFNR_EB]
    MANSP,                           -- Dunn. Block [MANSP]
    FNAM1,                           -- BDC FN [BDC_FNAM]
    FVAL1,                           -- BDC FV [BDC_FVAL]
    FKOA1,                           -- BDC-Acc.Type [KOART_BDC]
    FNAM2,                           -- BDC FN [BDC_FNAM]
    FVAL2,                           -- BDC FV [BDC_FVAL]
    FKOA2,                           -- BDC-Acc.Type [KOART_BDC]
    FNAM3,                           -- BDC FN [BDC_FNAM]
    FVAL3,                           -- BDC FV [BDC_FVAL]
    FKOA3,                           -- BDC-Acc.Type [KOART_BDC]
    IDENR,                           -- ID number [IDENR]
    B1APP,                           -- Application ID [APPLK_BF]
    B1ERR,                           -- Error Status [ESTAT_EB]
    B1STD,                           -- No Std Posting [ADDST_EB]
    B1DOC,                           -- Doc.no. [DOC_NUMBER]
    B1TYP,                           -- Ref. procedure [AWTYP]
    B2APP,                           -- Application ID [APPLK_BF]
    B2ERR,                           -- Error Status [ESTAT_EB]
    B2STD,                           -- No Std Posting [ADDST_EB]
    B2DOC,                           -- Doc.no. [DOC_NUMBER]
    B2TYP,                           -- Ref. procedure [AWTYP]
    PIBAN,                           -- Partner IBAN [PIBAN_EB]
    N2PCH,                           -- NotetoPayee Chng [FEB_N2PCHGIND]
    SVBUK,                           -- Company Code [BUKRS]
    SVKOA,                           -- Account Type [KOART_AV]
    SVKON,                           -- Account [KTONR_AV]
    SVAVS,                           -- Payt Advice No. [AVSID]
    REPRO,                           -- Process Enh. [REPRO_EB]
    TRNID,                           -- Transaction ID [EB_TRANSID]
    ACCDOC_TMP_DOC_ID,               -- Temp. Document ID [FDC_ACCDOC_TMP_DOC_ID]
    CHECT_ORIG,                      -- Check number [CHECT]
    CHECT_TYPE,                      -- Type of document which is mentioned in CHECT [CHECT_TYPE]
    ML_STATUS,                       -- Machine Lrn. Status [FEB_ML_STATUS]
    PR_STATUS,                       -- Posting Rule Status [FEB_PR_STATUS]
    AK1BL_GJAHR,                     -- FY Doc PstgOnAcct BB [AK1BL_GJAHR]
    AKBLN_GJAHR,                     -- FY Doc on A/c DocNo. [AKBLN_GJAHR]
    BELNR_GJAHR,                     -- FY Bk Ldgr Acctg Doc [BELNR_GJAHR]
    NBBLN_GJAHR,                     -- FY SL Accounting Doc [NBBLN_GJAHR]
    SDOC2_GJAHR,                     -- FYr2S/LAcctDoc [SDOC2_GJAHR]
    POSTINGRULEUUID,                 -- Rule Key [FAR_PSTRL_NODE_KEY]
    DUMMY_FEBEP,                     -- Dummy function in length 1 [DUMMY]
    BP_ID_CATEGORY,                  -- ID Categ. [BU_ID_CATEGORY]
    BP_ID_NUMBER,                    -- ID Number [BU_ID_NUMBER]
    ADDITIONAL_INFO,                 -- Add. info. [ADDITIONAL_INFO_EB]
    KEYPP,                           -- Subarea [KEYPP_EB]
    ML_STATUS_ACCDET,                -- Machn Lrn Status Acc [FEB_ML_STATUS_AD]
    PART_APPL_STATUS,                -- Partial Appl. Status [FEB_PART_APPL_STATUS]
    ADVCASSIGNMENTREPETITIONSTATUS,  -- Advc. Assgmt RptnSts [FEB_ADV_ASSIGNMENT_REP_STATUS]
    REPETITIONSTARTDATE,             -- Start of Rptn. Date [REPETITIONSTARTDATE]
    REPETITIONENDDATE,               -- End of Rptn. Date [REPETITIONENDDATE]
    REPETITIONJOBLASTRUNDATETIME,    -- Assig. Job Last Run [REPETITIONJOBLASTRUNDATETIME]
    SEMOBJBYPROCESSINGAPPLICATION,   -- Sem. Obj. App. [FAR_BS_ITM_SEM_OBJ_PROC_APP]
    REFBYPROCESSINGAPPLICATION,      -- Ref. Proc. App. [FAR_BS_ITM_REF_BY_PROC_APP]
    BANKSTMNTPROCESSINGAPPLICATION,  -- Proc. App. [FAR_BS_ITM_PROCESSING_APP]
    ACCOUNTSERVICERREFERENCE,        -- Account Servicer Reference [FEB_ACCT_SERVICER_REF]
    PROCESSED_KUKEY,                 -- Processed Statement Short Key [FARP_KUKEY_PROCESSED]
    PROCESSED_ESNUM,                 -- Processed Line Item Number [FARP_ESNUM_PROCESSED]
    BANK_STATUS_CODE,                -- Bank Status Code [FAR_BS_ITEM_BANK_STATUS_CODE]
    BANKSTMNTITMPROCESSINGCATEGORY,  -- Processing Category [FAR_BS_ITEM_PROCESSING_CAT]
    TATYP,                           -- Transaction [FEB_BSPROC_TATYP]
    X_FWBTR_CHG,                     -- Status of Changes Regarding Foreign Currency [FEB_X_FWBTR_CHG]
    CURR_RATE,                       -- Exchange Rate [FEB_CURR_RATE]
    REPROCREASONCODE,                -- Reproc. Reason Code [FEB_REPRO_REASON_CODE]
    XREF1,                           -- Reference Key 1 [XREF1]
    FIPEX,                           -- Commitment Item [FM_FIPEX]
    PRIMARY KEY (MANDT, KUKEY, ESNUM)
);

Learn More