C_SupplierInvoiceItemDEX

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_SupplierInvoiceItemDEX.
-- 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: CMMSUPINVCITMDEX

CREATE VIEW C_SupplierInvoiceItemDEX AS
SELECT
  SupplierInvoice,
  FiscalYear,
  SupplierInvoiceItem,
  QtyInPurchaseOrderPriceUnit,
  PurchaseOrderPriceUnit,
  PurchaseOrderQuantityUnit,
  PurchaseOrder,
  PurchaseOrderItem,
  ReferenceDocument AS PrmtHbReferenceDocument,
  ReferenceDocumentFiscalYear AS PrmtHbReferenceDocumentFsclYr,
  ReferenceDocumentItem AS PrmtHbReferenceDocumentItem,
  PurchaseOrderItemMaterial,
  QuantityInPurchaseOrderUnit,
  SuplrInvcItmHasQualityVariance,
  SuplrInvcItemHasOrdPrcQtyVarc,
  SuplrInvcItemHasQtyVariance,
  SuplrInvcItemHasPriceVariance,
  SuplrInvcItemHasOtherVariance,
  SuplrInvcItemHasAmountOutsdTol,
  SuplrInvcItemHasDateVariance,
  IsSubsequentDebitCredit,
  Plant,
  DocumentCurrency,
  SupplierInvoiceItemAmount,
  _SupplierInvoiceAPI01.SuplrInvcAutomReducedAmount AS SuplrInvcAutomReducedAmount,
  _SupplierInvoiceAPI01.UnplannedDeliveryCost AS UnplannedDeliveryCost,
  _SupplierInvoiceAPI01.DocumentHeaderText AS DocumentHeaderText,
  _SupplierInvoiceAPI01.DocumentDate AS DocumentDate,
  _SupplierInvoiceAPI01.PostingDate AS PostingDate,
  _SupplierInvoiceAPI01.CompanyCode AS CompanyCode,
  _SupplierInvoiceAPI01.SupplierInvoiceOrigin AS SupplierInvoiceOrigin,
  _SupplierInvoiceAPI01.InvoicingParty AS InvoicingParty,
  _SupplierInvoiceAPI01.UnplannedDeliveryCostTaxCode AS UnplannedDeliveryCostTaxCode,
  _SupplierInvoiceAPI01.ReverseDocument AS ReverseDocument,
  _SupplierInvoiceAPI01.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  _SupplierInvoiceAPI01.SupplierInvoiceIDByInvcgParty AS SupplierInvoiceIDByInvcgParty,
  _SupplierInvoiceAPI01.IsInvoice AS IsInvoice,
  _SupplierInvoiceAPI01.SupplierInvoiceStatus AS SupplierInvoiceStatus,
  I_SuplrInvcItemPurOrdRefAPI01._PurOrdPriceUnitOfMeasure AS _PurOrdPriceUnitOfMeasure
FROM I_SuplrInvcItemPurOrdRefAPI01
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 C_SupplierInvoiceDEX AS _SupplierInvoiceDEX ON SupplierInvoice = _SupplierInvoiceDEX.SupplierInvoice AND FiscalYear = _SupplierInvoiceDEX.FiscalYear  -- association [1..1]
LEFT OUTER JOIN C_PurchaseOrderDEX AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN C_PurchaseOrderItemDEX AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON PurchaseOrderItemMaterial = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _InvoicingParty ON InvoicingParty = _InvoicingParty.Supplier  -- association [1..1]
LEFT OUTER JOIN I_SupplierInvoiceStatusAPI01 AS _SupplierInvoiceStatus ON SupplierInvoiceStatus = _SupplierInvoiceStatus.SupplierInvoiceStatus  -- association [0..1]
;