C_BusSolnOrdEmailDataProvider

@AbapCatalog.sqlViewName: 'CSOLNEMAILOM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true


@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
  semanticKey: 'BusinessSolutionOrder',
  representativeKey: 'BusinessSolutionOrder',
  usageType: {serviceQuality: #C, sizeCategory: #XXL, dataClass: #TRANSACTIONAL}
}
@ClientHandling: {
  algorithm: #SESSION_VARIABLE
}

@VDM: {
  viewType: #CONSUMPTION
}
@EndUserText.label: 'Email data provider for Solution Order OM'
define view C_BusSolnOrdEmailDataProvider as select from I_ServiceDocumentEnhcd   
 
{
  key cast(ServiceDocument as bus_solution_order_id)                             as BusinessSolutionOrder,
  @Consumption.hidden: true
  key ServiceObjectType,
      cast( ServiceDocumentDescription as bus_soln_description )                 as BusSolnOrdDescription,
      cast(_SoldToParty.BusinessPartnerName as vdm_sold_to_name)                 as SoldToPartyName,
      cast(_ContactPerson.BusinessPartnerName as crms4_contact_person_name)      as ContactPersonName,
      cast(_ShipToParty.BusinessPartnerName as ship_to_name)                     as ShipToPartyName,
      cast(_RespEmployee.BusinessPartnerName as resp_empl_name)                  as ResponsibleEmployeeName,
     
                    
   RequestedServiceStartDate,
    ServiceDocNetAmount,
    ServiceDocGrossAmount,
    TransactionCurrency,
    
      // The following fields are required for authorization checks

   
      @Consumption.hidden: true
  ServiceDocumentType,
      @Consumption.hidden: true
      SalesOrganization,
      @Consumption.hidden: true
     SalesOffice,
      @Consumption.hidden: true
      SalesGroup,
      @Consumption.hidden: true
      DistributionChannel,
      @Consumption.hidden: true
      Division,
      @Consumption.hidden: true
     ResponsibleEmployee,
      @Consumption.hidden: true
     SalesOrganizationOrgUnitID,
      @Consumption.hidden: true
     SalesOfficeOrgUnitID,
      @Consumption.hidden: true
    SalesGroupOrgUnitID,
      @Consumption.hidden: true
     ServiceOrganization
}

where
      I_ServiceDocumentEnhcd.ServiceObjectType          = 'BUS2000172'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_SERVICEDOCUMENTENHCD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/