I_ManufacturingOrderComponent

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_ManufacturingOrderComponent.
-- 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: IMFGORDERCOMP

CREATE VIEW I_ManufacturingOrderComponent AS
SELECT
  resb.Reservation AS Reservation,
  resb.ReservationItem AS ReservationItem,
  resb.RecordType AS ReservationRecordType,
  resb.MaterialGroup AS MaterialGroup,
  resb.Material AS Material,
  resb.Plant AS Plant,
  resb.OrderCategory AS ManufacturingOrderCategory,
  resb.OrderType AS ManufacturingOrderType,
  cast(resb.OrderID as manufacturingorder preserving type) AS ManufacturingOrder,
  resb.Sequence AS ManufacturingOrderSequence,
  resb.SequenceCategory AS MfgOrderSequenceCategory,
  resb.OrderOperation AS ManufacturingOrderOperation,
  resb.ProductionPlant AS ProductionPlant,
  resb.OrderInternalID AS OrderInternalID,
  resb.OrderOperationInternalID AS OrderOperationInternalID,
  cast(afko.MRPController as assymrpcontrl preserving type) AS AssemblyMRPController,
  afko.ProductionSupervisor AS ProductionSupervisor,
  resb.MatlCompRequirementDate AS MatlCompRequirementDate,
  resb.MatlCompRequirementTime AS MatlCompRequirementTime,
  resb.LatestRequirementDate AS LatestRequirementDate,
  afko.ActualReleasedDate AS MfgOrderActualReleaseDate,
  resb.ReservationItemCreationCode AS ReservationItemCreationCode,
  resb.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  resb.MatlCompIsMarkedForDeletion AS MatlCompIsMarkedForDeletion,
  resb.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  resb.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  resb.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  resb.MatlCompIsTextItem AS MatlCompIsTextItem,
  resb.MaterialPlanningRelevance AS MaterialPlanningRelevance,
  resb.MatlCompIsConfigurable AS MatlCompIsConfigurable,
  resb.MaterialComponentIsClassified AS MaterialComponentIsClassified,
  resb.MaterialCompIsIntraMaterial AS MaterialCompIsIntraMaterial,
  resb.MaterialIsDirectlyProduced AS MaterialIsDirectlyProduced,
  resb.MaterialIsDirectlyProcured AS MaterialIsDirectlyProcured,
  resb.MaterialComponentText AS MaterialComponentText,
  resb.MaterialComponentSecondText AS MaterialComponentSecondText,
  resb.MaterialComponentHasLongText AS MaterialComponentHasLongText,
  resb.LongTextLanguage AS LongTextLanguage,
  resb.RequirementType AS RequirementType,
  resb.SalesOrder AS SalesOrder,
  resb.SalesOrderItem AS SalesOrderItem,
  resb.WBSElementInternalID AS WBSElementInternalID,
  resb.ProductConfiguration AS ProductConfiguration,
  resb.ChangeNumber AS ChangeNumber,
  resb.MaterialRevisionLevel AS MaterialRevisionLevel,
  resb.EffectivityParameterVariant AS EffectivityParameterVariant,
  resb.MatlCompFreeDefinedAttribute AS MatlCompFreeDefinedAttribute,
  resb.MaterialComponentSortText AS MaterialComponentSortText,
  resb.ObjectInternalID AS ObjectInternalID,
  resb.BillOfMaterialCategory AS BillOfMaterialCategory,
  resb.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  afko.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  resb.BillOfMaterialVariant AS BillOfMaterialVariant,
  cast(afko.BillOfMaterial as pph_stnum preserving type) AS BillOfMaterial,
  resb.BOMItem AS BillOfMaterialItemNodeNumber,
  resb.BillOfMaterialVersion AS BillOfMaterialVersion,
  resb.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  resb.InheritedBOMItemNode AS InheritedBOMItemNode,
  resb.BOMItemCategory AS BillOfMaterialItemCategory,
  resb.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  resb.BOMItemDescription AS BOMItemDescription,
  resb.BOMItemText2 AS BOMItemText2,
  resb.BOMExplosionDateID AS BOMExplosionDateID,
  resb.PurchasingInfoRecord AS PurchasingInfoRecord,
  resb.PurchasingGroup AS PurchasingGroup,
  resb.PurchaseRequisition AS PurchaseRequisition,
  resb.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  resb.PurchaseOrder AS PurchaseOrder,
  resb.PurchaseOrderItem AS PurchaseOrderItem,
  resb.PurchaseOrderScheduleLine AS PurchaseOrderScheduleLine,
  resb.Supplier AS Supplier,
  resb.DeliveryDurationInDays AS DeliveryDurationInDays,
  resb.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  resb.NumberOfPriceUnits AS NumberOfOperationPriceUnits,
  resb.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  resb.StorageLocation AS StorageLocation,
  resb.DebitCreditCode AS DebitCreditCode,
  resb.GoodsMovementType AS GoodsMovementType,
  resb.InventorySpecialStockType AS InventorySpecialStockType,
  resb.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  resb.ConsumptionPosting AS ConsumptionPosting,
  resb.SupplyArea AS SupplyArea,
  resb.GoodsRecipientName AS GoodsRecipientName,
  resb.UnloadingPointName AS UnloadingPointName,
  resb.StockSegment AS StockSegment,
  resb.RequirementSegment AS RequirementSegment,
  resb.Batch AS Batch,
  resb.BatchSplitType AS BatchSplitType,
  resb.BatchMasterReservationItem AS BatchMasterReservationItem,
  resb.BatchClassification AS BatchClassification,
  resb.MaterialStaging AS MaterialStaging,
  resb.Warehouse AS Warehouse,
  resb.StorageType AS StorageType,
  resb.StorageBin AS StorageBin,
  resb.MaterialCompCostingRelevancy AS MaterialCompCostingRelevancy,
  resb.BusinessArea AS BusinessArea,
  resb.CompanyCode AS CompanyCode,
  resb.GLAccount AS GLAccount,
  resb.FunctionalArea AS FunctionalArea,
  resb.ControllingArea AS ControllingArea,
  resb.AccountAssignmentCategory AS AccountAssignmentCategory,
  resb.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  resb.CommitmentItemShortID AS CommitmentItemShortID,
  resb.MaterialCompIsVariableSized AS MaterialCompIsVariableSized,
  resb.VariableSizeItemQuantity AS VariableSizeItemQuantity,
  resb.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  resb.VariableSizeDimension1 AS VariableSizeDimension1,
  resb.VariableSizeDimension2 AS VariableSizeDimension2,
  resb.VariableSizeDimension3 AS VariableSizeDimension3,
  resb.VariableSizeCompFormulaKey AS VariableSizeCompFormulaKey,
  resb.MaterialCompIsAlternativeItem AS MaterialCompIsAlternativeItem,
  resb.AlternativeItemGroup AS AlternativeItemGroup,
  resb.AlternativeItemStrategy AS AlternativeItemStrategy,
  resb.AlternativeItemPriority AS AlternativeItemPriority,
  resb.UsageProbabilityPercent AS UsageProbabilityPercent,
  resb.AlternativeMstrReservationItem AS AlternativeMstrReservationItem,
  resb.MaterialComponentIsPhantomItem AS MaterialComponentIsPhantomItem,
  resb.OrderPathValue AS OrderPathValue,
  resb.OrderLevelValue AS OrderLevelValue,
  resb.Assembly AS Assembly,
  resb.AssemblyOrderPathValue AS AssemblyOrderPathValue,
  resb.AssemblyOrderLevelValue AS AssemblyOrderLevelValue,
  resb.DiscontinuationGroup AS DiscontinuationGroup,
  resb.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  resb.MatlCompIsFollowUpMaterial AS MatlCompIsFollowUpMaterial,
  resb.FollowUpGroup AS FollowUpGroup,
  resb.FollowUpMaterial AS FollowUpMaterial,
  resb.FollowUpMaterialIsNotActive AS FollowUpMaterialIsNotActive,
  resb.FollowUpMaterialIsActive AS FollowUpMaterialIsActive,
  resb.DiscontinuationMasterResvnItem AS DiscontinuationMasterResvnItem,
  resb.MaterialProvisionType AS MaterialProvisionType,
  resb.MatlComponentSparePartType AS MatlComponentSparePartType,
  resb.LeadTimeOffset AS LeadTimeOffset,
  resb.OperationLeadTimeOffsetUnit AS OperationLeadTimeOffsetUnit,
  resb.OperationLeadTimeOffset AS OperationLeadTimeOffset,
  resb.QuantityIsFixed AS QuantityIsFixed,
  resb.IsNetScrap AS IsNetScrap,
  resb.ComponentScrapInPercent AS ComponentScrapInPercent,
  resb.OperationScrapInPercent AS OperationScrapInPercent,
  resb.MaterialQtyToBaseQtyNmrtr AS MaterialQtyToBaseQtyNmrtr,
  resb.MaterialQtyToBaseQtyDnmntr AS MaterialQtyToBaseQtyDnmntr,
  resb.RequiredQuantity AS RequiredQuantity,
  resb.WithdrawnQuantity AS WithdrawnQuantity,
  resb.ConfirmedAvailableQuantity AS ConfirmedAvailableQuantity,
  resb.MaterialCompOriginalQuantity AS MaterialCompOriginalQuantity,
  resb.GoodsMovementEntryQty AS GoodsMovementEntryQty,
  resb.Currency AS Currency,
  resb.WithdrawnQuantityAmount AS WithdrawnQuantityAmount,
  resb.CriticalComponentType AS CriticalComponentType,
  resb.CriticalComponentLevel AS CriticalComponentLevel,
  resb._SequenceCategory AS _MfgOrderSequenceCategory,
  resb._OrderInternalID AS _OrderInternalID,
  resb._ProductionPlant AS _ProductionPlant,
  resb._RequirementType AS _RequirementType,
  resb._MaterialGroup AS _MaterialGroup,
  resb._Material AS _Material,
  resb._Product AS _Product,
  resb._ProductPlant AS _ProductPlant,
  resb._ProductStorageLocation AS _ProductStorageLocation,
  resb._Plant AS _Plant,
  resb._StorageLocation AS _StorageLocation,
  resb._Batch AS _Batch,
  resb._BatchSplitType AS _BatchSplitType,
  resb._DebitCreditCode AS _DebitCreditCode,
  resb._GoodsMovementType AS _GoodsMovementType,
  resb._InventorySpecialStockType AS _InventorySpecialStockType,
  resb._InventorySpecialStockValnType AS _InventorySpecialStockValnType,
  resb._ConsumptionPosting AS _ConsumptionPosting,
  resb._SupplyArea AS _SupplyArea,
  resb._Warehouse AS _Warehouse,
  resb._FollowUpMaterial AS _FollowUpMaterial,
  resb._DiscontinuationType AS _DiscontinuationType,
  resb._ProvisionType AS _ProvisionType,
  resb._SparePartType AS _SparePartType,
  resb._PhantomAssembly AS _PhantomAssembly,
  resb._BOMExplosion AS _BOMExplosion,
  resb._BillOfMaterialItem AS _BillOfMaterialItem,
  resb._BOMItemCategory AS _BOMItemCategory,
  resb._SalesOrder AS _SalesOrder,
  resb._SalesOrderItem AS _SalesOrderItem,
  resb._WBSElementBasicData AS _WBSElementBasicData,
  resb._ChangeNumber AS _ChangeNumber,
  resb._MaterialRevisionLevel AS _MaterialRevisionLevel,
  resb._PurchasingGroup AS _PurchasingGroup,
  resb._PurchasingInfoRecord AS _PurchasingInfoRecord,
  resb._PurchaseOrder AS _PurchaseOrder,
  resb._PurchaseOrderItem AS _PurchaseOrderItem,
  resb._PurchaseRequisition AS _PurchaseRequisition,
  resb._PurchaseRequisitionItem AS _PurchaseRequisitionItem,
  resb._Supplier AS _Supplier,
  resb._CompanyCode AS _CompanyCode,
  resb._BusinessArea AS _BusinessArea,
  resb._GLAccount AS _GLAccount,
  resb._ControllingArea AS _ControllingArea,
  resb._FunctionalArea AS _FunctionalArea,
  resb._AccountAssignmentCategory AS _AccountAssignmentCategory,
  resb._EarmarkedFunds AS _EarmarkedFunds,
  resb._EarmarkedFundsItem AS _EarmarkedFundsItem,
  resb._Fund AS _Fund,
  resb._FundsCenter AS _FundsCenter,
  resb._CommitmentItem AS _CommitmentItem,
  resb._CommitmentItemShortID AS _CommitmentItemShortID,
  resb._OpLeadTimeOffsetUnit AS _OpLeadTimeOffsetUnit,
  resb._VariableSizeItemUnit AS _VariableSizeItemUnit,
  resb._VariableSizeComponentUnit AS _VariableSizeCompUnit,
  resb._BaseUnit AS _BaseUnit,
  resb._EntryUnit AS _EntryUnit,
  resb._Currency AS _Currency,
  resb._StatusObject AS _StatusObject,
  resb._LongTextLanguage AS _LongTextLanguage,
  resb._LongText AS _LongText
