FEBKO_DRAFT

Bank Statement Root (draft) | #fiori | Component: Fiori UI for Accounts Receivable
Column Name Description
MANDT Client
BANKSTATEMENTDRAFTUUID Draft (Technical ID)
Column Name Description
💲 Currency Key (CURRENCY):
CLOSINGBALANCEAMTINTRANSCRCY Closing Balance Amount
OPENINGBALANCEAMTINTRANSCRCY Opening Balance Amount
TOTALCREDITAMOUNTINTRANSCRCY Total Credit
TOTALDEBITAMOUNTINTRANSCRCY Total Debit
Column Name Description
Column Name Description
BANKSTATEMENTDATE Bank Statement Date
BANKSTATEMENTIMPORTDATE Bank Statement Import Date into System
BANKSTATEMENTIMPORTTIME Bank Statement Import Time into System
POSTINGDATE Posting Date in the Document
Column Name Description
ISACTIVEENTITY Draft - Indicator - Is active document Show values
HASACTIVEENTITY Draft - Indicator - Has active document Show values
HASDRAFTENTITY Draft - Indicator - Has draft document Show values
BANKDATASTORAGEAPPLICATION Application Using Bank Data Storage Show values
BANKLEDGERISPOSTED Indicator that posting Area 1 was posted or not Show values
BANKSTATEMENTISMANUALLYCREATED Has the bank statement being manually created? Show values
BANKSTATEMENTSTATUS Bank Statement Status Code Show values
CLOSINGBALANCEISINTERIM Indicator that the Closing Balance is interim Show values
OPENINGBALANCEISINTERIM Indicator that the Opening Balance is interim Show values
SUBLEDGERISPOSTEDSUCCESSFULLY Indicator that posting Area 2 was posted or not Show values
Column Name Description Domain name
ISLATESTBANKSTATEMENT Single-Character Flag CHAR1
BANKACCOUNT Bank Account Number BANKN
BANKACCOUNTADDITIONALNAME Additional House Bank Account Name CHAR35
BANKACCOUNTHOLDERNAME Bank Account Holder CHAR35
BANKACCOUNTREFERENCETEXT Reference Specifications for Bank Details CHAR20
BANKACCOUNTTYPE Bank Account Type CHAR23
BANKCOUNTRY Country/Region Key of Bank LAND1
BANKINTERNALID Bank Number BANKL
BANKNAME Name of House Bank TEXT60
BANKSTATEMENT Bank Statement Number FARP_AZNUM
BANKSTATEMENTFORMAT Bank Statement Format INPUT_FORMAT
BANKSTATEMENTINTERNALID Bank Statement Identification CHAR20
BANKSTATEMENTISINTERPRETED All bank statement items have been interpreted. CHAR1
BANKSTATEMENTNUMBEROFITEMS Line Item Number FARP_ESNUM
BANKSTATEMENTPAGENUMBER Bank Statement Page Number FARP_AZSNR
BANKSTATEMENTSHORTID Bank Statement Short Key FARP_KUKEY
CHARTOFACCOUNTS Chart of Accounts KTOPL
COMPANYCODE Company Code BUKRS
CREATEDBYUSER User who uploaded the file into the System CHAR12
GLACCOUNT General Ledger Account SAKNR
BANKACCOUNTINTERNALID Bank Account Technical ID NUM10
BANKACCOUNTUUID Character field, length 32 CHAR32
HOUSEBANK House Bank Key HBKID
HOUSEBANKACCOUNT House Bank Account HKTID
IBAN Bank Account IBAN IBAN
INTERESTRATEINPERCENT Credit Interest Rate HZINS_EB
PAYMENTTRANSACTIONTYPEGROUP Payment Transaction Type Group VGTYP_EB
BANKSTATEMENTRECIPIENTREFID Payee Keys CHAR20
SENDINGBANK Sending Bank (Electronic Bank Statement) CHAR50
DUMMY_FEBKODRAFT Dummy function in length 1 DUMMY
Master Data Relations Join Conditions
Currency Key
  • FEBKO_DRAFT.MANDT == TCURC.MANDT
  • FEBKO_DRAFT.CURRENCY == TCURC.WAERS