P_PMRPSIMLNRSCEGROUP1

DDL: P_PMRPSIMLNRSCEGROUP1 SQL: PMRPSIMRSCGRPBC1 Type: view BASIC
7 Fields 4 Data Sources

P_PMRPSIMLNRSCEGROUP1 is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (pmrp_resource, pmrp_wgroup_rel, pmrp_simulation, pmrp_simulation) and exposes 7 fields with key fields nodeid, nodetype, nodeid, nodetype.

Data Sources (4)

SourceAliasJoin Type
pmrp_resource res inner
pmrp_wgroup_rel resgroup inner
pmrp_simulation sim from
pmrp_simulation sim union_all

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMRPSIMRSCGRPBC1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY nodeid pmrp_wgroup_rel nodeid UUID Internal
KEY nodetype pmrp_wgroup_rel nodetype Object Type
parentnodeid pmrp_wgroup_rel parentnodeid Object ID
KEY nodeid pmrp_resource resource_id UUID Internal
KEY nodetype Object Type
parentnodeid Object ID
reference_id pmrp_simulation reference_id Reference No.

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_PMRPSIMLNRSCEGROUP1.
-- 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.
-- SQL view name: PMRPSIMRSCGRPBC1

CREATE VIEW P_PMRPSIMLNRSCEGROUP1 AS
SELECT
  resgroup.nodeid AS nodeid,
  resgroup.nodetype AS nodetype,
  resgroup.parentnodeid AS parentnodeid,
  sim.reference_id AS reference_id
FROM pmrp_simulation AS sim
INNER JOIN pmrp_wgroup_rel AS resgroup ON /* join condition not captured in parsed metadata */
INNER JOIN pmrp_resource AS res ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): pmrp_simulation
;

Learn More