C_GRIRSupplierInvoiceItem

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_GRIRSupplierInvoiceItem.
-- 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: CFIGRIRSUPINITM

CREATE VIEW C_GRIRSupplierInvoiceItem AS
SELECT
  I_SupplierInvoiceItemPurOrdRef.SupplierInvoice AS SupplierInvoice,
  cast( I_SupplierInvoiceItemPurOrdRef.FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  I_SupplierInvoiceItemPurOrdRef.SupplierInvoiceItem AS SupplierInvoiceItem,
  I_SupplierInvoiceItemPurOrdRef._SupplierInvoice.AccountingDocumentType AS AccountingDocumentType,
  I_SupplierInvoiceItemPurOrdRef._SupplierInvoice.CompanyCode AS CompanyCode,
  I_SupplierInvoiceItemPurOrdRef._SupplierInvoice.PostingDate AS PostingDate,
  I_SupplierInvoiceItemPurOrdRef._SupplierInvoice.CreatedByUser AS CreatedByUser,
  I_SupplierInvoiceItemPurOrdRef._SupplierInvoice.SupplierInvoiceIDByInvcgParty AS DocumentReferenceID,
  I_SupplierInvoiceItemPurOrdRef._SupplierInvoice.DocumentDate AS DocumentDate,
  I_SupplierInvoiceItemPurOrdRef._SupplierInvoice.InvoicingParty AS Supplier,
  I_SupplierInvoiceItemPurOrdRef.DocumentCurrency AS TransactionCurrency,
  I_SupplierInvoiceItemPurOrdRef._SupplierInvoice.ExchangeRate AS ExchangeRate,
  I_SupplierInvoiceItemPurOrdRef._SupplierInvoice.UnplannedDeliveryCost AS FreightCost,
  I_SupplierInvoiceItemPurOrdRef.DebitCreditCode AS DebitCreditCode,
  I_SupplierInvoiceItemPurOrdRef.TaxCode AS TaxCode,
  I_SupplierInvoiceItemPurOrdRef.Plant AS ProductionPlant,
  I_SupplierInvoiceItemPurOrdRef.PurchaseOrderItemMaterial AS PurchaseOrderItemMaterial,
  I_SupplierInvoiceItemPurOrdRef.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  I_SupplierInvoiceItemPurOrdRef.QuantityInPurchaseOrderUnit AS QuantityInPurchaseOrderUnit,
  _PurchasingDocumentItem.OrderQuantity AS OrderQuantity,
  I_SupplierInvoiceItemPurOrdRef._SupplierInvoice.ManualCashDiscount AS ManualCashDiscount,
  I_SupplierInvoiceItemPurOrdRef._SupplierInvoice.DocumentHeaderText AS DocumentHeaderText,
  cast( I_SupplierInvoiceItemPurOrdRef.PurchaseOrder as fis_ebeln preserving type) AS PurchasingDocument,
  cast( I_SupplierInvoiceItemPurOrdRef.PurchaseOrderItem as fis_ebelp preserving type) AS PurchasingDocumentItem,
  I_SupplierInvoiceItemPurOrdRef.ReferenceDocumentItem AS ReferenceDocumentItem,
  I_SupplierInvoiceItemPurOrdRef.SupplierInvoiceItemAmount AS AmountInTransactionCurrency,
  I_SupplierInvoiceItemPurOrdRef._SupplierInvoice.PaymentBlockingReason AS PaymentBlockingReason,
  I_SupplierInvoiceItemPurOrdRef.Plant AS Plant,
  cast(_PurchasingDocument.PurchasingGroup as fis_grir_ekgrp preserving type ) AS PurchasingGroup,
  cast(_PurchasingDocument.PurchasingOrganization as fis_grir_ekorg preserving type ) AS PurchasingOrganization,
  _PurchasingDocument._PurchasingGroup AS _PurchasingGroup,
  _PurchasingDocument._PurchasingOrganization AS _PurchasingOrganization
FROM I_SupplierInvoiceItemPurOrdRef
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument AND PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON CreatedByUser = _CreatedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_GRIRProcess AS _GRIRProcess ON CompanyCode = _GRIRProcess.CompanyCode AND PurchasingDocument = _GRIRProcess.PurchasingDocument AND PurchasingDocumentItem = _GRIRProcess.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SupplierInvoiceAPI01 AS _SupplierInvoiceAPI01 ON SupplierInvoice = _SupplierInvoiceAPI01.SupplierInvoice AND FiscalYear = _SupplierInvoiceAPI01.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _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 I_PurchaseOrderItem AS _PurchaseOrderItem ON PurchasingDocument = _PurchaseOrderItem.PurchaseOrder AND PurchasingDocumentItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
;