P_RTGVERSUIWFL_S

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

P_RTGVERSUIWFL_S is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (P_RTGVERSUIWFLHLP, P_SWF_FLEX_I_PROCESS_S, tca01_subtype) and exposes 6 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsVersion, subtype.

Data Sources (3)

SourceAliasJoin Type
P_RTGVERSUIWFLHLP _wflhlp inner
P_SWF_FLEX_I_PROCESS_S P_SWF_FLEX_I_PROCESS_S inner
tca01_subtype tca from

Annotations (6)

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

Learn More