C_CADocumentWrkflwEmlTmpl

DDL: C_CADOCUMENTWRKFLWEMLTMPL Type: view CONSUMPTION

CA Document Workflow Email Template

C_CADocumentWrkflwEmlTmpl is a Consumption CDS View that provides data about "CA Document Workflow Email Template" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTask) and exposes 9 fields with key field WorkflowTaskInternalID. It has 1 association to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTask Workflowtask from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CAWorkflowTaskURL _WorkflowTaskURL _WorkflowTaskURL.WorkflowTaskInternalID = Workflowtask.WorkflowTaskInternalID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCADOCWFEMLTMPL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label CA Document Workflow Email Template view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID
CADocumentNumber _CADocument CADocumentNumber
TransactionCurrency _CADocument TransactionCurrency
CreationDate _CADocument CreationDate
DocumentDate _CADocument DocumentDate
CAPostingDate _CADocument CAPostingDate
CADocumentType _CADocument CADocumentType
CAReconciliationKey _CADocument CAReconciliationKey
WorkflowTaskURL _WorkflowTaskURL WorkflowTaskURL 
@AbapCatalog: {
  sqlViewName: 'CCADOCWFEMLTMPL',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'CA Document Workflow Email Template'
@ObjectModel.usageType : {
  serviceQuality: #D,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType : #CONSUMPTION


define view C_CADocumentWrkflwEmlTmpl
  as select from           I_WorkflowTask              as Workflowtask
    left outer to one join I_WorkflowTaskApplObject    as _WorkflowTaskApplObject on Workflowtask.WorkflowTaskInternalID = _WorkflowTaskApplObject.WorkflowTaskInternalID
    left outer to one join I_CADocumentHeader   as _CADocument        on _CADocument.CADocumentNumber = _WorkflowTaskApplObject.TechnicalWrkflwObject
  association [0..1] to I_CAWorkflowTaskURL as _WorkflowTaskURL on _WorkflowTaskURL.WorkflowTaskInternalID = Workflowtask.WorkflowTaskInternalID
{
  key Workflowtask.WorkflowTaskInternalID,
      _CADocument.CADocumentNumber,
      _CADocument.TransactionCurrency,
      _CADocument.CreationDate,
      _CADocument.DocumentDate,
      _CADocument.CAPostingDate,
      _CADocument.CADocumentType,
      _CADocument.CAReconciliationKey,
      _WorkflowTaskURL.WorkflowTaskURL
}

where
  (
       _WorkflowTaskApplObject.WorkflowObjectRole            = '01'
    or _WorkflowTaskApplObject.WorkflowObjectRole            = '99'
  )
  and  _WorkflowTaskApplObject.SAPObjectNodeRepresentation   = 'ContrAcctgDocument'
  and  _WorkflowTaskApplObject.TechnicalWrkflwObjectCategory = 'CL'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CADOCUMENTHEADER",
"I_CAWORKFLOWTASKURL",
"I_WORKFLOWTASK",
"I_WORKFLOWTASKAPPLOBJECT"
],
"ASSOCIATED":
[
"I_CAWORKFLOWTASKURL"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More