C_ConvertPlannedOrder

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_ConvertPlannedOrder.
-- 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: CCONVPLNDORDERS

CREATE VIEW C_ConvertPlannedOrder AS
SELECT
  PlannedOrder,
  Material,
  I_PlannedOrder._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  BaseUnit,
  PlannedTotalQtyInBaseUnit,
  PlannedOrderType,
  BillOfMaterialStatus,
  PlannedOrderCategory,
  MRPArea,
  MRPPlant,
  ProductionPlant,
  I_PlannedOrder.MRPController AS MRPController,
  MaterialProcurementCategory,
  PlannedOrderIsFirm,
  PlannedOrderOpeningDate,
  PlndOrderPlannedStartDate,
  PlndOrderPlannedEndDate,
  ProductionVersion,
  ProductionSupervisor,
  FixedSupplier AS Supplier,
  cast( '' as abap.char( 2 ) ) AS PlndOrdProcessingActionControl,
  _PurchasingDocument.PurchasingGroup AS PurchasingGroup,
  I_PlannedOrder._Material AS _Material,
  I_PlannedOrder._MRPController AS _MRPController,
  _PurchasingDocument._PurchasingGroup AS _PurchasingGroup,
  I_PlannedOrder.PlannedOrderLongText AS PlannedOrderLongText
FROM I_PlannedOrder
INNER JOIN I_SDMAreaOfResponsibility AS SDMAreaOfResponsibility ON /* join condition not captured in parsed metadata */
;