I_ProdAllocObjTimeSeriesTP

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_ProdAllocObjTimeSeriesTP.
-- 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.

CREATE VIEW I_ProdAllocObjTimeSeriesTP AS
SELECT
  Document.ProdAllocationTimeSeriesUUID AS ProdAllocationTimeSeriesUUID,
  Document.ProductAllocationObjectUUID AS ProductAllocationObjectUUID,
  Document.CharcValueCombinationUUID AS CharcValueCombinationUUID,
  Document.ProdAllocFlxblTmeSersUUID AS ProdAllocFlxblTmeSersUUID,
  Document.ProdAllocPerdStartUTCDateTime AS ProdAllocPerdStartUTCDateTime,
  Document.ProdAllocPeriodStartTimeZone AS ProdAllocPeriodStartTimeZone,
  Document.ProdAllocationPeriodStartDate AS ProdAllocationPeriodStartDate,
  Document.ProdAllocPeriodEndUTCDateTime AS ProdAllocPeriodEndUTCDateTime,
  Document.ProdAllocPeriodEndTimeZone AS ProdAllocPeriodEndTimeZone,
  Document.ProductAllocationQuantity AS ProductAllocationQuantity,
  Document.ProductAllocationQuantityUnit AS ProductAllocationQuantityUnit
FROM I_ProdAllocObjectTimeSeries AS Document
LEFT OUTER JOIN I_ProdAllocationObjectTP AS _ProdAllocationObjectTP ON _ProdAllocationObjectTP.ProductAllocationObjectUUID = ProductAllocationObjectUUID  -- association [1..1]
LEFT OUTER JOIN I_ProdAllocObjFlxblTmeSersTP AS _ProdAllocObjFlxblTmeSersTP ON ProdAllocFlxblTmeSersUUID = _ProdAllocObjFlxblTmeSersTP.ProdAllocFlxblTmeSersUUID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProductAllocationQuantityUnit ON _ProductAllocationQuantityUnit.UnitOfMeasure = ProductAllocationQuantityUnit  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _ProdAllocPeriodStartTimeZone ON _ProdAllocPeriodStartTimeZone.TimeZoneID = ProdAllocPeriodStartTimeZone  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _ProdAllocPeriodEndTimeZone ON _ProdAllocPeriodEndTimeZone.TimeZoneID = ProdAllocPeriodEndTimeZone  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _PlannedCalendarPeriod ON _PlannedCalendarPeriod.CalendarDate = ProdAllocationPeriodStartDate  -- association [0..1]
;