Ehenv_Scenario_Limits

DDL: EHENV_SCENARIO_LIMITS SQL: EHENVV_SCEN_LMT Type: view

Environmental Scenario Limits

Ehenv_Scenario_Limits is a CDS View that provides data about "Environmental Scenario Limits" in SAP S/4HANA. It reads from 2 data sources (ehenvd_scen_lmt, ehenvd_scen_root) and exposes 9 fields.

Data Sources (2)

SourceAliasJoin Type
ehenvd_scen_lmt ehenvd_scen_lmt from
ehenvd_scen_root ehenvd_scen_root inner

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName EHENVV_SCEN_LMT view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Environmental Scenario Limits view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (9)

KeyFieldSource TableSource FieldDescription
scen_key ehenvd_scen_root db_key UUID
valid_from ehenvd_scen_root valid_from Validity Start Time
valid_to ehenvd_scen_root valid_to Validity End Time
limit_key ehenvd_scen_lmt db_key UUID
bo_key_ref bo_key_ref NodeID
unit unit UoM
type type Worklist Type
limit_value limit_value Value
name name Zone name

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 Ehenv_Scenario_Limits.
-- 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: EHENVV_SCEN_LMT

CREATE VIEW Ehenv_Scenario_Limits AS
SELECT
  ehenvd_scen_root.db_key AS scen_key,
  ehenvd_scen_root.valid_from AS valid_from,
  ehenvd_scen_root.valid_to AS valid_to,
  ehenvd_scen_lmt.db_key AS limit_key,
  bo_key_ref,
  unit,
  type,
  limit_value,
  name
FROM ehenvd_scen_lmt
INNER JOIN ehenvd_scen_root ON /* join condition not captured in parsed metadata */
;