C_GRIRMaterialDocumentItem

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_GRIRMaterialDocumentItem.
-- 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.

CREATE VIEW C_GRIRMaterialDocumentItem AS
SELECT
  I_GoodsMovementDocument.MaterialDocument AS MaterialDocument,
  I_GoodsMovementDocument.MaterialDocumentItem AS MaterialDocumentItem,
  cast( I_GoodsMovementDocument.MaterialDocumentYear as fis_grir_mjahr preserving type ) AS MaterialDocumentYear,
  I_GoodsMovementDocument.CompanyCode AS CompanyCode,
  cast(_PurchasingDocument.PurchasingGroup as fis_grir_ekgrp preserving type ) AS PurchasingGroup,
  cast(_PurchasingDocument.PurchasingOrganization as fis_grir_ekorg preserving type ) AS PurchasingOrganization,
  I_GoodsMovementDocument.InventoryTransactionType AS InventoryTransactionType,
  I_GoodsMovementDocument.AccountingDocumentType AS AccountingDocumentType,
  I_GoodsMovementDocument.DocumentDate AS DocumentDate,
  I_GoodsMovementDocument.PostingDate AS PostingDate,
  I_GoodsMovementDocument.MaterialDocumentHeaderText AS MaterialDocumentHeaderText,
  I_GoodsMovementDocument.CreatedByUser AS CreatedByUser,
  I_GoodsMovementDocument.ReferenceDocument AS ReferenceDocument,
  I_GoodsMovementDocument.GoodsMovementType AS GoodsMovementType,
  I_GoodsMovementDocument.Plant AS Plant,
  I_GoodsMovementDocument.StorageLocation AS StorageLocation,
  I_GoodsMovementDocument.Supplier AS Supplier,
  I_GoodsMovementDocument.DebitCreditCode AS DebitCreditCode,
  I_GoodsMovementDocument.Material AS Material,
  cast( I_GoodsMovementDocument.PurchaseOrder as fis_ebeln preserving type) AS PurchasingDocument,
  cast( I_GoodsMovementDocument.PurchaseOrderItem as fis_ebelp preserving type) AS PurchasingDocumentItem,
  I_GoodsMovementDocument._PurchaseOrderItem.PurchaseOrderItemText AS PurchaseOrderItemText,
  I_GoodsMovementDocument._CompanyCode.Currency AS CompanyCodeCurrency,
  I_GoodsMovementDocument._PurchaseOrderItem.OrderQuantity AS OrderQuantity,
  I_GoodsMovementDocument._PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  I_GoodsMovementDocument.TotalGoodsMvtAmtInCCCrcy AS AmountInCompanyCodeCurrency,
  I_GoodsMovementDocument._Material AS _Material,
  I_GoodsMovementDocument._Plant AS _Plant,
  I_GoodsMovementDocument._PurchaseOrder AS _PurchaseOrder,
  I_GoodsMovementDocument._PurchaseOrderItem AS _PurchaseOrderItem,
  I_GoodsMovementDocument._StorageLocation AS _StorageLocation,
  I_GoodsMovementDocument._CompanyCode._Currency AS _Currency,
  I_GoodsMovementDocument._PurchaseOrderItem._OrderQuantityUnit AS _OrderQuantityUnit,
  I_GoodsMovementDocument._CompanyCode AS _CompanyCode
FROM I_GoodsMovementDocument
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_MaterialDocumentYear AS _MaterialDocumentYear ON MaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentHeader AS _MaterialDocumentHeader ON MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear AND MaterialDocument = _MaterialDocumentHeader.MaterialDocument  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON CreatedByUser = _CreatedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- 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_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
;