P_BANKCASHBALANCEHISTORY

DDL: P_BANKCASHBALANCEHISTORY SQL: PBACCBALHIS Type: view COMPOSITE
20 Fields 1 Data Sources 2 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 20 fields with key fields BankAccountInternalID, CashBalanceDate, CashBalanceKey. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BankCashBalanceHistory _Balance from

Associations (2)

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

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 (20)

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
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
CashBalanceChannelText I_BankCashBalanceHistory CashBalanceChannelText
CashBalanceType I_BankCashBalanceHistory CashBalanceType Balance Type
CashBalanceTypeText I_BankCashBalanceHistory CashBalanceTypeText
CreatedByUser I_BankCashBalanceHistory CreatedByUser User Name
CreatedByUserName I_BankCashBalanceHistory CreatedByUserName Person Resp.
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

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,
  _Balance.CashBalanceAmount AS CashBalanceAmount,
  _Balance.CashBalanceCurrency AS CashBalanceCurrency,
  _Balance.CashBalanceAmount AS CashClosingValDteBalanceAmount,
  _LedgerBalance.CashBalanceAmount AS CashClosingLedgerBalanceAmount,
  _Balance.CashBalanceChannel AS CashBalanceChannel,
  _Balance.CashBalanceChannelText AS CashBalanceChannelText,
  _Balance.CashBalanceType AS CashBalanceType,
  _Balance.CashBalanceTypeText AS CashBalanceTypeText,
  _Balance.CreatedByUser AS CreatedByUser,
  _Balance.CreatedByUserName AS CreatedByUserName,
  _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..*]
;

Learn More