C_BankCashBalancePreview

DDL: C_BANKCASHBALANCEPREVIEW SQL: CCASHBALPREVIEW Type: view CONSUMPTION
18 Fields 1 Data Sources

Preview Bank Cash Balance Before Import

C_BankCashBalancePreview is a Consumption CDS View that provides data about "Preview Bank Cash Balance Before Import" in SAP S/4HANA. It reads from 1 data source (I_BankCashBalancePreview) and exposes 18 fields with key fields RowIndex, CashBalanceCreatedByUser.

Data Sources (1)

SourceAliasJoin Type
I_BankCashBalancePreview I_BankCashBalancePreview from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CCASHBALPREVIEW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Preview Bank Cash Balance Before Import view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
UI.headerInfo.typeName Manage Bank Account Balances view
UI.headerInfo.typeNamePlural Manage Bank Account Balances view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY RowIndex RowIndex Row index
KEY CashBalanceCreatedByUser CashBalanceCreatedByUser User Name
CompanyCode CompanyCode Receiver Company Code
MnlImportedBkAcctBalFileName MnlImportedBkAcctBalFileName Uploaded File Name
BankAccountInternalID BankAccountInternalID Technical ID
CashBalanceDate CashBalanceDate Value date
IBAN IBAN IBAN House Bank
CashBalanceCreatedAtDateTime CashBalanceCreatedAtDateTime Time Stamp
CompanyCodeName _CompanyCode CompanyCodeName Company Name
CashBalanceAmount CashBalanceAmount Billing Amount
CashBalanceCurrency CashBalanceCurrency Currency
BankAccountNumber BankAccountNumber Bank Account
BankCountry BankCountry Bank Ctry/Rgn. Key
CountryName _CountryText CountryName Country
BankKey BankKey Bank Number
BankName _Bank BankName Bank Name
BankAccountCurrency BankAccountCurrency Currency
BankAccountDescription BankAccountDescription Well Code Des.

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 C_BankCashBalancePreview.
-- 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: CCASHBALPREVIEW

CREATE VIEW C_BankCashBalancePreview AS
SELECT
  RowIndex,
  CashBalanceCreatedByUser,
  CompanyCode,
  MnlImportedBkAcctBalFileName,
  BankAccountInternalID,
  CashBalanceDate,
  IBAN,
  CashBalanceCreatedAtDateTime,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  CashBalanceAmount,
  CashBalanceCurrency,
  BankAccountNumber,
  BankCountry,
  _CountryText.CountryName AS CountryName,
  BankKey,
  _Bank.BankName AS BankName,
  BankAccountCurrency,
  BankAccountDescription
FROM I_BankCashBalancePreview
;

Learn More