C_ADM_WORKFLOW

DDL: C_ADM_WORKFLOW SQL: CADMWRKFLW Type: view CONSUMPTION
23 Fields 2 Data Sources 1 Associations

Flexible Workflow

C_ADM_WORKFLOW is a Consumption CDS View that provides data about "Flexible Workflow" in SAP S/4HANA. It reads from 2 data sources (I_WorkflowScenarioApplComp, I_ADM_WORKFLOW) and exposes 23 fields with key field WorkflowInternalID. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_WorkflowScenarioApplComp _Component left_outer
I_ADM_WORKFLOW Workflow from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_ADM_WORKFLOW_TASK _WorkflowTaskDetails $projection.WorkflowInternalID = _WorkflowTaskDetails.WorkflowInternalID

Annotations (24)

NameValueLevelField
AbapCatalog.sqlViewName CADMWRKFLW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Flexible Workflow view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingDelegated false view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
Search.searchable true view
Consumption.semanticObject WorkflowAdministration view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
UI.headerInfo.typeName Workflow view
UI.headerInfo.typeNamePlural Workflows view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value WorkflowInternalID view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value WrkflwScenName view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY WorkflowInternalID I_ADM_WORKFLOW WorkflowInternalID
WorkflowScenarioDefinition I_ADM_WORKFLOW WorkflowScenarioDefinition Task
TechnicalWrkflwObject I_ADM_WORKFLOW TechnicalWrkflwObject
WrkflwScenarioNameendasWrkflwScenName
WrkflwScenNameSearch I_ADM_WORKFLOW WrkflwScenarioName
WrkflwScenNameFBNameSearch I_ADM_WORKFLOW WrkflwScenNameFallBack
SAPObjectNodeRepresentation I_ADM_WORKFLOW SAPObjectNodeRepresentation
WorkflowStatus I_ADM_WORKFLOW WorkflowStatus Status
WrkflwTskCreationDate I_ADM_WORKFLOW WrkflwTskCreationDate
WrkflwTskCompletionDate I_ADM_WORKFLOW WrkflwTskCompletionDate
WrkflwChangedOn I_ADM_WORKFLOW WrkflwChangedOn
WrkflwTskCreationTime I_ADM_WORKFLOW WrkflwTskCreationTime Created On
WrkflwTskCompletionTime I_ADM_WORKFLOW WrkflwTskCompletionTime Completed
WrkflwChangedAt I_ADM_WORKFLOW WrkflwChangedAt Modified at
CreatedBy I_ADM_WORKFLOW CreatedBy User Name
Criticality I_ADM_WORKFLOW Criticality Status Rating
_WorkflowStatus I_ADM_WORKFLOW _WorkflowStatus
_WorkflowTaskDetails _WorkflowTaskDetails
WorkflowScenarioDefinition1asScenario
BusinessObject
_WorkflowLog I_ADM_WORKFLOW _WorkflowLog
WorkflowSubject
SAPApplicationComponent I_WorkflowScenarioApplComp SAPApplicationComponent

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_ADM_WORKFLOW.
-- 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: CADMWRKFLW

CREATE VIEW C_ADM_WORKFLOW AS
SELECT
  Workflow.WorkflowInternalID AS WorkflowInternalID,
  Workflow.WorkflowScenarioDefinition AS WorkflowScenarioDefinition,
  Workflow.TechnicalWrkflwObject AS TechnicalWrkflwObject,
  case when Workflow.WrkflwScenarioName is initial or Workflow.WrkflwScenarioName is null then Workflow.WrkflwScenNameFallBack else Workflow.WrkflwScenarioName end as WrkflwScenName AS WrkflwScenarioNameendasWrkflwScenName,
  Workflow.WrkflwScenarioName AS WrkflwScenNameSearch,
  Workflow.WrkflwScenNameFallBack AS WrkflwScenNameFBNameSearch,
  Workflow.SAPObjectNodeRepresentation AS SAPObjectNodeRepresentation,
  Workflow.WorkflowStatus AS WorkflowStatus,
  Workflow.WrkflwTskCreationDate AS WrkflwTskCreationDate,
  Workflow.WrkflwTskCompletionDate AS WrkflwTskCompletionDate,
  Workflow.WrkflwChangedOn AS WrkflwChangedOn,
  Workflow.WrkflwTskCreationTime AS WrkflwTskCreationTime,
  Workflow.WrkflwTskCompletionTime AS WrkflwTskCompletionTime,
  Workflow.WrkflwChangedAt AS WrkflwChangedAt,
  Workflow.CreatedBy AS CreatedBy,
  Workflow.Criticality AS Criticality,
  Workflow._WorkflowStatus AS _WorkflowStatus,
  concat_with_space(cast( case when Workflow.WrkflwScenarioName is initial or Workflow.WrkflwScenarioName is null then Workflow.WrkflwScenNameFallBack else Workflow.WrkflwScenarioName end as swf_flex_scenario_name preserving type), concat('(', concat(Workflow.WorkflowScenarioDefinition, ')')), 1) as Scenario AS WorkflowScenarioDefinition1asScenario,
  concat_with_space(Workflow.SAPObjectNodeRepresentation, concat('(', concat(Workflow.TechnicalWrkflwObject, ')')), 1) AS BusinessObject,
  Workflow._WorkflowLog AS _WorkflowLog,
  Workflow._WorkflowTitle.wi_text AS WorkflowSubject,
  _Component.SAPApplicationComponent AS SAPApplicationComponent
FROM I_ADM_WORKFLOW AS Workflow
LEFT OUTER JOIN I_WorkflowScenarioApplComp AS _Component ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_ADM_WORKFLOW_TASK AS _WorkflowTaskDetails ON WorkflowInternalID = _WorkflowTaskDetails.WorkflowInternalID  -- association [0..*]
;

Learn More