I_BANKCASHBALANCEHISTORY

CDS View
18 Fields 6 CDS Views

Bank Cash Balance History

I_BANKCASHBALANCEHISTORY is a CDS View in S/4HANA. Bank Cash Balance History. It contains 18 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_BankAccountBalanceSituation view_entity from CONSUMPTION Situation for Bank Account Balance
I_ShrtTrmCshPosLatestBalance view_entity inner COMPOSITE Latest Balance of Bank Account
P_BANKCASHBALANCEHISTORY view from COMPOSITE Bank Cash Balance History
P_BkCshBalByCshBalDte view_entity inner TRANSACTIONAL Balance By Cash Balance Date
P_ShrtTrmCshPosBankAccHasBal view from COMPOSITE
P_ShrtTrmCshPosLatestBalTS view_entity inner COMPOSITE

Fields (18)

KeyField CDS FieldsUsed in Views
KEY BankAccountInternalID BankAccountInternalID 3
KEY BankStatementShortID BankStatementShortID 3
KEY CashBalanceDate CashBalanceDate 3
KEY CashBalanceKey CashBalanceKey 2
KEY CashBalanceType CashBalanceType 3
_BalanceChannelText _BalanceChannelText 1
_BalanceTypeText _BalanceTypeText 1
_User _User 1
BankStatement BankStatement 2
BankStatementDate BankStatementDate 1
CashBalanceAmount CashBalanceAmount,CashClosingValDteBalanceAmount 4
CashBalanceChannel CashBalanceChannel 3
CashBalanceCreatedAtDateTime CashBalanceCreatedAtDateTime 1
CashBalanceCurrency CashBalanceCurrency 3
CashClosingAvailBalanceSource CashClosingAvailBalanceSource 1
CompanyCode CompanyCode 3
CreatedByUser CreatedByUser 2
OriginDocument OriginDocument 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.

-- Bank Cash Balance History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BANKCASHBALANCEHISTORY (
    BANKACCOUNTINTERNALID,
    BANKSTATEMENTSHORTID,
    CASHBALANCEDATE,
    CASHBALANCEKEY,
    CASHBALANCETYPE,
    _BALANCECHANNELTEXT,
    _BALANCETYPETEXT,
    _USER,
    BANKSTATEMENT,
    BANKSTATEMENTDATE,
    CASHBALANCEAMOUNT,
    CASHBALANCECHANNEL,
    CASHBALANCECREATEDATDATETIME,
    CASHBALANCECURRENCY,
    CASHCLOSINGAVAILBALANCESOURCE,
    COMPANYCODE,
    CREATEDBYUSER,
    ORIGINDOCUMENT,
    PRIMARY KEY (BANKACCOUNTINTERNALID, BANKSTATEMENTSHORTID, CASHBALANCEDATE, CASHBALANCEKEY, CASHBALANCETYPE)
);

Learn More