C_SrvcQtanWorkflowEmail

DDL: C_SRVCQTANWORKFLOWEMAIL SQL: CSERVQTANWFEML Type: view CONSUMPTION
54 Fields 2 Data Sources 1 Associations

Email Data Provider for workflow

C_SrvcQtanWorkflowEmail is a Consumption CDS View that provides data about "Email Data Provider for workflow" in SAP S/4HANA. It reads from 2 data sources (I_WorkflowTask, I_WorkflowTaskApplObject) and exposes 54 fields with key field WorkflowTaskInternalID. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_WorkflowTask _Workflowtask from
I_WorkflowTaskApplObject _WorkflowTaskApplObject inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_WorkflowTaskURL _WorkflowTaskURL $projection.WorkflowTaskInternalID = _WorkflowTaskURL.WorkflowTaskInternalID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CSERVQTANWFEML view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Email Data Provider for workflow view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID Work Item ID
WorkflowTaskType I_WorkflowTask WorkflowTaskType Type
WorkflowTaskPriority I_WorkflowTask WorkflowTaskPriority Priority
WorkflowTaskStatus I_WorkflowTask WorkflowTaskStatus Status
WrkflwTskCreationUTCDateTime I_WorkflowTask WrkflwTskCreationUTCDateTime Created On
WrkflwTskCompletionUTCDateTime I_WorkflowTask WrkflwTskCompletionUTCDateTime Completed
TopLevelWorkflowTask I_WorkflowTask TopLevelWorkflowTask Top Level Workflow
ParentWorkflowTask I_WorkflowTask ParentWorkflowTask Workflow
WorkflowTaskCreatedByUser I_WorkflowTask WorkflowTaskCreatedByUser Creator
WorkflowTaskCurrentUser I_WorkflowTask WorkflowTaskCurrentUser Agent
WorkflowTaskDefinition I_WorkflowTask WorkflowTaskDefinition Task
WorkflowTaskDefinitionObject I_WorkflowTask WorkflowTaskDefinitionObject
TopLevelWorkflowTaskDefinition I_WorkflowTask TopLevelWorkflowTaskDefinition Top Task
TopLevelWrkflwTskDefObjType I_WorkflowTask TopLevelWrkflwTskDefObjType
TopLevelWrkflwTskDefObject I_WorkflowTask TopLevelWrkflwTskDefObject
WorkflowTaskStepType I_WorkflowTask WorkflowTaskStepType WF Step ID
WorkflowTaskProcessorRole I_WorkflowTask WorkflowTaskProcessorRole Agent Rule Id
WorkflowTaskResult I_WorkflowTask WorkflowTaskResult
_TaskApplicationLeadingObject I_WorkflowTask _TaskApplicationLeadingObject
_TaskApplicationObject I_WorkflowTask _TaskApplicationObject
_TaskDueDate I_WorkflowTask _TaskDueDate
_TaskPriority I_WorkflowTask _TaskPriority
_TaskRecipient I_WorkflowTask _TaskRecipient
_TaskStartEvent I_WorkflowTask _TaskStartEvent
_TaskStatus I_WorkflowTask _TaskStatus
_TaskTitle I_WorkflowTask _TaskTitle
_TaskType I_WorkflowTask _TaskType
_TopLevelTaskDefinition I_WorkflowTask _TopLevelTaskDefinition
SrvcQtanApprvlWfTskCrtnUTCTime
SrvcQtanApprvlWfTskDueUTCDate
SrvcQtanApprvlWfTskDueUTCTime
ServiceQuotation _SrvcQtanEmailDataProvider ServiceQuotation
ServiceQuotationDescription _SrvcQtanEmailDataProvider ServiceQuotationDescription
SoldToPartyName _SrvcQtanEmailDataProvider SoldToPartyName Sold-to Party Name
ContactPersonName _SrvcQtanEmailDataProvider ContactPersonName Full Name
ShipToPartyName _SrvcQtanEmailDataProvider ShipToPartyName Ship-To Party Name
ResponsibleEmployeeName _SrvcQtanEmailDataProvider ResponsibleEmployeeName
ServiceDocNetAmount _SrvcQtanEmailDataProvider ServiceDocNetAmount
ServiceDocGrossAmount _SrvcQtanEmailDataProvider ServiceDocGrossAmount
TransactionCurrency _SrvcQtanEmailDataProvider TransactionCurrency Transaction Currency
Equipment _SrvcQtanEmailDataProvider Equipment Equipment check
ProductID _SrvcQtanEmailDataProvider ProductID Product ID
SerialNumber _SrvcQtanEmailDataProvider SerialNumber Serial Number
ServiceObjectType _SrvcQtanEmailDataProvider ServiceObjectType Object Type
ServiceDocumentType _SrvcQtanEmailDataProvider ServiceDocumentType Transaction Type
SalesOrganization _SrvcQtanEmailDataProvider SalesOrganization Sales Organization
SalesOffice _SrvcQtanEmailDataProvider SalesOffice Sales Office
SalesGroup _SrvcQtanEmailDataProvider SalesGroup Sales Group
DistributionChannel _SrvcQtanEmailDataProvider DistributionChannel RefDistCh-Cust/Mat.
Division _SrvcQtanEmailDataProvider Division Internal Division ID
SalesOrganizationOrgUnitID _SrvcQtanEmailDataProvider SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID _SrvcQtanEmailDataProvider SalesOfficeOrgUnitID
SalesGroupOrgUnitID _SrvcQtanEmailDataProvider SalesGroupOrgUnitID
ServiceOrganization _SrvcQtanEmailDataProvider ServiceOrganization

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_SrvcQtanWorkflowEmail.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CSERVQTANWFEML

