C_CashBankBusinessPartnerUsed

DDL: C_CASHBANKBUSINESSPARTNERUSED Type: view_entity CONSUMPTION Package: FCLM_MANAGEBANKS
12 Fields 1 Data Sources 2 OData Services

Bank Business Partner Used

C_CashBankBusinessPartnerUsed is a Consumption CDS View that provides data about "Bank Business Partner Used" in SAP S/4HANA. It reads from 1 data source (I_CashBankBusinessPartnerUsed) and exposes 12 fields with key fields BusinessPartnerNumber, 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_CashBankBusinessPartnerUsed I_CashBankBusinessPartnerUsed from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Bank Business Partner Used view
AccessControl.personalData.blocking #REQUIRED view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED 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 (12)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerNumber BusinessPartnerNumber Issuing Authority
KEY BankCountry BankCountry Bank Ctry/Rgn. Key
KEY BankInternalID BankInternalID Bank Key
BusinessPartnerRoleDescription
CountryName _AddrCountryText CountryName Country
AddressCountry AddressCountry Country/Reg.
AddressCityName AddressCityName City
BankName _Bank BankName Bank Name
BankCountryName _CountryText CountryName Country
BusinessPartnerName BusinessPartnerName Extracted Customer Name
_BusinessPartner _BusinessPartner
_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_CashBankBusinessPartnerUsed.
-- 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_CashBankBusinessPartnerUsed AS
SELECT
  BusinessPartnerNumber,
  BankCountry,
  BankInternalID,
  cast ( '' as char255 ) AS BusinessPartnerRoleDescription,
  _AddrCountryText.CountryName AS CountryName,
  AddressCountry,
  AddressCityName,
  _Bank.BankName AS BankName,
  _CountryText.CountryName AS BankCountryName,
  BusinessPartnerName
FROM I_CashBankBusinessPartnerUsed
;

Learn More