N_SupplierInvoiceItemPurOrdRef

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 N_SupplierInvoiceItemPurOrdRef.
-- 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: NSIITMPURORDREF

CREATE VIEW N_SupplierInvoiceItemPurOrdRef AS
SELECT
  item.SupplierInvoice AS SupplierInvoice,
  item.FiscalYear AS FiscalYear,
  item.SupplierInvoiceItem AS SupplierInvoiceItem,
  item.PurchaseOrder AS PurchaseOrder,
  item.PurchaseOrderItem AS PurchaseOrderItem,
  item.Plant AS Plant,
  item.SupplierInvoiceItemText AS SupplierInvoiceItemText,
  item.PurchaseOrderItemMaterial AS PurchaseOrderItemMaterial,
  item.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  item.QuantityInPurchaseOrderUnit AS QuantityInPurchaseOrderUnit,
  item.PurchaseOrderPriceUnit AS PurchaseOrderPriceUnit,
  item.QtyInPurchaseOrderPriceUnit AS QtyInPurchaseOrderPriceUnit,
  item.SuplrInvcDeliveryCostCndnType AS SuplrInvcDeliveryCostCndnType,
  item.SuplrInvcDeliveryCostCndnStep AS SuplrInvcDeliveryCostCndnStep,
  item.SuplrInvcDeliveryCostCndnCount AS SuplrInvcDeliveryCostCndnCount,
  I_SupplierInvoice.DocumentCurrency AS DocumentCurrency,
  item.SupplierInvoiceItemAmount AS SupplierInvoiceItemAmount,
  item.IsSubsequentDebitCredit AS IsSubsequentDebitCredit,
  item.TaxCode AS TaxCode,
  item.TaxJurisdiction AS TaxJurisdiction,
  item.ReferenceDocument AS ReferenceDocument,
  item.ReferenceDocumentFiscalYear AS ReferenceDocumentFiscalYear,
  item.ReferenceDocumentItem AS ReferenceDocumentItem,
  item.DebitCreditCode AS DebitCreditCode,
  item.FreightSupplier AS FreightSupplier,
  item.IsNotCashDiscountLiable AS IsNotCashDiscountLiable,
  item.SuplrInvcItemHasPriceVariance AS SuplrInvcItemHasPriceVariance,
  item.SuplrInvcItemHasQtyVariance AS SuplrInvcItemHasQtyVariance,
  item.SuplrInvcItemHasDateVariance AS SuplrInvcItemHasDateVariance,
  item.SuplrInvcItemHasOrdPrcQtyVarc AS SuplrInvcItemHasOrdPrcQtyVarc,
  item.SuplrInvcItemHasOtherVariance AS SuplrInvcItemHasOtherVariance,
  item.SuplrInvcItemHasAmountOutsdTol AS SuplrInvcItemHasAmountOutsdTol,
  item.SuplrInvcItmHasQualityVariance AS SuplrInvcItmHasQualityVariance,
  'X' AS IsOnlineSupplierInvoiceItem
FROM P_ITEM_ONLINE AS item
INNER JOIN I_SupplierInvoice ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SupplierInvoice AS _SupplierInvoice ON SupplierInvoice = _SupplierInvoice.SupplierInvoice AND FiscalYear = _SupplierInvoice.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_SupplierInvoiceFiscalYear AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_SupplierInvoiceItmAcctAssgmt AS _SupplierInvoiceItmAcctAssgmt ON SupplierInvoice = _SupplierInvoiceItmAcctAssgmt.SupplierInvoice AND FiscalYear = _SupplierInvoiceItmAcctAssgmt.FiscalYear AND SupplierInvoiceItem = _SupplierInvoiceItmAcctAssgmt.SupplierInvoiceItem  -- association [0..*]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON PurchaseOrderQuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON PurchaseOrderItemMaterial = _Material.Material  -- association [0..1]
LEFT OUTER JOIN E_OnlineSupplierInvoiceItem AS _OnlineExtension ON SupplierInvoice = _OnlineExtension.SupplierInvoice AND FiscalYear = _OnlineExtension.FiscalYear AND SupplierInvoiceItem = _OnlineExtension.SupplierInvoiceItem  -- association [0..1]
LEFT OUTER JOIN E_BatchSupplierInvoiceItem AS _BatchExtension ON SupplierInvoice = _BatchExtension.SupplierInvoice AND FiscalYear = _BatchExtension.FiscalYear AND SupplierInvoiceItem = _BatchExtension.SupplierInvoiceItem  -- association [0..1]
;