R_SuplrListBusPartnerDetails

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@Search.searchable: true
@EndUserText.label: 'Business Partner Details for Suplr List'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.sqlViewName: 'RSUPLRLBPDET'
@AbapCatalog.compiler.compareFilter:true
@ObjectModel:{
               usageType.dataClass: #TRANSACTIONAL,
               usageType.serviceQuality: #C,
               usageType.sizeCategory: #L
               }
@ObjectModel.semanticKey: ['Supplier']
@ObjectModel.representativeKey: 'Supplier'

@ObjectModel.dataCategory: #VALUE_HELP
@AccessControl.privilegedAssociations: ['_Address']



define root view R_SuplrListBusPartnerDetails

  as select from I_Supplier as _Supplier

  //  association [0..*] to I_BusinessPartnerSuplrCo      as _BusinessPartnerSuplrCo      on $projection.Supplier = _BusinessPartnerSuplrCo.Supplier


  //  association [1..1] to I_Supplier_to_BusinessPartner as _Supplier_to_BusinessPartner on  $projection.Supplier = _Supplier_to_BusinessPartner.Supplier

  association [1..1] to I_CountryText                as _CountryText                on  $projection.Country   = _CountryText.Country
                                                                                    and _CountryText.Language = $session.system_language
  association [1..1] to I_SupplierToBusinessPartner  as _SupplierToBusinessPartner  on  $projection.Supplier = _SupplierToBusinessPartner.Supplier
  association [1..1] to I_Address_2                    as _Address                    on  $projection.AddressID = _Address.AddressID
                                                                                      and _Address.AddressPersonID = ''
                                                                                      and _Address.AddressRepresentationCode = '' 
  association [0..1] to I_RegionText                 as _RegionText                 on  $projection.Region   = _RegionText.Region
                                                                                    and $projection.Country  = _RegionText.Country
                                                                                    and _RegionText.Language = $session.system_language
  association [0..1] to I_SuplrListSuplrCountryGroup as _SuplrListSuplrCountryGroup on  $projection.Country = _SuplrListSuplrCountryGroup.Country
  association [0..1] to I_SupplierAccountGroupText   as _AccountGroupText           on  $projection.SupplierAccountGroup = _AccountGroupText.SupplierAccountGroup
                                                                                    and _AccountGroupText.Language       = $session.system_language

{

        @ObjectModel.text.element:  [ 'SupplierName' ]
        @Search: { defaultSearchElement: true, ranking: #HIGH }
  key   Supplier,

        @ObjectModel.text.element:  [ 'OrganizationBPName1' ]
        @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
        _SupplierToBusinessPartner._BusinessPartner.BusinessPartner,

        // _BusinessPartnerSuplrCo.CompanyCode,

        _SupplierToBusinessPartner.BusinessPartnerUUID,

        @Semantics.text: true
        SupplierName,

        @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
        _SupplierToBusinessPartner._BusinessPartner.BusinessPartnerIsBlocked,

        AddressID,


        // @ObjectModel.text.association: '_CountryText'

        _Supplier.Country,
        //   @ObjectModel.text.association: '_RegionText'

        _Supplier.Region,

        //_Address.County,


        @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
        _SupplierToBusinessPartner._BusinessPartner.FirstName,

        @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
        _SupplierToBusinessPartner._BusinessPartner.LastName,

        @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
        @Semantics.text: true
        OrganizationBPName1,

        @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
        OrganizationBPName2,

        @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
        _SupplierToBusinessPartner._BusinessPartner.OrganizationBPName3,

        @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
        _SupplierToBusinessPartner._BusinessPartner.OrganizationBPName4,

        //Supplier.PurchasingIsBlocked,


        _SuplrListSuplrCountryGroup.SupplierCountryGroup,

        AuthorizationGroup,
        SupplierAccountGroup,
        _Address,
        _RegionText,
        _SuplrListSuplrCountryGroup,
        //    @ObjectModel.association.type: [#TO_COMPOSITION_CHILD] //compositional relationship to text view

        _CountryText,
        _AccountGroupText,
        //        _Supplier_to_BusinessPartner,//to be removed

        _SupplierToBusinessPartner
}