I_MfgOrderComponentWithStatus

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_MfgOrderComponentWithStatus.
-- 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_MfgOrderComponentWithStatus AS
SELECT
  comp.Reservation AS Reservation,
  comp.ReservationItem AS ReservationItem,
  comp.ReservationRecordType AS ReservationRecordType,
  cast(comp.MaterialGroup as matkl preserving type) AS MaterialGroup,
  cast(comp.Material as matnr preserving type) AS Material,
  cast(comp.Plant as werks_d preserving type) AS Plant,
  comp.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  cast(comp.ManufacturingOrderType as aufart preserving type) AS ManufacturingOrderType,
  comp.ManufacturingOrder AS ManufacturingOrder,
  comp.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  comp.MfgOrderSequenceCategory AS MfgOrderSequenceCategory,
  comp.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  cast(comp.ProductionPlant as pwwrk preserving type) AS ProductionPlant,
  comp.OrderInternalID AS OrderInternalID,
  comp.OrderOperationInternalID AS OrderOperationInternalID,
  comp.AssemblyMRPController AS AssemblyMRPController,
  comp.ProductionSupervisor AS ProductionSupervisor,
  comp.ReservationItemCreationCode AS ReservationItemCreationCode,
  comp.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  comp.MatlCompIsMarkedForDeletion AS MatlCompIsMarkedForDeletion,
  comp.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  comp.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  comp.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  comp.MatlCompIsTextItem AS MatlCompIsTextItem,
  comp.MaterialPlanningRelevance AS MaterialPlanningRelevance,
  comp.MatlCompIsConfigurable AS MatlCompIsConfigurable,
  comp.MaterialComponentIsClassified AS MaterialComponentIsClassified,
  comp.MaterialCompIsIntraMaterial AS MaterialCompIsIntraMaterial,
  comp.MaterialIsDirectlyProduced AS MaterialIsDirectlyProduced,
  comp.MaterialIsDirectlyProcured AS MaterialIsDirectlyProcured,
  stat.MaterialComponentIsCreated AS MaterialComponentIsCreated,
  stat.MaterialComponentIsReleased AS MaterialComponentIsReleased,
  stat.MaterialComponentIsPrinted AS MaterialComponentIsPrinted,
  stat.MaterialComponentIsDeleted AS MaterialComponentIsDeleted,
  stat.MatlCompIsCreatedByOrderSplit AS MatlCompIsCreatedByOrderSplit,
  comp.MaterialComponentText AS MaterialComponentText,
  comp.MaterialComponentSecondText AS MaterialComponentSecondText,
  comp.MaterialComponentHasLongText AS MaterialComponentHasLongText,
  comp.LongTextLanguage AS LongTextLanguage,
  comp.MatlCompRequirementDate AS MatlCompRequirementDate,
  comp.MatlCompRequirementTime AS MatlCompRequirementTime,
  comp.LatestRequirementDate AS LatestRequirementDate,
  comp.RequirementType AS RequirementType,
  comp.SalesOrder AS SalesOrder,
  comp.SalesOrderItem AS SalesOrderItem,
  comp.WBSElementInternalID AS WBSElementInternalID,
  cast(_MaterialPlant.MRPController as pph_dispo preserving type) AS MRPController,
  comp.ProductConfiguration AS ProductConfiguration,
  comp.ChangeNumber AS ChangeNumber,
  comp.MaterialRevisionLevel AS MaterialRevisionLevel,
  comp.EffectivityParameterVariant AS EffectivityParameterVariant,
  comp.MatlCompFreeDefinedAttribute AS MatlCompFreeDefinedAttribute,
  comp.MaterialComponentSortText AS MaterialComponentSortText,
  comp.ObjectInternalID AS ObjectInternalID,
  comp.BillOfMaterialCategory AS BillOfMaterialCategory,
  comp.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  comp.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  comp.BillOfMaterialVariant AS BillOfMaterialVariant,
  comp.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  comp.BillOfMaterialVersion AS BillOfMaterialVersion,
  comp.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  comp.InheritedBOMItemNode AS InheritedBOMItemNode,
  comp.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  comp.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  comp.BOMExplosionDateID AS BOMExplosionDateID,
  comp.PurchasingGroup AS PurchasingGroup,
  comp.PurchaseOrderScheduleLine AS PurchaseOrderScheduleLine,
  cast(comp.Supplier as lifnr preserving type) AS Supplier,
  comp.DeliveryDurationInDays AS DeliveryDurationInDays,
  comp.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  comp.NumberOfOperationPriceUnits AS NumberOfOperationPriceUnits,
  comp.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  comp.StorageLocation AS StorageLocation,
  comp.DebitCreditCode AS DebitCreditCode,
  comp.GoodsMovementType AS GoodsMovementType,
  comp.InventorySpecialStockType AS InventorySpecialStockType,
  comp.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  comp.ConsumptionPosting AS ConsumptionPosting,
  comp.SupplyArea AS SupplyArea,
  comp.GoodsRecipientName AS GoodsRecipientName,
  comp.UnloadingPointName AS UnloadingPointName,
  comp.MaterialCompCostingRelevancy AS MaterialCompCostingRelevancy,
  comp.BusinessArea AS BusinessArea,
  cast(comp.CompanyCode as bukrs preserving type) AS CompanyCode,
  comp.GLAccount AS GLAccount,
  comp.FunctionalArea AS FunctionalArea,
  cast(comp.ControllingArea as kokrs preserving type) AS ControllingArea,
  comp.AccountAssignmentCategory AS AccountAssignmentCategory,
  comp.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  cast(comp.Batch as charg_d preserving type) AS Batch,
  comp.BatchSplitType AS BatchSplitType,
  comp.BatchMasterReservationItem AS BatchMasterReservationItem,
  comp.BatchClassification AS BatchClassification,
  comp.MaterialCompIsVariableSized AS MaterialCompIsVariableSized,
  comp.VariableSizeItemUnit AS VariableSizeItemUnit,
  comp.VariableSizeItemQuantity AS VariableSizeItemQuantity,
  comp.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  comp.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  comp.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  comp.VariableSizeDimension1 AS VariableSizeDimension1,
  comp.VariableSizeDimension2 AS VariableSizeDimension2,
  comp.VariableSizeDimension3 AS VariableSizeDimension3,
  comp.VariableSizeCompFormulaKey AS VariableSizeCompFormulaKey,
  comp.MaterialCompIsAlternativeItem AS MaterialCompIsAlternativeItem,
  comp.AlternativeItemGroup AS AlternativeItemGroup,
  comp.AlternativeItemStrategy AS AlternativeItemStrategy,
  comp.AlternativeItemPriority AS AlternativeItemPriority,
  comp.UsageProbabilityPercent AS UsageProbabilityPercent,
  comp.AlternativeMstrReservationItem AS AlternativeMstrReservationItem,
  comp.MaterialComponentIsPhantomItem AS MaterialComponentIsPhantomItem,
  comp.OrderPathValue AS OrderPathValue,
  comp.OrderLevelValue AS OrderLevelValue,
  comp.Assembly AS Assembly,
  comp.AssemblyOrderPathValue AS AssemblyOrderPathValue,
  comp.AssemblyOrderLevelValue AS AssemblyOrderLevelValue,
  comp.DiscontinuationGroup AS DiscontinuationGroup,
  comp.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  comp.MatlCompIsFollowUpMaterial AS MatlCompIsFollowUpMaterial,
  comp.FollowUpGroup AS FollowUpGroup,
  comp.FollowUpMaterial AS FollowUpMaterial,
  comp.FollowUpMaterialIsActive AS FollowUpMaterialIsActive,
  comp.DiscontinuationMasterResvnItem AS DiscontinuationMasterResvnItem,
  comp.MaterialProvisionType AS MaterialProvisionType,
  comp.MatlComponentSparePartType AS MatlComponentSparePartType,
  comp.LeadTimeOffset AS LeadTimeOffset,
  comp.OperationLeadTimeOffsetUnit AS OperationLeadTimeOffsetUnit,
  comp.OperationLeadTimeOffset AS OperationLeadTimeOffset,
  comp.QuantityIsFixed AS QuantityIsFixed,
  comp.IsNetScrap AS IsNetScrap,
  comp.ComponentScrapInPercent AS ComponentScrapInPercent,
  comp.OperationScrapInPercent AS OperationScrapInPercent,
  comp.MaterialQtyToBaseQtyNmrtr AS MaterialQtyToBaseQtyNmrtr,
  comp.MaterialQtyToBaseQtyDnmntr AS MaterialQtyToBaseQtyDnmntr,
  comp.RequiredQuantity AS RequiredQuantity,
  comp.WithdrawnQuantity AS WithdrawnQuantity,
  comp.ConfirmedAvailableQuantity AS ConfirmedAvailableQuantity,
  comp.MaterialCompOriginalQuantity AS MaterialCompOriginalQuantity,
  comp.GoodsMovementEntryQty AS GoodsMovementEntryQty,
  cast(comp.Currency as waers preserving type) AS Currency,
  comp.WithdrawnQuantityAmount AS WithdrawnQuantityAmount,
  comp.StockSegment AS StockSegment,
  comp.RequirementSegment AS RequirementSegment,
  comp.CriticalComponentType AS CriticalComponentType,
  comp.CriticalComponentLevel AS CriticalComponentLevel,
  comp._Reservation AS _Reservation,
  comp._ReservationItem AS _ReservationItem,
  comp._ReservationRecordType AS _ReservationRecordType,
  comp._MfgOrder AS _MfgOrder,
  comp._MfgOrderCategory AS _MfgOrderCategory,
  comp._MfgOrderType AS _MfgOrderType,
  comp._MfgOrderOperation AS _MfgOrderOperation,
  comp._MfgOrderOperationBySemKey AS _MfgOrderOperationBySemKey,
  comp._MfgOrderSequence AS _MfgOrderSequence,
  comp._MfgOrderSequenceCategory AS _MfgOrderSequenceCategory,
  comp._MfgOrderComponentLongText AS _MfgOrderComponentLongText,
  comp._OrderInternalID AS _OrderInternalID,
  comp._ProductionPlant AS _ProductionPlant,
  comp._AssemblyMRPController AS _AssemblyMRPController,
  comp._ProductionSupervisor AS _ProductionSupervisor,
  comp._RequirementType AS _RequirementType,
  comp._MaterialGroup AS _MaterialGroup,
  comp._Material AS _Material,
  comp._Product AS _Product,
  comp._ProductPlant AS _ProductPlant,
  comp._ProductStorageLocation AS _ProductStorageLocation,
  comp._ProductSupplyPlanning AS _ProductSupplyPlanning,
  comp._ProductUnitsOfMeasure AS _ProductUnitsOfMeasure,
  comp._Plant AS _Plant,
  comp._StorageLocation AS _StorageLocation,
  comp._Batch AS _Batch,
  comp._BatchSplitType AS _BatchSplitType,
  comp._DebitCreditCode AS _DebitCreditCode,
  comp._GoodsMovementType AS _GoodsMovementType,
  comp._InventorySpecialStockType AS _InventorySpecialStockType,
  comp._InventorySpecialStockValnType AS _InventorySpecialStockValnType,
  comp._ConsumptionPosting AS _ConsumptionPosting,
  comp._SupplyArea AS _SupplyArea,
  comp._FollowUpMaterial AS _FollowUpMaterial,
  comp._DiscontinuationType AS _DiscontinuationType,
  comp._ProvisionType AS _ProvisionType,
  comp._SparePartType AS _SparePartType,
  comp._PhantomAssembly AS _PhantomAssembly,
  comp._BOMExplosion AS _BOMExplosion,
  comp._BillOfMaterialItem AS _BillOfMaterialItem,
  comp._BOMItemCategory AS _BOMItemCategory,
  comp._SalesOrder AS _SalesOrder,
  comp._SalesOrderItem AS _SalesOrderItem,
  comp._WBSElementBasicData AS _WBSElementBasicData,
  comp._EnterpriseProjectElement AS _EnterpriseProjectElement,
  comp._ChangeNumber AS _ChangeNumber,
  comp._MaterialRevisionLevel AS _MaterialRevisionLevel,
  comp._PurchasingGroup AS _PurchasingGroup,
  comp._PurchasingInfoRecord AS _PurchasingInfoRecord,
  comp._PurchaseOrder AS _PurchaseOrder,
  comp._PurchaseOrderItem AS _PurchaseOrderItem,
  comp._PurchaseRequisition AS _PurchaseRequisition,
  comp._PurchaseRequisitionItem AS _PurchaseRequisitionItem,
  comp._Supplier AS _Supplier,
  comp._SupplierCompanyByPlant AS _SupplierCompanyByPlant,
  comp._CompanyCode AS _CompanyCode,
  comp._BusinessArea AS _BusinessArea,
  comp._GLAccount AS _GLAccount,
  comp._ControllingArea AS _ControllingArea,
  comp._FunctionalArea AS _FunctionalArea,
  comp._AccountAssignmentCategory AS _AccountAssignmentCategory,
  comp._EarmarkedFunds AS _EarmarkedFunds,
  comp._EarmarkedFundsItem AS _EarmarkedFundsItem,
  comp._OpLeadTimeOffsetUnit AS _OpLeadTimeOffsetUnit,
  comp._VariableSizeItemUnit AS _VariableSizeItemUnit,
  comp._VariableSizeCompUnit AS _VariableSizeCompUnit,
  comp._VariableSizeDimensionUnit AS _VariableSizeDimensionUnit,
  comp._BaseUnit AS _BaseUnit,
  comp._EntryUnit AS _EntryUnit,
  comp._Currency AS _Currency,
  comp._StatusObject AS _StatusObject,
  comp._LongTextLanguage AS _LongTextLanguage,
  stat._ComponentIsCreatedCode AS _ComponentIsCreatedCode,
  stat._ComponentIsReleasedCode AS _ComponentIsReleasedCode,
  stat._ComponentIsPrintedCode AS _ComponentIsPrintedCode,
  stat._ComponentIsDeletedCode AS _ComponentIsDeletedCode,
  stat._CompIsCreatedByOrderSplitCode AS _CompIsCreatedByOrderSplitCode,
  comp._MfgOrderText AS _MfgOrderText,
  comp._PlantText AS _PlantText,
  comp._ProductionPlantText AS _ProductionPlantText,
  comp._MaterialText AS _MaterialText,
  comp._WBSElementText AS _WBSElementText,
  comp._StorageLocationText AS _StorageLocationText,
  comp._SupplyAreaText AS _SupplyAreaText,
  comp._SupplierText AS _SupplierText,
  comp._PurchasingGroupText AS _PurchasingGroupText,
  comp._PhantomAssemblyText AS _PhantomAssemblyText,
  comp._FollowUpMaterialText AS _FollowUpMaterialText,
  comp._StatusObjectText AS _StatusObjectText,
  comp._BusinessAreaText AS _BusinessAreaText,
  comp._CompanyCodeText AS _CompanyCodeText,
  comp._ControllingAreaText AS _ControllingAreaText,
  comp._FunctionalAreaText AS _FunctionalAreaText
FROM I_ManufacturingOrderComponent AS comp
INNER JOIN P_OrderOpCompStatusBasicAggrgn AS stat ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MRPController AS _MRPController ON Plant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_MaterialPlant AS _MaterialPlant ON Plant = _MaterialPlant.Plant AND Material = _MaterialPlant.Material  -- 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]
;