I_MfgOrderItemDuration

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_MfgOrderItemDuration.
-- 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: IMFGORDITEMDURN

CREATE VIEW I_MfgOrderItemDuration AS
SELECT
  item.ManufacturingOrder AS ManufacturingOrder,
  item.ManufacturingOrderItem AS ManufacturingOrderItem,
  item.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  item.ManufacturingOrderType AS ManufacturingOrderType,
  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 _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,
  item.Material AS Material,
  item.ProductionPlant AS ProductionPlant,
  item.PlanningPlant AS MRPPlant,
  item.MRPController AS MRPController,
  item.ProductionSupervisor AS ProductionSupervisor,
  item.Reservation AS Reservation,
  item.ProductionVersion AS ProductionVersion,
  item.MRPArea AS MRPArea,
  item.SerialNumberAssgmtProfile AS SerialNumberAssgmtProfile,
  item.NumberOfSerialNumbers AS NumberOfSerialNumbers,
  item.ProductConfiguration AS ProductConfiguration,
  item.IsCompletelyDelivered AS IsCompletelyDelivered,
  item.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  item.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  item.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  item.StorageLocation AS StorageLocation,
  item.Batch AS Batch,
  item.InventoryValuationType AS InventoryValuationType,
  item.InventoryValuationCategory AS InventoryValuationCategory,
  item.InventorySpecialStockType AS InventorySpecialStockType,
  item.MfgOrderConfirmedEndDate AS MfgOrderConfirmedEndDate,
  item.MfgOrderConfirmedEndTime AS MfgOrderConfirmedEndTime,
  item.MfgOrderPlannedStartDate AS MfgOrderPlannedStartDate,
  item.MfgOrderPlannedStartTime AS MfgOrderPlannedStartTime,
  item.MfgOrderScheduledStartDate AS MfgOrderScheduledStartDate,
  item.MfgOrderScheduledStartTime AS MfgOrderScheduledStartTime,
  item.MfgOrderActualStartDate AS MfgOrderActualStartDate,
  item.MfgOrderActualStartTime AS MfgOrderActualStartTime,
  item.MfgOrderPlannedEndDate AS MfgOrderPlannedEndDate,
  item.MfgOrderPlannedEndTime AS MfgOrderPlannedEndTime,
  item.MfgOrderScheduledEndDate AS MfgOrderScheduledEndDate,
  item.MfgOrderScheduledEndTime AS MfgOrderScheduledEndTime,
  item.MfgOrderActualEndDate AS MfgOrderActualEndDate,
  item.MfgOrderScheduledReleaseDate AS MfgOrderScheduledReleaseDate,
  item.MfgOrderActualReleaseDate AS MfgOrderActualReleaseDate,
  item.MfgOrderItemPlannedEndDate AS MfgOrderItemPlannedEndDate,
  item.MfgOrderItemScheduledEndDate AS MfgOrderItemScheduledEndDate,
  item.MfgOrderItemPlndDeliveryDate AS MfgOrderItemPlndDeliveryDate,
  item.MfgOrderItemActualDeliveryDate AS MfgOrderItemActualDeliveryDate,
  cast(durn.MfgOrderItemAvailabilityDate as mfgorderitemavailydate preserving type) AS MfgOrderItemAvailabilityDate,
  item.MfgOrderItemTotalCmtmtDate AS MfgOrderItemTotalCmtmtDate,
  durn.PlannedDurationInWorkdays AS MfgOrdItemGdsRcptPlndDuration,
  durn.ScheduledDurationInWorkdays AS MfgOrdItemGdsRcptSchdldDurn,
  durn.ActualDurationInWorkdays AS MfgOrdItemGdsRcptActDuration,
  item.ProductionUnit AS ProductionUnit,
  item.MfgOrderItemPlannedTotalQty AS MfgOrderItemPlannedTotalQty,
  item.MfgOrderItemPlannedScrapQty AS MfgOrderItemPlannedScrapQty,
  item.MfgOrderItemPlannedYieldQty AS MfgOrderItemPlannedYieldQty,
  item.MfgOrderItemGoodsReceiptQty AS MfgOrderItemGoodsReceiptQty,
  item.MfgOrderItemActualDeviationQty AS MfgOrderItemActualDeviationQty,
  item.MfgOrderConfirmedYieldQty AS MfgOrderConfirmedYieldQty,
  item.MfgOrderConfirmedScrapQty AS MfgOrderConfirmedScrapQty,
  item.MfgOrderConfirmedReworkQty AS MfgOrderConfirmedReworkQty,
  item.MfgOrderConfirmedTotalQty AS MfgOrderConfirmedTotalQty,
  item.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  item.MfgOrderPlannedScrapQty AS MfgOrderPlannedScrapQty,
  item.ManufacturingObject AS ManufacturingObject,
  item.ObjectInternalID AS ObjectInternalID,
  item._MfgOrder AS _MfgOrder,
  item._MfgOrderCategory AS _MfgOrderCategory,
  item._MfgOrderType AS _MfgOrderType,
  item._ProductionPlant AS _ProductionPlant,
  item._ProductionSupervisor AS _ProductionSupervisor,
  item._MRPController AS _MRPController,
  item._MRPPlant AS _MRPPlant,
  item._MRPArea AS _MRPArea,
  item._Material AS _Material,
  item._ProductionUnit AS _ProductionUnit,
  item._ProductionVersion AS _ProductionVersion,
  item._Reservation AS _Reservation,
  item._StorageLocation AS _StorageLocation,
  item._InventorySpecialStockType AS _InventorySpecialStockType,
  item._InventoryValuationType AS _InventoryValuationType
FROM I_ManufacturingOrderItem AS item
INNER JOIN P_MfgOrderItemDurnInWorkdays ON /* join condition not captured in parsed metadata */
;