C_SlsPrcWrkflwEmailTemplate

DDL: C_SLSPRCWRKFLWEMAILTEMPLATE SQL: CSPRCWFEMLTMPL Type: view CONSUMPTION

Email Notification for Sales Price Workflow

C_SlsPrcWrkflwEmailTemplate is a Consumption CDS View that provides data about "Email Notification for Sales Price Workflow" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTask) and exposes 7 fields with key field WorkflowTaskInternalID. It has 1 association to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTask Workflowtask from

Associations (1)

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

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSPRCWFEMLTMPL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Email Notification for Sales Price Workflow view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID
SalesPriceApprovalRequest SalesPriceApprovalRequest SalesPriceApprovalRequest
ConditionType SalesPriceApprovalRequest ConditionType
SlsPrcWrkflwTskCreationUTCDate
WorkflowTaskPriority I_WorkflowTask WorkflowTaskPriority
WorkflowTaskStatus I_WorkflowTask WorkflowTaskStatus
WorkflowTaskURL _WorkflowTaskURL WorkflowTaskURL 
@AbapCatalog.sqlViewName: 'CSPRCWFEMLTMPL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Email Notification for Sales Price Workflow'
@VDM.viewType : #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType : {
  serviceQuality: #D,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}

define view C_SlsPrcWrkflwEmailTemplate 
  as select from I_WorkflowTask as Workflowtask
  left outer to one join I_WorkflowTaskApplObject as WorkflowTaskApplObject on WorkflowTaskApplObject.WorkflowTaskInternalID = Workflowtask.WorkflowTaskInternalID
                                                                             and WorkflowTaskApplObject.SAPObjectNodeRepresentation   = 'SalesPriceApprovalRequest'
                                                                             and WorkflowTaskApplObject.TechnicalWrkflwObjectCategory = 'CL'
  left outer to one join I_SalesPriceApprovalRequest  as SalesPriceApprovalRequest      on SalesPriceApprovalRequest.SalesPriceApprovalRequest = WorkflowTaskApplObject.TechnicalWrkflwObject
  left outer to one join I_SalesPriceApprovalRequestURL as SalesPriceApprovalRequestURL     on SalesPriceApprovalRequestURL.SalesPriceApprovalRequest = WorkflowTaskApplObject.TechnicalWrkflwObject
  association [0..1] to  I_WorkflowTaskURL        as _WorkflowTaskURL       on $projection.WorkflowTaskInternalID  = _WorkflowTaskURL.WorkflowTaskInternalID
{
  key Workflowtask.WorkflowTaskInternalID,
      SalesPriceApprovalRequest.SalesPriceApprovalRequest,
      SalesPriceApprovalRequest.ConditionType,  
    cast(tstmp_to_dats( Workflowtask.WrkflwTskCreationUTCDateTime, 'UTC', $session.client, 'NULL' ) as sww_lsd ) as SlsPrcWrkflwTskCreationUTCDate ,
      Workflowtask.WorkflowTaskPriority,
      Workflowtask.WorkflowTaskStatus,
      _WorkflowTaskURL.WorkflowTaskURL   
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESPRICEAPPROVALREQUEST",
"I_SALESPRICEAPPROVALREQUESTURL",
"I_WORKFLOWTASK",
"I_WORKFLOWTASKAPPLOBJECT",
"I_WORKFLOWTASKURL"
],
"ASSOCIATED":
[
"I_WORKFLOWTASKURL"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More