C_BankAddressTP

DDL: C_BANKADDRESSTP Type: view_entity CONSUMPTION
68 Fields 1 Data Sources

Consumption Bank Address TP

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

Data Sources (1)

SourceAliasJoin Type
R_BankAddressTP R_BankAddressTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption Bank Address TP view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view

Fields (68)

KeyFieldSource TableSource FieldDescription
KEY BankCountry BankCountry Bank Ctry/Rgn. Key
KEY BankInternalID BankInternalID Bank Key
StreetName StreetName Text
HouseNumber HouseNumber House Number
HouseNumberSupplementText HouseNumberSupplementText Supplement
CityName CityName Name
PostalCode PostalCode Postal Code
Country Country Venue: Ctry/Reg
Region Region Venue Region
CorrespondenceLanguage CorrespondenceLanguage Language
LanguageNamelocalized
DistrictName DistrictName District
VillageName VillageName Different City
CompanyPostalCode CompanyPostalCode Company Post Cd
StreetAddrNonDeliverableReason StreetAddrNonDeliverableReason Undeliverable
AddressNonDeliverableReasonTxtlocalized
StreetPrefixName1 StreetPrefixName1 Street 2
StreetPrefixName2 StreetPrefixName2 Street 3
StreetSuffixName1 StreetSuffixName1 Street 4
StreetSuffixName2 StreetSuffixName2 Street 5
Building Building Building code
Floor Floor Floor
RoomNumber RoomNumber Room Number
FormOfAddress FormOfAddress Title Key
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
TransportZone TransportZone Transport Zone
AddressSearchTerm1 AddressSearchTerm1 Search Term 1
AddressSearchTerm2 AddressSearchTerm2 Search Term 2
POBox POBox PO Box
POBoxAddrNonDeliverableReason POBoxAddrNonDeliverableReason Undeliverable
AddrNonDeliverableReasonDesclocalized
POBoxIsWithoutNumber POBoxIsWithoutNumber PO Box w/o No.
POBoxPostalCode POBoxPostalCode PO Box Postal Code
POBoxLobbyName POBoxLobbyName PO Box Lobby
POBoxDeviatingCityName POBoxDeviatingCityName PO Box City
POBoxDeviatingRegion POBoxDeviatingRegion PO Region
POBoxDeviatingCountry POBoxDeviatingCountry PO Box C/R
CountryNamelocalized
RegionNameasBankPOBoxRegionNamelocalized
CareOfName CareOfName c/o
DeliveryServiceTypeCode DeliveryServiceTypeCode Delvry Serv Type
DeliveryServiceTypeDescriptionlocalized
DeliveryServiceNumber DeliveryServiceNumber Delivery Service No.
AddressTimeZone AddressTimeZone Time Zone
TimeZoneTextlocalized
SecondaryRegionName SecondaryRegionName County
TertiaryRegionName TertiaryRegionName Township
AddressRepresentationCode AddressRepresentationCode Address Version
AddressID AddressID Ship-to address
PhoneNumberCountry PhoneNumberCountry
PhoneNumber PhoneNumber Telephone no.
PhoneExtensionNumber PhoneExtensionNumber Extension
InternationalPhoneNumber InternationalPhoneNumber Telephone no.
TelephoneCountryPrefix _TelCountryPrefix TelephoneCountryPrefix Tel. to
MobilePhoneCountry MobilePhoneCountry Country/Region
MobilePhoneNumber MobilePhoneNumber Telephone
InternationalMobilePhoneNumber InternationalMobilePhoneNumber
FaxNumberCountry FaxNumberCountry Country/Region
FaxAreaCodeSubscriberNumber FaxAreaCodeSubscriberNumber Fax
FaxExtensionNumber FaxExtensionNumber Extension
InternationalFaxNumber InternationalFaxNumber Fax Number
EmailAddress EmailAddress E-Mail Address
CountryNameasBankCountryNamelocalized
RegionNamelocalized
_BankredirectedtoparentC_BankTP
_Country _Country
_FormOfAddress _FormOfAddress
_Region _Region

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_BankAddressTP.
-- 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_BankAddressTP AS
SELECT
  BankCountry,
  BankInternalID,
  StreetName,
  HouseNumber,
  HouseNumberSupplementText,
  CityName,
  PostalCode,
  Country,
  Region,
  CorrespondenceLanguage,
  _CorrespondenceLanguage._Text.LanguageName : localized AS LanguageNamelocalized,
  DistrictName,
  VillageName,
  CompanyPostalCode,
  StreetAddrNonDeliverableReason,
  _StreetAddrNonDeliverableRsn._Text.AddressNonDeliverableReasonTxt : localized AS AddressNonDeliverableReasonTxtlocalized,
  StreetPrefixName1,
  StreetPrefixName2,
  StreetSuffixName1,
  StreetSuffixName2,
  Building,
  Floor,
  RoomNumber,
  FormOfAddress,
  TaxJurisdiction,
  TransportZone,
  AddressSearchTerm1,
  AddressSearchTerm2,
  POBox,
  POBoxAddrNonDeliverableReason,
  _POBoxAddrNonDeliverableReason._Text.AddrNonDeliverableReasonDesc : localized AS AddrNonDeliverableReasonDesclocalized,
  POBoxIsWithoutNumber,
  POBoxPostalCode,
  POBoxLobbyName,
  POBoxDeviatingCityName,
  POBoxDeviatingRegion,
  POBoxDeviatingCountry,
  _POBoxDeviatingCountry._Text.CountryName : localized AS CountryNamelocalized,
  _POBoxDeviatingRegion._RegionText.RegionName as BankPOBoxRegionName : localized AS RegionNameasBankPOBoxRegionNamelocalized,
  CareOfName,
  DeliveryServiceTypeCode,
  _DeliveryServiceTypeCode._Text.DeliveryServiceTypeDescription : localized AS DeliveryServiceTypeDescriptionlocalized,
  DeliveryServiceNumber,
  AddressTimeZone,
  _TimeZone._TimeZoneText.TimeZoneText : localized AS TimeZoneTextlocalized,
  SecondaryRegionName,
  TertiaryRegionName,
  AddressRepresentationCode,
  AddressID,
  PhoneNumberCountry,
  PhoneNumber,
  PhoneExtensionNumber,
  InternationalPhoneNumber,
  _TelCountryPrefix.TelephoneCountryPrefix AS TelephoneCountryPrefix,
  MobilePhoneCountry,
  MobilePhoneNumber,
  InternationalMobilePhoneNumber,
  FaxNumberCountry,
  FaxAreaCodeSubscriberNumber,
  FaxExtensionNumber,
  InternationalFaxNumber,
  EmailAddress,
  _Country._Text.CountryName as BankCountryName : localized AS CountryNameasBankCountryNamelocalized,
  _Region._RegionText.RegionName : localized AS RegionNamelocalized,
  BankAddress._Bank : redirected to parent C_BankTP AS _BankredirectedtoparentC_BankTP
FROM R_BankAddressTP
;

Learn More