C_Simulate

DDL: C_SIMULATE SQL: SIMULATEC Type: view
6 Fields 1 Data Sources

Consumption view for Simulated Rules

C_Simulate is a CDS View that provides data about "Consumption view for Simulated Rules" in SAP S/4HANA. It reads from 1 data source (I_Simulate) and exposes 6 fields with key fields rule_id, object_type, policy_type.

Data Sources (1)

SourceAliasJoin Type
I_Simulate GR from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SIMULATEC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Consumption view for Simulated Rules view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY rule_id I_Simulate rule_id Rule ID
KEY object_type I_Simulate object_type Type
KEY policy_type I_Simulate policy_type Audit Area
value_fromendasValue_from
value_toendasValue_to
rule_groupendasRule_Group

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 C_Simulate.
-- 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: SIMULATEC

CREATE VIEW C_Simulate AS
SELECT
  GR.rule_id AS rule_id,
  GR.object_type AS object_type,
  GR.policy_type AS policy_type,
  case GR.policy_category when 'RTP' then rtpConds.value_from else rstConds.value_from end as Value_from AS value_fromendasValue_from,
  case GR.policy_category when 'RTP' then rtpConds.value_to else rstConds.value_to end as Value_to AS value_toendasValue_to,
  case GR.policy_category when 'RTP' then rtpRules.rule_group else rstRules.rule_group end as Rule_Group AS rule_groupendasRule_Group
FROM I_Simulate AS GR
;

Learn More