FROM I_OrderComponent AS resb
INNER JOIN I_LogisticsOrderBasic AS afko ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ReservationDocumentHeader AS _Reservation ON Reservation = _Reservation.Reservation  -- association [1..1]
LEFT OUTER JOIN I_ReservationDocumentItem AS _ReservationItem ON Reservation = _ReservationItem.Reservation AND ReservationItem = _ReservationItem.ReservationItem AND ReservationRecordType = _ReservationItem.RecordType  -- association [1..1]
LEFT OUTER JOIN I_ReservationDocRecordType AS _ReservationRecordType ON ReservationRecordType = _ReservationRecordType.RecordType  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderOperationBySemKey AS _MfgOrderOperationBySemKey ON ManufacturingOrder = _MfgOrderOperationBySemKey.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderOperationBySemKey.ManufacturingOrderSequence AND ManufacturingOrderOperation = _MfgOrderOperationBySemKey.ManufacturingOrderOperation  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderCategory AS _MfgOrderCategory ON ManufacturingOrderCategory = _MfgOrderCategory.ManufacturingOrderCategory  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderType AS _MfgOrderType ON ManufacturingOrderType = _MfgOrderType.ManufacturingOrderType  -- association [1..1]
LEFT OUTER JOIN I_ProductSupplyPlanning AS _ProductSupplyPlanning ON Material = _ProductSupplyPlanning.Product AND Plant = _ProductSupplyPlanning.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductUnitsOfMeasure AS _ProductUnitsOfMeasure ON Material = _ProductUnitsOfMeasure.Product  -- association [1..*]
LEFT OUTER JOIN I_MRPController AS _AssemblyMRPController ON Plant = _AssemblyMRPController.Plant AND AssemblyMRPController = _AssemblyMRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupervisor AS _ProductionSupervisor ON Plant = _ProductionSupervisor.Plant AND ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor  -- 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_ManufacturingOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrderSequence AS _MfgOrderSequence ON ManufacturingOrder = _MfgOrderSequence.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderSequence.ManufacturingOrderSequence  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrderOperation AS _MfgOrderOperation ON OrderInternalID = _MfgOrderOperation.MfgOrderInternalID AND OrderOperationInternalID = _MfgOrderOperation.OrderOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderComponentLongText AS _MfgOrderComponentLongText ON Reservation = _MfgOrderComponentLongText.Reservation AND ReservationItem = _MfgOrderComponentLongText.ReservationItem AND ReservationRecordType = _MfgOrderComponentLongText.RecordType AND LongTextLanguage = _MfgOrderComponentLongText.LongTextLanguage  -- association [0..1]
LEFT OUTER JOIN E_ReservationDocumentItem AS _Extension ON Reservation = _Extension.Reservation AND ReservationItem = _Extension.ReservationItem AND ReservationRecordType = _Extension.RecordType  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _MfgOrderText ON ManufacturingOrder = _MfgOrderText.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlantText ON ProductionPlant = _ProductionPlantText.Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _PlantText ON Plant = _PlantText.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _MaterialText ON Material = _MaterialText.Product  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementText ON WBSElementInternalID = _WBSElementText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocationText ON Plant = _StorageLocationText.Plant AND StorageLocation = _StorageLocationText.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyAreaText AS _SupplyAreaText ON Plant = _SupplyAreaText.Plant AND SupplyArea = _SupplyAreaText.ProductionSupplyArea  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _SupplierText ON Supplier = _SupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroupText ON PurchasingGroup = _PurchasingGroupText.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _PhantomAssemblyText ON Assembly = _PhantomAssemblyText.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _FollowUpMaterialText ON FollowUpMaterial = _FollowUpMaterialText.Product  -- association [0..*]
LEFT OUTER JOIN I_StatusObject AS _StatusObjectText ON ObjectInternalID = _StatusObjectText.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
;