CUAN_PM_SCN_PAR

DDL: CUAN_PM_SCN_PAR SQL: CUAN_PMSCN_PAR Type: view Package: CUAN_CDS_PREDICTIVE

Predictive Scenario Parameter (Runtime)

CUAN_PM_SCN_PAR is a CDS View that provides data about "Predictive Scenario Parameter (Runtime)" in SAP S/4HANA. It reads from 4 data sources (cuanc_pm_scn_par, cuanw_ps, cuanw_ps, cuanw_ps) and exposes 25 fields with key fields client, scenario_id, par_name, scenario_id, par_name. Part of development package CUAN_CDS_PREDICTIVE.

Data Sources (4)

SourceAliasJoin Type
cuanc_pm_scn_par t1 from
cuanw_ps t1 union_all
cuanw_ps t1 union_all
cuanw_ps t2 left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CUAN_PMSCN_PAR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Predictive Scenario Parameter (Runtime) view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY client cuanw_ps client Workflow definition: Client
KEY scenario_id cuanw_ps scenario_id
KEY par_name cuanw_ps par_name
optional cuanw_ps optional TRUE
value_help cuanw_ps value_help
key_field cuanw_ps key_field
text_field cuanw_ps text_field
node_name cuanw_ps node_name Object Name
query_name cuanw_ps query_name Query
KEY scenario_id cuanw_ps predictivescenario
KEY par_name cuanw_ps predictivescenarioparameter
optional TRUE
value_help t3 value_entity
key_field t3 value_attribute
text_field t3 desc_attribute
node_name Object Name
query_name Query
KEY scenario_id cuanw_ps predictivescenario
KEY par_name cuanw_ps predictivescenarioparameter
optional TRUE
value_help
key_field
text_field
node_name Object Name
query_name Query

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 CUAN_PM_SCN_PAR.
-- 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: CUAN_PMSCN_PAR

CREATE VIEW CUAN_PM_SCN_PAR AS
SELECT
  t1.client AS client,
  t1.scenario_id AS scenario_id,
  t1.par_name AS par_name,
  t1.optional AS optional,
  t1.value_help AS value_help,
  t1.key_field AS key_field,
  t1.text_field AS text_field,
  t1.node_name AS node_name,
  t1.query_name AS query_name
FROM cuanc_pm_scn_par AS t1
LEFT OUTER JOIN cuanw_ps AS t2 ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): cuanw_ps
;