v_sumintsu30

DDL: DDL_EEDMSUMINTSU30 SQL: v_eedmsumintsu30 Type: view

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

Data Sources (3)

SourceAliasJoin Type
eprofhead profhead from
eedmsettlin settlin inner
eprofval30 val30 inner

Annotations (4)

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

Fields (7)

KeyFieldSource TableSource FieldDescription
settldoc eedmsettlin settldoc Settlement Doc.
seltype eedmsettlin seltype SelPart Tech
settlunit eedmsettlin settlunit Settlement Unit
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_sumintsu30.
-- 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_eedmsumintsu30

CREATE VIEW v_sumintsu30 AS
SELECT
  settlin.settldoc AS settldoc,
  settlin.seltype AS seltype,
  settlin.settlunit AS settlunit,
  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 */
;