I_NumberRangeInterval_TP

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_NumberRangeInterval_TP.
-- 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: CNRINTERVALTP

CREATE VIEW I_NumberRangeInterval_TP AS
SELECT
  NumberRangeInterval.NumberRangeObject AS Object,
  cast( NumberRangeInterval.NumberRangeSubObject as nrsobj_case_sensitive preserving type ) AS SubObject,
  NumberRangeInterval.NumberRangeToYear AS ToYear,
  NumberRangeInterval.NumberRangeInterval AS IntervalNumber,
  case NumberRangeInterval.NumberRangeFlagExternal when 'X' then NumberRangeInterval.NumberRangeFromNumber else ltrim( NumberRangeInterval.NumberRangeFromNumber, '0' ) end as FromNumber AS NumberRangeFromNumber0endasFromNumber,
  case NumberRangeInterval.NumberRangeFlagExternal when 'X' then NumberRangeInterval.NumberRangeToNumber else ltrim( NumberRangeInterval.NumberRangeToNumber, '0' ) end as ToNumber AS NumberRangeToNumber0endasToNumber,
  cast( case NumberRangeInterval.NumberRangeLevel when '00000000000000000000' then '0' else ltrim( NumberRangeInterval.NumberRangeLevel, '0' ) end as abap.char(20) ) as IntervalLevel AS char20asIntervalLevel,
  cast ( NumberRangeInterval.NumberRangeFlagExternal as abap_boolean preserving type ) AS IsExternal,
  NumberRangeInterval.TransportRequestID AS TransportRequestID,
  _NumberRangeObject.BufferType AS BufferTypeDB
FROM I_NumberRangeInterval AS NumberRangeInterval
LEFT OUTER JOIN I_SubObject AS _SubObject ON Object = _SubObject.Object AND SubObject = _SubObject.SubObject  -- association [0..1]
LEFT OUTER JOIN I_NumberRangeInterval_Sort AS _NumberRangeInterval_Sort ON Object = _NumberRangeInterval_Sort.Object AND SubObject = _NumberRangeInterval_Sort.SubObject AND ToYear = _NumberRangeInterval_Sort.ToYear AND IntervalNumber = _NumberRangeInterval_Sort.IntervalNumber  -- association [1..1]
LEFT OUTER JOIN I_UNASSIGNEDBUFFERENTRIES AS _UnassignedBufferEntries ON IntervalNumber = _UnassignedBufferEntries.Nrrangenr AND Object = _UnassignedBufferEntries.Object AND SubObject = _UnassignedBufferEntries.Subobject AND ToYear = _UnassignedBufferEntries.Toyear  -- association [0..*]
;