P_PT_SettlementNumberRange

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_SettlementNumberRange.
-- 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_SettlementNumberRange AS
SELECT
  CompanyCode,
  cast( substring(_CompanyCode.VATRegistration, 3, 18) as stceg) AS VATRegistration,
  PortugueseDgtlSignatureSeries AS PT_SeriesIdentifier,
  'N' AS PT_SeriesTypeCode,
  'SI' AS PT_SeriesDocumentClass,
  _NumberRange.NumberRangeObject AS PT_SeriesNumberRangeObject,
  _NumberRange.NumberRangeSubObject AS PT_SeriesNumberRangeSubObject,
  _NumberRange.NumberRangeToYear AS PT_SeriesNumberRangeToYear,
  SettlmtDocType,
  'L' AS PT_SeriesBusinessProcess,
  cast (_NumberRange.NumberRangeToNumber as glo_pt_series_ln) AS PT_SeriesLastNumber,
  NumberRange AS PT_SeriesNumberRangeInterval
FROM I_PT_SettlementNumberRange
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_NumberRangeInterval AS _NumberRange ON _NumberRange.NumberRangeObject = 'GLO_PT_SET' AND _NumberRange.NumberRangeSubObject = CompanyCode AND _NumberRange.NumberRangeInterval = PT_SeriesNumberRangeInterval  -- association [0..1]
LEFT OUTER JOIN P_PT_DgtlSgntrStartSettlement AS _StartSet ON CompanyCode = _StartSet.CompanyCode AND SettlmtDocType = _StartSet.SettlmtDocType AND PT_SeriesNumberRangeInterval = _StartSet.PT_SeriesNumberRangeInterval  -- association [0..1]
;