I_OrderProdnResourceTool

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_OrderProdnResourceTool.
-- 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: IORDPRODNRSCTOOL

CREATE VIEW I_OrderProdnResourceTool AS
SELECT
  cast(affh.aufpl as pph_aufpl preserving type) AS OrderInternalBillOfOperations,
  affh.pzlfh AS OrderProdnRsceToolInternalID,
  affh.loekz AS IsDeleted,
  affh.datui AS CreationDate,
  affh.useri AS CreatedByUser,
  affh.datuc AS LastChangeDate,
  affh.userc AS LastChangedByUser,
  affh.txtz1 AS OrderProdnRsceToolText,
  affh.txtsp AS Language,
  aufv.aufnr AS OrderID,
  cast(aufv.autyp as pph_autyp preserving type) AS OrderCategory,
  aufv.auart AS OrderType,
  aufv.werks AS Plant,
  cast(affh.aplzl as operationinternalid preserving type) AS OrderIntBillOfOperationsItem,
  aufv.dispo AS MRPController,
  affh.objty AS ProductionResourceType,
  affh.objid AS ProductionResourceInternalID,
  affh.steuf AS ProdnRsceToolControlProfile,
  affh.psnfh AS ProdnRsceToolItemNumber,
  affh.objnr AS ObjectInternalID,
  affh.plnty_key AS BillOfOperationsType,
  affh.plnnr_key AS BillOfOperationsGroup,
  affh.pzlfh_key AS BOOOperationPRTInternalID,
  affh.zaehl_key AS BOOOperationPRTIntVersCounter,
  affh.fsfhd AS EarliestSchedldUsageStartDate,
  affh.fsfhz AS EarliestSchedldUsageStartTime,
  affh.fefhd AS EarliestSchedldUsageEndDate,
  affh.fefhz AS EarliestSchedldUsageEndTime,
  affh.ssfhd AS LatestSchedldUsageStartDate,
  affh.ssfhz AS LatestSchedldUsageStartTime,
  affh.sefhd AS LatestSchedldUsageEndDate,
  affh.sefhz AS LatestSchedldUsageEndTime,
  affh.isfhd AS ActualUsageStartDate,
  affh.isfhz AS ActualUsageStartTime,
  affh.iefhd AS ActualUsageEndDate,
  affh.iefhz AS ActualUsageEndTime,
  affh.daueh AS ProdnRsceToolUsageDurnUnit,
  affh.daufl AS ProdnRsceToolUsageDuration,
  affh.mgeinh AS ProdnRsceToolStdWorkQtyUnit,
  affh.mgvgw AS ProdnRsceToolStandardWorkQty,
  cast(affh.mgsoleh as pph_mgsoleh preserving type) AS PlannedProdnRsceToolQtyUnit,
  affh.mgsol AS PlannedTotalProdnRsceToolQty,
  cast(affh.mgisteh as pph_mgisteh preserving type) AS ConfirmedProdnRsceToolQtyUnit,
  affh.mgist AS ConfirmedProdnRsceToolQty,
  cast(affh.mgrsteh as pph_mgrsteh preserving type) AS RemainingProdnRsceToolQtyUnit,
  affh.mgrst AS RemainingProdnRsceToolQty,
  affh.eweinh AS ProdnRsceToolUsageQuantityUnit,
  affh.ewvgw AS ProdnRsceToolUsageQuantity,
  cast(affh.ewsoleh as vdm_ewsoleh preserving type) AS PlndProdnRsceToolUsageQtyUnit,
  affh.ewsol AS PlannedProdnRsceToolUsageQty,
  cast(affh.ewisteh as vdm_ewisteh preserving type) AS ConfdProdnRsceToolUsageQtyUnit,
  affh.ewist AS ConfirmedProdnRsceToolUsageQty,
  cast(affh.ewrsteh as vdm_ewrsteh preserving type) AS RmngProdnRsceToolUsageQtyUnit,
  affh.ewrst AS RemainingProdnRsceToolUsageQty,
  affh.mgform AS ProdnRsceToolTotQtyCalcFormula,
  affh.ewform AS ProdnRsceToolUsageQtyCalcFmla,
  affh.registrable AS ProdnRsceToolRegnIsAllowed,
  cast( '' as char1 ) AS IsCloudSystem,
  cast( _OrderOperation.Operation as maintenanceorderoperation preserving type ) AS MaintenanceOrderOperation
FROM affh
LEFT OUTER JOIN I_OrdInternalBillOfOperations AS _OrdInternalBillOfOperations ON OrderInternalBillOfOperations = _OrdInternalBillOfOperations.OrderInternalBillOfOperations  -- association [1..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalBillOfOperations = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_LogisticsOrder AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [0..1]
LEFT OUTER JOIN I_OrderType AS _OrderType ON OrderType = _OrderType.OrderType  -- association [0..1]
LEFT OUTER JOIN I_OrderOperationBasic AS _OrderOperation ON OrderInternalBillOfOperations = _OrderOperation.OrderInternalID AND OrderIntBillOfOperationsItem = _OrderOperation.OrderOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProdnRsceToolControlProfile AS _ProdnRsceToolControlProfile ON ProdnRsceToolControlProfile = _ProdnRsceToolControlProfile.ProdnRsceToolControlProfile  -- association [0..1]
LEFT OUTER JOIN I_ProductionResourceType AS _ProductionResourceType ON ProductionResourceType = _ProductionResourceType.ProductionResourceType  -- association [0..1]
LEFT OUTER JOIN I_ProdnRsceToolByInternalKey AS _ProdnRsceToolByInternalKey ON ProductionResourceType = _ProdnRsceToolByInternalKey.ProductionResourceType AND ProductionResourceInternalID = _ProdnRsceToolByInternalKey.ProductionResourceInternalID  -- association [1..1]
LEFT OUTER JOIN I_ProdnRsceToolMasterData AS _ProdnRsceToolMasterData ON ProductionResourceType = _ProdnRsceToolMasterData.ProductionResourceType AND ProductionResourceInternalID = _ProdnRsceToolMasterData.ProductionResourceInternalID  -- 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_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- 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_UnitOfMeasure AS _ProdnRsceToolUsageDurnUnit ON ProdnRsceToolUsageDurnUnit = _ProdnRsceToolUsageDurnUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProdnRsceToolStdWorkQtyUnit ON ProdnRsceToolStdWorkQtyUnit = _ProdnRsceToolStdWorkQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PlannedProdnRsceToolQtyUnit ON PlannedProdnRsceToolQtyUnit = _PlannedProdnRsceToolQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConfirmedProdnRsceToolQtyUnit ON ConfirmedProdnRsceToolQtyUnit = _ConfirmedProdnRsceToolQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RemainingProdnRsceToolQtyUnit ON RemainingProdnRsceToolQtyUnit = _RemainingProdnRsceToolQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProdnRsceToolUsageQtyUnit ON ProdnRsceToolUsageQuantityUnit = _ProdnRsceToolUsageQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PlndProdnRsceToolUsageQtyUnit ON PlndProdnRsceToolUsageQtyUnit = _PlndProdnRsceToolUsageQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConfdProdnRsceToolUsgeQtyUnit ON ConfdProdnRsceToolUsageQtyUnit = _ConfdProdnRsceToolUsgeQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RmngProdnRsceToolUsageQtyUnit ON RmngProdnRsceToolUsageQtyUnit = _RmngProdnRsceToolUsageQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObject ON ObjectInternalID = _StatusObject.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_OrderOperationPRTLongText AS _LongText ON OrderInternalBillOfOperations = _LongText.OrderInternalID AND OrderProdnRsceToolInternalID = _LongText.OrderProdnRsceToolInternalID AND Language = _LongText.LongTextLanguage  -- association [0..1]
LEFT OUTER JOIN I_DocumentProdnRsceTool AS _DocumentProdnRsceTool ON ProductionResourceType = _DocumentProdnRsceTool.ProductionResourceType AND ProductionResourceInternalID = _DocumentProdnRsceTool.ProductionResourceInternalID  -- association [0..1]
LEFT OUTER JOIN I_EquipmentProdnRsceTool AS _EquipmentProdnRsceTool ON ProductionResourceType = _EquipmentProdnRsceTool.ProductionResourceType AND ProductionResourceInternalID = _EquipmentProdnRsceTool.ProductionResourceInternalID  -- association [0..1]
LEFT OUTER JOIN I_MaterialProdnRsceTool AS _MaterialProdnRsceTool ON ProductionResourceType = _MaterialProdnRsceTool.ProductionResourceType AND ProductionResourceInternalID = _MaterialProdnRsceTool.ProductionResourceInternalID  -- association [0..1]
LEFT OUTER JOIN I_MiscProdnRsceTool AS _MiscProdnRsceTool ON ProductionResourceType = _MiscProdnRsceTool.ProductionResourceType AND ProductionResourceInternalID = _MiscProdnRsceTool.ProductionResourceInternalID  -- association [0..1]
LEFT OUTER JOIN I_MsrgPointProdnRsceTool AS _MsrgPointProdnRsceTool ON ProductionResourceType = _MsrgPointProdnRsceTool.ProductionResourceType AND ProductionResourceInternalID = _MsrgPointProdnRsceTool.ProductionResourceInternalID  -- association [0..1]
LEFT OUTER JOIN I_MaintOrdOpProdnRsceToolText AS _ProdnRsceToolLongText ON _ProdnRsceToolLongText.MaintenanceOrder = OrderID AND _ProdnRsceToolLongText.MaintenanceOrderOperation = MaintenanceOrderOperation AND _ProdnRsceToolLongText.MaintenanceOrderSubOperation = '' AND _ProdnRsceToolLongText.ProdnRsceToolItemNumber = ProdnRsceToolItemNumber AND _ProdnRsceToolLongText.OrderProdnRsceToolInternalID = OrderProdnRsceToolInternalID AND _ProdnRsceToolLongText.Language = $session.system_language  -- association [0..1]
;