I_MfgOrderDuration

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_MfgOrderDuration.
-- 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: IMFGORDERDURN

CREATE VIEW I_MfgOrderDuration AS
SELECT
  ord.ManufacturingOrder AS ManufacturingOrder,
  ord.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  ord.ManufacturingOrderType AS ManufacturingOrderType,
  ord.ManufacturingOrderText AS ManufacturingOrderText,
  ord.ManufacturingOrderHasLongText AS ManufacturingOrderHasLongText,
  ord.LongTextLanguageCode AS LongTextLanguageCode,
  ord.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  ord.IsMarkedForDeletion AS MfgOrderIsToBeDeleted,
  ord.MfgOrderHasMultipleItems AS MfgOrderHasMultipleItems,
  ord.MfgOrderIsPartOfCollvOrder AS MfgOrderIsPartOfCollvOrder,
  ord.ProdnProcgIsFlexible AS ProdnProcgIsFlexible,
  case when _isCreated.StatusCode is null then '' else 'X' end AS OrderIsCreated,
  case when _isReleased.StatusCode is null then '' else 'X' end AS OrderIsReleased,
  case when _isPrinted.StatusCode is null then '' else 'X' end AS OrderIsPrinted,
  case when _isConfirmed.StatusCode is null then '' else 'X' end AS OrderIsConfirmed,
  case when _isPartConf.StatusCode is null then '' else 'X' end AS OrderIsPartiallyConfirmed,
  case when _isDelivered.StatusCode is null then '' else 'X' end AS OrderIsDelivered,
  case when _isDeleted.StatusCode is null then '' else 'X' end AS OrderIsDeleted,
  case when _isPreCosted.StatusCode is null then '' else 'X' end AS OrderIsPreCosted,
  case when _SRuleIsCreated.StatusCode is null then '' else 'X' end AS SettlementRuleIsCreated,
  case when _isPartRel.StatusCode is null then '' else 'X' end AS OrderIsPartiallyReleased,
  case when _isLocked.StatusCode is null then '' else 'X' end AS OrderIsLocked,
  case when _isTechCompl.StatusCode is null then '' else 'X' end AS OrderIsTechnicallyCompleted,
  case when _isClosed.StatusCode is null then '' else 'X' end AS OrderIsClosed,
  case when _isPartDeliv.StatusCode is null then '' else 'X' end AS OrderIsPartiallyDelivered,
  case when _isMarkedDel.StatusCode is null then '' else 'X' end AS OrderIsMarkedForDeletion,
  case when _isSRuleManual.StatusCode is null then '' else 'X' end AS SettlementRuleIsCrtedManually,
  case when _isScheduled.StatusCode is null then '' else 'X' end AS OrderIsScheduled,
  case when _hasGenerOper.StatusCode is null then '' else 'X' end AS OrderHasGeneratedOperations,
  case when _inBatches.StatusCode is null then '' else 'X' end AS OrderIsToBeHandledInBatches,
  case when _AvNotChecked.StatusCode is null then '' else 'X' end AS MaterialAvailyIsNotChecked,
  case when _isShopFloor.StatusCode is null then '' else 'X' end AS OrderIsShopFloorOrder,
  case when _isPartCollRel.StatusCode is null then '' else 'X' end AS OrderInCollvOrdersIsReleased,
  ord.CreationDate AS MfgOrderCreationDate,
  ord.CreationTime AS MfgOrderCreationTime,
  ord.CreatedByUser AS CreatedByUser,
  ord.LastChangeDate AS LastChangeDate,
  ord.LastChangeTime AS LastChangeTime,
  ord.LastChangedByUser AS LastChangedByUser,
  ord.Material AS Material,
  ord.Product AS Product,
  ord.StorageLocation AS StorageLocation,
  ord.GoodsRecipientName AS GoodsRecipientName,
  ord.UnloadingPointName AS UnloadingPointName,
  ord.InventoryUsabilityCode AS InventoryUsabilityCode,
  ord.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  ord.QuantityDistributionKey AS QuantityDistributionKey,
  ord.StockSegment AS StockSegment,
  ord.MfgOrderInternalID AS OrderInternalBillOfOperations,
  ord.SuperiorOrder AS MfgOrderSuperiorMfgOrder,
  ord.ReferenceOrder AS ReferenceOrder,
  ord.LeadingOrder AS LeadingOrder,
  ord.Currency AS Currency,
  ord.ProductionPlant AS ProductionPlant,
  ord.PlanningPlant AS MRPPlant,
  ord.MRPArea AS MRPArea,
  ord.Batch AS Batch,
  ord.MRPController AS MRPController,
  ord.ProductionSupervisor AS ProductionSupervisor,
  ord.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  ord.ProductionSchedulingProfile AS ProductionSchedulingProfile,
  ord.ProductionVersion AS ProductionVersion,
  ord.PlannedOrder AS PlannedOrder,
  ord.SalesOrder AS SalesOrder,
  ord.SalesOrderItem AS SalesOrderItem,
  ord.WBSElementInternalID AS WBSElementInternalID,
  ord.WBSElementInternalID_2 AS WBSElementInternalID_2,
  ord.Reservation AS Reservation,
  ord.MfgOrderConfirmation AS MfgOrderConfirmation,
  ord.NumberOfMfgOrderConfirmations AS NumberOfMfgOrderConfirmations,
  ord.CapacityRequirement AS CapacityRequirement,
  ord.InspectionLot AS InspectionLot,
  ord.ChangeNumber AS ChangeNumber,
  ord.BasicSchedulingType AS BasicSchedulingType,
  ord.ObjectInternalID AS ObjectInternalID,
  ord.ProductConfiguration AS ProductConfiguration,
  ord.EffectivityParameterVariant AS EffectivityParameterVariant,
  ord.ConditionApplication AS ConditionApplication,
  ord.CapacityActiveVersion AS CapacityActiveVersion,
  ord.CapacityRqmtHasNotToBeCreated AS CapacityRqmtHasNotToBeCreated,
  ord.OrderSequenceNumber AS OrderSequenceNumber,
  ord.MfgOrderSplitStatus AS MfgOrderSplitStatus,
  ord.BillOfOperationsMaterial AS BillOfOperationsMaterial,
  ord.BillOfOperationsType AS BillOfOperationsType,
  ord.BillOfOperations AS BillOfOperations,
  ord.BillOfOperationsGroup AS BillOfOperationsGroup,
  ord.BillOfOperationsVariant AS BillOfOperationsVariant,
  ord.BOOInternalVersionCounter AS BOOInternalVersionCounter,
  ord.BillOfOperationsApplication AS BillOfOperationsApplication,
  ord.BillOfOperationsUsage AS BillOfOperationsUsage,
  ord.BillOfOperationsVersion AS BillOfOperationsVersion,
  ord.BOOExplosionDate AS BOOExplosionDate,
  ord.BOOValidityStartDate AS BOOValidityStartDate,
  ord.BillOfMaterialCategory AS BillOfMaterialCategory,
  ord.BillOfMaterial AS BillOfMaterial,
  ord.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  ord.BillOfMaterialVariant AS BillOfMaterialVariant,
  ord.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  ord.BillOfMaterialVersion AS BillOfMaterialVersion,
  ord.BOMExplosionDate AS BOMExplosionDate,
  ord.BOMValidityStartDate AS BOMValidityStartDate,
  ord.BusinessArea AS BusinessArea,
  ord.CompanyCode AS CompanyCode,
  ord.ControllingArea AS ControllingArea,
  ord.ProfitCenter AS ProfitCenter,
  ord.CostCenter AS CostCenter,
  ord.ResponsibleCostCenter AS ResponsibleCostCenter,
  ord.CostElement AS CostElement,
  ord.CostingSheet AS CostingSheet,
  ord.GLAccount AS GLAccount,
  ord.ProductCostCollector AS ProductCostCollector,
  ord.ActualCostsCostingVariant AS ActualCostsCostingVariant,
  ord.PlannedCostsCostingVariant AS PlannedCostsCostingVariant,
  ord.ControllingObjectClass AS ControllingObjectClass,
  ord.FunctionalArea AS FunctionalArea,
  ord.EventBasedPostingMethod AS EventBasedPostingMethod,
  ord.EventBasedProcessingKey AS EventBasedProcessingKey,
  ord.MfgOrderPlannedStartDate AS MfgOrderPlannedStartDate,
  ord.MfgOrderPlannedStartTime AS MfgOrderPlannedStartTime,
  ord.MfgOrderPlannedEndDate AS MfgOrderPlannedEndDate,
  ord.MfgOrderPlannedEndTime AS MfgOrderPlannedEndTime,
  ord.MfgOrderPlannedReleaseDate AS MfgOrderPlannedReleaseDate,
  ord.MfgOrderScheduledStartDate AS MfgOrderScheduledStartDate,
  ord.MfgOrderScheduledStartTime AS MfgOrderScheduledStartTime,
  ord.MfgOrderScheduledEndDate AS MfgOrderScheduledEndDate,
  ord.MfgOrderScheduledEndTime AS MfgOrderScheduledEndTime,
  ord.MfgOrderScheduledReleaseDate AS MfgOrderScheduledReleaseDate,
  ord.MfgOrderActualStartDate AS MfgOrderActualStartDate,
  ord.MfgOrderActualStartTime AS MfgOrderActualStartTime,
  ord.MfgOrderActualEndDate AS MfgOrderActualEndDate,
  ord.MfgOrderActualReleaseDate AS MfgOrderActualReleaseDate,
  ord.MfgOrderItemActualDeliveryDate AS MfgOrderActualDeliveryDate,
  ord.MfgOrderConfirmedEndDate AS MfgOrderConfirmedEndDate,
  ord.MfgOrderConfirmedEndTime AS MfgOrderConfirmedEndTime,
  ord.MfgOrderTotalCommitmentDate AS MfgOrderTotalCommitmentDate,
  ord.ProductionUnit AS ProductionUnit,
  ord.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  ord.MfgOrderPlannedScrapQty AS MfgOrderPlannedScrapQty,
  cast((ord.MfgOrderPlannedTotalQty - ord.MfgOrderPlannedScrapQty) as plannedyieldquantity) AS MfgOrderPlannedYieldQty,
  ord.MfgOrderConfirmedYieldQty AS MfgOrderConfirmedYieldQty,
  ord.MfgOrderConfirmedScrapQty AS MfgOrderConfirmedScrapQty,
  ord.MfgOrderConfirmedReworkQty AS MfgOrderConfirmedReworkQty,
  ord.ExpectedDeviationQuantity AS ExpectedDeviationQuantity,
  ord.ActualDeliveredQuantity AS ActualDeliveredQuantity,
  ord.ChangeToScheduledDatesIsMade AS ChangeToScheduledDatesIsMade,
  ord.MasterProductionOrder AS MasterProductionOrder,
  ord.ProductSeasonYear AS ProductSeasonYear,
  ord.ProductSeason AS ProductSeason,
  ord.ProductCollection AS ProductCollection,
  ord.ProductTheme AS ProductTheme,
  ord.RequestOrderType AS RequestOrderType,
  ord.OrderSettlementTriggerType AS OrderSettlementTriggerType,
  ord._MfgOrderCategory AS _MfgOrderCategory,
  ord._MfgOrderType AS _MfgOrderType,
  ord._MfgOrderLongText AS _MfgOrderLongText,
  ord._MfgOrderImportance AS _MfgOrderImportance,
  ord._OrderTypeDetails AS _OrderTypeDetails,
  ord._SuperiorOrder AS _SuperiorOrder,
  ord._ReferenceOrder AS _ReferenceOrder,
  ord._LeadingOrder AS _LeadingOrder,
  ord._CreatedByUser AS _CreatedByUser,
  ord._LastChangedByUser AS _LastChangedByUser,
  ord._LongTextLanguage AS _LongTextLanguage,
  ord._ProductionUnit AS _ProductionUnit,
  ord._Currency AS _Currency,
  ord._OrderInternalID AS _OrderInternalID,
  ord._BillOfOperationsMaterial AS _BillOfOperationsMaterial,
  ord._BillOfOperationsType AS _BillOfOperationsType,
  ord._BillOfOperationsGroup AS _BillOfOperationsGroup,
  ord._BillOfOperationsGroup2 AS _BillOfOperationsGroup2,
  ord._BillOfOperations AS _BillOfOperations,
  ord._BillOfOperations2 AS _BillOfOperations2,
  ord._BillOfOperationsChangeState AS _BillOfOperationsChangeState,
  ord._BillOfOperationsChangeState2 AS _BillOfOperationsChangeState2,
  ord._BillOfOperationsApplication AS _BillOfOperationsApplication,
  ord._BillOfOperationsUsage AS _BillOfOperationsUsage,
  ord._ConfirmationGroup AS _ConfirmationGroup,
  ord._Reservation AS _Reservation,
  ord._ProductionPlant AS _Plant,
  ord._PlanningPlant AS _MRPPlant,
  ord._Material AS _Material,
  ord._StorageLocation AS _StorageLocation,
  ord._InventoryUsabilityCode AS _InventoryUsabilityCode,
  ord._Batch AS _Batch,
  ord._Batch_2 AS _Batch_2,
  ord._MRPArea AS _MRPArea,
  ord._MRPController AS _MRPController,
  ord._ProductionSupervisor AS _ProductionSupervisor,
  ord._ProductionSchedulingProfile AS _ProductionSchedulingProfile,
  ord._ResponsiblePlannerGroup AS _ResponsiblePlannerGroup,
  ord._ProductPlant AS _ProductPlant,
  ord._ProductPlant2 AS _ProductPlant2,
  ord._CapacityRequirement AS _CapacityRequirement,
  ord._ChangeNumber AS _ChangeNumber,
  ord._InspectionLot AS _InspectionLot,
  ord._SalesOrder AS _SalesOrder,
  ord._SalesOrderItem AS _SalesOrderItem,
  ord._SalesDocument AS _SalesDocument,
  ord._SalesDocumentItem AS _SalesDocumentItem,
  ord._WBSElement AS _WBSElement,
  ord._WBSElementBasicData AS _WBSElementBasicData,
  ord._WBSElementBasicData2 AS _WBSElementBasicData2,
  ord._PlannedOrder AS _PlannedOrder,
  ord._BusinessArea AS _BusinessArea,
  ord._ProfitCenter AS _ProfitCenter,
  ord._CostCenter AS _CostCenter,
  ord._CostElement AS _CostElement,
  ord._ResponsibleCostCenter AS _ResponsibleCostCenter,
  ord._CompanyCode AS _CompanyCode,
  ord._ControllingArea AS _ControllingArea,
  ord._GLAccount AS _GLAccount,
  ord._ProductCostCollector AS _ProductCostCollector,
  ord._ControllingObjectClass AS _ControllingObjectClass,
  ord._FunctionalArea AS _FunctionalArea,
  ord._ActualCostsCostingVariant AS _ActualCostsCostingVariant,
  ord._PlannedCostsCostingVariant AS _PlannedCostsCostingVariant,
  ord._BasicSchedulingType AS _BasicSchedulingType,
  ord._LongText AS _LongText,
  ord._RFM_MasterProductOrder AS _RFM_MasterProductOrder,
  ord._RequestOrderType AS _RequestOrderType
FROM I_ManufacturingOrder AS ord
LEFT OUTER JOIN I_ProductionVersion AS _ProductionVersion ON Material = _ProductionVersion.Material AND ProductionPlant = _ProductionVersion.Plant AND ProductionVersion = _ProductionVersion.ProductionVersion  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _PlannedStartDate ON MfgOrderPlannedStartDate = _PlannedStartDate.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _PlannedEndDate ON MfgOrderPlannedEndDate = _PlannedEndDate.CalendarDate  -- association [1..1]
;