I_NumberOfCashBankUsage

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 I_NumberOfCashBankUsage.
-- 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: INROFCSHBKUSGE

CREATE VIEW I_NumberOfCashBankUsage AS
SELECT
  Bank.BankCountry AS BankCountry,
  Bank.BankInternalID AS BankInternalID,
  case when _UsedBpCount.UnderBankBPQuantity is not null then _UsedBpCount.UnderBankBPQuantity else cast ( 0 as abap.int4) end as NumberOfBusinessPartnerUsed AS int4endasNumberOfBusinessPartnerUsed,
  case when _UsedCompanyCount.NumberOfCompanyUsed is not null then _UsedCompanyCount.NumberOfCompanyUsed else cast ( 0 as abap.int4) end as NumberOfCompanyUsed AS int4endasNumberOfCompanyUsed,
  Bank.BankCategory AS BankCategory
FROM I_Bank_2 AS Bank
LEFT OUTER JOIN I_BankCompanyCodeUsedCount AS _UsedCompanyCount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BankWithBankAccountCount AS _BankAccountUsage ON BankCountry = _BankAccountUsage.BankCountry AND BankInternalID = _BankAccountUsage.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankWithHouseBankCount AS _HouseBankUsage ON BankCountry = _HouseBankUsage.BankCountry AND BankInternalID = _HouseBankUsage.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankUsedBPCount AS _UsedBpCount ON BankCountry = _UsedBpCount.BankCountry AND BankInternalID = _UsedBpCount.BankInternalID  -- association [0..1]
;