A_BankAddress_3

DDL: A_BANKADDRESS_3 Type: view_entity CONSUMPTION

Bank Address

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

1 data source(s) 40 fields

Data Sources (1)

SourceAliasJoin Type
R_BankAddressTP R_BankAddressTP projection

Annotations (7)

NameValueLevelField
EndUserText.label Bank Address view
AccessControl.authorizationCheck #MANDATORY view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY BankCountry BankCountry
KEY BankInternalID BankInternalID
StreetName StreetName
HouseNumber HouseNumber
HouseNumberSupplementText HouseNumberSupplementText
CityName CityName
PostalCode PostalCode
Country Country
Region Region
CorrespondenceLanguage CorrespondenceLanguage
DistrictName DistrictName
VillageName VillageName
CompanyPostalCode CompanyPostalCode
StreetAddrNonDeliverableReason StreetAddrNonDeliverableReason
StreetPrefixName1 StreetPrefixName1
StreetPrefixName2 StreetPrefixName2
StreetSuffixName1 StreetSuffixName1
StreetSuffixName2 StreetSuffixName2
Building Building
Floor Floor
RoomNumber RoomNumber
FormOfAddress FormOfAddress
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
AddressRepresentationCode AddressRepresentationCode
_BankredirectedtoparentA_Bank_3 
@EndUserText.label: 'Bank Address'
@AccessControl.authorizationCheck: #MANDATORY
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #MASTER
}
@VDM: {
  viewType: #CONSUMPTION
}
define view entity A_BankAddress_3
as projection on R_BankAddressTP as BankAddress {

  key BankCountry,
  key BankInternalID,

      //LongBankName,              //char80 ... ... it is exposed via case condition in C_BankTP

      //LongBankBranch,            //char80

      StreetName,
      HouseNumber,
      HouseNumberSupplementText,
      CityName,
      PostalCode,
//      @ObjectModel.foreignKey.association: '_Country'

      Country,
//      @ObjectModel.foreignKey.association: '_Region'

      Region,

      CorrespondenceLanguage,

      DistrictName,
      VillageName,
      CompanyPostalCode,
      StreetAddrNonDeliverableReason,
      StreetPrefixName1,
      StreetPrefixName2,
      StreetSuffixName1,
      StreetSuffixName2,
      Building,
      Floor,
      RoomNumber,
//      @ObjectModel.foreignKey.association: '_FormOfAddress'

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

      AddressRepresentationCode,
      //AddressID,


      // Associations

      BankAddress._Bank : redirected to parent A_Bank_3,
      BankAddress._BankScriptVariant : redirected to composition child A_BankScriptedAddress_3

//      _Region,

//      _Country,

//      _FormOfAddress

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_BANKADDRESSTP"
],
"ASSOCIATED":
[
"A_BANKSCRIPTEDADDRESS_3",
"A_BANK_3",
"R_BANKSCRIPTEDADDRESSTP",
"R_BANKTP"
],
"BASE":
[
"R_BANKADDRESSTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More