P_PT_BillingNumberRange

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_BillingNumberRange.
-- 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_BillingNumberRange AS
SELECT
  CompanyCode,
  cast( substring(_CompanyCode.VATRegistration, 3, 18) as stceg) AS VATRegistration,
  PortugueseDgtlSignatureSeries AS PT_SeriesIdentifier,
  'N' AS PT_SeriesTypeCode,
  PT_SeriesDocumentType,
  'B' AS PT_SeriesBusinessProcess,
  _NumberRange.NumberRangeObject AS PT_SeriesNumberRangeObject,
  _NumberRange.NumberRangeSubObject AS PT_SeriesNumberRangeSubObject,
  NumberRangeInterval AS PT_SeriesNumberRangeInterval,
  _NumberRange.NumberRangeToYear AS PT_SeriesNumberRangeToYear,
  PortugueseLeadingBillgDocType
FROM I_PT_DgtlSgntrNmbrRngeBilling
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentType AS _BillingDocumentType ON _BillingDocumentType.BillingDocumentType = PortugueseLeadingBillgDocType  -- association [0..1]
LEFT OUTER JOIN I_NumberRangeInterval AS _NumberRange ON _NumberRange.NumberRangeObject = 'RV_BELEG' AND _NumberRange.NumberRangeInterval = PT_SeriesNumberRangeInterval  -- association [0..1]
LEFT OUTER JOIN I_PT_DgtlSgntrStartBilling AS _DgtlsgntrStartBillg ON _DgtlsgntrStartBillg.PT_SeriesNumberRangeInterval = PT_SeriesNumberRangeInterval  -- association [0..1]
;