I_MfgOrderConfMatlDocItem

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_MfgOrderConfMatlDocItem.
-- 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: IMFGORDCNFMATDOC

CREATE VIEW I_MfgOrderConfMatlDocItem AS
SELECT
  afru.MfgOrderConfirmationGroup AS MfgOrderConfirmationGroup,
  afru.MfgOrderConfirmation AS MfgOrderConfirmation,
  afwi.MaterialDocument AS MaterialDocument,
  cast(afwi.MaterialDocumentYear as nsdm_mjahr preserving type) AS MaterialDocumentYear,
  cast(afwi.MaterialDocumentItem as nsdm_mblpo preserving type) AS MaterialDocumentItem,
  mseg.PostingDate AS PostingDate,
  mseg.DocumentDate AS DocumentDate,
  cast(mseg.CreatedByUser as ernam preserving type) AS CreatedByUser,
  afru.ManufacturingOrder AS ManufacturingOrder,
  afru.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  afru.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  afru.ManufacturingOrderOperation_2 AS ManufacturingOrderOperation_2,
  mseg.OrderItem AS ManufacturingOrderItem,
  afru.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  afru.ManufacturingOrderType AS ManufacturingOrderType,
  afru.Plant AS ConfirmationPlant,
  afru.ConfirmationText AS ConfirmationText,
  afru.FinalConfirmationType AS FinalConfirmationType,
  afru.IsFinalConfirmation AS IsFinalConfirmation,
  afru.OpenReservationsIsCleared AS OpenReservationsIsCleared,
  afru.IsReversed AS IsReversed,
  afru.IsReversal AS IsReversal,
  cast(mseg.Material as co_matnr preserving type) AS Material,
  mseg.Plant AS Plant,
  mseg.Reservation AS Reservation,
  mseg.ReservationItem AS ReservationItem,
  mseg.ReservationRecordType AS ReservationRecordType,
  cast(mseg.StorageLocation as pph_lgort preserving type) AS StorageLocation,
  mseg.Batch AS Batch,
  cast(mseg.InventoryValuationType as pph_bwtar preserving type) AS InventoryValuationType,
  cast(mseg.ConsumptionPosting as pph_kzvbr preserving type) AS ConsumptionPosting,
  cast(mseg.GoodsMovementType as pph_bwart preserving type) AS GoodsMovementType,
  mseg.GoodsMovementReasonCode AS GoodsMovementReasonCode,
  mseg.GoodsMovementRefDocType AS GoodsMovementRefDocType,
  cast(mseg.InventoryUsabilityCode as inventoryusabilitycode preserving type) AS InventoryUsabilityCode,
  cast(mseg.InventorySpecialStockType as inventoryspecialstocktype preserving type) AS InventorySpecialStockType,
  cast(mseg.InventorySpecialStockValnType as pph_kzbws preserving type) AS InventorySpecialStockValnType,
  cast(mseg.SalesOrder as co_kdauf preserving type) AS SalesOrder,
  cast(mseg.SalesOrderItem as co_kdpos preserving type) AS SalesOrderItem,
  cast(mseg.WBSElementInternalID as pph_pspel preserving type) AS WBSElementInternalID,
  cast(mseg.WBSElementInternalID as ps_s4_pspnr preserving type) AS WBSElementInternalID_2,
  mseg.Supplier AS Supplier,
  mseg.Customer AS Customer,
  cast(mseg.GoodsRecipientName as pph_wempf preserving type) AS GoodsRecipientName,
  cast(mseg.UnloadingPointName as ablad preserving type) AS UnloadingPointName,
  mseg.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  mseg.IsCompletelyDelivered AS IsCompletelyDelivered,
  mseg.ShelfLifeExpirationDate AS ShelfLifeExpirationDate,
  mseg.ManufactureDate AS ManufactureDate,
  mseg.StorageType AS StorageType,
  mseg.StorageBin AS StorageBin,
  mseg.EWMWarehouse AS EWMWarehouse,
  mseg.HandlingUnitExternalID AS HandlingUnitExternalID,
  mseg.MaterialDocumentItemText AS MaterialDocumentItemText,
  mseg.MaterialBaseUnit AS BaseUnit,
  cast(mseg.QuantityInBaseUnit as vdm_pp_menge preserving type) AS QuantityInBaseUnit,
  mseg.EntryUnit AS EntryUnit,
  cast(mseg.QuantityInEntryUnit as pph_erfmg preserving type) AS QuantityInEntryUnit,
  afru._ConfirmationGroup AS _ConfirmationGroup,
  afwi._MaterialDocumentYear AS _MaterialDocumentYear,
  afru._MfgOrderOperation AS _MfgOrderOperation,
  afru._MfgOrderOperation2 AS _MfgOrderOperation2,
  afru._MfgOrderCategory AS _MfgOrderCategory,
  afru._MfgOrderType AS _MfgOrderType,
  afru._Plant AS _ConfirmationPlant,
  afru._FinalConfirmationType AS _FinalConfirmationType,
  afru._ReversedIndicator AS _ReversedIndicator,
  afru._ReversalIndicator AS _ReversalIndicator
FROM I_MfgOrderConfirmation AS afru
INNER JOIN I_OrderConfMatlDocItemAssgmt AS afwi ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaterialDocumentRecord AS mseg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ConfirmationCount AS _ConfirmationCount ON MfgOrderConfirmationGroup = _ConfirmationCount.ConfirmationGroup AND MfgOrderConfirmation = _ConfirmationCount.ConfirmationCount  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentHeader_2 AS _MaterialDocumentHeader ON MaterialDocument = _MaterialDocumentHeader.MaterialDocument AND MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear  -- association [1..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_CalendarDate AS _ShelfLifeExpirationDate ON ShelfLifeExpirationDate = _ShelfLifeExpirationDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _ManufactureDate ON ManufactureDate = _ManufactureDate.CalendarDate  -- association [0..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 [0..1]
LEFT OUTER JOIN I_ManufacturingOrderSequence AS _MfgOrderSequence ON ManufacturingOrder = _MfgOrderSequence.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderSequence.ManufacturingOrderSequence  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderConfirmation AS _MfgOrderConfirmation ON MfgOrderConfirmationGroup = _MfgOrderConfirmation.MfgOrderConfirmationGroup AND MfgOrderConfirmation = _MfgOrderConfirmation.MfgOrderConfirmation  -- association [1..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_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [1..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_InvtrySpecialStockValnType AS _InventorySpecialStockValnType ON InventorySpecialStockValnType = _InventorySpecialStockValnType.InventorySpecialStockValnType  -- 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_WBSElementBasicData AS _WBSElementBasic ON WBSElementInternalID_2 = _WBSElementBasic.WBSElementInternalID  -- 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_EWM_WarehouseNumber_2 AS _EWMWarehouse ON EWMWarehouse = _EWMWarehouse.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageBin_2 AS _EWMStorageBin ON EWMWarehouse = _EWMStorageBin.EWMWarehouse AND EWMStorageBin = _EWMStorageBin.EWMStorageBin  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentYear AS _MaterialDocumentYear ON MaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear  -- association [1..1]
-- UNION ALL with additional select branch(es): I_MfgOrderConfirmation
;