CDS_GSEG_OT_KEY

DDL: CDS_GSEG_OT_KEY Type: view_entity Package: GEN_SEGMENTATION_META_DATA

Segmentation Objects with Keys

CDS_GSEG_OT_KEY is a CDS View that provides data about "Segmentation Objects with Keys" in SAP S/4HANA. It reads from 4 data sources (gseg_w_ot_ds, gseg_obj_type, gseg_ot_key, gseg_w_ot) and exposes 4 fields with key fields appl_id, ot_id, ot_key. Part of development package GEN_SEGMENTATION_META_DATA.

Data Sources (4)

SourceAliasJoin Type
gseg_w_ot_ds od left_outer
gseg_obj_type ot from
gseg_ot_key otk left_outer
gseg_w_ot wot left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Segmentation Objects with Keys view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY appl_id gseg_obj_type appl_id Policy Key
KEY ot_id gseg_obj_type ot_id
KEY ot_key gseg_ot_key ot_key
ot_id_sap gseg_w_ot ot_id

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 CDS_GSEG_OT_KEY.
-- 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 CDS_GSEG_OT_KEY AS
SELECT
  ot.appl_id AS appl_id,
  ot.ot_id AS ot_id,
  otk.ot_key AS ot_key,
  wot.ot_id AS ot_id_sap
FROM gseg_obj_type AS ot
LEFT OUTER JOIN gseg_ot_key AS otk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gseg_w_ot AS wot ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gseg_w_ot_ds AS od ON /* join condition not captured in parsed metadata */
;