I_ManageOrdersTP

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_ManageOrdersTP.
-- 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: IMPEMANORDERTP

CREATE VIEW I_ManageOrdersTP AS
SELECT
  cast(ManufacturingOrder as aufnr preserving type) AS ManufacturingOrder,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  ManufacturingOrderText,
  ReferenceOrder,
  MRPPlant,
  MRPArea,
  MRPController,
  ResponsiblePlannerGroup,
  ControllingArea,
  ProfitCenter,
  CostCenter,
  ResponsibleCostCenter,
  CostElement,
  GLAccount,
  FunctionalArea,
  ProductionPlant,
  ProductionSupervisor,
  SalesOrder AS SalesDocument,
  SalesOrderItem AS SalesDocumentItem,
  _WBSElement.WBSElement AS WBSElement,
  _WBSElement.WBSDescription AS WBSDescription,
  ProductionVersion,
  _ProductionVersion.ProductionVersionText AS ProductionVersionText,
  _ProductionVersion.ProductionLine AS ProductionLine,
  ManufacturingOrderImportance,
  ProdnProcgIsFlexible,
  MfgOrderSuperiorMfgOrder,
  I_MfgOrderDuration.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  MfgOrderSplitStatus,
  OrderIsCreated,
  OrderIsReleased,
  OrderIsPrinted,
  OrderIsConfirmed,
  OrderIsPartiallyConfirmed,
  OrderIsDelivered,
  OrderIsDeleted,
  OrderIsPreCosted,
  SettlementRuleIsCreated,
  OrderIsPartiallyReleased,
  OrderIsTechnicallyCompleted,
  OrderIsClosed,
  OrderIsPartiallyDelivered,
  OrderIsLocked,
  SettlementRuleIsCrtedManually,
  OrderIsScheduled,
  OrderIsShopFloorOrder,
  OrderHasGeneratedOperations,
  OrderIsToBeHandledInBatches,
  MaterialAvailyIsNotChecked,
  MfgOrderIsToBeDeleted,
  OrderInCollvOrdersIsReleased,
  MfgOrderScheduledStartDate,
  MfgOrderScheduledStartTime,
  MfgOrderScheduledEndDate,
  MfgOrderScheduledEndTime,
  MfgOrderActualStartDate,
  MfgOrderActualStartTime,
  MfgOrderActualEndDate,
  MfgOrderConfirmedEndDate,
  MfgOrderConfirmedEndTime,
  MfgOrderCreationDate,
  MfgOrderCreationTime,
  LastChangeDate,
  LastChangeTime,
  MfgOrderPlannedStartDate,
  MfgOrderPlannedStartTime,
  MfgOrderPlannedReleaseDate,
  MfgOrderPlannedEndTime,
  MfgOrderPlannedEndDate,
  MfgOrderScheduledReleaseDate,
  MfgOrderActualReleaseDate,
  MfgOrderTotalCommitmentDate,
  ProductionUnit,
  MfgOrderPlannedTotalQty,
  MfgOrderConfirmedYieldQty,
  MfgOrderConfirmedScrapQty,
  MfgOrderPlannedScrapQty,
  MfgOrderPlannedYieldQty,
  ActualDeliveredQuantity,
  ExpectedDeviationQuantity,
  MfgOrderConfirmedReworkQty,
  InspectionLot,
  BasicSchedulingType,
  ConfirmedStartDelayInSeconds,
  CurrentStartDelayInSeconds,
  ConfirmedEndDelayInSeconds,
  CurrentEndDelayInSeconds,
  Material,
  I_MfgOrderDuration.Product AS Product,
  ProductConfiguration,
  EffectivityParameterVariant,
  ObjectInternalID,
  Batch,
  ChangeToScheduledDatesIsMade,
  MasterProductionOrder,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsVersion,
  RequestOrderType,
  EventBasedPostingMethod,
  EventBasedProcessingKey,
  OrderSettlementTriggerType,
  StockSegment,
  CreatedByUser,
  I_MfgOrderDuration._RequestOrderType AS _RequestOrderType
FROM I_MfgOrderDuration
INNER JOIN P_MfgOrderAORList AS _AORList ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductionLine AS _ProductionLine ON ProductionPlant = _ProductionLine.Plant AND productionline = _ProductionLine.ProductionLine  -- association [0..1]
LEFT OUTER JOIN P_ProdnProductHierarcyNode AS _ProductHierNodePlant ON Material = _ProductHierNodePlant.Material AND ProductionPlant = _ProductHierNodePlant.ProductionPlant AND _ProductHierNodePlant.ProdnProductHierarchyPurpose = '02' AND _ProductHierNodePlant.UniversalHierVersValidFrom <= $session.user_date AND _ProductHierNodePlant.UniversalHierVersValidTo >= $session.user_date  -- association [0..1]
LEFT OUTER JOIN P_ProdnProductHierarcyNode AS _ProductHierNodeAllPlants ON Material = _ProductHierNodeAllPlants.Material AND _ProductHierNodeAllPlants.ProductionPlant = '*' AND _ProductHierNodeAllPlants.ProdnProductHierarchyPurpose = '02' AND _ProductHierNodeAllPlants.UniversalHierVersValidFrom <= $session.user_date AND _ProductHierNodeAllPlants.UniversalHierVersValidTo >= $session.user_date  -- association [0..1]
LEFT OUTER JOIN P_ProdnProductHierarcyNode AS _ProductHierNodeAll ON Material = _ProductHierNodeAll.Material AND _ProductHierNodeAll.ProductionPlant = '*' AND _ProductHierNodeAll.ProdnProductHierarchyPurpose = '*' AND _ProductHierNodeAll.UniversalHierVersValidFrom <= $session.user_date AND _ProductHierNodeAll.UniversalHierVersValidTo >= $session.user_date  -- association [0..1]
LEFT OUTER JOIN I_ProductionVersionBasic AS _ProductionVersion ON Material = _ProductionVersion.Material AND ProductionPlant = _ProductionVersion.Plant AND ProductionVersion = _ProductionVersion.ProductionVersion  -- association [0..1]
LEFT OUTER JOIN I_ChFiExProdnOrdConfign AS _ChFiExProdnOrdConfign ON ManufacturingOrder = _ChFiExProdnOrdConfign.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN E_LogisticsOrder AS _Extension ON ManufacturingOrder = _Extension.OrderID  -- association [1..1]
;