R_ProductionOrderTP

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_ProductionOrderTP.
-- 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_ProductionOrderTP AS
SELECT
  cast(ManufacturingOrder as vdm_manufacturingorder preserving type) AS ProductionOrder,
  cast(ManufacturingOrder as manufacturingorder preserving type) AS ManufacturingOrder,
  ManufacturingOrderCategory,
  cast(ManufacturingOrderType as aufart preserving type ) AS ProductionOrderType,
  ManufacturingOrderText AS ProductionOrderText,
  ManufacturingOrderHasLongText AS OrderHasLongText,
  LongTextLanguageCode,
  ManufacturingOrderImportance AS OrderImportance,
  IsMarkedForDeletion,
  IsCompletelyDelivered,
  MfgOrderHasMultipleItems AS OrderHasMultipleItems,
  MfgOrderIsPartOfCollvOrder AS OrderIsPartOfCollectiveOrder,
  MfgOrderHierarchyLevel AS OrderHierarchyLevelValue,
  OrderIsNotCostedAutomatically,
  OrdIsNotSchedldAutomatically,
  ProdnProcgIsFlexible,
  CreationDate,
  CreationTime,
  CreatedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangedByUser,
  Product,
  StorageLocation,
  Batch,
  GoodsRecipientName,
  UnloadingPointName,
  InventoryUsabilityCode,
  MaterialGoodsReceiptDuration,
  QuantityDistributionKey,
  StockSegment,
  MfgOrderInternalID AS OrderInternalID,
  ReferenceOrder,
  LeadingOrder,
  SuperiorOrder,
  Currency,
  ProductionPlant,
  PlanningPlant,
  cast(MRPArea as berid preserving type ) AS MRPArea,
  MRPController,
  ProductionSupervisor,
  ProductionSchedulingProfile,
  ResponsiblePlannerGroup,
  ProductionVersion,
  SalesOrder,
  SalesOrderItem,
  cast( WBSElementInternalID as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  Reservation,
  SettlementReservation,
  MfgOrderConfirmation AS OrderConfirmationGroup,
  NumberOfMfgOrderConfirmations AS NumberOfOrderConfirmations,
  PlannedOrder,
  CapacityRequirement,
  InspectionLot,
  ChangeNumber,
  BasicSchedulingType,
  SchedulingIsAllowingForBreaks,
  ObjectInternalID,
  ProductConfiguration,
  EffectivityParameterVariant,
  ConditionApplication,
  CapacityActiveVersion,
  CapacityRqmtHasNotToBeCreated,
  OrderSequenceNumber,
  BillOfOperationsMaterial,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BOOInternalVersionCounter,
  BillOfOperationsUsage,
  BillOfOperationsVersion,
  BOOExplosionDate,
  BOOValidityStartDate,
  BillOfMaterialCategory,
  cast(BillOfMaterial as pph_stnum preserving type ) AS BillOfMaterial,
  BillOfMaterialVariant,
  BillOfMaterialVariantUsage,
  BillOfMaterialVersion,
  BOMExplosionDate,
  BOMValidityStartDate,
  BusinessArea,
  cast(CompanyCode as bukrs preserving type ) AS CompanyCode,
  ControllingArea,
  ProfitCenter,
  CostCenter,
  cast(ResponsibleCostCenter as pph_kostl preserving type ) AS ResponsibleCostCenter,
  CostElement,
  CostingSheet,
  GLAccount,
  ProductCostCollector,
  ActualCostsCostingVariant,
  PlannedCostsCostingVariant,
  ControllingObjectClass,
  FunctionalArea,
  OverheadCode,
  ResultAnalysisInternalID,
  VarianceKey,
  EventBasedProcessingKey,
  EventBasedPostingMethod,
  SchedulingFloatProfile,
  FloatBeforeProductionInWrkDays,
  FloatAfterProductionInWorkDays,
  ReleasePeriodInWorkDays,
  MfgOrderPlannedStartDate AS OrderPlannedStartDate,
  MfgOrderPlannedStartTime AS OrderPlannedStartTime,
  MfgOrderPlannedEndDate AS OrderPlannedEndDate,
  MfgOrderPlannedEndTime AS OrderPlannedEndTime,
  MfgOrderPlannedReleaseDate AS PlannedReleaseDate,
  MfgOrderScheduledStartDate AS OrderScheduledStartDate,
  MfgOrderScheduledStartTime AS OrderScheduledStartTime,
  MfgOrderScheduledEndDate AS OrderScheduledEndDate,
  MfgOrderScheduledEndTime AS OrderScheduledEndTime,
  MfgOrderScheduledReleaseDate AS OrderScheduledReleaseDate,
  MfgOrderActualStartDate AS OrderActualStartDate,
  MfgOrderActualStartTime AS OrderActualStartTime,
  MfgOrderItemActualDeliveryDate AS OrderActualEndDate,
  MfgOrderActualReleaseDate AS OrderActualReleaseDate,
  MfgOrderConfirmedEndDate AS OrderConfirmedEndDate,
  MfgOrderConfirmedEndTime AS OrderConfirmedEndTime,
  MfgOrderTotalCommitmentDate AS TotalCommitmentDate,
  MfgOrderActualCompletionDate AS TechnicalCompletionDate,
  ProductionUnit,
  MfgOrderPlannedTotalQty AS OrderPlannedTotalQty,
  MfgOrderPlannedScrapQty AS OrderPlannedScrapQty,
  MfgOrderConfirmedYieldQty AS OrderConfirmedYieldQty,
  MfgOrderConfirmedScrapQty AS OrderConfirmedScrapQty,
  MfgOrderConfirmedReworkQty AS OrderConfirmedReworkQty,
  ExpectedDeviationQuantity,
  ActualDeliveredQuantity
FROM I_ManufacturingOrder AS Header
LEFT OUTER JOIN R_ProductionOrderOperationTP AS _Operation ON _Operation.ProductionOrder = ProductionOrder AND _Operation.ProductionOrderSequence = '000000'  -- association [0..*]
LEFT OUTER JOIN R_ProdnOrderItemSerialNumberTP AS _SerialNumber ON _SerialNumber.ProductionOrder = ProductionOrder  -- association [0..*]
LEFT OUTER JOIN R_EventBasedOrderPostingRuleTP AS _PostingRule ON _PostingRule.OrderID = ProductionOrder AND _PostingRule.OrderItem = '0000'  -- association [0..*]
LEFT OUTER JOIN R_VariantConfigurationTP AS _VariantConfiguration ON VarConfigurationBusObjectType = _VariantConfiguration.VarConfigurationBusObjectType AND VarConfigurationBusObjectKey = _VariantConfiguration.VarConfigurationBusObjectKey  -- association [0..1]
LEFT OUTER JOIN E_ProductionOrder AS _Extension ON ProductionOrder = _Extension.ProductionOrder  -- association [1..1]
LEFT OUTER JOIN R_ProductionOrderItemTP AS _Item ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_ProductionOrderSequenceTP AS _Sequence ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ProductionOrderOpComponentTP AS _Component ON /* condition not available in parsed metadata */  -- association [0..*]
;