I_SuplrInvcItemPurOrdRefAPI01

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_SuplrInvcItemPurOrdRefAPI01.
-- 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: ISIPORDREFAPI01

CREATE VIEW I_SuplrInvcItemPurOrdRefAPI01 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.StockUnit AS StockUnit,
  item.SuplrInvcDeliveryCostCndnType AS SuplrInvcDeliveryCostCndnType,
  item.SuplrInvcDeliveryCostCndnStep AS SuplrInvcDeliveryCostCndnStep,
  item.SuplrInvcDeliveryCostCndnCount AS SuplrInvcDeliveryCostCndnCount,
  item.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,
  item.TaxCountry AS TaxCountry,
  item.SuplrInvcItmUnplndDelivCost AS SuplrInvcItmUnplndDelivCost,
  item.IsFinallyInvoiced AS IsFinallyInvoiced,
  item._Currency AS _Currency
FROM I_SupplierInvoiceItemPurOrdRef AS item
INNER JOIN I_SupplierInvoiceAPI01 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SupplierInvoiceAPI01 AS _SupplierInvoiceAPI01 ON SupplierInvoice = _SupplierInvoiceAPI01.SupplierInvoice AND FiscalYear = _SupplierInvoiceAPI01.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_SuplrInvcItmAcctAssgmtAPI01 AS _SuplrInvcItmAcctAssgmtAPI01 ON SupplierInvoice = _SuplrInvcItmAcctAssgmtAPI01.SupplierInvoice AND FiscalYear = _SuplrInvcItmAcctAssgmtAPI01.FiscalYear AND SupplierInvoiceItem = _SuplrInvcItmAcctAssgmtAPI01.SupplierInvoiceItem  -- association [1..*]
;