I_PPS_PurContrWrkflwDetailBase

DDL: I_PPS_PURCONTRWRKFLWDETAILBASE Type: view_entity BASIC
4 Fields 2 Data Sources

PPS Purchase Doc workflow objectID

I_PPS_PurContrWrkflwDetailBase is a Basic CDS View that provides data about "PPS Purchase Doc workflow objectID" in SAP S/4HANA. It reads from 2 data sources (swwwihead, I_PPS_PurContrWorkflowTask) and exposes 4 fields with key fields WorkflowTaskInternalID, TechnicalWrkflwObject.

Data Sources (2)

SourceAliasJoin Type
swwwihead _head from
I_PPS_PurContrWorkflowTask _tech inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label PPS Purchase Doc workflow objectID view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_PPS_PurContrWorkflowTask WorkflowTaskInternalID Work Item ID
KEY TechnicalWrkflwObject I_PPS_PurContrWorkflowTask TechnicalWrkflwObject Instance ID
TechnicalWrkflwObjectType I_PPS_PurContrWorkflowTask TechnicalWrkflwObjectType Trans Doc Ty ID
clientNULLendasPPSPurgDocApprovalDate

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 I_PPS_PurContrWrkflwDetailBase.
-- 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 I_PPS_PurContrWrkflwDetailBase AS
SELECT
  _tech.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _tech.TechnicalWrkflwObject AS TechnicalWrkflwObject,
  _tech.TechnicalWrkflwObjectType AS TechnicalWrkflwObjectType,
  case _steplog.flex_return_value when 'requestApproved' then tstmp_to_dats(cast( _head.wi_aed_timestamp as abap.dec(15) ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) end as PPSPurgDocApprovalDate AS clientNULLendasPPSPurgDocApprovalDate
FROM swwwihead AS _head
INNER JOIN I_PPS_PurContrWorkflowTask AS _tech ON /* join condition not captured in parsed metadata */
;

Learn More