I_OIL_MaterialDocumentItem

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_OIL_MaterialDocumentItem.
-- 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 I_OIL_MaterialDocumentItem AS
SELECT
  MaterialDocumentYear AS LgclInvtryAdjmtDocumentYear,
  MaterialDocument,
  cast( lpad(MaterialDocumentItem, 6, '0' ) as oia_item ) AS ExchangeItemNumber,
  Material,
  StockIdentifyingMaterial,
  Plant,
  StorageLocation,
  StorageType,
  StorageBin,
  Batch,
  ShelfLifeExpirationDate,
  ManufactureDate,
  Supplier,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  cast(WBSElementInternalID as nsdm_wbselement_internal_id preserving type) AS WBSElementInternalID,
  Customer,
  InventorySpecialStockType,
  InventoryStockType,
  StockOwner,
  GoodsMovementType,
  DebitCreditCode,
  InventoryUsabilityCode,
  QuantityInBaseUnit,
  MaterialBaseUnit,
  QuantityInEntryUnit,
  EntryUnit,
  PostingDate,
  YearMonth,
  YearWeek,
  DocumentDate,
  ReservationRecordType AS ReservationItemRecordType,
  TotalGoodsMvtAmtInCCCrcy,
  CompanyCodeCurrency,
  InventoryValuationType,
  ReservationIsFinallyIssued,
  PurchaseOrder,
  PurchaseOrderItem,
  ProjectNetwork,
  OrderID,
  OrderItem,
  MaintOrderRoutingNumber,
  MaintOrderOperationCounter,
  Reservation,
  ReservationItem,
  DeliveryDocument,
  DeliveryDocumentItem,
  ReversedMaterialDocumentYear,
  ReversedMaterialDocument,
  ReversedMaterialDocumentItem,
  RvslOfGoodsReceiptIsAllowed,
  GoodsRecipientName,
  GoodsMovementReasonCode,
  UnloadingPointName,
  CostCenter,
  GLAccount,
  ServicePerformer,
  PersonWorkAgreement,
  AccountAssignmentCategory,
  WorkItem,
  ServicesRenderedDate,
  IssgOrRcvgMaterial,
  IssuingOrReceivingPlant,
  IssuingOrReceivingStorageLoc,
  IssgOrRcvgBatch,
  IssgOrRcvgSpclStockInd,
  IssuingOrReceivingValType,
  CompanyCode,
  BusinessArea,
  ControllingArea,
  FiscalYearPeriod,
  FiscalYearVariant,
  GoodsMovementRefDocType,
  IsCompletelyDelivered,
  MaterialDocumentItemText,
  IsAutomaticallyCreated,
  SerialNumbersAreCreatedAutomly,
  GoodsReceiptType,
  ConsumptionPosting,
  MultiAcctAssgmtOriglMatlDocItm,
  MultipleAccountAssignmentCode,
  GoodsMovementIsCancelled,
  IssuingOrReceivingStockType,
  ManufacturingOrder,
  ManufacturingOrderItem,
  MaterialDocumentLine,
  MaterialDocumentParentLine,
  SpecialStockIdfgSalesOrder,
  SpecialStockIdfgSalesOrderItem,
  cast(SpecialStockIdfgWBSElement as nsdm_wbselement_internal_id preserving type) AS SpecialStockIdfgWBSElement,
  QtyInPurchaseOrderPriceUnit,
  OrderPriceUnit,
  QuantityInDeliveryQtyUnit,
  DeliveryQuantityUnit,
  ProfitCenter,
  _Product.ProductStandardID AS ProductStandardID,
  GdsMvtExtAmtInCoCodeCrcy,
  InvtryMgmtReferenceDocument,
  InvtryMgmtRefDocumentItem,
  EWMStorageBin,
  MaterialDocumentPostingType,
  OriginalMaterialDocumentItem
FROM I_MaterialDocumentRecord
LEFT OUTER JOIN I_MaterialDocumentYear AS _MaterialDocumentYear ON LgclInvtryAdjmtDocumentYear = _MaterialDocumentYear.MaterialDocumentYear  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentHeader_2 AS _MaterialDocumentHeader ON LgclInvtryAdjmtDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear AND MaterialDocument = _MaterialDocumentHeader.MaterialDocument  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentHeader_2 AS _ReversedMatDoc ON ReversedMaterialDocumentYear = _ReversedMatDoc.MaterialDocumentYear AND ReversedMaterialDocument = _ReversedMatDoc.MaterialDocument  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentItem_2 AS _ReversedMatDocItem ON ReversedMaterialDocumentYear = _ReversedMatDocItem.MaterialDocumentYear AND ReversedMaterialDocument = _ReversedMatDocItem.MaterialDocument AND ReversedMaterialDocumentItem = _ReversedMatDocItem.MaterialDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
;