I_MfgOrderBasic

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_MfgOrderBasic.
-- 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: IPPMFGORDERBASIC

CREATE VIEW I_MfgOrderBasic AS
SELECT
  cast(aufv.OrderID as manufacturingorder preserving type) AS ManufacturingOrder,
  cast(aufv.OrderInternalBillOfOperations as pph_aufpl preserving type) AS OrderInternalID,
  aufv.Reservation AS Reservation,
  aufv.OrderCategory AS ManufacturingOrderCategory,
  aufv.OrderType AS ManufacturingOrderType,
  aufv.IsMarkedForDeletion AS MfgOrderIsToBeDeleted,
  aufv.MfgOrderHasMultipleItems AS MfgOrderHasMultipleItems,
  aufv.MfgOrderIsPartOfCollvOrder AS MfgOrderIsPartOfCollvOrder,
  aufv.OrderHierarchyLevelValue AS MfgOrderHierarchyLevelValue,
  aufv.OrderHierarchyPathValue AS MfgOrderHierarchyPathValue,
  aufv.OrderIsNotCostedAutomatically AS OrderIsNotCostedAutomatically,
  aufv.OrdIsNotSchedldAutomatically AS OrdIsNotSchedldAutomatically,
  aufv.ProdnProcgIsFlexible AS ProdnProcgIsFlexible,
  aufv.ExtdQualityCheckIsRequired AS ExtdQualityCheckIsRequired,
  aufv.MfgOrderIsProductReworkOrder AS MfgOrderIsProductReworkOrder,
  aufv.OrderDescription AS ManufacturingOrderText,
  aufv.LongTextLanguage AS LongTextLanguage,
  cast(aufv.CreationDate as ordercreationdate preserving type) AS CreationDate,
  cast(aufv.CreationTime as ordercreationtime preserving type) AS CreationTime,
  aufv.CreatedByUser AS CreatedByUser,
  aufv.LastChangeDate AS LastChangeDate,
  aufv.LastChangeTime AS LastChangeTime,
  aufv.LastChangedByUser AS LastChangedByUser,
  aufv.ReferenceOrder AS ReferenceOrder,
  aufv.LeadingOrder AS LeadingOrder,
  aufv.MfgOrderSuperiorMfgOrder AS SuperiorOrder,
  aufv.Currency AS Currency,
  cast(aufv.Plant as pwwrk preserving type) AS ProductionPlant,
  cast(aufv.ProductionSupervisor as pph_fevor preserving type) AS ProductionSupervisor,
  cast(aufv.MRPController as pph_dispo preserving type) AS MRPController,
  aufv.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  cast(aufv.ProductionSchedulingProfile as pph_prodprf preserving type) AS ProductionSchedulingProfile,
  cast(aufv.PriorityCode as orderimportancecode preserving type) AS ManufacturingOrderImportance,
  aufv.SalesOrder AS SalesOrder,
  aufv.SalesOrderItem AS SalesOrderItem,
  aufv.WBSElementInternalID_2 AS WBSElementInternalID,
  aufv.ObjectInternalID AS ObjectInternalID,
  aufv.InspectionLot AS InspectionLot,
  aufv.ProductConfiguration AS ProductConfiguration,
  aufv.CapacityRequirement AS CapacityRequirement,
  aufv.ChangeNumber AS ChangeNumber,
  aufv.MaterialRevisionLevel_2 AS MaterialRevisionLevel,
  cast(aufv.BasicSchedulingType as basicschedtype preserving type) AS BasicSchedulingType,
  aufv.BusinessArea AS BusinessArea,
  aufv.CompanyCode AS CompanyCode,
  aufv.ControllingArea AS ControllingArea,
  aufv.CostCenter AS CostCenter,
  aufv.ProfitCenter AS ProfitCenter,
  aufv.CostElement AS CostElement,
  aufv.CostingSheet AS CostingSheet,
  aufv.GLAccount AS GLAccount,
  aufv.ProductCostCollector AS ProductCostCollector,
  aufv.ActualCostsCostingVariant AS ActualCostsCostingVariant,
  aufv.PlannedCostsCostingVariant AS PlannedCostsCostingVariant,
  cast(aufv.ControllingObjectClass as pph_scope preserving type) AS ControllingObjectClass,
  aufv.FunctionalArea AS FunctionalArea,
  aufv.EventBasedPostingMethod AS EventBasedPostingMethod,
  aufv.Material AS BillOfOperationsMaterial,
  aufv.BillOfOperationsType AS BillOfOperationsType,
  aufv.BillOfOperations AS BillOfOperations,
  aufv.BillOfOperationsGroup AS BillOfOperationsGroup,
  aufv.BillOfOperationsVariant AS BillOfOperationsVariant,
  aufv.BillOfOperationsApplication AS BillOfOperationsApplication,
  aufv.BillOfOperationsUsage AS BillOfOperationsUsage,
  aufv.BillOfOperationsVersion AS BillOfOperationsVersion,
  aufv.BOOExplosionDate AS BOOExplosionDate,
  aufv.BOOValidityStartDate AS BOOValidityStartDate,
  aufv.BillOfMaterialCategory AS BillOfMaterialCategory,
  aufv.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  aufv.BillOfMaterialVariant AS BillOfMaterialVariant,
  aufv.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  aufv.BillOfMaterialVersion AS BillOfMaterialVersion,
  aufv.BOMExplosionDate AS BOMExplosionDate,
  aufv.BOMValidityStartDate AS BOMValidityStartDate,
  aufv.SchedulingFloatProfile AS SchedulingFloatProfile,
  aufv.FloatBeforeProductionInWrkDays AS FloatBeforeProductionInWrkDays,
  aufv.FloatAfterProductionInWorkDays AS FloatAfterProductionInWorkDays,
  aufv.ReleasePeriodInWorkDays AS ReleasePeriodInWorkDays,
  aufv.ChangeToScheduledDatesIsMade AS ChangeToScheduledDatesIsMade,
  cast(aufv.PlannedStartTime as mfgorderplannedstarttime preserving type) AS MfgOrderPlannedStartTime,
  cast(aufv.PlannedEndDate as mfgorderplannedenddate preserving type) AS MfgOrderPlannedEndDate,
  cast(aufv.PlannedEndTime as mfgorderplannedendtime preserving type) AS MfgOrderPlannedEndTime,
  cast(aufv.PlannedReleaseDate as mfgorderplannedreleasedate preserving type) AS MfgOrderPlannedReleaseDate,
  cast(aufv.ScheduledBasicStartTime as mfgorderscheduledstarttime preserving type) AS MfgOrderScheduledStartTime,
  cast(aufv.ScheduledBasicEndDate as mfgorderscheduledenddate preserving type) AS MfgOrderScheduledEndDate,
  cast(aufv.ScheduledBasicEndTime as mfgorderscheduledendtime preserving type) AS MfgOrderScheduledEndTime,
  cast(aufv.ScheduledReleaseDate as mfgorderscheduledreleasedate preserving type) AS MfgOrderScheduledReleaseDate,
  cast(aufv.ActualStartTime as mfgorderactualstarttime preserving type) AS MfgOrderActualStartTime,
  cast(aufv.ActualEndDate as mfgorderactualenddate preserving type) AS MfgOrderActualEndDate,
  cast(aufv.ActualReleasedDate as mfgorderactualreleasedate preserving type) AS MfgOrderActualReleaseDate,
  aufv.ActualDeliveryDate AS MfgOrderActualDeliveryDate,
  aufv.TechnicalCompletionDate AS MfgOrderActualCompletionDate,
  cast(aufv.ConfirmedEndDate as mfgorderconfirmedenddate preserving type) AS MfgOrderConfirmedEndDate,
  cast(aufv.ConfirmedEndTime as mfgorderconfirmedendtime preserving type) AS MfgOrderConfirmedEndTime,
  cast(aufv.BaseUnit as productionunit preserving type) AS ProductionUnit,
  cast(aufv.OrderPlannedTotalQty as mfgorderplannedtotalqty preserving type) AS MfgOrderPlannedTotalQty,
  cast(aufv.OrderPlannedScrapQty as mfgorderplannedscrapqty preserving type) AS MfgOrderPlannedScrapQty,
  cast(aufv.OrderConfirmedYieldQty as co_igmng preserving type) AS MfgOrderConfirmedYieldQty,
  cast(aufv.OrderConfirmedScrapQty as co_iasmg preserving type) AS MfgOrderConfirmedScrapQty,
  aufv.MfgOrderConfirmedReworkQty AS MfgOrderConfirmedReworkQty,
  aufv.MasterProductionOrder AS MasterProductionOrder,
  aufv._ReferenceOrder AS _ReferenceOrder,
  aufv._LeadingOrder AS _LeadingOrder,
  aufv._Currency AS _Currency,
  aufv._Reservation AS _Reservation,
  aufv._InspectionLot AS _InspectionLot,
  aufv._StatusObject AS _StatusObject,
  aufv._CapacityRequirement AS _CapacityRequirement,
  aufv._SalesOrder AS _SalesOrder,
  aufv._SalesOrderItem AS _SalesOrderItem,
  aufv._WBSElementBasicData2 AS _WBSElementBasicData,
  aufv._ChangeNumber AS _ChangeNumber,
  aufv._BusinessArea AS _BusinessArea,
  aufv._ProfitCenter AS _ProfitCenter,
  aufv._CostCenter AS _CostCenter,
  aufv._CompanyCode AS _CompanyCode,
  aufv._ControllingArea AS _ControllingArea,
  aufv._ControllingObjectClass AS _ControllingObjectClass,
  aufv._FunctionalArea AS _FunctionalArea,
  aufv._GLAccount AS _GLAccount,
  aufv._ProductCostCollector AS _ProductCostCollector,
  aufv._BillOfOperationsType AS _BillOfOperationsType,
  aufv._BillOfOperationsApplication AS _BillOfOperationsApplication,
  aufv._BillOfOperationsUsage AS _BillOfOperationsUsage,
  aufv._BasicSchedulingType AS _BasicSchedulingType,
  aufv._SchedulingFloatProfile AS _SchedulingFloatProfile
