sedt_einc

DDL: SEDT_EINC SQL: SEDT_EINC_VIEW Type: view
6 Fields 2 Data Sources

sedt_einc is a CDS View in SAP S/4HANA. It reads from 2 data sources (enhobj, sedt_einc_r) and exposes 6 fields with key fields einc_include, state.

Data Sources (2)

SourceAliasJoin Type
enhobj enhobj left_outer
sedt_einc_r sedt_einc_r from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SEDT_EINC_VIEW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY einc_include sedt_einc_r name Zone name
KEY state sedt_einc_r state Vehicle Region
enhname enhobj enhname Enh.Impl.
pgmid enhobj pgmid Program Name
obj_type enhobj obj_type Type
obj_name enhobj obj_name Object 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 sedt_einc.
-- 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: SEDT_EINC_VIEW

CREATE VIEW sedt_einc AS
SELECT
  sedt_einc_r.name AS einc_include,
  sedt_einc_r.state AS state,
  enhobj.enhname AS enhname,
  enhobj.pgmid AS pgmid,
  enhobj.obj_type AS obj_type,
  enhobj.obj_name AS obj_name
FROM sedt_einc_r
LEFT OUTER JOIN enhobj ON /* join condition not captured in parsed metadata */
;

Learn More