P_WorkflowToObject

DDL: P_WORKFLOWTOOBJECT SQL: PWFTOOBJECT Type: view BASIC
3 Fields 2 Data Sources

P_WorkflowToObject is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (swwwihead, sww_wi2obj) and exposes 3 fields with key field WorkItem.

Data Sources (2)

SourceAliasJoin Type
swwwihead _head inner
sww_wi2obj _wi2obj from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PWFTOOBJECT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey WorkItem view
VDM.private true view
VDM.viewType #BASIC view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY WorkItem sww_wi2obj wi_id WorkItem ID
ObjectKey sww_wi2obj instid Instance ID
ReleaseDateTime sww_wi2obj crea_tmp Created On

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 P_WorkflowToObject.
-- 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: PWFTOOBJECT

CREATE VIEW P_WorkflowToObject AS
SELECT
  _wi2obj.wi_id AS WorkItem,
  _wi2obj.instid AS ObjectKey,
  _wi2obj.crea_tmp AS ReleaseDateTime
FROM sww_wi2obj AS _wi2obj
INNER JOIN swwwihead AS _head ON /* join condition not captured in parsed metadata */
;

Learn More