I_BANKCASHBALANCEHISTORY

CDS View
19 Fields 6 CDS Views

Bank Cash Balance History

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

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_ShrtTrmCshPosLatestBalance view 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_ShrtTrmCshPosLatestBalDate view_entity from COMPOSITE
P_ShrtTrmCshPosLatestBalTS view_entity inner COMPOSITE

Fields (19)

KeyField CDS FieldsUsed in Views
KEY BankAccountInternalID BankAccountInternalID 2
KEY BankStatementShortID BankStatementShortID 3
KEY CashBalanceDate CashBalanceDate 2
KEY CashBalanceKey CashBalanceKey 1
KEY CashBalanceType CashBalanceType 2
_BalanceChannelText _BalanceChannelText 1
_BalanceTypeText _BalanceTypeText 1
_User _User 1
BankStatement BankStatement 2
CashBalanceAmount CashBalanceAmount,CashClosingValDteBalanceAmount 3
CashBalanceChannel CashBalanceChannel 2
CashBalanceChannelText CashBalanceChannelText 1
CashBalanceCreatedAtDateTime CashBalanceCreatedAtDateTime 1
CashBalanceCurrency CashBalanceCurrency 2
CashBalanceTypeText CashBalanceTypeText 1
CompanyCode CompanyCode 2
CreatedByUser CreatedByUser 2
CreatedByUserName CreatedByUserName 1
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,
    CASHBALANCEAMOUNT,
    CASHBALANCECHANNEL,
    CASHBALANCECHANNELTEXT,
    CASHBALANCECREATEDATDATETIME,
    CASHBALANCECURRENCY,
    CASHBALANCETYPETEXT,
    COMPANYCODE,
    CREATEDBYUSER,
    CREATEDBYUSERNAME,
    ORIGINDOCUMENT,
    PRIMARY KEY (BANKACCOUNTINTERNALID, BANKSTATEMENTSHORTID, CASHBALANCEDATE, CASHBALANCEKEY, CASHBALANCETYPE)
);

Learn More