CREATE VIEW C_SrvcQtanWorkflowEmail AS
SELECT
  _Workflowtask.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _Workflowtask.WorkflowTaskType AS WorkflowTaskType,
  _Workflowtask.WorkflowTaskPriority AS WorkflowTaskPriority,
  _Workflowtask.WorkflowTaskStatus AS WorkflowTaskStatus,
  _Workflowtask.WrkflwTskCreationUTCDateTime AS WrkflwTskCreationUTCDateTime,
  _Workflowtask.WrkflwTskCompletionUTCDateTime AS WrkflwTskCompletionUTCDateTime,
  _Workflowtask.TopLevelWorkflowTask AS TopLevelWorkflowTask,
  _Workflowtask.ParentWorkflowTask AS ParentWorkflowTask,
  _Workflowtask.WorkflowTaskCreatedByUser AS WorkflowTaskCreatedByUser,
  _Workflowtask.WorkflowTaskCurrentUser AS WorkflowTaskCurrentUser,
  _Workflowtask.WorkflowTaskDefinition AS WorkflowTaskDefinition,
  _Workflowtask.WorkflowTaskDefinitionObject AS WorkflowTaskDefinitionObject,
  _Workflowtask.TopLevelWorkflowTaskDefinition AS TopLevelWorkflowTaskDefinition,
  _Workflowtask.TopLevelWrkflwTskDefObjType AS TopLevelWrkflwTskDefObjType,
  _Workflowtask.TopLevelWrkflwTskDefObject AS TopLevelWrkflwTskDefObject,
  _Workflowtask.WorkflowTaskStepType AS WorkflowTaskStepType,
  _Workflowtask.WorkflowTaskProcessorRole AS WorkflowTaskProcessorRole,
  _Workflowtask.WorkflowTaskResult AS WorkflowTaskResult,
  _Workflowtask._TaskApplicationLeadingObject AS _TaskApplicationLeadingObject,
  _Workflowtask._TaskApplicationObject AS _TaskApplicationObject,
  _Workflowtask._TaskDueDate AS _TaskDueDate,
  _Workflowtask._TaskPriority AS _TaskPriority,
  _Workflowtask._TaskRecipient AS _TaskRecipient,
  _Workflowtask._TaskStartEvent AS _TaskStartEvent,
  _Workflowtask._TaskStatus AS _TaskStatus,
  _Workflowtask._TaskTitle AS _TaskTitle,
  _Workflowtask._TaskType AS _TaskType,
  _Workflowtask._TopLevelTaskDefinition AS _TopLevelTaskDefinition,
  cast(tstmp_to_tims( _Workflowtask.WrkflwTskCreationUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_lst ) AS SrvcQtanApprvlWfTskCrtnUTCTime,
  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,
  _SrvcQtanEmailDataProvider.ServiceQuotation AS ServiceQuotation,
  _SrvcQtanEmailDataProvider.ServiceQuotationDescription AS ServiceQuotationDescription,
  _SrvcQtanEmailDataProvider.SoldToPartyName AS SoldToPartyName,
  _SrvcQtanEmailDataProvider.ContactPersonName AS ContactPersonName,
  _SrvcQtanEmailDataProvider.ShipToPartyName AS ShipToPartyName,
  _SrvcQtanEmailDataProvider.ResponsibleEmployeeName AS ResponsibleEmployeeName,
  _SrvcQtanEmailDataProvider.ServiceDocNetAmount AS ServiceDocNetAmount,
  _SrvcQtanEmailDataProvider.ServiceDocGrossAmount AS ServiceDocGrossAmount,
  _SrvcQtanEmailDataProvider.TransactionCurrency AS TransactionCurrency,
  _SrvcQtanEmailDataProvider.Equipment AS Equipment,
  _SrvcQtanEmailDataProvider.ProductID AS ProductID,
  _SrvcQtanEmailDataProvider.SerialNumber AS SerialNumber,
  _SrvcQtanEmailDataProvider.ServiceObjectType AS ServiceObjectType,
  _SrvcQtanEmailDataProvider.ServiceDocumentType AS ServiceDocumentType,
  _SrvcQtanEmailDataProvider.SalesOrganization AS SalesOrganization,
  _SrvcQtanEmailDataProvider.SalesOffice AS SalesOffice,
  _SrvcQtanEmailDataProvider.SalesGroup AS SalesGroup,
  _SrvcQtanEmailDataProvider.DistributionChannel AS DistributionChannel,
  _SrvcQtanEmailDataProvider.Division AS Division,
  _SrvcQtanEmailDataProvider.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  _SrvcQtanEmailDataProvider.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  _SrvcQtanEmailDataProvider.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  _SrvcQtanEmailDataProvider.ServiceOrganization AS ServiceOrganization
FROM I_WorkflowTask AS _Workflowtask
INNER JOIN I_WorkflowTaskApplObject AS _WorkflowTaskApplObject ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkflowTaskURL AS _WorkflowTaskURL ON WorkflowTaskInternalID = _WorkflowTaskURL.WorkflowTaskInternalID  -- association [0..1]
;

Learn More