I_NominationItemAggregation

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 I_NominationItemAggregation.
-- 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: INOMIVERSAGGR

CREATE VIEW I_NominationItemAggregation AS
SELECT
  i.NominationDoc AS NominationDoc,
  i.NominationDocItem AS NominationDocItem,
  e.LocationId AS LocationId,
  e.ScheduledMaterial AS ScheduledMaterial,
  e.NominationPlannedQuantity AS NominationPlannedQuantity,
  e.NominationPlannedUnit AS NominationPlannedUnit,
  e.NominationScheduleDate AS NominationScheduleDate,
  e.NominationCalendarWeek AS NominationCalendarWeek,
  e.NominationCalendarMonth AS NominationCalendarMonth,
  e.NominationCalendarYear AS NominationCalendarYear,
  e.ScheduledBatchStartDateTime AS ScheduledBatchStartDateTime,
  e.ScheduledBatchEndDateTime AS ScheduledBatchEndDateTime,
  e.NominationScheduleType AS NominationScheduleType,
  e.IsReferenceDocument AS IsReferenceDocument,
  e.ContractPartner AS ContractPartner,
  e.ScheduledQuantityUnit AS ScheduledQuantityUnit,
  e.NominationVersion AS NominationVersion
FROM I_NominationItemMaxVersion AS i
LEFT OUTER JOIN I_NominationVersionItem AS e ON /* join condition not captured in parsed metadata */
;