CUANW_PS
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description |
|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA