I_ProductionOrder

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_ProductionOrder.
-- 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_ProductionOrder AS
SELECT
  cast(head.OrderID as vdm_manufacturingorder preserving type) AS ProductionOrder,
  cast(head.OrderDescription as vdm_prodnordertext preserving type) AS ProductionOrderText,
  head.OrderHasLongText AS ProductionOrderHasLongText,
  head.LongTextLanguage AS LongTextLanguage,
  OrderCategory,
  cast(head.OrderType as vdm_prodnordertype preserving type) AS ProductionOrderType,
  cast(head.PriorityCode as orderimportancecode preserving type) AS OrderImportance,
  head.IsMarkedForDeletion AS IsMarkedForDeletion,
  head.MfgOrderHasMultipleItems AS OrderHasMultipleItems,
  head.MfgOrderIsPartOfCollvOrder AS OrderIsPartOfCollectiveOrder,
  head.OrderHierarchyLevelValue AS OrderHierarchyLevelValue,
  head.OrderHierarchyPathValue AS OrderHierarchyPathValue,
  head.OrderIsNotCostedAutomatically AS OrderIsNotCostedAutomatically,
  head.OrdIsNotSchedldAutomatically AS OrdIsNotSchedldAutomatically,
  head.ProdnProcgIsFlexible AS ProdnProcgIsFlexible,
  head.MfgOrderIsProductReworkOrder AS MfgOrderIsProductReworkOrder,
  cast(head.CreationDate as ordercreationdate preserving type) AS CreationDate,
  cast(head.CreationTime as ordercreationtime preserving type) AS CreationTime,
  head.CreatedByUser AS CreatedByUser,
  head.LastChangeDate AS LastChangeDate,
  head.LastChangeTime AS LastChangeTime,
  head.LastChangedByUser AS LastChangedByUser,
  cast(head.OrderInternalBillOfOperations as pph_aufpl preserving type) AS ProductionOrderInternalID,
  head.ReferenceOrder AS ReferenceOrder,
  head.LeadingOrder AS LeadingOrder,
  head.Currency AS Currency,
  cast(head.Plant as pwwrk preserving type) AS ProductionPlant,
  cast(head.MRPController as pph_dispo preserving type) AS MRPController,
  cast(head.ProductionSupervisor as pph_fevor preserving type) AS ProductionSupervisor,
  cast(head.ProductionSchedulingProfile as pph_prodprf preserving type) AS ProductionSchedulingProfile,
  head.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  head.SalesOrder AS SalesOrder,
  head.SalesOrderItem AS SalesOrderItem,
  head.Reservation AS Reservation,
  cast(head.SettlementReservation as settlmntres preserving type) AS SettlementReservation,
  head.MfgOrderConfirmation AS OrderConfirmationGroup,
  cast(head.MfgOrderConfirmationCount as pph_noofconf preserving type) AS NumberOfOrderConfirmations,
  head.CapacityRequirement AS CapacityRequirement,
  head.InspectionLot AS InspectionLot,
  head.ChangeNumber AS ChangeNumber,
  head.MaterialRevisionLevel_2 AS MaterialRevisionLevel,
  cast(head.BasicSchedulingType as basicschedtype preserving type) AS BasicSchedulingType,
  head.SchedulingIsAllowingForBreaks AS SchedulingIsAllowingForBreaks,
  cast(head.ObjectInternalID as pph_objnr preserving type) AS ObjectInternalID,
  head.ConditionApplication AS ConditionApplication,
  head.CapacityActiveVersion AS CapacityActiveVersion,
  head.CapacityRqmtHasNotToBeCreated AS CapacityRqmtHasNotToBeCreated,
  head.OrderSequenceNumber AS OrderSequenceNumber,
  head.Material AS BillOfOperationsMaterial,
  head.BillOfOperationsType AS BillOfOperationsType,
  head.BillOfOperationsGroup AS BillOfOperationsGroup,
  head.BillOfOperationsVariant AS BillOfOperationsVariant,
  head.BillOfOperationsApplication AS BillOfOperationsApplication,
  head.BillOfOperationsUsage AS BillOfOperationsUsage,
  head.BillOfOperationsVersion AS BillOfOperationsVersion,
  head.BOOExplosionDate AS BOOExplosionDate,
  head.BOOValidityStartDate AS BOOValidityStartDate,
  head.BillOfMaterialCategory AS BillOfMaterialCategory,
  head.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  head.BillOfMaterialVariant AS BillOfMaterialVariant,
  head.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  head.BOMExplosionDate AS BOMExplosionDate,
  head.BOMValidityStartDate AS BOMValidityStartDate,
  head.BusinessArea AS BusinessArea,
  head.CompanyCode AS CompanyCode,
  head.ControllingArea AS ControllingArea,
  head.ProfitCenter AS ProfitCenter,
  head.CostCenter AS CostCenter,
  head.ResponsibleCostCenter AS ResponsibleCostCenter,
  head.CostElement AS CostElement,
  head.CostingSheet AS CostingSheet,
  head.GLAccount AS GLAccount,
  head.ActualCostsCostingVariant AS ActualCostsCostingVariant,
  head.PlannedCostsCostingVariant AS PlannedCostsCostingVariant,
  cast(head.ControllingObjectClass as pph_scope preserving type) AS ControllingObjectClass,
  head.FunctionalArea AS FunctionalArea,
  head.OverheadCode AS OverheadCode,
  head.ResultAnalysisInternalID AS ResultAnalysisInternalID,
  head.VarianceKey AS VarianceKey,
  head.EventBasedPostingMethod AS EventBasedPostingMethod,
  head.EventBasedProcessingKey AS EventBasedProcessingKey,
  head.SchedulingFloatProfile AS SchedulingFloatProfile,
  head.FloatBeforeProductionInWrkDays AS FloatBeforeProductionInWrkDays,
  head.FloatAfterProductionInWorkDays AS FloatAfterProductionInWorkDays,
  head.ReleasePeriodInWorkDays AS ReleasePeriodInWorkDays,
  head.ChangeToScheduledDatesIsMade AS ChangeToScheduledDatesIsMade,
  cast(head.PlannedStartTime as mfgorderplannedstarttime preserving type) AS OrderPlannedStartTime,
  cast(head.PlannedEndDate as mfgorderplannedenddate preserving type) AS OrderPlannedEndDate,
  cast(head.PlannedEndTime as mfgorderplannedendtime preserving type) AS OrderPlannedEndTime,
  cast(head.PlannedReleaseDate as mfgorderplannedreleasedate preserving type) AS OrderPlannedReleaseDate,
  cast(head.ScheduledBasicStartTime as mfgorderscheduledstarttime preserving type) AS OrderScheduledStartTime,
  cast(head.ScheduledBasicEndDate as mfgorderscheduledenddate preserving type) AS OrderScheduledEndDate,
  cast(head.ScheduledBasicEndTime as mfgorderscheduledendtime preserving type) AS OrderScheduledEndTime,
  cast(head.ScheduledReleaseDate as mfgorderscheduledreleasedate preserving type) AS OrderScheduledReleaseDate,
  cast(head.ActualStartTime as mfgorderactualstarttime preserving type) AS OrderActualStartTime,
  cast(head.ConfirmedEndDate as mfgorderconfirmedenddate preserving type) AS OrderConfirmedEndDate,
  cast(head.ConfirmedEndTime as mfgorderconfirmedendtime preserving type) AS OrderConfirmedEndTime,
  cast(head.ActualEndDate as mfgorderactualenddate preserving type) AS OrderActualEndDate,
  cast(head.ActualReleasedDate as mfgorderactualreleasedate preserving type) AS OrderActualReleaseDate,
  cast(head.BaseUnit as productionunit preserving type) AS ProductionUnit,
  cast(head.OrderPlannedTotalQty as mfgorderplannedtotalqty preserving type) AS OrderPlannedTotalQty,
  cast(head.OrderPlannedScrapQty as mfgorderplannedscrapqty preserving type) AS OrderPlannedScrapQty,
  cast(head.OrderConfirmedYieldQty as co_igmng preserving type) AS OrderConfirmedYieldQty,
  cast(head.OrderConfirmedScrapQty as co_iasmg preserving type) AS OrderConfirmedScrapQty,
  head.MfgOrderConfirmedReworkQty AS OrderConfirmedReworkQty,
  head._OrderTypeDetails AS _OrderTypeDetails,
  head._Currency AS _Currency,
  head._BillOfOperationsType AS _BillOfOperationsType,
  head._BillOfOperationsApplication AS _BillOfOperationsApplication,
  head._BillOfOperationsUsage AS _BillOfOperationsUsage,
  head._ConfirmationGroup AS _ConfirmationGroup,
  head._Reservation AS _Reservation,
  head._SettlementReservation AS _SettlementReservation,
  head._SalesOrder AS _SalesOrder,
  head._SalesOrderItem AS _SalesOrderItem,
  head._CapacityRequirement AS _CapacityRequirement,
  head._InspectionLot AS _InspectionLot,
  head._BasicSchedulingType AS _BasicSchedulingType,
  head._SchedulingFloatProfile AS _SchedulingFloatProfile,
  head._BusinessArea AS _BusinessArea,
  head._ProfitCenter AS _ProfitCenter,
  head._CostCenter AS _CostCenter,
  head._ResponsibleCostCenter AS _ResponsibleCostCenter,
  head._CompanyCode AS _CompanyCode,
  head._ControllingArea AS _ControllingArea,
  head._ControllingObjectClass AS _ControllingObjectClass,
  head._FunctionalArea AS _FunctionalArea,
  head._ProductCostCollector AS _ProductCostCollector
FROM I_LogisticsOrder AS head
LEFT OUTER JOIN I_ProductionOrderType AS _ProductionOrderType ON ProductionOrderType = _ProductionOrderType.ProductionOrderType  -- association [1..1]
LEFT OUTER JOIN I_ProductionOrderInternalID AS _ProductionOrderInternal ON ProductionOrderInternalID = _ProductionOrderInternal.ProductionOrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_Language AS _LongTextLanguage ON LongTextLanguage = _LongTextLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProductionUnit ON ProductionUnit = _ProductionUnit.UnitOfMeasure  -- 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_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeNumber ON ChangeNumber = _ChangeNumber.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_ChangeMstrObjTypeRevisionLvl AS _MaterialRevisionLevel ON MaterialRevisionLevel = _MaterialRevisionLevel.RevisionLevel AND _MaterialRevisionLevel.ChangeNumberObjectType = '41'  -- association [0..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObject ON ObjectInternalID = _StatusObject.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- 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]
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_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Product AS _BillOfOperationsMaterial ON BillOfOperationsMaterial = _BillOfOperationsMaterial.Product  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [0..1]
LEFT OUTER JOIN I_MfgBillOfOperations AS _BillOfOperations ON BillOfOperationsType = _BillOfOperations.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant  -- association [0..1]
LEFT OUTER JOIN I_MfgBillOfOperationsChgSt AS _BillOfOperationsChangeState ON BillOfOperationsType = _BillOfOperationsChangeState.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsChangeState.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsChangeState.BillOfOperationsVariant AND BOOInternalVersionCounter = _BillOfOperationsChangeState.BOOInternalVersionCounter  -- association [0..1]
LEFT OUTER JOIN E_LogisticsOrder AS _Extension ON ProductionOrder = _Extension.OrderID  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlantText ON ProductionPlant = _ProductionPlantText.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductionOrder AS _ReferenceOrderText ON ReferenceOrder = _ReferenceOrderText.ProductionOrder  -- association [0..1]
LEFT OUTER JOIN I_ProductionOrder AS _LeadingOrderText ON LeadingOrder = _LeadingOrderText.ProductionOrder  -- association [0..1]
LEFT OUTER JOIN I_ProductionOrder AS _SuperiorOrderText ON SuperiorOrder = _SuperiorOrderText.ProductionOrder  -- association [0..1]
LEFT OUTER JOIN I_InspectionLot AS _InspectionLotText ON InspectionLot = _InspectionLotText.InspectionLot  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _BillOfOperationsMaterialText ON BillOfOperationsMaterial = _BillOfOperationsMaterialText.Product  -- association [0..*]
LEFT OUTER JOIN I_StatusObject AS _StatusObjectText ON ObjectInternalID = _StatusObjectText.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_ProductCostCtrlgOrder AS _ProductCostCollectorText ON ProductCostCollector = _ProductCostCollectorText.OrderID  -- association [0..1]
LEFT OUTER JOIN I_ProductionOrderItem AS _ProductionOrderItem ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_ProductionOrderSequence AS _ProductionOrderSequence ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_ProductionOrderDocumentLink AS _ProductionOrderDocumentLink ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProductionOrderLongText AS _ProductionOrderLongText ON /* condition not available in parsed metadata */  -- association [0..*]
;