C_PurchaserValueHelp

@AbapCatalog.sqlViewName: 'CPURCHVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Purchaser Value Help'
@VDM.viewType: #CONSUMPTION
@ObjectModel: {
   usageType.serviceQuality: #C,
   usageType.sizeCategory: #S,
   usageType.dataClass: #MIXED
}
@AccessControl.privilegedAssociations:  [ '_UserContactCard' ]
@ObjectModel.dataCategory: #VALUE_HELP
define view C_PurchaserValueHelp as 
//select from C_SupplierInvoiceBlockedItem as Inv

select distinct from I_SupplierInvoice as Inv
//select from C_SupplierInvoiceList as Inv


  inner join I_SupplierInvoiceItemPurOrdRef as _InvToPurgDoc    on  Inv.SupplierInvoice = _InvToPurgDoc.SupplierInvoice
                                                               and Inv.FiscalYear      = _InvToPurgDoc.FiscalYear

  /*inner join I_SuplrInvcSeldPurgDocument   as _InvToPurgDoc    on  Inv.SupplierInvoice = _InvToPurgDoc.SupplierInvoice
                                                               and Inv.FiscalYear      = _InvToPurgDoc.FiscalYear*/  
                                                           
  inner join I_PurchaseOrder               as _PurchaseOrder   on  _InvToPurgDoc.PurchaseOrder   = _PurchaseOrder.PurchaseOrder
       
  association [1..1] to I_UserContactCard  as _UserContactCard on  $projection.CreatedByUser = _UserContactCard.ContactCardID                                                      
  //inner join I_UserContactCard             as _UserContactCard on  _PurchaseOrder.CreatedByUser = _UserContactCard.ContactCardID

{
  key Inv.SupplierInvoice,
  key Inv.FiscalYear,
  key _PurchaseOrder.CreatedByUser,     
      _PurchaseOrder.PurchaseOrderType,
      _PurchaseOrder.PurchasingGroup,
      _PurchaseOrder.PurchasingOrganization,
      
      _PurchaseOrder.IsEndOfPurposeBlocked,
      Inv.CompanyCode,  // no association->no VH handling

      _InvToPurgDoc.PurchaseOrder,                          
      /*@Search: {
         defaultSearchElement: true,
         ranking: #HIGH,
         fuzzinessThreshold: 0.8
      } */            
      _UserContactCard.FirstName,
  /*
      @Search: {
         defaultSearchElement: true,
         ranking: #HIGH,
         fuzzinessThreshold: 0.8
      }*/
      _UserContactCard.LastName,
  
      /*@UI.hidden: true*/
      _UserContactCard.FullName,
  
      _UserContactCard.Department,
  
      cast ( _UserContactCard.EmailAddress as apoc_email_address preserving type ) as EmailAddress,
  
      _UserContactCard.PhoneNumber,
  
      _UserContactCard.MobilePhoneNumber,      
      _UserContactCard        
      //, _BlockingReason.SuplrInvcItmBlockingReason

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDER",
"I_SUPPLIERINVOICE",
"I_SUPPLIERINVOICEITEMPURORDREF",
"I_USERCONTACTCARD"
],
"ASSOCIATED":
[
"I_USERCONTACTCARD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/