I_KSR_CFG_SQL_M

DDL: I_KSR_CFG_SQL_M Type: view_entity Package: S_KSR_CFG

KSR-CFG: SQL Trace Filters View

I_KSR_CFG_SQL_M is a CDS View that provides data about "KSR-CFG: SQL Trace Filters View" in SAP S/4HANA. It reads from 1 data source (ksr_cfg_sql) and exposes 11 fields with key fields profile_id, field_id, range_line. It has 3 associations to related views. Part of development package S_KSR_CFG.

Data Sources (1)

SourceAliasJoin Type
ksr_cfg_sql ksr_cfg_sql from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_KSR_CFG_SQL_FD_VH _FieldId $projection.field_id = _FieldId.FieldId
[1..1] I_KSR_CFG_STF_OP_VH _OperatorId $projection.range_option_hlp = _OperatorId.OperatorId
[1..1] I_KSR_CFG_STF_SN_VH _Sign $projection.sign = _Sign.Sign

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label KSR-CFG: SQL Trace Filters View view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY profile_id profile_id Text Profile
KEY field_id field_id Field name
KEY range_line range_line Position
sign sign Type of SIGN component in row type of a Ranges type
range_option range_option Type of OPTION component in row type of a Ranges type
low low Value from
high high Value up to
_Profiles _Profiles
_FieldId _FieldId
_OperatorId _OperatorId
_Sign _Sign

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

CREATE VIEW I_KSR_CFG_SQL_M AS
SELECT
  profile_id,
  field_id,
  range_line,
  sign,
  range_option,
  low,
  high
FROM ksr_cfg_sql
LEFT OUTER JOIN I_KSR_CFG_SQL_FD_VH AS _FieldId ON field_id = _FieldId.FieldId  -- association [1..1]
LEFT OUTER JOIN I_KSR_CFG_STF_OP_VH AS _OperatorId ON range_option_hlp = _OperatorId.OperatorId  -- association [1..1]
LEFT OUTER JOIN I_KSR_CFG_STF_SN_VH AS _Sign ON sign = _Sign.Sign  -- association [1..1]
;