I_MfgOrderForOutput

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_MfgOrderForOutput.
-- 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 I_MfgOrderForOutput AS
SELECT
  cast(ord.ManufacturingOrder as co_aufnr preserving type) AS ManufacturingOrder,
  ord.ManufacturingOrderText AS ManufacturingOrderText,
  ord.ManufacturingOrderHasLongText AS ManufacturingOrderHasLongText,
  ord.LongTextLanguageCode AS LongTextLanguageCode,
  ord.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  ord.MfgOrderHasMultipleItems AS MfgOrderHasMultipleItems,
  ord.MfgOrderIsPartOfCollvOrder AS MfgOrderIsPartOfCollvOrder,
  ord.MfgOrderHierarchyLevelValue AS MfgOrderHierarchyLevelValue,
  ord.MfgOrderHierarchyPathValue AS MfgOrderHierarchyPathValue,
  ord.CreationDate AS CreationDate,
  ord.CreationTime AS CreationTime,
  ord.CreatedByUser AS CreatedByUser,
  ord.LastChangeDate AS LastChangeDate,
  ord.LastChangeTime AS LastChangeTime,
  ord.LastChangedByUser AS LastChangedByUser,
  ord.Product AS Product,
  _Product._Text[1: Language=$session.system_language].ProductName AS ProductName,
  StorageLocation,
  ord.Batch AS Batch,
  ord.GoodsRecipientName AS GoodsRecipientName,
  ord.UnloadingPointName AS UnloadingPointName,
  ord.InventoryUsabilityCode AS InventoryUsabilityCode,
  ord.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  ord.QuantityDistributionKey AS QuantityDistributionKey,
  ord.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  cast(ord.ManufacturingOrderType as aufart preserving type) AS ManufacturingOrderType,
  ord.SuperiorOrder AS SuperiorOrder,
  ord.ReferenceOrder AS ReferenceOrder,
  ord.LeadingOrder AS LeadingOrder,
  ord.ProductionPlant AS ProductionPlant,
  ord._ProductionPlant.PlantName AS ProductionPlantName,
  ord.PlanningPlant AS PlanningPlant,
  ord._PlanningPlant.PlantName AS PlanningPlantName,
  cast(ord.MRPArea as berid preserving type) AS MRPArea,
  ord._MRPArea.MRPAreaText AS MRPAreaText,
  ord.MRPController AS MRPController,
  ord._MRPController.MRPControllerName AS MRPControllerName,
  ord.ProductionSupervisor AS ProductionSupervisor,
  ord._ProductionSupervisor.ProductionSupervisorName AS ProductionSupervisorName,
  ord.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  ord._ResponsiblePlannerGroup.ResponsiblePlannerGroupName AS ResponsiblePlannerGroupName,
  ord.ProductionSchedulingProfile AS ProductionSchedulingProfile,
  ord.ProductionVersion AS ProductionVersion,
  ord.PlannedOrder AS PlannedOrder,
  ord.SalesOrder AS SalesOrder,
  ord.SalesOrderItem AS SalesOrderItem,
  ord._WBSElementBasicData2.WBSElementExternalID AS WBSElement,
  ord._WBSElementBasicData2.WBSDescription AS WBSDescription,
  ord.Reservation AS Reservation,
  ord.CapacityRequirement AS CapacityRequirement,
  ord.InspectionLot AS InspectionLot,
  ord.ChangeNumber AS ChangeNumber,
  ord.BasicSchedulingType AS BasicSchedulingType,
  ord.ObjectInternalID AS ObjectInternalID,
  ord.EffectivityParameterVariant AS EffectivityParameterVariant,
  ord.CapacityActiveVersion AS CapacityActiveVersion,
  ord.MfgOrderSplitStatus AS MfgOrderSplitStatus,
  ord.BillOfOperationsMaterial AS BillOfOperationsMaterial,
  ord.BillOfOperationsType AS BillOfOperationsType,
  ord.BillOfOperationsGroup AS BillOfOperationsGroup,
  ord.BillOfOperationsVariant AS BillOfOperationsVariant,
  ord.BOOInternalVersionCounter AS BOOInternalVersionCounter,
  ord.BillOfOperationsUsage AS BillOfOperationsUsage,
  ord.BillOfOperationsVersion AS BillOfOperationsVersion,
  ord.BOOExplosionDate AS BOOExplosionDate,
  ord.BOOValidityStartDate AS BOOValidityStartDate,
  ord.BillOfMaterialCategory AS BillOfMaterialCategory,
  ord.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  ord.BillOfMaterialVariant AS BillOfMaterialVariant,
  ord.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  ord.BillOfMaterialVersion AS BillOfMaterialVersion,
  ord.BOMExplosionDate AS BOMExplosionDate,
  ord.BOMValidityStartDate AS BOMValidityStartDate,
  ord.BusinessArea AS BusinessArea,
  cast(ord.CompanyCode as bukrs preserving type) AS CompanyCode,
  ord.ControllingArea AS ControllingArea,
  ord.ProfitCenter AS ProfitCenter,
  ord.CostCenter AS CostCenter,
  cast(ord.ResponsibleCostCenter as pph_kostl preserving type) AS ResponsibleCostCenter,
  ord.CostElement AS CostElement,
  ord.CostingSheet AS CostingSheet,
  ord.GLAccount AS GLAccount,
  ord.ProductCostCollector AS ProductCostCollector,
  ord.ActualCostsCostingVariant AS ActualCostsCostingVariant,
  ord.PlannedCostsCostingVariant AS PlannedCostsCostingVariant,
  ord.ControllingObjectClass AS ControllingObjectClass,
  ord.FunctionalArea AS FunctionalArea,
  ord.SchedulingFloatProfile AS SchedulingFloatProfile,
  ord.FloatBeforeProductionInWrkDays AS FloatBeforeProductionInWrkDays,
  ord.FloatAfterProductionInWorkDays AS FloatAfterProductionInWorkDays,
  ord.ReleasePeriodInWorkDays AS ReleasePeriodInWorkDays,
  ord.MfgOrderPlannedStartDate AS MfgOrderPlannedStartDate,
  ord.MfgOrderPlannedStartTime AS MfgOrderPlannedStartTime,
  ord.MfgOrderPlannedEndDate AS MfgOrderPlannedEndDate,
  ord.MfgOrderPlannedEndTime AS MfgOrderPlannedEndTime,
  ord.MfgOrderPlannedReleaseDate AS MfgOrderPlannedReleaseDate,
  ord.MfgOrderScheduledStartDate AS MfgOrderScheduledStartDate,
  ord.MfgOrderScheduledStartTime AS MfgOrderScheduledStartTime,
  ord.MfgOrderScheduledEndDate AS MfgOrderScheduledEndDate,
  ord.MfgOrderScheduledEndTime AS MfgOrderScheduledEndTime,
  ord.MfgOrderScheduledReleaseDate AS MfgOrderScheduledReleaseDate,
  ord.MfgOrderActualStartDate AS MfgOrderActualStartDate,
  ord.MfgOrderActualStartTime AS MfgOrderActualStartTime,
  ord.MfgOrderConfirmedEndDate AS MfgOrderConfirmedEndDate,
  ord.MfgOrderConfirmedEndTime AS MfgOrderConfirmedEndTime,
  ord.MfgOrderActualReleaseDate AS MfgOrderActualReleaseDate,
  ord.MfgOrderActualCompletionDate AS MfgOrderActualCompletionDate,
  ord.MfgOrderItemActualDeliveryDate AS MfgOrderItemActualDeliveryDate,
  ord.MfgOrderTotalCommitmentDate AS MfgOrderTotalCommitmentDate,
  ord.ProductionUnit AS ProductionUnit,
  ord.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  ord.MfgOrderPlannedScrapQty AS MfgOrderPlannedScrapQty,
  ord.MfgOrderConfirmedYieldQty AS MfgOrderConfirmedYieldQty,
  ord.MfgOrderConfirmedScrapQty AS MfgOrderConfirmedScrapQty,
  ord.MfgOrderConfirmedReworkQty AS MfgOrderConfirmedReworkQty,
  ord.ExpectedDeviationQuantity AS ExpectedDeviationQuantity,
  ord.ActualDeliveredQuantity AS ActualDeliveredQuantity
FROM I_ManufacturingOrder AS ord
;