C_CADocumentWrkflwEmlTmpl

DDL: C_CADOCUMENTWRKFLWEMLTMPL Type: view CONSUMPTION
9 Fields 1 Data Sources 1 Associations

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.

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 Work Item ID
CADocumentNumber _CADocument CADocumentNumber Document Number
TransactionCurrency _CADocument TransactionCurrency Transaction Currency
CreationDate _CADocument CreationDate Time Stamp
DocumentDate _CADocument DocumentDate Journal Entry Date
CAPostingDate _CADocument CAPostingDate Posting Date
CADocumentType _CADocument CADocumentType Document Type
CAReconciliationKey _CADocument CAReconciliationKey Reconcil. Key
WorkflowTaskURL _WorkflowTaskURL WorkflowTaskURL

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_CADocumentWrkflwEmlTmpl.
-- 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.

CREATE VIEW C_CADocumentWrkflwEmlTmpl AS
SELECT
  Workflowtask.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _CADocument.CADocumentNumber AS CADocumentNumber,
  _CADocument.TransactionCurrency AS TransactionCurrency,
  _CADocument.CreationDate AS CreationDate,
  _CADocument.DocumentDate AS DocumentDate,
  _CADocument.CAPostingDate AS CAPostingDate,
  _CADocument.CADocumentType AS CADocumentType,
  _CADocument.CAReconciliationKey AS CAReconciliationKey,
  _WorkflowTaskURL.WorkflowTaskURL AS WorkflowTaskURL
FROM I_WorkflowTask AS Workflowtask
LEFT OUTER JOIN I_CAWorkflowTaskURL AS _WorkflowTaskURL ON _WorkflowTaskURL.WorkflowTaskInternalID = Workflowtask.WorkflowTaskInternalID  -- association [0..1]
;

Learn More