RS_P_ANA_UMM2_PS_ALL

DDL: RS_P_ANA_UMM2_PS_ALL SQL: RSANAUMMPSALL Type: view Package: RS_ANA_UMM_DB
11 Fields 6 Data Sources

Predictive Scenarios (Draft & Published)

RS_P_ANA_UMM2_PS_ALL is a CDS View that provides data about "Predictive Scenarios (Draft & Published)" in SAP S/4HANA. It reads from 6 data sources and exposes 11 fields. Part of development package RS_ANA_UMM_DB.

Data Sources (6)

SourceAliasJoin Type
rsanaummps a from
interpret interpret cross
is is left_outer
rsanaummps p left_outer
rsanaummpsdraft r union
rsanaummpsdraft t left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName RSANAUMMPSALL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Predictive Scenarios (Draft & Published) view

Fields (11)

KeyFieldSource TableSource FieldDescription
guid
name rsanaummps name Zone name
status
parent rsanaummps parent UUID
description rsanaummps description Well Code Des.
name rsanaummpsdraft name Zone name
status
parent rsanaummpsdraft parent UUID
description rsanaummpsdraft description Well Code Des.
creationdate rsanaummpsdraft creationdate Time Stamp
extensible rsanaummpsdraft extensible Fiori Extensible

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 RS_P_ANA_UMM2_PS_ALL.
-- 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: RSANAUMMPSALL

CREATE VIEW RS_P_ANA_UMM2_PS_ALL AS
SELECT
  cast ( a.name as rsana_umm2_uuid ) AS guid,
  a.name AS name,
  cast ( 'Published' as rsana_umm2_status ) AS status,
  a.parent AS parent,
  a.description AS description,
  r.creationdate AS creationdate,
  r.extensible AS extensible
FROM rsanaummps AS a
LEFT OUTER JOIN rsanaummpsdraft AS t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN is ON /* join condition not captured in parsed metadata */
CROSS JOIN interpret
LEFT OUTER JOIN rsanaummps AS p ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): rsanaummpsdraft
;

Learn More