C_CashBankTP

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_CashBankTP.
-- 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_CashBankTP AS
SELECT
  BankCountry,
  BankInternalID,
  CashBankKeyForDisplay,
  CreatedByUser,
  LongBankName,
  LongBankBranch,
  AddressRegion,
  CityName,
  StreetName,
  BankIsInternal,
  BankIsStandard,
  SWIFTCode,
  BankNetworkGrouping,
  BankNumber,
  IsMarkedForDeletion,
  BankCategory,
  _BankCategory.BankCategoryDescription AS BankCategoryDescription,
  BankIsMyBank,
  BankHasHouseBanks,
  BankHasBankAccounts,
  LastChangeDateTime,
  LongBankBranchIsHidden,
  BankNumberIsHidden,
  SWIFTCodeIsHidden,
  BankNetworkGroupingIsHidden,
  BankAddressIsHidden,
  BankScriptedAddressIsHidden,
  _BankUsage.NumberOfBankAccounts AS NumberOfBankAccounts,
  _BankUsage.NumberOfHouseBanks AS NumberOfHouseBanks,
  _BankUsage.NumberOfBusinessPartnerUsed AS NumberOfBusinessPartnerUsed,
  _BankUsage.NumberOfCompanyUsed AS NumberOfCompanyUsed,
  _Country._Text[1:Language = $session.system_language].CountryShortName AS BankCountryName,
  _Region._RegionText[1:Language = $session.system_language].RegionName AS RegionName,
  _CreatedBy.UserDescription AS CreatedByUserFullName,
  _BankHierarchy.BankHierarchyGroupName AS BankHierarchyGroupName,
  virtual HouseBanksIsHidden :abap_boolean AS virtualHouseBanksIsHiddenabap_boolean,
  virtual ChangeDocObject :cdobjectv AS virtualChangeDocObjectcdobjectv
FROM R_CashBankTP
LEFT OUTER JOIN C_CashBankAddress AS _BankAddress ON BankCountry = _BankAddress.BankCountry AND BankInternalID = _BankAddress.BankInternalID  -- association [0..1]
LEFT OUTER JOIN C_CashBankScriptedAddress AS _BankScriptedAddress ON BankCountry = _BankScriptedAddress.BankCountry AND BankInternalID = _BankScriptedAddress.BankInternalID  -- association [0..*]
LEFT OUTER JOIN C_CashBankContactPerson AS _ContactPerson ON BankCountry = _ContactPerson.BankCountry AND BankInternalID = _ContactPerson.BankInternalID  -- association [0..*]
LEFT OUTER JOIN C_CashBankBusinessPartnerUsed AS _BusinessPartnerUsed ON BankCountry = _BusinessPartnerUsed.BankCountry AND BankInternalID = _BusinessPartnerUsed.BankInternalID  -- association [0..*]
LEFT OUTER JOIN C_CashBankCompanyCodeUsed AS _CompanyCodeUsed ON BankCountry = _CompanyCodeUsed.BankCountry AND BankInternalID = _CompanyCodeUsed.BankInternalID  -- association [0..*]
;