C_RequestWithBankAccount

DDL: C_REQUESTWITHBANKACCOUNT SQL: CREQBANKACCT Type: view CONSUMPTION
15 Fields 1 Data Sources 5 Associations

bank account with request

C_RequestWithBankAccount is a Consumption CDS View that provides data about "bank account with request" in SAP S/4HANA. It reads from 1 data source (I_RequestWithBankAccount) and exposes 15 fields with key fields BankAccountChangeRequest, BankAccountInternalID, BankAccountRevision. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_RequestWithBankAccount BankAccount from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_BankAccountTextRev _AccountText $projection.BankAccountInternalID = _AccountText.BankAccountInternalID and $projection.BankAccountRevision = _AccountText.BankAccountRevision and _AccountText.Language = $session.system_language
[0..1] I_Bank_2 _Bank $projection.BankCountry = _Bank.BankCountry and $projection.Bank = _Bank.BankInternalID
[0..1] I_CurrencyText _CurrencyText $projection.BankAccountCurrency = _CurrencyText.Currency and _CurrencyText.Language = $session.system_language
[0..1] I_BankAccountTypeText _BankAccountType $projection.BankAccountType = _BankAccountType.BankAccountType and _BankAccountType.Language = $session.system_language
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CREQBANKACCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label bank account with request view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
UI.headerInfo.typeName Bank Account view
UI.headerInfo.typeNamePlural Bank Accounts view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BankAccountChangeRequest I_RequestWithBankAccount BankAccountChangeRequest Request unique ID
KEY BankAccountInternalID I_RequestWithBankAccount BankAccountInternalID Technical ID
KEY BankAccountRevision I_RequestWithBankAccount BankAccountRevision Revision Number
BankAccountDescription _AccountText BankAccountDescription
BankAccountNumber I_RequestWithBankAccount BankAccountNumber Bank Account
BankAccountCurrency I_RequestWithBankAccount BankAccountCurrency Currency
CurrencyName _CurrencyText CurrencyName
Bank I_RequestWithBankAccount Bank Bank Number
BankName _Bank BankName Bank Name
BankCountry I_RequestWithBankAccount BankCountry Bank Ctry/Rgn. Key
CountryName CountryName Country
BankAccountType I_RequestWithBankAccount AccountType Accounting Type(dtl)
BankAccountTypeText _BankAccountType BankAccountTypeText
CompanyCode I_RequestWithBankAccount CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name

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_RequestWithBankAccount.
-- 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: CREQBANKACCT

CREATE VIEW C_RequestWithBankAccount AS
SELECT
  BankAccount.BankAccountChangeRequest AS BankAccountChangeRequest,
  BankAccount.BankAccountInternalID AS BankAccountInternalID,
  BankAccount.BankAccountRevision AS BankAccountRevision,
  _AccountText.BankAccountDescription AS BankAccountDescription,
  BankAccount.BankAccountNumber AS BankAccountNumber,
  BankAccount.BankAccountCurrency AS BankAccountCurrency,
  _CurrencyText.CurrencyName AS CurrencyName,
  BankAccount.Bank AS Bank,
  _Bank.BankName AS BankName,
  BankAccount.BankCountry AS BankCountry,
  CountryName,
  BankAccount.AccountType AS BankAccountType,
  _BankAccountType.BankAccountTypeText AS BankAccountTypeText,
  BankAccount.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName
FROM I_RequestWithBankAccount AS BankAccount
LEFT OUTER JOIN I_BankAccountTextRev AS _AccountText ON BankAccountInternalID = _AccountText.BankAccountInternalID AND BankAccountRevision = _AccountText.BankAccountRevision AND _AccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Bank_2 AS _Bank ON BankCountry = _Bank.BankCountry AND Bank = _Bank.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_CurrencyText AS _CurrencyText ON BankAccountCurrency = _CurrencyText.Currency AND _CurrencyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BankAccountTypeText AS _BankAccountType ON BankAccountType = _BankAccountType.BankAccountType AND _BankAccountType.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;

Learn More