P_RTGVERSUIWFL

DDL: P_RTGVERSUIWFL Type: view_entity BASIC
6 Fields 3 Data Sources

Workflow state for routings

P_RTGVERSUIWFL is a Basic CDS View that provides data about "Workflow state for routings" in SAP S/4HANA. It reads from 3 data sources (P_RTGVERSUIWFLHLP, SWF_FLEX_I_PROCESS, tca01_subtype) and exposes 6 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsVersion, subtype.

Data Sources (3)

SourceAliasJoin Type
P_RTGVERSUIWFLHLP _wflhlp inner
SWF_FLEX_I_PROCESS SWF_FLEX_I_PROCESS inner
tca01_subtype tca from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Workflow state for routings view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType P_RTGVERSUIWFLHLP BillOfOperationsType Task List Type
KEY BillOfOperationsGroup P_RTGVERSUIWFLHLP BillOfOperationsGroup Group
KEY BillOfOperationsVariant P_RTGVERSUIWFLHLP BillOfOperationsVariant Group Counter
KEY BillOfOperationsVersion P_RTGVERSUIWFLHLP BillOfOperationsVersion Routing Version
KEY subtype tca01_subtype subtype Version Profile
Status SWF_FLEX_I_PROCESS Status Workflow Status

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_RTGVERSUIWFL.
-- 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_RTGVERSUIWFL AS
SELECT
  _wflhlp.BillOfOperationsType AS BillOfOperationsType,
  _wflhlp.BillOfOperationsGroup AS BillOfOperationsGroup,
  _wflhlp.BillOfOperationsVariant AS BillOfOperationsVariant,
  _wflhlp.BillOfOperationsVersion AS BillOfOperationsVersion,
  tca.subtype AS subtype,
  SWF_FLEX_I_PROCESS.Status AS Status
FROM tca01_subtype AS tca
INNER JOIN SWF_FLEX_I_PROCESS ON /* join condition not captured in parsed metadata */
INNER JOIN P_RTGVERSUIWFLHLP AS _wflhlp ON /* join condition not captured in parsed metadata */
;

Learn More