C_CashBankScriptedAddress

DDL: C_CASHBANKSCRIPTEDADDRESS Type: view_entity CONSUMPTION
32 Fields 1 Data Sources 1 Associations

Cash Bank Scripted Address

C_CashBankScriptedAddress is a Consumption CDS View that provides data about "Cash Bank Scripted Address" in SAP S/4HANA. It reads from 1 data source (R_BankScriptedAddressTP) and exposes 32 fields with key fields BankCountry, BankInternalID, AddressRepresentationCode. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_BankScriptedAddressTP _BankScriptedAddress from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Bank_2 _BankDetail $projection.BankCountry = _BankDetail.BankCountry and $projection.BankInternalID = _BankDetail.BankInternalID

Annotations (8)

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

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY BankCountry R_BankScriptedAddressTP BankCountry Bank Ctry/Rgn. Key
KEY BankInternalID R_BankScriptedAddressTP BankInternalID Bank Key
KEY AddressRepresentationCode R_BankScriptedAddressTP AddressRepresentationCode Address Version
AddressCodeDesc
LongBankName R_BankScriptedAddressTP LongBankName
LongBankBranch R_BankScriptedAddressTP LongBankBranch
StreetName R_BankScriptedAddressTP StreetName Text
HouseNumber R_BankScriptedAddressTP HouseNumber House Number
HouseNumberSupplementText R_BankScriptedAddressTP HouseNumberSupplementText Supplement
CityName R_BankScriptedAddressTP CityName Name
Building R_BankScriptedAddressTP Building Building code
RoomNumber R_BankScriptedAddressTP RoomNumber Room Number
Floor R_BankScriptedAddressTP Floor Floor
StreetPrefixName1 R_BankScriptedAddressTP StreetPrefixName1 Street 2
StreetPrefixName2 R_BankScriptedAddressTP StreetPrefixName2 Street 3
StreetSuffixName1 R_BankScriptedAddressTP StreetSuffixName1 Street 4
StreetSuffixName2 R_BankScriptedAddressTP StreetSuffixName2 Street 5
DistrictName R_BankScriptedAddressTP DistrictName District
VillageName R_BankScriptedAddressTP VillageName Different City
Country R_BankScriptedAddressTP Country Venue: Ctry/Reg
BankCountryName
AddressSearchTerm1 R_BankScriptedAddressTP AddressSearchTerm1 Search Term 1
AddressSearchTerm2 R_BankScriptedAddressTP AddressSearchTerm2 Search Term 2
POBoxLobbyName R_BankScriptedAddressTP POBoxLobbyName PO Box Lobby
POBoxDeviatingCityName R_BankScriptedAddressTP POBoxDeviatingCityName PO Box City
CareOfName R_BankScriptedAddressTP CareOfName c/o
SecondaryRegionName R_BankScriptedAddressTP SecondaryRegionName County
TertiaryRegionName R_BankScriptedAddressTP TertiaryRegionName Township
BankName _BankDetail BankName Bank Name
CountryShortName
AddressID R_BankScriptedAddressTP AddressID Ship-to address
_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_CashBankScriptedAddress.
-- 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_CashBankScriptedAddress AS
SELECT
  _BankScriptedAddress.BankCountry AS BankCountry,
  _BankScriptedAddress.BankInternalID AS BankInternalID,
  _BankScriptedAddress.AddressRepresentationCode AS AddressRepresentationCode,
  _BankScriptedAddress._AddressRepresentationCode._Text[1:Language = $session.system_language].AddressRepresentationDesc AS AddressCodeDesc,
  _BankScriptedAddress.LongBankName AS LongBankName,
  _BankScriptedAddress.LongBankBranch AS LongBankBranch,
  _BankScriptedAddress.StreetName AS StreetName,
  _BankScriptedAddress.HouseNumber AS HouseNumber,
  _BankScriptedAddress.HouseNumberSupplementText AS HouseNumberSupplementText,
  _BankScriptedAddress.CityName AS CityName,
  _BankScriptedAddress.Building AS Building,
  _BankScriptedAddress.RoomNumber AS RoomNumber,
  _BankScriptedAddress.Floor AS Floor,
  _BankScriptedAddress.StreetPrefixName1 AS StreetPrefixName1,
  _BankScriptedAddress.StreetPrefixName2 AS StreetPrefixName2,
  _BankScriptedAddress.StreetSuffixName1 AS StreetSuffixName1,
  _BankScriptedAddress.StreetSuffixName2 AS StreetSuffixName2,
  _BankScriptedAddress.DistrictName AS DistrictName,
  _BankScriptedAddress.VillageName AS VillageName,
  _BankScriptedAddress.Country AS Country,
  _BankScriptedAddress._Country._Text[1:Language = $session.system_language].CountryShortName AS BankCountryName,
  _BankScriptedAddress.AddressSearchTerm1 AS AddressSearchTerm1,
  _BankScriptedAddress.AddressSearchTerm2 AS AddressSearchTerm2,
  _BankScriptedAddress.POBoxLobbyName AS POBoxLobbyName,
  _BankScriptedAddress.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  _BankScriptedAddress.CareOfName AS CareOfName,
  _BankScriptedAddress.SecondaryRegionName AS SecondaryRegionName,
  _BankScriptedAddress.TertiaryRegionName AS TertiaryRegionName,
  _BankDetail.BankName AS BankName,
  _BankDetail._Country._Text[1:Language = $session.system_language].CountryShortName AS CountryShortName,
  _BankScriptedAddress.AddressID AS AddressID
FROM R_BankScriptedAddressTP AS _BankScriptedAddress
LEFT OUTER JOIN I_Bank_2 AS _BankDetail ON BankCountry = _BankDetail.BankCountry AND BankInternalID = _BankDetail.BankInternalID  -- association [1..1]
;

Learn More