I_ARBANKSTATEMENT

CDS View
41 Fields 15 CDS Views

Interface view for Bank Statement Header details

I_ARBANKSTATEMENT is a CDS View in S/4HANA. Interface view for Bank Statement Header details. It contains 41 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
C_JP_MachineLrngClrdBankStmnt view from CONSUMPTION Japan Cleared Bank Statement
FARMLVD_BSITM view from Cleared Bank Statement Item
FARMLVD_BSITM_STAT_PREP view from BankStmntItem CashApp Statistic Prepare
I_ARBankStatementItemTP view left_outer COMPOSITE Bank Statement Item BO active and draft
I_ARBankStatementTP view from TRANSACTIONAL Bank Statement BO active and draft
P_Arbankstmtreprocessing01 view left_outer COMPOSITE
P_Arbsitmonacc view inner COMPOSITE
P_Arbsitmopenbs view inner COMPOSITE
P_Arbsitmopenitm view inner COMPOSITE
P_ARBSItmWithPayDoc view inner COMPOSITE
P_CN_BankStatementandItem view inner COMPOSITE
P_CN_MaxDateBankStatement view from COMPOSITE
P_CN_MaxStatement view from COMPOSITE
P_FARMLVD_BSITM_CLRTYP view from CONSUMPTION Cleared Bank Statement Type
P_IntraBkStaUTCDateTime view inner COMPOSITE

Fields (41)

KeyField CDS FieldsUsed in Views
KEY BankInternalID BankInternalID 2
KEY BankStatementDate BankStatementDate 2
KEY BankStatementShortID BankStatementShortID 4
KEY BankStatementTime BankStatementTime 1
KEY CompanyCode CompanyCode 11
KEY Currency Currency 5
KEY HouseBank HouseBank 7
KEY HouseBankAccount HouseBankAccount 6
AccountType AccountType 1
BankAccount BankAccount 2
BankAccountHolderName BankAccountHolderName 1
BankAccountInternalID BankAccountInternalID 2
BankAccountReferenceText BankAccountReferenceText 1
BankAccountType BankAccountType 1
BankCountry BankCountry 1
BankDataStorageApplication BankDataStorageApplication 3
BankLedgerIsPosted BankLedgerIsPosted 1
BankName BankName 2
BankStatement BankStatement 2
BankStatementFormat BankStatementFormat 1
BankStatementImportDate BankStatementImportDate 4
BankStatementImportTime BankStatementImportTime 4
BankStatementNumberOfItems BankStatementNumberOfItems 1
BankStatementRecipientRefID BankStatementRecipientRefID 1
BankStatementStatus BankStatementStatus 1
BankStatementStatusName BankStatementStatusName 1
ChartOfAccounts ChartOfAccounts 1
ClosingBalanceAmtInTransCrcy ClosingBalanceAmtInTransCrcy,Endbalance 2
CreatedByUser CreatedByUser 4
GLAccount GLAccount 1
IBAN IBAN 1
InterestRateInPercent InterestRateInPercent 1
InterimClsgBalAmtInTransCrcy InterimClsgBalAmtInTransCrcy 1
InterimOpenBalAmtInTransCrcy InterimOpenBalAmtInTransCrcy 1
NumberOfItems NumberOfItems 1
OpeningBalanceAmtInTransCrcy OpeningBalanceAmtInTransCrcy 1
PaymentTransactionTypeGroup PaymentTransactionTypeGroup 1
SendingBank SendingBank 2
SubledgerIsPostedSuccessfully SubledgerIsPostedSuccessfully 1
TotalCreditAmountInTransCrcy TotalCreditAmountInTransCrcy 1
TotalDebitAmountInTransCrcy TotalDebitAmountInTransCrcy 1

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.

-- Interface view for Bank Statement Header details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ARBANKSTATEMENT (
    BANKINTERNALID,
    BANKSTATEMENTDATE,
    BANKSTATEMENTSHORTID,
    BANKSTATEMENTTIME,
    COMPANYCODE,
    CURRENCY,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    ACCOUNTTYPE,
    BANKACCOUNT,
    BANKACCOUNTHOLDERNAME,
    BANKACCOUNTINTERNALID,
    BANKACCOUNTREFERENCETEXT,
    BANKACCOUNTTYPE,
    BANKCOUNTRY,
    BANKDATASTORAGEAPPLICATION,
    BANKLEDGERISPOSTED,
    BANKNAME,
    BANKSTATEMENT,
    BANKSTATEMENTFORMAT,
    BANKSTATEMENTIMPORTDATE,
    BANKSTATEMENTIMPORTTIME,
    BANKSTATEMENTNUMBEROFITEMS,
    BANKSTATEMENTRECIPIENTREFID,
    BANKSTATEMENTSTATUS,
    BANKSTATEMENTSTATUSNAME,
    CHARTOFACCOUNTS,
    CLOSINGBALANCEAMTINTRANSCRCY,
    CREATEDBYUSER,
    GLACCOUNT,
    IBAN,
    INTERESTRATEINPERCENT,
    INTERIMCLSGBALAMTINTRANSCRCY,
    INTERIMOPENBALAMTINTRANSCRCY,
    NUMBEROFITEMS,
    OPENINGBALANCEAMTINTRANSCRCY,
    PAYMENTTRANSACTIONTYPEGROUP,
    SENDINGBANK,
    SUBLEDGERISPOSTEDSUCCESSFULLY,
    TOTALCREDITAMOUNTINTRANSCRCY,
    TOTALDEBITAMOUNTINTRANSCRCY,
    PRIMARY KEY (BANKINTERNALID, BANKSTATEMENTDATE, BANKSTATEMENTSHORTID, BANKSTATEMENTTIME, COMPANYCODE, CURRENCY, HOUSEBANK, HOUSEBANKACCOUNT)
);

Learn More