R_RFM_ManageMfgOrderTP

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 R_RFM_ManageMfgOrderTP.
-- 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 R_RFM_ManageMfgOrderTP AS
SELECT
  ManufacturingOrder,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  ManufacturingOrderText,
  OrderInternalBillOfOperations,
  ReferenceOrder,
  MRPPlant,
  MRPPlantName,
  MRPArea,
  MRPAreaText,
  MRPController,
  MRPControllerName,
  ResponsiblePlannerGroup,
  ControllingArea,
  ProfitCenter,
  CostCenter,
  GLAccount,
  FunctionalArea,
  ProductionPlant,
  ProductionPlantName,
  ProductionSupervisor,
  SalesDocument,
  SalesDocumentItem,
  WBSDescription,
  ProductionVersion,
  ProductionVersionText,
  ProductionLine,
  ManufacturingOrderImportance,
  MfgOrderSuperiorMfgOrder,
  InspectionLot,
  BasicSchedulingType,
  SchedulingTypeName,
  MfgOrderScheduledStartDate,
  MfgOrderScheduledEndDate,
  MfgOrderActualStartDate,
  MfgOrderActualEndDate,
  MfgOrderConfirmedEndDate,
  MfgOrderCreationDate,
  LastChangeDate,
  MfgOrderPlannedStartDate,
  MfgOrderPlannedEndDate,
  MfgOrderPlannedReleaseDate,
  MfgOrderScheduledReleaseDate,
  MfgOrderActualReleaseDate,
  OrderStartDate,
  MfgOrderEndDate,
  ProductionUnit,
  _UnitOfMeasureText.UnitOfMeasureName AS UnitOfMeasureName,
  MfgOrderPlannedTotalQty,
  MfgOrderPlannedScrapQty,
  MfgOrderPlannedYieldQty,
  MfgOrderConfirmedYieldQty,
  MfgOrderConfirmedScrapQty,
  MfgOrderConfirmedReworkQty,
  ExpectedDeviationQuantity,
  ActualDeliveredQuantity,
  OrderOpenQuantity,
  OrderYieldDeviationQty,
  OrderHasQualityIssue,
  Material,
  MaterialName,
  EffectivityParameterVariant,
  Batch,
  OrderLongText,
  ManufacturingOrderTypeName,
  StorageLocation,
  StockSegment,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  CombinedProductionOrder,
  MasterProductionOrder,
  CrossPlantConfigurableProduct,
  _MaterialText.MaterialName AS FashionGenericMaterialName,
  MaterialType,
  _MaterialTypeText.MaterialTypeName AS MaterialTypeName,
  MaterialGroup,
  _MaterialGroupText.MaterialGroupName AS MaterialGroupName,
  ProductCategory,
  _ProductCategoryText.Name AS ProductCategoryName,
  ProductCharacteristic1,
  ProductCharacteristic2,
  ProductCharacteristic3,
  ObjectInternalID,
  _status.OrderStatusInternalID AS OrderStatusInternalID
FROM I_RFM_MfgOrderDuration
LEFT OUTER JOIN I_RFM_MfgOrderCurrentStatus AS _status ON ObjectInternalID = _status.StatusObject  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON CrossPlantConfigurableProduct = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialTypeText AS _MaterialTypeText ON MaterialType = _MaterialTypeText.MaterialType AND _MaterialTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductCategoryText AS _ProductCategoryText ON ProductCategory = _ProductCategoryText.ProductCategory AND _ProductCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup AND _MaterialGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON ProductionUnit = _UnitOfMeasureText.UnitOfMeasure AND _UnitOfMeasureText.Language = $session.system_language  -- association [0..1]
;