C_SrvcQtanWorkflowEmail

@AbapCatalog.sqlViewName: 'CSERVQTANWFEML'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Email Data Provider for workflow'
@ObjectModel: {
    usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #D,
                sizeCategory:   #L}
}
@AccessControl.personalData.blocking:#REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
define view C_SrvcQtanWorkflowEmail
  as select from    I_WorkflowTask              as _Workflowtask
    inner join      I_WorkflowTaskApplObject    as _WorkflowTaskApplObject    on  _WorkflowTaskApplObject.WorkflowTaskInternalID        = _Workflowtask.WorkflowTaskInternalID
                                                                              and _WorkflowTaskApplObject.WorkflowObjectRole            = '01'
                                                                              and _WorkflowTaskApplObject.SAPObjectNodeRepresentation   = 'ServiceQuotation'
                                                                              and _WorkflowTaskApplObject.TechnicalWrkflwObjectCategory = 'CL'
    left outer to one join  C_SrvcQtanEmailDataProvider as _SrvcQtanEmailDataProvider on _SrvcQtanEmailDataProvider.ServiceQuotation = _WorkflowTaskApplObject.TechnicalWrkflwObject
  association [0..1] to I_WorkflowTaskURL as _WorkflowTaskURL on $projection.WorkflowTaskInternalID = _WorkflowTaskURL.WorkflowTaskInternalID
{
  key _Workflowtask.WorkflowTaskInternalID,
      _Workflowtask.WorkflowTaskType,
      _Workflowtask.WorkflowTaskPriority,
      _Workflowtask.WorkflowTaskStatus,
      _Workflowtask.WrkflwTskCreationUTCDateTime,
      _Workflowtask.WrkflwTskCompletionUTCDateTime,
      _Workflowtask.TopLevelWorkflowTask,
      _Workflowtask.ParentWorkflowTask,
      _Workflowtask.WorkflowTaskCreatedByUser,
      _Workflowtask.WorkflowTaskCurrentUser,
      _Workflowtask.WorkflowTaskDefinition,
      //      _Workflowtask.WorkflowTaskDefinitionObjType,

      _Workflowtask.WorkflowTaskDefinitionObject,
      _Workflowtask.TopLevelWorkflowTaskDefinition,
      _Workflowtask.TopLevelWrkflwTskDefObjType,
      _Workflowtask.TopLevelWrkflwTskDefObject,
      _Workflowtask.WorkflowTaskStepType,
      _Workflowtask.WorkflowTaskProcessorRole,
      //      _Workflowtask.WorkflowTaskDefinitionVersion,

      //      _Workflowtask.WorkflowTaskDefinitionType,

      _Workflowtask.WorkflowTaskResult,
      _Workflowtask._TaskApplicationLeadingObject,
      _Workflowtask._TaskApplicationObject,
      //      _Workflowtask._TaskDefinition,

      _Workflowtask._TaskDueDate,
      _Workflowtask._TaskPriority,
      _Workflowtask._TaskRecipient,
      _Workflowtask._TaskStartEvent,
      _Workflowtask._TaskStatus,
      _Workflowtask._TaskTitle,
      _Workflowtask._TaskType,
      _Workflowtask._TopLevelTaskDefinition,
      //      _Workflowtask._WorkflowStepType,

      //      _Workflowtask._WorkflowTaskStepResult,

      //      _Workflowtask._WorkflowTaskResult._WorkflowTaskResultReason.WorkflowTaskResultReason,

      //      _Workflowtask._WorkflowTaskResult._WorkflowTaskResultReason._WorkflowTaskResultReasonText[1:Language=$session.system_language].WorkflowTaskResultReasonText,

      //      _WorkflowTaskURL.WorkflowTaskURL,

      //      cast(tstmp_to_dats( _Workflowtask.WrkflwTskCreationUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_lsd ) as SrvcQtanApprvlWfTskCrtnUTCDate,

      cast(tstmp_to_tims( _Workflowtask.WrkflwTskCreationUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_lst ) as SrvcQtanApprvlWfTskCrtnUTCTime,
      //Deadline Due Time

      cast(tstmp_to_dats( _TaskDueDate.WorkflowTaskDueUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_led )    as SrvcQtanApprvlWfTskDueUTCDate,
      cast(tstmp_to_tims( _TaskDueDate.WorkflowTaskDueUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_let )    as SrvcQtanApprvlWfTskDueUTCTime,
      // Service Quotation Details

      _SrvcQtanEmailDataProvider.ServiceQuotation,
      _SrvcQtanEmailDataProvider.ServiceQuotationDescription,
      _SrvcQtanEmailDataProvider.SoldToPartyName,
      _SrvcQtanEmailDataProvider.ContactPersonName,
      _SrvcQtanEmailDataProvider.ShipToPartyName,
      _SrvcQtanEmailDataProvider.ResponsibleEmployeeName,
      //      _SrvcQtanEmailDataProvider.SrvcQuotationValidityStartDate,

      //      _SrvcQtanEmailDataProvider.SrvcQuotationValidityEndDate,

      //      _SrvcQtanEmailDataProvider.RequestedServiceStartDate,

      _SrvcQtanEmailDataProvider.ServiceDocNetAmount,
      _SrvcQtanEmailDataProvider.ServiceDocGrossAmount,
      _SrvcQtanEmailDataProvider.TransactionCurrency,
      _SrvcQtanEmailDataProvider.Equipment,
      _SrvcQtanEmailDataProvider.ProductID,
      _SrvcQtanEmailDataProvider.SerialNumber,
      // The following fields are required for authorization checks

      @Consumption.hidden: true
      _SrvcQtanEmailDataProvider.ServiceObjectType,
      @Consumption.hidden: true
      _SrvcQtanEmailDataProvider.ServiceDocumentType,
      @Consumption.hidden: true
      _SrvcQtanEmailDataProvider.SalesOrganization,
      @Consumption.hidden: true
      _SrvcQtanEmailDataProvider.SalesOffice,
      @Consumption.hidden: true
      _SrvcQtanEmailDataProvider.SalesGroup,
      @Consumption.hidden: true
      _SrvcQtanEmailDataProvider.DistributionChannel,
      @Consumption.hidden: true
      _SrvcQtanEmailDataProvider.Division,
      //   @Consumption.hidden: true

      //   _SrvcQtanEmailDataProvider.ResponsibleEmployee,

      @Consumption.hidden: true
      _SrvcQtanEmailDataProvider.SalesOrganizationOrgUnitID,
      @Consumption.hidden: true
      _SrvcQtanEmailDataProvider.SalesOfficeOrgUnitID,
      @Consumption.hidden: true
      _SrvcQtanEmailDataProvider.SalesGroupOrgUnitID,
      @Consumption.hidden: true
      _SrvcQtanEmailDataProvider.ServiceOrganization

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_SRVCQTANEMAILDATAPROVIDER",
"I_WORKFLOWTASK",
"I_WORKFLOWTASKAPPLOBJECT",
"I_WORKFLOWTASKDUEDATE"
],
"ASSOCIATED":
[
"I_WORKFLOWTASKAPPLOBJECT",
"I_WORKFLOWTASKDEFINITION",
"I_WORKFLOWTASKDUEDATE",
"I_WORKFLOWTASKLEADINGAPPLOBJ",
"I_WORKFLOWTASKPRIORITY",
"I_WORKFLOWTASKRECIPIENT",
"I_WORKFLOWTASKSTARTEVENT",
"I_WORKFLOWTASKSTATUS",
"I_WORKFLOWTASKTITLE",
"I_WORKFLOWTASKTYPE",
"I_WORKFLOWTASKURL"
],
"BASE":
[
"I_WORKFLOWTASK"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/