P_BANKCASHBALANCEHISTORY

DDL: P_BANKCASHBALANCEHISTORY SQL: PBACCBALHIS Type: view COMPOSITE
21 Fields 1 Data Sources 3 Associations

Bank Cash Balance History

P_BANKCASHBALANCEHISTORY is a Composite CDS View that provides data about "Bank Cash Balance History" in SAP S/4HANA. It reads from 1 data source (I_BankCashBalanceHistory) and exposes 21 fields with key fields BankAccountInternalID, CashBalanceDate, CashBalanceKey. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BankCashBalanceHistory _Balance from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_BankAccount _BankAccount $projection.BankAccountInternalID = _BankAccount.BankAccountInternalID
[0..*] I_BankAccountText _BankAccountText $projection.BankAccountInternalID = _BankAccountText.BankAccountInternalID
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PBACCBALHIS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Bank Cash Balance History view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID I_BankCashBalanceHistory BankAccountInternalID Technical ID
KEY CashBalanceDate I_BankCashBalanceHistory CashBalanceDate Value Date
KEY CashBalanceKey I_BankCashBalanceHistory CashBalanceKey UUID
CompanyCode I_BankCashBalanceHistory CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
CashBalanceAmount I_BankCashBalanceHistory CashBalanceAmount Billing Amount
CashBalanceCurrency I_BankCashBalanceHistory CashBalanceCurrency Currency
CashClosingValDteBalanceAmount I_BankCashBalanceHistory CashBalanceAmount Billing Amount
CashClosingLedgerBalanceAmount _LedgerBalance CashBalanceAmount Billing Amount
CashBalanceChannel I_BankCashBalanceHistory CashBalanceChannel Update Method
CashBalanceType I_BankCashBalanceHistory CashBalanceType Balance Type
CreatedByUser I_BankCashBalanceHistory CreatedByUser User Name
CashBalanceCreatedAtDateTime I_BankCashBalanceHistory CashBalanceCreatedAtDateTime Time Stamp
OriginDocument I_BankCashBalanceHistory OriginDocument Source Doc. ID
BankStatementShortID I_BankCashBalanceHistory BankStatementShortID Statement Short Key
BankStatement I_BankCashBalanceHistory BankStatement Bank Statement No.
BankAccountNumber _BankAccount BankAccountNumber Bank Account
BankAccountDescription
_User _User
_BalanceChannelText _BalanceChannelText
_BalanceTypeText _BalanceTypeText

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_BANKCASHBALANCEHISTORY.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PBACCBALHIS

CREATE VIEW P_BANKCASHBALANCEHISTORY AS
SELECT
  _Balance.BankAccountInternalID AS BankAccountInternalID,
  _Balance.CashBalanceDate AS CashBalanceDate,
  _Balance.CashBalanceKey AS CashBalanceKey,
  _Balance.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Balance.CashBalanceAmount AS CashBalanceAmount,
  _Balance.CashBalanceCurrency AS CashBalanceCurrency,
  _Balance.CashBalanceAmount AS CashClosingValDteBalanceAmount,
  _LedgerBalance.CashBalanceAmount AS CashClosingLedgerBalanceAmount,
  _Balance.CashBalanceChannel AS CashBalanceChannel,
  _Balance.CashBalanceType AS CashBalanceType,
  _Balance.CreatedByUser AS CreatedByUser,
  _Balance.CashBalanceCreatedAtDateTime AS CashBalanceCreatedAtDateTime,
  _Balance.OriginDocument AS OriginDocument,
  _Balance.BankStatementShortID AS BankStatementShortID,
  _Balance.BankStatement AS BankStatement,
  _BankAccount.BankAccountNumber AS BankAccountNumber,
  _BankAccountText[1:Language=$session.system_language].BankAccountDescription AS BankAccountDescription
FROM I_BankCashBalanceHistory AS _Balance
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON BankAccountInternalID = _BankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAccountText AS _BankAccountText ON BankAccountInternalID = _BankAccountText.BankAccountInternalID  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;

Learn More