CUANW_PS

Transparent Table System Table (transport)

Predictive Scenario

CUANW_PS is an SAP database table in S/4HANA. Predictive Scenario. It contains 14 fields. 39 CDS views read from this table.

CDS Views using this table (39)

ViewTypeJoinVDMDescription
CUAN_PM_DS_PA_D view union_all Data Parameter Default Value (Runtime)
CUAN_PM_DS_PA_D view left_outer Data Parameter Default Value (Runtime)
CUAN_PM_DS_PA_T view union_all Data Parameter Description (Runtime)
CUAN_PM_DS_PA_T view left_outer Data Parameter Description (Runtime)
CUAN_PM_DS_PAR view left_outer Data Parameter (Runtime)
CUAN_PM_DS_PAR view union_all Data Parameter (Runtime)
CUAN_PM_DS_T view left_outer Alias for Predictive Data Source (Runtime)
CUAN_PM_DS_VAR view left_outer Predictor Variable (Runtime)
CUAN_PM_DS_VDEP view left_outer Predictor Parameter Dependency (Runtime)
CUAN_PM_DSRC view union_all Alias for Predictive Data Source (Runtime)
CUAN_PM_DSRC view left_outer Alias for Predictive Data Source (Runtime)
CUAN_PM_SCN_ANC view left_outer Predictive Scenario Anchors (Runtime)
CUAN_PM_SCN_ANC view union_all Predictive Scenario Anchors (Runtime)
CUAN_PM_SCN_P_D view union_all Predictive Scenario Parameter Default Value (Runtime)
CUAN_PM_SCN_P_D view left_outer Predictive Scenario Parameter Default Value (Runtime)
CUAN_PM_SCN_P_T view union_all Predictive Scenario Parameter Description (Runtime)
CUAN_PM_SCN_P_T view left_outer Predictive Scenario Parameter Description (Runtime)
CUAN_PM_SCN_PAR view left_outer Predictive Scenario Parameter (Runtime)
CUAN_PM_SCN_PAR view union_all Predictive Scenario Parameter (Runtime)
CUAN_PM_SCN_PRC view left_outer Process to Scenario Assigment (Runtime)
CUAN_PM_SCN_PRC view union_all Process to Scenario Assigment (Runtime)
CUAN_PM_SCN_SCP view left_outer Applicable Scope to Scenario Assignment (Runtime)
CUAN_PM_SCN_SCP view union_all Applicable Scope to Scenario Assignment (Runtime)
CUAN_PM_SCNAR_T view left_outer Predictive Scenario Description (Runtime)
CUAN_PM_SCNARIO view union_all Predictive Scenario (Runtime)
CUAN_PM_SCNARIO view left_outer Predictive Scenario (Runtime)
CUAN_PM_SCP view left_outer Applicable Scope (Runtime)
CUAN_PM_SCP view union_all Applicable Scope (Runtime)
CUAN_PM_SCP_ADT view left_outer Applicable Scope for ADT (Runtime)
CUAN_PM_SCP_ADT view union_all Applicable Scope for ADT (Runtime)
CUAN_PM_SCVAL_T view left_outer Scenario Value Descriptions (Runtime)
CUAN_PM_SCVAL_T view union_all Scenario Value Descriptions (Runtime)
CUAN_PM_UI_I_T view left_outer Text table for initial values (Runtime)
CUAN_PM_UI_SCN view left_outer Displaying properties for Scores (Runtime)
CUAN_PM_UI_SCN view union_all Displaying properties for Scores (Runtime)
CUAN_PM_UI_THRS view left_outer Thresholds, descriptions and colors for scores (Runtime)
CUAN_PM_UI_THRS view union_all Thresholds, descriptions and colors for scores (Runtime)
I_MKT_CustomPredictiveScore view from BASIC Marketing: Custom Predictive Scores
I_MKT_PredictiveScenario view from BASIC Predictive Scenarios

Fields (14)

KeyField Data ElementDescription
KEY predictivescenario cuan_pm_scenario
KEY predictivescenarioversion cuan_ps_version
predictivescenariotype cuan_pm_type
predictivescenariostatus cuan_psx_status
persistencealias cuan_sp_view_alias
predictivescenarioview cuan_ps_scenarioview
predictivescenarioscorecolumn cuan_pm_target_attr
predictivedatasourceview cuan_ps_datasourceview
prdtvdatasourceviewpackage cuan_ps_ds_package
prdtvdatasourceviewid cuan_ps_datasourceview_id
predictivedatasourcekeycolumn cuan_pm_ds_key
prdtvscendatasrceinterfacevers cuan_pm_ds_inf_ver
prdtvdatasrcewrkgsettablealias cuan_ps_js_ds_alias
predictivescenarioicon cuan_ps_icon

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Predictive Scenario
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CUANW_PS (
    PREDICTIVESCENARIO,              -- cuan_pm_scenario
    PREDICTIVESCENARIOVERSION,       -- cuan_ps_version
    PREDICTIVESCENARIOTYPE,          -- cuan_pm_type
    PREDICTIVESCENARIOSTATUS,        -- cuan_psx_status
    PERSISTENCEALIAS,                -- cuan_sp_view_alias
    PREDICTIVESCENARIOVIEW,          -- cuan_ps_scenarioview
    PREDICTIVESCENARIOSCORECOLUMN,   -- cuan_pm_target_attr
    PREDICTIVEDATASOURCEVIEW,        -- cuan_ps_datasourceview
    PRDTVDATASOURCEVIEWPACKAGE,      -- cuan_ps_ds_package
    PRDTVDATASOURCEVIEWID,           -- cuan_ps_datasourceview_id
    PREDICTIVEDATASOURCEKEYCOLUMN,   -- cuan_pm_ds_key
    PRDTVSCENDATASRCEINTERFACEVERS,  -- cuan_pm_ds_inf_ver
    PRDTVDATASRCEWRKGSETTABLEALIAS,  -- cuan_ps_js_ds_alias
    PREDICTIVESCENARIOICON,          -- cuan_ps_icon
    PRIMARY KEY (PREDICTIVESCENARIO, PREDICTIVESCENARIOVERSION)
);