P_PT_DeliveryNumberRange

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 P_PT_DeliveryNumberRange.
-- 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 P_PT_DeliveryNumberRange AS
SELECT
  CompanyCode,
  cast( substring(_CompanyCode.VATRegistration, 3, 18) as stceg) AS VATRegistration,
  PortugueseDgtlSignatureSeries AS PT_SeriesIdentifier,
  'MG' AS PT_SeriesDocumentClass,
  _NumberRange.NumberRangeObject AS PT_SeriesNumberRangeObject,
  _NumberRange.NumberRangeSubObject AS PT_SeriesNumberRangeSubObject,
  _NumberRange.NumberRangeToYear AS PT_SeriesNumberRangeToYear,
  'D' AS PT_SeriesBusinessProcess,
  cast (_NumberRange.NumberRangeToNumber as glo_pt_series_ln) AS PT_SeriesLastNumber,
  DeliveryDocumentType,
  NumberRange AS PT_SeriesNumberRangeInterval
FROM I_PT_DeliveryNumberRange
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN P_PT_SimplifiedDelivDocType AS _DocType ON _DocType.DeliveryDocumentType = DeliveryDocumentType  -- association [0..1]
LEFT OUTER JOIN I_NumberRangeInterval AS _NumberRange ON _NumberRange.NumberRangeObject = 'GLO_PT_OBD' AND _NumberRange.NumberRangeSubObject = CompanyCode AND _NumberRange.NumberRangeInterval = PT_SeriesNumberRangeInterval  -- association [0..1]
LEFT OUTER JOIN P_PT_DgtlSgntrStartDeliveries AS _StartDeliv ON CompanyCode = _StartDeliv.CompanyCode AND PT_SeriesNumberRangeInterval = _StartDeliv.PT_SeriesNumberRangeInterval  -- association [0..1]
;