C_CashBankCompanyCodeUsed

DDL: C_CASHBANKCOMPANYCODEUSED Type: view_entity CONSUMPTION Package: FCLM_MANAGEBANKS
10 Fields 1 Data Sources 2 OData Services

Bank Company Code Used

C_CashBankCompanyCodeUsed is a Consumption CDS View that provides data about "Bank Company Code Used" in SAP S/4HANA. It reads from 1 data source (I_CashBankCompanyCodeUsed) and exposes 10 fields with key fields CompanyCode, BankCountry, BankInternalID. It is exposed through 2 OData services (ASQL_F1574A, UI_CASHBANK_MANAGE). Part of development package FCLM_MANAGEBANKS.

Data Sources (1)

SourceAliasJoin Type
I_CashBankCompanyCodeUsed I_CashBankCompanyCodeUsed from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Bank Company Code Used view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F1574A ASQL_F1574A C2 NOT_RELEASED
UI_CASHBANK_MANAGE UI_CASHBANK_MANAGE V4 C1 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY BankCountry BankCountry Bank Ctry/Rgn. Key
KEY BankInternalID BankInternalID Bank Key
CompanyCountryName _CompanyCountryName CountryName Country
Country Country Venue: Ctry/Reg
CityName CityName Name
BankName _Bank BankName Bank Name
BankCountryName _BankCountryName CountryName Country
CompanyCodeName CompanyCodeName Company Name
_Bank _Bank

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_CashBankCompanyCodeUsed.
-- 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.

CREATE VIEW C_CashBankCompanyCodeUsed AS
SELECT
  CompanyCode,
  BankCountry,
  BankInternalID,
  _CompanyCountryName.CountryName AS CompanyCountryName,
  Country,
  CityName,
  _Bank.BankName AS BankName,
  _BankCountryName.CountryName AS BankCountryName,
  CompanyCodeName
FROM I_CashBankCompanyCodeUsed
;

Learn More