R_ProductionOrderOpComponentTP

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 R_ProductionOrderOpComponentTP.
-- 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 R_ProductionOrderOpComponentTP AS
SELECT
  Component.Reservation AS Reservation,
  Component.ReservationItem AS ReservationItem,
  Component.ReservationRecordType AS ReservationRecordType,
  cast(Component.MaterialGroup as matkl preserving type ) AS MaterialGroup,
  cast(Component.Material as matnr preserving type ) AS Material,
  Component.Plant AS Plant,
  cast(Component.ManufacturingOrder as vdm_manufacturingorder preserving type) AS ProductionOrder,
  Component.ManufacturingOrderSequence AS ProductionOrderSequence,
  Component.MfgOrderSequenceCategory AS SequenceCategory,
  cast ( Component.ManufacturingOrderOperation as vdm_vornr preserving type ) AS ProductionOrderOperation,
  Component.OrderInternalID AS OrderInternalID,
  Component.OrderOperationInternalID AS OrderOperationInternalID,
  Component.MatlCompRequirementDate AS MatlCompRequirementDate,
  Component.MatlCompRequirementTime AS MatlCompRequirementTime,
  Component.LatestRequirementDate AS LatestRequirementDate,
  Component.ReservationItemCreationCode AS ReservationItemCreationCode,
  Component.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  Component.MatlCompIsMarkedForDeletion AS MatlCompIsMarkedForDeletion,
  Component.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  Component.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  Component.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  Component.MaterialCompIsAlternativeItem AS MaterialCompIsAlternativeItem,
  Component.MatlCompIsTextItem AS MatlCompIsTextItem,
  Component.MaterialProvisionType AS MaterialProvisionType,
  Component.MaterialPlanningRelevance AS MaterialPlanningRelevance,
  Component.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  Component.MatlCompIsConfigurable AS MatlCompIsConfigurable,
  Component.MaterialCompCostingRelevancy AS MaterialCompCostingRelevancy,
  Component.MaterialComponentIsClassified AS MaterialComponentIsClassified,
  Component.MaterialCompIsIntraMaterial AS MaterialCompIsIntraMaterial,
  Component.UsageProbabilityPercent AS UsageProbabilityPercent,
  Component.MaterialIsDirectlyProduced AS MaterialIsDirectlyProduced,
  Component.MaterialIsDirectlyProcured AS MaterialIsDirectlyProcured,
  Component.LongTextLanguage AS LongTextLanguage,
  Component.MaterialComponentHasLongText AS MaterialComponentHasLongText,
  Component.RequirementType AS RequirementType,
  Component.SalesOrder AS SalesOrder,
  Component.SalesOrderItem AS SalesOrderItem,
  cast ( Component.WBSElementInternalID as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  Component.ProductConfiguration AS ProductConfiguration,
  Component.ChangeNumber AS ChangeNumber,
  Component.EffectivityParameterVariant AS EffectivityParameterVariant,
  Component.MatlCompFreeDefinedAttribute AS MatlCompFreeDefinedAttribute,
  Component.BillOfMaterialCategory AS BillOfMaterialCategory,
  Component.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  Component.BillOfMaterialVariant AS BillOfMaterialVariant,
  Component.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  Component.BillOfMaterialVersion AS BillOfMaterialVersion,
  Component.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  Component.InheritedBOMItemNode AS InheritedBOMItemNode,
  Component.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  Component.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  Component.MaterialComponentText AS MaterialComponentText,
  Component.MaterialComponentSecondText AS MaterialComponentSecondText,
  Component.BOMExplosionDateID AS BOMExplosionDateID,
  Component.PurchasingInfoRecord AS PurchasingInfoRecord,
  Component.PurchasingGroup AS PurchasingGroup,
  Component.Supplier AS Supplier,
  Component.DeliveryDurationInDays AS DeliveryDurationInDays,
  Component.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  Component.NumberOfOperationPriceUnits AS NumberOfOperationPriceUnits,
  Component.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  Component.StorageLocation AS StorageLocation,
  cast(Component.Batch as charg_d preserving type ) AS Batch,
  Component.BatchSplitType AS BatchSplitType,
  Component.DebitCreditCode AS DebitCreditCode,
  Component.GoodsMovementType AS GoodsMovementType,
  Component.InventorySpecialStockType AS InventorySpecialStockType,
  Component.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  Component.ConsumptionPosting AS ConsumptionPosting,
  Component.SupplyArea AS SupplyArea,
  Component.GoodsRecipientName AS GoodsRecipientName,
  Component.UnloadingPointName AS UnloadingPointName,
  Component.StockSegment AS StockSegment,
  Component.RequirementSegment AS RequirementSegment,
  Component.BusinessArea AS BusinessArea,
  Component.GLAccount AS GLAccount,
  Component.FunctionalArea AS FunctionalArea,
  Component.AccountAssignmentCategory AS AccountAssignmentCategory,
  Component.MaterialCompIsVariableSized AS MaterialCompIsVariableSized,
  Component.VariableSizeItemUnit AS VariableSizeItemUnit,
  Component.VariableSizeItemQuantity AS VariableSizeItemQuantity,
  Component.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  Component.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  Component.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  Component.VariableSizeDimension1 AS VariableSizeDimension1,
  Component.VariableSizeDimension2 AS VariableSizeDimension2,
  Component.VariableSizeDimension3 AS VariableSizeDimension3,
  Component.VariableSizeCompFormulaKey AS VariableSizeCompFormulaKey,
  Component.MaterialComponentIsPhantomItem AS MaterialComponentIsPhantomItem,
  Component.OrderPathValue AS OrderPathValue,
  Component.OrderLevelValue AS OrderLevelValue,
  Component.LeadTimeOffset AS LeadTimeOffset,
  Component.OperationLeadTimeOffsetUnit AS OperationLeadTimeOffsetUnit,
  Component.OperationLeadTimeOffset AS OperationLeadTimeOffset,
  Component.QuantityIsFixed AS QuantityIsFixed,
  Component.IsNetScrap AS IsNetScrap,
  Component.ComponentScrapInPercent AS ComponentScrapInPercent,
  Component.OperationScrapInPercent AS OperationScrapInPercent,
  Component.MaterialQtyToBaseQtyNmrtr AS MaterialQtyToBaseQtyNmrtr,
  Component.MaterialQtyToBaseQtyDnmntr AS MaterialQtyToBaseQtyDnmntr,
  Component.BaseUnit AS BaseUnit,
  Component.RequiredQuantity AS RequiredQuantity,
  Component.WithdrawnQuantity AS WithdrawnQuantity,
  Component.ConfirmedAvailableQuantity AS ConfirmedAvailableQuantity,
  Component.MaterialCompOriginalQuantity AS MaterialCompOriginalQuantity,
  Component.EntryUnit AS EntryUnit,
  Component.GoodsMovementEntryQty AS GoodsMovementEntryQty,
  Component.Currency AS Currency,
  Component.WithdrawnQuantityAmount AS WithdrawnQuantityAmount
FROM I_ManufacturingOrderComponent AS Component
LEFT OUTER JOIN E_ProductionOrderComponent AS _Extension ON Reservation = _Extension.Reservation AND ReservationItem = _Extension.ReservationItem AND ReservationRecordType = _Extension.ReservationRecordType  -- association [1..1]
;