A_BankAddress

DDL: A_BANKADDRESS Type: view_entity

Bank Address

A_BankAddress is a CDS View that provides data about "Bank Address" in SAP S/4HANA. It reads from 1 data source (R_BankAddressDepTP) and exposes 48 fields with key fields BankCountry, BankInternalID, AddressRepresentationCode.

1 data source(s) 48 fields

Data Sources (1)

SourceAliasJoin Type
R_BankAddressDepTP R_BankAddressDepTP projection

Annotations (6)

NameValueLevelField
EndUserText.label Bank Address view
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY BankCountry BankCountry
KEY BankInternalID BankInternalID
KEY AddressRepresentationCode AddressRepresentationCode
AddressID AddressID
CorrespondenceLanguage CorrespondenceLanguage
CityName CityName
DistrictName DistrictName
VillageName VillageName
PostalCode PostalCode
CompanyPostalCode CompanyPostalCode
StreetName StreetName
StreetAddrNonDeliverableReason StreetAddrNonDeliverableReason
StreetPrefixName1 StreetPrefixName1
StreetPrefixName2 StreetPrefixName2
StreetSuffixName1 StreetSuffixName1
StreetSuffixName2 StreetSuffixName2
HouseNumber HouseNumber
HouseNumberSupplementText HouseNumberSupplementText
Building Building
Floor Floor
RoomNumber RoomNumber
Country Country
Region Region
FormOfAddress FormOfAddress
AddresseeName1 AddresseeName1
AddresseeName2 AddresseeName2
AddresseeName3 AddresseeName3
AddresseeName4 AddresseeName4
TaxJurisdiction TaxJurisdiction
TransportZone TransportZone
POBox POBox
POBoxAddrNonDeliverableReason POBoxAddrNonDeliverableReason
POBoxIsWithoutNumber POBoxIsWithoutNumber
POBoxPostalCode POBoxPostalCode
POBoxLobbyName POBoxLobbyName
POBoxDeviatingCityName POBoxDeviatingCityName
POBoxDeviatingRegion POBoxDeviatingRegion
POBoxDeviatingCountry POBoxDeviatingCountry
CareOfName CareOfName
DeliveryServiceTypeCode DeliveryServiceTypeCode
DeliveryServiceNumber DeliveryServiceNumber
AddressTimeZone AddressTimeZone
SecondaryRegionName SecondaryRegionName
TertiaryRegionName TertiaryRegionName
_BankredirectedtoparentA_Bank_2
_Region _Region
_Country _Country
_FormOfAddress _FormOfAddress 
@EndUserText.label: 'Bank Address'
@AccessControl.authorizationCheck: #CHECK
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #L,
  dataClass: #MASTER
}

define view entity A_BankAddress
  as projection on R_BankAddressDepTP as BankAddress
{

  key BankCountry,
  key BankInternalID,
  key AddressRepresentationCode, //adrc-nation

      AddressID, //adrc-ADDRNUMBER -> additional?


//      AddressObjectType,

      CorrespondenceLanguage,
//      PrfrdCommMediumType,

//      AddresseeFullName,


      CityName,
      DistrictName,
      VillageName,
      PostalCode,
      CompanyPostalCode,
      StreetName,
      StreetAddrNonDeliverableReason,
      StreetPrefixName1,
      StreetPrefixName2,
      StreetSuffixName1,
      StreetSuffixName2,
      HouseNumber,
      HouseNumberSupplementText,
      Building,
      Floor,
      RoomNumber,
      @ObjectModel.foreignKey.association: '_Country'
      Country,
      @ObjectModel.foreignKey.association: '_Region'
      Region,
      @ObjectModel.foreignKey.association: '_FormOfAddress'
      FormOfAddress,
      AddresseeName1,
      AddresseeName2,
      AddresseeName3,
      AddresseeName4,
      TaxJurisdiction,
      TransportZone,

      POBox,
      POBoxAddrNonDeliverableReason,
      POBoxIsWithoutNumber,
      POBoxPostalCode,
      POBoxLobbyName,
      POBoxDeviatingCityName,
      POBoxDeviatingRegion,
      POBoxDeviatingCountry,
      CareOfName,
      DeliveryServiceTypeCode,
      DeliveryServiceNumber,
      AddressTimeZone,
      SecondaryRegionName,
      TertiaryRegionName,

      // Associations

      BankAddress._Bank : redirected to parent A_Bank_2,

      _Region,
      _Country,
      _FormOfAddress

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_BANKADDRESSDEPTP"
],
"ASSOCIATED":
[
"A_BANK_2",
"I_COUNTRY",
"I_FORMOFADDRESS",
"I_REGION",
"R_BANKDEPTP"
],
"BASE":
[
"R_BANKADDRESSDEPTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More