I_MfgOrderMaterialDocumentItem

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_MfgOrderMaterialDocumentItem.
-- 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: IMFGORDMATDOCITM

CREATE VIEW I_MfgOrderMaterialDocumentItem AS
SELECT
  doc.MaterialDocument AS MaterialDocument,
  doc.MaterialDocumentYear AS MaterialDocumentYear,
  doc.OrderID AS ManufacturingOrder,
  doc.OrderItem AS ManufacturingOrderItem,
  ord.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  ord.ManufacturingOrderType AS ManufacturingOrderType,
  _MaterialDocumentHeader.CreationDate AS CreationDate,
  _MaterialDocumentHeader.CreationTime AS CreationTime,
  cast(_MaterialDocumentHeader.CreatedByUser as ernam preserving type) AS CreatedByUser,
  doc.ReversedMaterialDocumentYear AS ReversedMaterialDocumentYear,
  doc.ReversedMaterialDocument AS ReversedMaterialDocument,
  doc.ReversedMaterialDocumentItem AS ReversedMaterialDocumentItem,
  doc.GoodsMovementIsCancelled AS GoodsMovementIsCancelled,
  cast(doc.Material as co_matnr preserving type) AS Material,
  doc.Plant AS Plant,
  doc.Reservation AS Reservation,
  cast(doc.ReservationItem as pph_rspos preserving type) AS ReservationItem,
  cast(doc.ReservationRecordType as pph_rsart preserving type) AS ReservationRecordType,
  doc.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  cast(doc.StorageLocation as pph_lgort preserving type) AS StorageLocation,
  doc.Batch AS Batch,
  cast(doc.InventoryValuationType as pph_bwtar preserving type) AS InventoryValuationType,
  cast(doc.ConsumptionPosting as pph_kzvbr preserving type) AS ConsumptionPosting,
  cast(doc.DebitCreditCode as pph_shkzg preserving type) AS DebitCreditCode,
  cast(doc.GoodsMovementType as pph_bwart preserving type) AS GoodsMovementType,
  doc.GoodsMovementReasonCode AS GoodsMovementReasonCode,
  cast(doc.GoodsMovementRefDocType as pph_kzbew preserving type) AS GoodsMovementRefDocType,
  cast(doc.InventoryUsabilityCode as inventoryusabilitycode preserving type) AS InventoryUsabilityCode,
  cast(doc.InventorySpecialStockType as pph_sobkz preserving type) AS InventorySpecialStockType,
  cast(doc.SalesOrder as co_kdauf preserving type) AS SalesOrder,
  cast(doc.SalesOrderItem as co_kdpos preserving type) AS SalesOrderItem,
  cast(doc.WBSElementInternalID as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  doc.Supplier AS Supplier,
  doc.Customer AS Customer,
  cast(doc.GoodsRecipientName as pph_wempf preserving type) AS GoodsRecipientName,
  doc.UnloadingPointName AS UnloadingPointName,
  cast(doc.GoodsReceiptIsNonValuated as pph_weunb preserving type) AS GoodsReceiptIsNonValuated,
  doc.IsCompletelyDelivered AS IsCompletelyDelivered,
  doc.StorageType AS StorageType,
  doc.StorageBin AS StorageBin,
  doc.CompanyCode AS CompanyCode,
  doc.BusinessArea AS BusinessArea,
  doc.ControllingArea AS ControllingArea,
  doc.PostingDate AS PostingDate,
  doc.DocumentDate AS DocumentDate,
  doc.ShelfLifeExpirationDate AS ShelfLifeExpirationDate,
  doc.ManufactureDate AS ManufactureDate,
  doc.MaterialBaseUnit AS BaseUnit,
  doc.QuantityInBaseUnit AS QuantityInBaseUnit,
  doc.EntryUnit AS EntryUnit,
  cast(doc.QuantityInEntryUnit as pph_erfmg preserving type) AS QuantityInEntryUnit,
  doc.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast(doc.TotalGoodsMvtAmtInCCCrcy as pph_dmbtr preserving type) AS TotalGoodsMvtAmtInCCCrcy,
  cast('0' as plnfolge) AS ManufacturingOrderSequence,
  cast('0010' as vdm_vornr) AS ManufacturingOrderOperation,
  ord._MfgOrderCategory AS _MfgOrderCategory
FROM I_MaterialDocumentRecord AS doc
INNER JOIN I_MfgOrderBasic AS ord ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialDocumentHeader_2 AS _MaterialDocumentHeader ON MaterialDocument = _MaterialDocumentHeader.MaterialDocument AND MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentYear AS _MaterialDocumentYear ON MaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentItem_2 AS _MaterialDocumentItem ON MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear AND MaterialDocument = _MaterialDocumentItem.MaterialDocument AND MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrderItem AS _MfgOrderItem ON ManufacturingOrder = _MfgOrderItem.ManufacturingOrder AND ManufacturingOrderItem = _MfgOrderItem.ManufacturingOrderItem  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderType AS _MfgOrderType ON ManufacturingOrderType = _MfgOrderType.ManufacturingOrderType  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _CreationDate ON creationdate = _CreationDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _DocumentDate ON DocumentDate = _DocumentDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _PostingDate ON PostingDate = _PostingDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_ReservationDocumentHeader AS _Reservation ON Reservation = _Reservation.Reservation  -- association [0..1]
LEFT OUTER JOIN I_ReservationDocumentItem AS _ReservationItem ON Reservation = _ReservationItem.Reservation AND ReservationItem = _ReservationItem.ReservationItem AND ReservationRecordType = _ReservationItem.RecordType  -- association [0..1]
LEFT OUTER JOIN I_ReservationDocRecordType AS _ReservationRecordType ON ReservationRecordType = _ReservationRecordType.RecordType  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlant ON Plant = _ProductPlant.Plant AND Material = _ProductPlant.Product  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EntryUnit ON EntryUnit = _EntryUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [1..1]
LEFT OUTER JOIN I_PhysInvtryReasonCode AS _GoodsMovementReason ON GoodsMovementType = _GoodsMovementReason.GoodsMovementType AND GoodsMovementReasonCode = _GoodsMovementReason.ReasonForPhysInvtryDifference  -- association [0..1]
LEFT OUTER JOIN I_GoodsMovementRefDocType AS _GoodsMovementRefDocType ON GoodsMovementRefDocType = _GoodsMovementRefDocType.GoodsMovementRefDocType  -- association [0..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_InventoryValuationType AS _InventoryValuationType ON InventoryValuationType = _InventoryValuationType.InventoryValuationType  -- association [0..1]
LEFT OUTER JOIN I_ConsumptionPosting AS _ConsumptionPosting ON ConsumptionPosting = _ConsumptionPosting.ConsumptionPosting  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_StockType_2 AS _InventoryUsabilityCode ON InventoryUsabilityCode = _InventoryUsabilityCode.StockType  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Plant = _Batch.Plant AND Material = _Batch.Material AND Batch = _Batch.Batch  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderAPI01 AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItemAPI01 AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompanyByPlant AS _SupplierCompanyByPlant ON Plant = _SupplierCompanyByPlant.Plant AND Supplier = _SupplierCompanyByPlant.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompanyByPlant AS _CustomerCompanyByPlant ON Plant = _CustomerCompanyByPlant.Plant AND Customer = _CustomerCompanyByPlant.Customer  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _Currency ON CompanyCodeCurrency = _Currency.Currency  -- association [0..1]
;