C_CashBankAddress

DDL: C_CASHBANKADDRESS Type: view_entity CONSUMPTION
62 Fields 1 Data Sources

Cash Bank Address

C_CashBankAddress is a Consumption CDS View that provides data about "Cash Bank Address" in SAP S/4HANA. It reads from 1 data source (R_BankAddressTP) and exposes 62 fields with key fields BankCountry, BankInternalID.

Data Sources (1)

SourceAliasJoin Type
R_BankAddressTP _BankAddress from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Cash Bank Address view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

Fields (62)

KeyFieldSource TableSource FieldDescription
KEY BankCountry R_BankAddressTP BankCountry Bank Ctry/Rgn. Key
KEY BankInternalID R_BankAddressTP BankInternalID Bank Key
StreetName R_BankAddressTP StreetName Text
HouseNumber R_BankAddressTP HouseNumber House Number
HouseNumberSupplementText R_BankAddressTP HouseNumberSupplementText Supplement
CityName R_BankAddressTP CityName Name
PostalCode R_BankAddressTP PostalCode Postal Code
Country R_BankAddressTP Country Venue: Ctry/Reg
Region R_BankAddressTP Region Venue Region
CorrespondenceLanguage R_BankAddressTP CorrespondenceLanguage Language
LanguageName
DistrictName R_BankAddressTP DistrictName District
VillageName R_BankAddressTP VillageName Different City
CompanyPostalCode R_BankAddressTP CompanyPostalCode Company Post Cd
StreetAddrNonDeliverableReason R_BankAddressTP StreetAddrNonDeliverableReason Undeliverable
StreetPrefixName1 R_BankAddressTP StreetPrefixName1 Street 2
StreetPrefixName2 R_BankAddressTP StreetPrefixName2 Street 3
StreetSuffixName1 R_BankAddressTP StreetSuffixName1 Street 4
StreetSuffixName2 R_BankAddressTP StreetSuffixName2 Street 5
Building R_BankAddressTP Building Building code
Floor R_BankAddressTP Floor Floor
RoomNumber R_BankAddressTP RoomNumber Room Number
FormOfAddress R_BankAddressTP FormOfAddress Title Key
TaxJurisdiction R_BankAddressTP TaxJurisdiction Tax Jurisdiction
TransportZone R_BankAddressTP TransportZone Transport Zone
AddressSearchTerm1 R_BankAddressTP AddressSearchTerm1 Search Term 1
AddressSearchTerm2 R_BankAddressTP AddressSearchTerm2 Search Term 2
POBox R_BankAddressTP POBox PO Box
POBoxAddrNonDeliverableReason R_BankAddressTP POBoxAddrNonDeliverableReason Undeliverable
POBoxIsWithoutNumber R_BankAddressTP POBoxIsWithoutNumber PO Box w/o No.
POBoxPostalCode R_BankAddressTP POBoxPostalCode PO Box Postal Code
POBoxLobbyName R_BankAddressTP POBoxLobbyName PO Box Lobby
POBoxDeviatingCityName R_BankAddressTP POBoxDeviatingCityName PO Box City
POBoxDeviatingRegion R_BankAddressTP POBoxDeviatingRegion PO Region
POBoxDeviatingCountry R_BankAddressTP POBoxDeviatingCountry PO Box C/R
CareOfName R_BankAddressTP CareOfName c/o
DeliveryServiceTypeCode R_BankAddressTP DeliveryServiceTypeCode Delvry Serv Type
DeliveryServiceNumber R_BankAddressTP DeliveryServiceNumber Delivery Service No.
AddressTimeZone R_BankAddressTP AddressTimeZone Time Zone
SecondaryRegionName R_BankAddressTP SecondaryRegionName County
TertiaryRegionName R_BankAddressTP TertiaryRegionName Township
AddressRepresentationCode R_BankAddressTP AddressRepresentationCode Address Version
AddressCodeDesc
AddressID R_BankAddressTP AddressID Ship-to address
PhoneNumberCountry R_BankAddressTP PhoneNumberCountry
TelephoneCountryName
PhoneNumber R_BankAddressTP PhoneNumber Telephone no.
PhoneExtensionNumber R_BankAddressTP PhoneExtensionNumber Extension
InternationalPhoneNumber R_BankAddressTP InternationalPhoneNumber Telephone no.
TelephoneCountryPrefix
MobilePhoneCountry R_BankAddressTP MobilePhoneCountry Country/Region
MobilePhoneNumber R_BankAddressTP MobilePhoneNumber Telephone
InternationalMobilePhoneNumber R_BankAddressTP InternationalMobilePhoneNumber
FaxNumberCountry R_BankAddressTP FaxNumberCountry Country/Region
FaxAreaCodeSubscriberNumber R_BankAddressTP FaxAreaCodeSubscriberNumber Fax
FaxExtensionNumber R_BankAddressTP FaxExtensionNumber Extension
InternationalFaxNumber R_BankAddressTP InternationalFaxNumber Fax Number
EmailAddress R_BankAddressTP EmailAddress E-Mail Address
BankCountryName
RegionName
_TelCountryPrefix _TelCountryPrefix
_Bank R_BankAddressTP _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_CashBankAddress.
-- 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_CashBankAddress AS
SELECT
  _BankAddress.BankCountry AS BankCountry,
  _BankAddress.BankInternalID AS BankInternalID,
  _BankAddress.StreetName AS StreetName,
  _BankAddress.HouseNumber AS HouseNumber,
  _BankAddress.HouseNumberSupplementText AS HouseNumberSupplementText,
  _BankAddress.CityName AS CityName,
  _BankAddress.PostalCode AS PostalCode,
  _BankAddress.Country AS Country,
  _BankAddress.Region AS Region,
  _BankAddress.CorrespondenceLanguage AS CorrespondenceLanguage,
  _BankAddress._CorrespondenceLanguage._Text[1:Language = $session.system_language].LanguageName AS LanguageName,
  _BankAddress.DistrictName AS DistrictName,
  _BankAddress.VillageName AS VillageName,
  _BankAddress.CompanyPostalCode AS CompanyPostalCode,
  _BankAddress.StreetAddrNonDeliverableReason AS StreetAddrNonDeliverableReason,
  _BankAddress.StreetPrefixName1 AS StreetPrefixName1,
  _BankAddress.StreetPrefixName2 AS StreetPrefixName2,
  _BankAddress.StreetSuffixName1 AS StreetSuffixName1,
  _BankAddress.StreetSuffixName2 AS StreetSuffixName2,
  _BankAddress.Building AS Building,
  _BankAddress.Floor AS Floor,
  _BankAddress.RoomNumber AS RoomNumber,
  _BankAddress.FormOfAddress AS FormOfAddress,
  _BankAddress.TaxJurisdiction AS TaxJurisdiction,
  _BankAddress.TransportZone AS TransportZone,
  _BankAddress.AddressSearchTerm1 AS AddressSearchTerm1,
  _BankAddress.AddressSearchTerm2 AS AddressSearchTerm2,
  _BankAddress.POBox AS POBox,
  _BankAddress.POBoxAddrNonDeliverableReason AS POBoxAddrNonDeliverableReason,
  _BankAddress.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  _BankAddress.POBoxPostalCode AS POBoxPostalCode,
  _BankAddress.POBoxLobbyName AS POBoxLobbyName,
  _BankAddress.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  _BankAddress.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  _BankAddress.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  _BankAddress.CareOfName AS CareOfName,
  _BankAddress.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  _BankAddress.DeliveryServiceNumber AS DeliveryServiceNumber,
  _BankAddress.AddressTimeZone AS AddressTimeZone,
  _BankAddress.SecondaryRegionName AS SecondaryRegionName,
  _BankAddress.TertiaryRegionName AS TertiaryRegionName,
  _BankAddress.AddressRepresentationCode AS AddressRepresentationCode,
  _BankAddress._AddressRepresentationCode._Text[1:Language = $session.system_language].AddressRepresentationDesc AS AddressCodeDesc,
  _BankAddress.AddressID AS AddressID,
  _BankAddress.PhoneNumberCountry AS PhoneNumberCountry,
  _TelCountryPrefix._CountryText[1:Language = $session.system_language].CountryName AS TelephoneCountryName,
  _BankAddress.PhoneNumber AS PhoneNumber,
  _BankAddress.PhoneExtensionNumber AS PhoneExtensionNumber,
  _BankAddress.InternationalPhoneNumber AS InternationalPhoneNumber,
  _BankAddress._TelCountryPrefix.TelephoneCountryPrefix AS TelephoneCountryPrefix,
  _BankAddress.MobilePhoneCountry AS MobilePhoneCountry,
  _BankAddress.MobilePhoneNumber AS MobilePhoneNumber,
  _BankAddress.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  _BankAddress.FaxNumberCountry AS FaxNumberCountry,
  _BankAddress.FaxAreaCodeSubscriberNumber AS FaxAreaCodeSubscriberNumber,
  _BankAddress.FaxExtensionNumber AS FaxExtensionNumber,
  _BankAddress.InternationalFaxNumber AS InternationalFaxNumber,
  _BankAddress.EmailAddress AS EmailAddress,
  _BankAddress._Country._Text[1:Language = $session.system_language].CountryShortName AS BankCountryName,
  _BankAddress._Region._RegionText[1:Language = $session.system_language].RegionName AS RegionName,
  _BankAddress._Bank AS _Bank
FROM R_BankAddressTP AS _BankAddress
;

Learn More