CUAN_PM_SCN_P_T

DDL: CUAN_PM_SCN_P_T SQL: CUAN_PMSCN_P_T Type: view Package: CUAN_CDS_PREDICTIVE

Predictive Scenario Parameter Description (Runtime)

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

Data Sources (4)

SourceAliasJoin Type
cuanc_pm_scn_p_t t1 from
cuanw_ps t1 union_all
cuanw_ps t2 left_outer
P_MKT_BIMCVariableTblFunc t3 left_outer

Annotations (8)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY client cuanw_ps client Workflow definition: Client
KEY langu cuanw_ps langu Primary lang.
KEY scenario_id cuanw_ps scenario_id
KEY par_name cuanw_ps par_name
KEY langu Primary lang.
KEY scenario_id cuanw_ps predictivescenario
KEY par_name cuanw_ps predictivescenarioparameter
text P_MKT_BIMCVariableTblFunc description Well Code Des.

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_P_T.
-- 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_P_T

CREATE VIEW CUAN_PM_SCN_P_T AS
SELECT
  t1.client AS client,
  t1.langu AS langu,
  t1.scenario_id AS scenario_id,
  t1.par_name AS par_name,
  t3.description AS text
FROM cuanc_pm_scn_p_t AS t1
LEFT OUTER JOIN cuanw_ps AS t2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_MKT_BIMCVariableTblFunc AS t3 ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): cuanw_ps
;