I_BankAddressTP

DDL: I_BANKADDRESSTP Type: view_entity TRANSACTIONAL

Bank Address - TP

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

1 data source(s) 43 fields

Data Sources (1)

SourceAliasJoin Type
R_BankAddressTP R_BankAddressTP projection

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Bank Address - TP view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (43)

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
_BankredirectedtoparentI_BankTP
_Region _Region
_Country _Country
_FormOfAddress _FormOfAddress 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Bank Address - TP'
@VDM: {
  viewType: #TRANSACTIONAL
}
@ObjectModel:{
   usageType: {
     serviceQuality: #C,
     sizeCategory: #L,
     dataClass: #TRANSACTIONAL }
 }
define view entity I_BankAddressTP
  as projection on R_BankAddressTP as BankAddress
{
  key BankCountry,
  key BankInternalID,

      //LongBankName,              //char80 ... it is exposed via case condition in I_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 I_BankTP,
      BankAddress._BankScriptVariant : redirected to composition child I_BankScriptedAddressTP,

      _Region,
      _Country,
      _FormOfAddress
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_BANKADDRESSTP"
],
"ASSOCIATED":
[
"I_BANKSCRIPTEDADDRESSTP",
"I_BANKTP",
"I_COUNTRY",
"I_FORMOFADDRESS",
"I_REGION",
"R_BANKSCRIPTEDADDRESSTP",
"R_BANKTP"
],
"BASE":
[
"R_BANKADDRESSTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More