P_PPS_PurOrdWorkflow_Steplog

DDL: P_PPS_PURORDWORKFLOW_STEPLOG Type: view_entity BASIC

P_PPS_PurOrdWorkflow_Steplog is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (swpsteplog) and exposes 27 fields with key fields WfId, NodeId, NodePInd, LogDate, LogTime.

Data Sources (1)

SourceAliasJoin Type
swpsteplog swpsteplog 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 (27)

KeyFieldSource TableSource FieldDescription
KEY WfId wf_id Workflow ID
KEY NodeId node_id Workflow Step
KEY NodePInd node_p_ind ParForEach index
KEY LogDate log_date Date of logging
KEY LogTime log_time Time of logging
KEY LogCount log_count Log counter
Timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Deleted deleted Truth Value
Retrycount retrycount RetryCounter
WiId wi_id WorkItem ID
WiSystem wi_system WI system
TaskId task_id TaskID
WiAgent wi_agent Agent
WiAed wi_aed Done On
WiAet wi_aet Actual end time
Returncode returncode Terminating event
WiDhStat wi_dh_stat Deadline Status
PredNode pred_node Preceding node
PredNodep pred_nodep Parallelism index
PredWiId pred_wi_id WI ID of prec.activ.
Returnval returnval Return value
Returntyp returntyp Return Type
Dataaging _dataaging Data Aging
FlexReturnValue flex_return_value Returncode
FlexReturnNature flex_return_nature Nature
FlexStepId flex_step_id Id
FlexDecisionReason flex_decision_reason Decision Reason ID

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_Steplog.
-- 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_Steplog AS
SELECT
  wf_id AS WfId,
  node_id AS NodeId,
  node_p_ind AS NodePInd,
  log_date AS LogDate,
  log_time AS LogTime,
  log_count AS LogCount,
  Timestamp,
  Deleted,
  Retrycount,
  wi_id AS WiId,
  wi_system AS WiSystem,
  task_id AS TaskId,
  wi_agent AS WiAgent,
  wi_aed AS WiAed,
  wi_aet AS WiAet,
  Returncode,
  wi_dh_stat AS WiDhStat,
  pred_node AS PredNode,
  pred_nodep AS PredNodep,
  pred_wi_id AS PredWiId,
  Returnval,
  Returntyp,
  flex_return_value AS FlexReturnValue,
  flex_return_nature AS FlexReturnNature,
  flex_step_id AS FlexStepId,
  flex_decision_reason AS FlexDecisionReason
FROM swpsteplog
;