I_BusPartScriptedPersonAddrTP

//@AbapCatalog.sqlViewName: 'IBPSCRPTPERSADTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
//@ClientHandling.algorithm : #SESSION_VARIABLE

@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@EndUserText.label: 'Business partner scripted addresses'
define view entity I_BusPartScriptedPersonAddrTP
  as select from I_BusPartScriptedPersonAddress
  association [0..1] to I_AddressRepresentation             as _AddressRepresentation    on  $projection.AddressRepresentationCode = _AddressRepresentation.AddressRepresentationCode
  association [0..1] to I_BusinessPartnerFormOfAddress      as _FormOfAddress            on  $projection.FormOfAddress = _FormOfAddress.FormOfAddress
  association        to parent I_BusinessPartnerAddressTP_2 as _BusinessPartnerAddress   on  $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner
                                                                                         and $projection.AddressNumber = _BusinessPartnerAddress.AddressNumber
//                                                                                         and $projection.BPDrftUUID   = _BusinessPartnerAddress.BPDrftUUID

//                                                                                         and $projection.BPAddressDrftUUID   = _BusinessPartnerAddress.BPAddressDrftUUID

  association [1..1] to I_BusinessPartnerTP_2               as _BusinessPartner          on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
//                                                                                         and $projection.BPDrftUUID   = _BusinessPartner.BPDrftUUID

  association [0..1] to I_BusPartPrefixName                 as _BusPartPrefixName        on  $projection.LastNamePrefix = _BusPartPrefixName.LastNamePrefix
  association [0..1] to I_BusPartPrefixName                 as _LastNameSecondPrefixName on  $projection.LastNameSecondPrefix = _LastNameSecondPrefixName.LastNamePrefix
  association [0..1] to I_BusPartAcademicTitle              as _AcademicTitle            on  $projection.AcademicTitle = _AcademicTitle.AcademicTitle
  association [0..1] to I_BusPartAcademicTitle              as _AcademicTitle2           on  $projection.AcademicTitle2 = _AcademicTitle2.AcademicTitle
  association [0..1] to I_Country                           as _NameCountry              on  $projection.NameCountry = _NameCountry.Country
//  association [0..1] to I_BusPartNameFormat                 as _NameFormat               on  $projection.NameFormat  = _NameFormat.NameFormat

//                                                                                         and $projection.NameCountry = _NameFormat.Country

{
//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPDrftUUID,

//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPAddressDrftUUID,

//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPScriptedPersnAddrDrftUUID,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key BusinessPartner,
  key AddressNumber,
      @ObjectModel.foreignKey.association: '_AddressRepresentation'
  key AddressRepresentationCode,
      AddressRepresentationCode as AddrRepCodeForEditValue,
      tstmp_to_dats(ValidityStartDateTime,'UTC',  $session.client, 'NULL') as ValidityStartDate,
      tstmp_to_dats(ValidityEndDateTime,'UTC',  $session.client, 'NULL')   as ValidityEndDate,
      BusinessPartnerAddressUUID,
      CareOfName,
      AdditionalStreetSuffixName,
      //      CorrespondenceLanguage,

      PrfrdCommMediumType,
      POBox,
      POBoxIsWithoutNumber,
      POBoxPostalCode,
      POBoxLobbyName,
      POBoxDeviatingCityName,
      POBoxDeviatingRegion,
      POBoxDeviatingCountry,
      DeliveryServiceTypeCode,
      DeliveryServiceNumber,
      AddressTimeZone,
      FullName,
      CityName,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'DistrictName'
      District,
      DistrictName,
      HomeCityName,
      PostalCode,
      CompanyPostalCode,
      StreetName,
      StreetPrefixName,
      AdditionalStreetPrefixName,
      StreetSuffixName,
      HouseNumber,
      HouseNumberSupplementText,
      Building,
      Floor,
      RoomNumber,
      Country,
      Region,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'BPCountyText'
      County,
      BPCountyText,
      case
        when HouseNumber=''
            and StreetName=''
            and CityName=''
            and PostalCode=''
          then HouseNumber
          else
            case
              when HouseNumber=''
                  and StreetName=''
                then concat_with_space(PostalCode,CityName,1)
                else concat_with_space(HouseNumber,concat(
                      StreetName,concat_with_space(
                        ',',concat_with_space(PostalCode,CityName,1)
                        ,1)
                      )
                     ,1)
            end
      end                                                                  as FormattedAddress,

      TaxJurisdiction,
      TransportZone,
      @ObjectModel.foreignKey.association: '_FormOfAddress'
      FormOfAddress,
      Person,
      SearchTerm1,
      SearchTerm2,
      FirstName,
      LastName,
      BusinessPartnerBirthName,
      MiddleName,
      AdditionalLastName,
      PersonFullName,
      AcademicTitle,
      AcademicTitle2,
      LastNamePrefix,
      LastNameSecondPrefix,
      BusinessPartnerSupplementName,
      BusinessPartnerNicknameLabel,
      Initials,
      NameFormat,
      NameCountry,
      BPFirstNameSearchHelp,
      BPLastNameSearchHelp,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataControllerSet              as DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController1                as DataController1,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController2                as DataController2,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController3                as DataController3,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController4                as DataController4,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController5                as DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController6                as DataController6,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController7                as DataController7,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController8                as DataController8,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController9                as DataController9,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController10               as DataController10,
      
      _AddressRepresentation,
      _FormOfAddress,
      _BusinessPartnerAddress,
      _BPProtectedAddress,
      _BusinessPartner,
      _BusPartPrefixName,
      _LastNameSecondPrefixName,
      _AcademicTitle,
      _AcademicTitle2,
      _NameCountry,
      
      _BusinessPartner.AuthorizationGroup,
      _BusinessPartner.IsBusinessPurposeCompleted,
      _BPProtectedAddress.BPAddressIsProtected,
      
      _BusinessPartner._AuthorizationGroup as _AuthorizationGroup
      //_BPDataControllerUsage

      //      _NameFormat

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPPROTECTEDADDRESS",
"I_BUSINESSPARTNERTP_2",
"I_BUSPARTSCRIPTEDPERSONADDRESS"
],
"ASSOCIATED":
[
"I_ADDRESSREPRESENTATION",
"I_BPPROTECTEDADDRESS",
"I_BUSINESSPARTNERADDRESSTP_2",
"I_BUSINESSPARTNERFORMOFADDRESS",
"I_BUSINESSPARTNERTP_2",
"I_BUSPARTACADEMICTITLE",
"I_BUSPARTAUTHORIZATIONGROUP",
"I_BUSPARTPREFIXNAME",
"I_COUNTRY"
],
"BASE":
[
"I_BUSINESSPARTNERTP_2",
"I_BUSPARTSCRIPTEDPERSONADDRESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/