P_PT_AccountingNumberRange

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_AccountingNumberRange.
-- 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_AccountingNumberRange 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,
  PT_SeriesDocumentType,
  'F' AS PT_SeriesBusinessProcess,
  _NumberRange.NumberRangeObject AS PT_SeriesNumberRangeObject,
  _NumberRange.NumberRangeSubObject AS PT_SeriesNumberRangeSubObject,
  NumberRangeInterval AS PT_SeriesNumberRangeInterval,
  ToFiscalYear AS PT_SeriesNumberRangeToYear,
  PortugueseLeadingAcctgDocType
FROM I_PT_DgtlSgntrNmbrRngeAcctg
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_NumberRangeInterval AS _NumberRange ON _NumberRange.NumberRangeObject = 'RF_BELEG' AND _NumberRange.NumberRangeSubObject = CompanyCode AND _NumberRange.NumberRangeInterval = PT_SeriesNumberRangeInterval AND _NumberRange.NumberRangeToYear = PT_SeriesNumberRangeToYear  -- association [0..1]
LEFT OUTER JOIN I_PT_DgtlSgntrStartAccounting AS _DgtlsgntrStartAcctg ON _DgtlsgntrStartAcctg.CompanyCode = CompanyCode AND _DgtlsgntrStartAcctg.PT_SeriesNumberRangeInterval = PT_SeriesNumberRangeInterval AND _DgtlsgntrStartAcctg.PT_SeriesNumberRangeToYear = PT_SeriesNumberRangeToYear  -- association [0..1]
;