C_ProductionOrderEnhancedVH

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_ProductionOrderEnhancedVH.
-- 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 C_ProductionOrderEnhancedVH AS
SELECT
  cast(OrdHeader.ManufacturingOrder as manufacturingorder preserving type) AS ProductionOrder,
  OrdHeader.ManufacturingOrderText AS ProductionOrderText,
  cast(OrdHeader.ManufacturingOrderType as vdm_prodnordertype preserving type) AS ProductionOrderType,
  _ProductionOrderTypeText[ 1: Language = $session.system_language ].OrderTypeName AS ProductionOrderTypeName,
  cast(OrdHeader.ProductionPlant as pwwrk preserving type) AS ProductionPlant,
  OrdHeader._ProductionPlant[ 1: Language = $session.system_language ].PlantName AS PlantName,
  OrdHeader.Material AS Material,
  OrdHeader._MaterialText[ 1: Language = $session.system_language ].ProductName AS MaterialName,
  OrdHeader.MRPController AS MRPController,
  OrdHeader._MRPController.MRPControllerName AS MRPControllerName,
  OrdHeader.ProductionSupervisor AS ProductionSupervisor,
  OrdHeader._ProductionSupervisor.ProductionSupervisorName AS ProductionSupervisorName,
  cast(OrdHeader.SalesOrder as co_kdauf preserving type) AS SalesOrder,
  OrdHeader._MfgOrderType AS _MfgOrderType,
  OrdHeader._ProductionPlant AS _ProductionPlant,
  OrdHeader._MaterialText AS _MaterialText,
  OrdHeader._MRPController AS _MRPController,
  OrdHeader._ProductionSupervisor AS _ProductionSupervisor
FROM I_ManufacturingOrder AS OrdHeader
INNER JOIN I_MfgOrderWithStatus AS OrdData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OrderTypeText AS _ProductionOrderTypeText ON ProductionOrderType = _ProductionOrderTypeText.OrderType  -- association [0..*]
;