FROM I_LogisticsOrder AS aufv
LEFT OUTER JOIN I_MfgOrderCategory AS _MfgOrderCategory ON ManufacturingOrderCategory = _MfgOrderCategory.ManufacturingOrderCategory  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderType AS _MfgOrderType ON ManufacturingOrderType = _MfgOrderType.ManufacturingOrderType  -- association [1..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalID = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrderImportance AS _MfgOrderImportance ON ManufacturingOrderCategory = _MfgOrderImportance.ManufacturingOrderCategory AND ManufacturingOrderImportance = _MfgOrderImportance.ManufacturingOrderImportance  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrderLongText AS _MfgOrderLongText ON ManufacturingOrder = _MfgOrderLongText.ManufacturingOrder AND LongTextLanguage = _MfgOrderLongText.LongTextLanguage  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _SuperiorOrder ON SuperiorOrder = _SuperiorOrder.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON ProductionPlant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupervisor AS _ProductionSupervisor ON ProductionPlant = _ProductionSupervisor.Plant AND ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN I_ProductionSchedulingProfile AS _ProductionSchedulingProfile ON ProductionPlant = _ProductionSchedulingProfile.Plant AND ProductionSchedulingProfile = _ProductionSchedulingProfile.ProductionSchedulingProfile  -- association [0..1]
LEFT OUTER JOIN I_ResponsiblePlannerGroup AS _ResponsiblePlannerGroup ON ProductionPlant = _ResponsiblePlannerGroup.Plant AND ResponsiblePlannerGroup = _ResponsiblePlannerGroup.ResponsiblePlannerGroup  -- association [0..1]
LEFT OUTER JOIN I_Product AS _BillOfOperationsMaterial ON BillOfOperationsMaterial = _BillOfOperationsMaterial.Product  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProductionUnit ON ProductionUnit = _ProductionUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_CostElement AS _CostElement ON ControllingArea = _CostElement.ControllingArea AND CostElement = _CostElement.CostElement  -- association [0..1]
LEFT OUTER JOIN I_CostingVariant AS _ActualCostsCostingVariant ON ActualCostsCostingVariant = _ActualCostsCostingVariant.CostingVariant  -- association [0..1]
LEFT OUTER JOIN I_CostingVariant AS _PlannedCostsCostingVariant ON PlannedCostsCostingVariant = _PlannedCostsCostingVariant.CostingVariant  -- association [0..1]
;