I_ProductionOrderComponent

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_ProductionOrderComponent.
-- 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_ProductionOrderComponent AS
SELECT
  comp.Reservation AS Reservation,
  comp.ReservationItem AS ReservationItem,
  comp.RecordType AS ReservationRecordType,
  comp.MaterialGroup AS MaterialGroup,
  comp.Material AS Material,
  comp.Plant AS Plant,
  cast(comp.OrderType as vdm_prodnordertype preserving type) AS ProductionOrderType,
  cast(comp.OrderID as vdm_manufacturingorder preserving type) AS ProductionOrder,
  cast(comp.Sequence as vdm_prodnordersequence preserving type) AS ProductionOrderSequence,
  comp.SequenceCategory AS SequenceCategory,
  cast(comp.OrderOperation as vdm_prodnorderoperation preserving type) AS ProductionOrderOperation,
  comp.ProductionPlant AS ProductionPlant,
  comp.OrderInternalID AS OrderInternalID,
  comp.OrderOperationInternalID AS OrderOperationInternalID,
  comp.MatlCompRequirementDate AS MatlCompRequirementDate,
  comp.MatlCompRequirementTime AS MatlCompRequirementTime,
  comp.LatestRequirementDate AS LatestRequirementDate,
  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,
  comp.MaterialComponentText AS MaterialComponentText,
  comp.MaterialComponentSecondText AS MaterialComponentSecondText,
  comp.MaterialComponentHasLongText AS MaterialComponentHasLongText,
  comp.LongTextLanguage AS LongTextLanguage,
  comp.RequirementType AS RequirementType,
  comp.SalesOrder AS SalesOrder,
  comp.SalesOrderItem AS SalesOrderItem,
  comp.ProductConfiguration AS ProductConfiguration,
  comp.ChangeNumber AS ChangeNumber,
  comp.MaterialRevisionLevel AS MaterialRevisionLevel,
  comp.EffectivityParameterVariant AS EffectivityParameterVariant,
  comp.MaterialComponentSortText AS MaterialComponentSortText,
  comp.ObjectInternalID AS ObjectInternalID,
  comp.BillOfMaterialCategory AS BillOfMaterialCategory,
  comp.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  comp.BillOfMaterialVariant AS BillOfMaterialVariant,
  comp.BOMItem AS BillOfMaterialItemNodeNumber,
  comp.BOMItemCategory AS BillOfMaterialItemCategory,
  comp.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  comp.PurchasingInfoRecord AS PurchasingInfoRecord,
  comp.PurchasingGroup AS PurchasingGroup,
  comp.PurchaseRequisition AS PurchaseRequisition,
  comp.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  cast(comp.PurchaseOrder as pph_ebeln preserving type) AS PurchasingDocument,
  cast(comp.PurchaseOrderItem as pph_ebelp preserving type) AS PurchasingDocumentItem,
  comp.Supplier AS Supplier,
  comp.DeliveryDurationInDays AS DeliveryDurationInDays,
  comp.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  comp.NumberOfPriceUnits 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.StockSegment AS StockSegment,
  comp.RequirementSegment AS RequirementSegment,
  comp.MaterialStaging AS MaterialStaging,
  comp.Batch AS Batch,
  comp.BatchSplitType AS BatchSplitType,
  comp.BatchMasterReservationItem AS BatchMasterReservationItem,
  comp.BatchClassification AS BatchClassification,
  comp.MaterialCompCostingRelevancy AS MaterialCompCostingRelevancy,
  comp.BusinessArea AS BusinessArea,
  comp.CompanyCode AS CompanyCode,
  comp.GLAccount AS GLAccount,
  comp.FunctionalArea AS FunctionalArea,
  comp.ControllingArea AS ControllingArea,
  comp.AccountAssignmentCategory AS AccountAssignmentCategory,
  comp.MaterialCompIsVariableSized AS MaterialCompIsVariableSized,
  comp.VariableSizeItemQuantity AS VariableSizeItemQuantity,
  comp.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  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.LeadTimeOffset AS LeadTimeOffset,
  comp.OperationLeadTimeOffsetUnit AS OperationLeadTimeOffsetUnit,
  comp.OperationLeadTimeOffset AS OperationLeadTimeOffset,
  comp.QuantityIsFixed AS QuantityIsFixed,
  comp.IsNetScrap AS ScrapQtyIsNetScrap,
  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,
  comp.Currency AS Currency,
  comp.WithdrawnQuantityAmount AS WithdrawnQuantityAmount,
  comp._SequenceCategory AS _SequenceCategory,
  comp._OrderInternalID AS _OrderInternalID,
  comp._ProductionPlant AS _ProductionPlant,
  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._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._PhantomAssembly AS _Assembly,
  comp._BOMItemCategory AS _BOMItemCategory,
  comp._SalesOrder AS _SalesOrder,
  comp._SalesOrderItem AS _SalesOrderItem,
  comp._WBSElementBasicData AS _WBSElementBasicData,
  comp._ChangeNumber AS _ChangeNumber,
  comp._MaterialRevisionLevel AS _MaterialRevisionLevel,
  comp._PurchasingGroup AS _PurchasingGroup,
  comp._PurchasingInfoRecord AS _PurchasingInfoRecord,
  comp._PurchaseRequisition AS _PurchaseRequisition,
  comp._PurchaseRequisitionItem AS _PurchaseRequisitionItem,
  comp._Supplier AS _Supplier,
  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._OpLeadTimeOffsetUnit AS _OpLeadTimeOffsetUnit,
  comp._VariableSizeItemUnit AS _VariableSizeItemUnit,
  comp._VariableSizeComponentUnit AS _VariableSizeComponentUnit,
  comp._BaseUnit AS _BaseUnit,
  comp._EntryUnit AS _EntryUnit,
  comp._Currency AS _Currency,
  comp._StatusObject AS _StatusObject,
  comp._LongTextLanguage AS _LongTextLanguage
FROM I_OrderComponent AS comp
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_ProductionOrderType AS _ProductionOrderType ON ProductionOrderType = _ProductionOrderType.ProductionOrderType  -- association [1..1]
LEFT OUTER JOIN I_ProductionOrder AS _ProductionOrderHeader ON ProductionOrder = _ProductionOrderHeader.ProductionOrder  -- association [1..1]
LEFT OUTER JOIN I_ProductionOrderSequence AS _ProductionOrderSequence ON ProductionOrder = _ProductionOrderSequence.ProductionOrder AND ProductionOrderSequence = _ProductionOrderSequence.ProductionOrderSequence  -- association [1..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_ProductionOrder AS _ProductionOrderText ON ProductionOrder = _ProductionOrderText.ProductionOrder  -- 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 _AssemblyText ON Assembly = _AssemblyText.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..*]
LEFT OUTER JOIN I_ProdnOrderComponentLongText AS _LongText ON /* condition not available in parsed metadata */  -- association [0..*]
;