SHSM_FAGL_SEGM

DDL: SHSM_FAGL_SEGM SQL: SHSMFAGLSEGM Type: view
2 Fields 2 Data Sources

Segment Value Help

SHSM_FAGL_SEGM is a CDS View that provides data about "Segment Value Help" in SAP S/4HANA. It reads from 2 data sources (fagl_segm, fagl_segmt) and exposes 2 fields with key field SEGMENT.

Data Sources (2)

SourceAliasJoin Type
fagl_segm fagl_segm from
fagl_segmt fagl_segmt left_outer

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName SHSMFAGLSEGM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Segment Value Help view
ObjectModel.representativeKey SEGMENT view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY SEGMENT
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 SHSM_FAGL_SEGM.
-- 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: SHSMFAGLSEGM

CREATE VIEW SHSM_FAGL_SEGM AS
SELECT
  cast( fagl_segm.segment as fb_segment preserving type ) AS SEGMENT,
  cast( fagl_segmt.name as fis_segment_name preserving type ) AS NAME
FROM fagl_segm
LEFT OUTER JOIN fagl_segmt ON /* join condition not captured in parsed metadata */
;

Learn More