C_BankScriptedAddressTP

DDL: C_BANKSCRIPTEDADDRESSTP Type: view_entity CONSUMPTION

Consumption Bank Address TP

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

1 data source(s) 31 fields

Data Sources (1)

SourceAliasJoin Type
R_BankScriptedAddressTP R_BankScriptedAddressTP projection

Annotations (7)

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

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY BankCountry BankCountry
KEY BankInternalID BankInternalID
KEY AddressRepresentationCode AddressRepresentationCode
AddressCodeDesc
LongBankName LongBankName
LongBankBranch LongBankBranch
StreetName StreetName
HouseNumber HouseNumber
HouseNumberSupplementText HouseNumberSupplementText
CityName CityName
Building Building
RoomNumber RoomNumber
Floor Floor
StreetPrefixName1 StreetPrefixName1
StreetPrefixName2 StreetPrefixName2
StreetSuffixName1 StreetSuffixName1
StreetSuffixName2 StreetSuffixName2
DistrictName DistrictName
VillageName VillageName
Country Country
BankCountryName
AddressSearchTerm1 AddressSearchTerm1
AddressSearchTerm2 AddressSearchTerm2
POBoxLobbyName POBoxLobbyName
POBoxDeviatingCityName POBoxDeviatingCityName
CareOfName CareOfName
SecondaryRegionName SecondaryRegionName
TertiaryRegionName TertiaryRegionName
AddressID AddressID
_BankredirectedtoC_BankTP
_AddressRepresentationCode _AddressRepresentationCode 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Consumption Bank Address TP'
@Metadata.allowExtensions: true

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

@VDM.viewType: #CONSUMPTION


define view entity C_BankScriptedAddressTP
  as projection on R_BankScriptedAddressTP as BankScriptedAddress
{

  key BankCountry,
  key BankInternalID,
      // @ObjectModel.text.association: '_AddressRepresentationCode._Text'

      @Consumption.valueHelpDefinition: [{ entity : {name: 'C_BankAddressRepresentationVH', element: 'AddressRepresentationCode'  } }]//C_BankAddressRepCodeVH

      @ObjectModel.text.element: ['AddressCodeDesc']
  key AddressRepresentationCode, //is not initial


      //      @Consumption.valueHelpDefinition: [{ entity : {name: 'I_ActiveAddressRepresentation', element: 'AddressRepresentationCode'  } }]//C_BankAddressRepCodeVH

      //      @ObjectModel.text.element: ['AddressCodeDesc']

      //      AddressRepCodeForEdit,


      @UI.hidden: true
      @Semantics.text: true
      _AddressRepresentationCode._Text[1:Language = $session.system_language].AddressRepresentationDesc as AddressCodeDesc,

      LongBankName,   //char80

      LongBankBranch, //char80

      StreetName,
      HouseNumber,
      HouseNumberSupplementText,
      CityName,
      Building,
      RoomNumber,
      Floor, 
      //----Address---- Fields ADRC where NATION <> ''

      //  CorrespondenceLanguage,   

      //  CompanyPostalCode,

      //  StreetAddrNonDeliverableReason,

      StreetPrefixName1,
      StreetPrefixName2,
      StreetSuffixName1,
      StreetSuffixName2,
      DistrictName,
      VillageName,
       

      @ObjectModel.text.element: [ 'BankCountryName' ]
      @Consumption.valueHelpDefinition: [{ entity:  { name:  'I_CountryVH', element: 'Country' } }]
      Country,
      @UI.hidden: true
      @Semantics.text: true
      _Country._Text[1:Language = $session.system_language].CountryShortName                            as BankCountryName,


      //@ObjectModel.foreignKey.association: '_Country'

      //  Country,

      //      @ObjectModel.foreignKey.association: '_FormOfAddress'

      //      FormOfAddress,

      //AddresseeName1, -> BankNameInLocalScript,

      //AddresseeName2, -> BankNameInLocalScript,

      //AddresseeName3, -> BankBranchInLocalScript,

      //AddresseeName4, -> BankBranchInLocalScript,

      // Region,



      //   TaxJurisdiction,

      //   TransportZone,

      
      AddressSearchTerm1,
      AddressSearchTerm2,

      //   POBox,

      //   POBoxAddrNonDeliverableReason,

      //   POBoxIsWithoutNumber,

      //   POBoxPostalCode,

      POBoxLobbyName,
      POBoxDeviatingCityName,
      //   POBoxDeviatingRegion,

      //   POBoxDeviatingCountry,

      CareOfName,
      //   DeliveryServiceTypeCode,

      //   DeliveryServiceNumber,

      //   AddressTimeZone,

      SecondaryRegionName,
      TertiaryRegionName,


      AddressID, //adrc-ADDRNUMBER -> additional?


      /* Associations */
      //    BankScriptedAddress._Bank : redirected to parent C_BankTP,

      BankScriptedAddress._BankAddress : redirected to parent C_BankAddressTP,
      BankScriptedAddress._Bank        : redirected to C_BankTP,

      _AddressRepresentationCode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESSREPRESENTATION",
"I_ADDRESSREPRESENTATIONTEXT",
"I_COUNTRY",
"I_COUNTRYTEXT",
"R_BANKSCRIPTEDADDRESSTP"
],
"ASSOCIATED":
[
"C_BANKADDRESSTP",
"C_BANKTP",
"I_ADDRESSREPRESENTATION",
"R_BANKADDRESSTP",
"R_BANKTP"
],
"BASE":
[
"R_BANKSCRIPTEDADDRESSTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More