I_PL_SAFTInvoiceItem

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 I_PL_SAFTInvoiceItem.
-- 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: IPLSAFTINVOICEI

CREATE VIEW I_PL_SAFTInvoiceItem AS
SELECT
  saftn_pl_fa_I.extraction_id AS SAFTExtractionUUID,
  saftn_pl_fa_I.gjahr AS FiscalYear,
  saftn_pl_fa_I.belnr AS AccountingDocument,
  saftn_pl_fa_I.bukrs AS CompanyCode,
  saftn_pl_fa_I.posnr AS AccountingDocumentItemRef,
  saftn_pl_fa_I.description AS MaterialDescription,
  saftn_pl_fa_I.discounts AS DiscountAmount,
  saftn_pl_fa_I.quantity AS Quantity,
  saftn_pl_fa_I.tax_base AS TaxAmount,
  case when saftn_pl_fa_I.tax_percent is initial then 'zw' else lower(saftn_pl_fa_I.tax_percent) end as TaxRate AS tax_percentendasTaxRate,
  saftn_pl_fa_I.waers AS Currency,
  saftn_pl_fa_I.unit_price AS PriceUnit,
  saftn_pl_fa_I.inv_number AS InvoiceDocumentNumber,
  cast( case when saftn_pl_fa_I.unit_mesaure is initial then 'ST' else saftn_pl_fa_I.unit_mesaure end as meins ) as UnitOfMeasure AS unit_mesaureendasmeinsasUnitOfMeasure
FROM snd_pl_fa_i AS saftn_pl_fa_I
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
;