C_PT_SAFTSelfBillgInvoiceHdrC

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 C_PT_SAFTSelfBillgInvoiceHdrC.
-- 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: CPTSAFTSBINVHDRC

CREATE VIEW C_PT_SAFTSelfBillgInvoiceHdrC AS
SELECT
  InvoiceHeader.CompanyCode AS CompanyCode,
  InvoiceHeader.DocumentTransaction AS DocumentTransaction,
  InvoiceHeader.PortugueseInvoiceNumber AS PortugueseInvoiceNumber,
  InvoiceHeader.Supplier AS Supplier,
  InvoiceHeader.PostingDate AS PostingDate,
  PTDgtlSgntrSystemDateTimeText,
  PortugueseDgtlSgntrSystDteTime,
  LastChangedByUser,
  PortugueseDigitalSignature,
  PortugueseDgtlSgntrKeyVersion,
  FiscalPeriod,
  PortugueseInvoiceDate,
  PortugueseInvoiceType,
  PortugueseCustomerWithVersion,
  PlantCustomer,
  InvoiceReference,
  CompanyCodeCurrency,
  TaxAmountInCoCodeCrcy,
  NetAmountInCoCodeCurrency,
  TotalGrossAmountInCoCodeCrcy,
  DocumentCurrency,
  InvoiceAmountInFrgnCurrency,
  case when DocumentCurrency is not initial then InvoiceHeader.InvoiceGrossAmount else cast(0 as abap.curr(13,2)) end as InvoiceGrossAmount AS curr132endasInvoiceGrossAmount,
  ExchangeRate,
  PaymentTerms,
  PT_SeriesDocumentNumber,
  _PaymentTermsConditions.PaymentTermsValidityMonthDay AS PaymentTermsValidityMonthDay,
  InvoiceHeader._Customer AS _Customer
FROM I_PT_SAFTSelfBillgInvoiceHdr AS InvoiceHeader
LEFT OUTER JOIN I_PaymentTermsConditions AS _PaymentTermsConditions ON PaymentTerms = _PaymentTermsConditions.PaymentTerms AND PaymentTermsValidityMonthDay = _PaymentTermsConditions.PaymentTermsValidityMonthDay  -- association [0..1]
;