P_PPS_PurOrdWorkflow_Wi2obj

DDL: P_PPS_PURORDWORKFLOW_WI2OBJ Type: view_entity BASIC

P_PPS_PurOrdWorkflow_Wi2obj is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (sww_wi2obj) and exposes 22 fields with key field Guid.

Data Sources (1)

SourceAliasJoin Type
sww_wi2obj sww_wi2obj from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.private true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY Guid guid UUID 22 char.
WiId wi_id WorkItem ID
TopWiId top_wi_id Top Level Workflow
WiRhTask wi_rh_task Task
WiRelease wi_release Work Instruction Version Release
CreaTmp crea_tmp Created On
Catid catid Vendor Category ID
Instid instid Instance ID
Typeid typeid Trans Doc Ty ID
WiReltype wi_reltype Type of Relation
Removed removed Removed
Sont sont SAP Obj Node Type
SontKeyPart1 sont_key_part_1 SONT partial key 1
SontKeyPart2 sont_key_part_2 SONT partial key 2
SontKeyPart3 sont_key_part_3 SONT partial key 3
SontKeyPart4 sont_key_part_4 SONT partial key 4
SontKeyPart5 sont_key_part_5 SONT partial key 5
SontKeyPart6 sont_key_part_6 SONT partial key 6
LocalCreatedBy local_created_by Created By
LocalLastChangedBy local_last_changed_by User Name
LocalLastChangedAt local_last_changed_at Time Stamp
LastChangedAt last_changed_at Timestamp

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_PPS_PurOrdWorkflow_Wi2obj.
-- 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 P_PPS_PurOrdWorkflow_Wi2obj AS
SELECT
  Guid,
  wi_id AS WiId,
  top_wi_id AS TopWiId,
  wi_rh_task AS WiRhTask,
  wi_release AS WiRelease,
  crea_tmp AS CreaTmp,
  Catid,
  Instid,
  Typeid,
  wi_reltype AS WiReltype,
  Removed,
  Sont,
  sont_key_part_1 AS SontKeyPart1,
  sont_key_part_2 AS SontKeyPart2,
  sont_key_part_3 AS SontKeyPart3,
  sont_key_part_4 AS SontKeyPart4,
  sont_key_part_5 AS SontKeyPart5,
  sont_key_part_6 AS SontKeyPart6,
  local_created_by AS LocalCreatedBy,
  local_last_changed_by AS LocalLastChangedBy,
  local_last_changed_at AS LocalLastChangedAt,
  last_changed_at AS LastChangedAt
FROM sww_wi2obj
;