C_SlsDocFlfmtMfgOrder

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 C_SlsDocFlfmtMfgOrder.
-- 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: CSOFMFGORD

CREATE VIEW C_SlsDocFlfmtMfgOrder AS
SELECT
  MfgOrder.ManufacturingOrder AS ManufacturingOrder,
  MfgOrder.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  MfgOrder.ManufacturingOrderType AS ManufacturingOrderType,
  cast(MfgOrderItem.Material as productnumber preserving type ) AS Material,
  MfgOrderItem._Material._Text[1:Language=$session.system_language].MaterialName AS MaterialName,
  MfgOrder.ProductionPlant AS ProductionPlant,
  MfgOrder.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  MfgOrder.ProductionUnit AS ProductionUnit,
  MfgOrder.SalesOrder AS SalesOrder,
  MfgOrder.SalesOrderItem AS SalesOrderItem,
  SalesOrderItem.OrderQuantity AS OrderQuantity,
  SalesOrderItem.OrderQuantityUnit AS OrderQuantityUnit,
  SalesOrderItem.NetAmount AS NetAmount,
  SalesOrderItem.TransactionCurrency AS TransactionCurrency,
  MfgOrder.ProductionSupervisor AS ProductionSupervisor,
  MfgOrder._ProductionSupervisor.ProductionSupervisorName AS ProductionSupervisorName,
  MfgOrder.MRPController AS MRPController,
  MfgOrder._MRPController.MRPControllerName AS MRPControllerName,
  MfgOrder.MfgOrderScheduledStartDate AS MfgOrderScheduledStartDate,
  MfgOrder.MfgOrderScheduledEndDate AS MfgOrderScheduledEndDate,
  MfgOrder.MfgOrderScheduledReleaseDate AS MfgOrderScheduledReleaseDate,
  MfgOrder.MfgOrderActualStartDate AS MfgOrderActualStartDate,
  MfgOrder.MfgOrderActualReleaseDate AS MfgOrderActualReleaseDate,
  MfgOrder.MfgOrderItemActualDeliveryDate AS MfgOrderItemActualDeliveryDate,
  MfgOrder.MfgOrderConfirmedEndDate AS MfgOrderConfirmedEndDate,
  cast( case when MfgOrder.MfgOrderActualStartDate = '00000000' and MfgOrder.MfgOrderScheduledStartDate < $session.system_date then 1 when MfgOrder.MfgOrderActualStartDate <> '00000000' then 3 else 0 end as abap.int1 ) as MfgOrderActualStartDateCritlty AS int1asMfgOrderActualStartDateCritlty,
  cast( case when MfgOrder.MfgOrderActualReleaseDate = '00000000' and MfgOrder.MfgOrderScheduledReleaseDate < $session.system_date then 1 when MfgOrder.MfgOrderActualReleaseDate <> '00000000' then 3 else 0 end as abap.int1 ) as MfgOrdActualRelDateCriticality AS int1asMfgOrdActualRelDateCriticality,
  cast( case when MfgOrder.MfgOrderActualEndDate = '00000000' and MfgOrder.MfgOrderScheduledEndDate < $session.system_date then 1 when MfgOrder.MfgOrderActualEndDate <> '00000000' and MfgOrder.IsCompletelyDelivered = ' ' then 3 else 0 end as abap.int1 ) as MfgOrdActualEndDateCriticality AS int1asMfgOrdActualEndDateCriticality,
  MfgOrder._MfgOrderCategory AS _MfgOrderCategory,
  MfgOrder._MfgOrderType AS _MfgOrderType,
  MfgOrder._ProductionUnit AS _ProductionUnit,
  MfgOrder._Plant AS _Plant,
  SalesOrderItem._OrderQuantityUnit AS _OrderQuantityUnit,
  SalesOrderItem._TransactionCurrency AS _TransactionCurrency
FROM I_MfgOrder AS MfgOrder
LEFT OUTER JOIN E_LogisticsOrder AS _Extension ON ManufacturingOrder = _Extension.OrderID  -- association [0..1]
;