v_sumintgr30

DDL: DDL_EEDMSUMINTGR30 SQL: v_eedmsumintgr30 Type: view

v_sumintgr30 is a CDS View in SAP S/4HANA. It reads from 3 data sources (eprofhead, eedmsettlin, eprofval30) and exposes 8 fields.

Data Sources (3)

SourceAliasJoin Type
eprofhead profhead from
eedmsettlin settlin inner
eprofval30 val30 inner

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName v_eedmsumintgr30 view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view

Fields (8)

KeyFieldSource TableSource FieldDescription
settldoc eedmsettlin settldoc Settlement Doc.
seltype eedmsettlin seltype SelPart Tech
settlunit eedmsettlin settlunit Settlement Unit
grid_id eedmsettlin grid_id Grid
profdecimals eprofhead profdecimals Decimal places
mass eprofhead mass Unit of meas.
intsizeid eprofhead intsizeid Interval Length
valueday eprofval30 valueday Day

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 v_sumintgr30.
-- 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: v_eedmsumintgr30

CREATE VIEW v_sumintgr30 AS
SELECT
  settlin.settldoc AS settldoc,
  settlin.seltype AS seltype,
  settlin.settlunit AS settlunit,
  settlin.grid_id AS grid_id,
  profhead.profdecimals AS profdecimals,
  profhead.mass AS mass,
  profhead.intsizeid AS intsizeid,
  val30.valueday AS valueday
FROM eprofhead AS profhead
INNER JOIN eedmsettlin AS settlin ON /* join condition not captured in parsed metadata */
INNER JOIN eprofval30 AS val30 ON /* join condition not captured in parsed metadata */
;