I_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 I_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: ISIITMPURORDREF

CREATE VIEW I_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,
  _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,
  item.IsOnlineSupplierInvoiceItem AS IsOnlineSupplierInvoiceItem,
  item.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  item.ProductType AS ProductType,
  item.TaxCountry AS TaxCountry,
  item.InventoryValuationType AS InventoryValuationType,
  item.SuplrInvcItmUnplndDelivCost AS SuplrInvcItmUnplndDelivCost,
  item.SuplrInvcPurgDocItmCompanyCode AS SuplrInvcPurgDocItmCompanyCode,
  item.IsFinallyInvoiced AS IsFinallyInvoiced,
  item.RetentionAmountInDocCurrency AS RetentionAmountInDocCurrency,
  item.RetentionPercentage AS RetentionPercentage,
  item.RetentionDueDate AS RetentionDueDate,
  item.TaxDeterminationDate AS TaxDeterminationDate,
  item.IN_HSNOrSACCode AS IN_HSNOrSACCode,
  item.IN_CustomDutyAssessableValue AS IN_CustomDutyAssessableValue
FROM P_SUPLRINVCITEMLOGSUNION AS item
LEFT OUTER JOIN I_SupplierInvoice AS _SupplierInvoice ON SupplierInvoice = _SupplierInvoice.SupplierInvoice AND FiscalYear = _SupplierInvoice.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchaseOrder = _PurchasingDocumentItem.PurchasingDocument AND PurchaseOrderItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON PurchaseOrderQuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PurOrdPriceUnitOfMeasure ON PurchaseOrderPriceUnit = _PurOrdPriceUnitOfMeasure.UnitOfMeasure  -- 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_Currency AS _Currency ON documentcurrency = _Currency.Currency  -- association [0..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]
;