A_ProductionRsceTools_2

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 A_ProductionRsceTools_2.
-- 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 A_ProductionRsceTools_2 AS
SELECT
  MfgOrderInternalID AS OrderInternalBillOfOperations,
  MfgOrderOpProdnRsceToolIntID,
  ProductionResourceTool,
  ProdnRsceToolCategory_2 AS ProdnRsceToolCategory,
  _ProdnRsceToolCategory_2._Text[1: Language=$session.system_language].ProdnRsceToolCategoryName AS ProdnRsceToolCategoryName,
  ProdnRsceToolControlProfile,
  _MaterialProdnRsceTool.Plant AS ProdnRsceToolPlant,
  OrderOperationInternalID,
  cast(ManufacturingOrder as vdm_manufacturingorder preserving type) AS ManufacturingOrder,
  cast( ManufacturingOrderOperation as vdm_vornr preserving type ) AS ManufacturingOrderOperation,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  ProductionPlant,
  BillOfOperationsType,
  BillOfOperationsGroup,
  EarliestSchedldUsageStartDate,
  EarliestSchedldUsageStartTime,
  EarliestSchedldUsageEndDate,
  EarliestSchedldUsageEndTime,
  LatestSchedldUsageStartDate,
  LatestSchedldUsageStartTime,
  LatestSchedldUsageEndDate,
  LatestSchedldUsageEndTime,
  ActualUsageStartDate,
  ActualUsageStartTime,
  ActualUsageEndDate,
  ActualUsageEndTime,
  ProdnRsceToolUsageDurnUnit,
  ProdnRsceToolUsageDuration,
  _ProdnRsceToolUsageDurnUnit.UnitOfMeasureISOCode AS PRTUsageDurationUnitISOCode,
  _ProdnRsceToolUsageDurnUnit.UnitOfMeasureSAPCode AS PRTUsageDurationUnitSAPCode,
  ProdnRsceToolTotQtyCalcFormula,
  ProdnRsceToolUsageQtyCalcFmla,
  ProdnRsceToolStdWorkQtyUnit,
  ProdnRsceToolStandardWorkQty,
  _ProdnRsceToolStdWorkQtyUnit.UnitOfMeasureISOCode AS PRTStdWorkQtyUnitISOCode,
  _ProdnRsceToolStdWorkQtyUnit.UnitOfMeasureSAPCode AS PRTStdWorkQtyUnitSAPCode,
  PlannedProdnRsceToolQtyUnit,
  PlannedTotalProdnRsceToolQty,
  _PlannedProdnRsceToolQtyUnit.UnitOfMeasureISOCode AS PlannedPRTQtyUnitISOCode,
  _PlannedProdnRsceToolQtyUnit.UnitOfMeasureSAPCode AS PlannedPRTQtyUnitSAPCode,
  ConfirmedProdnRsceToolQtyUnit,
  ConfirmedProdnRsceToolQty,
  _ConfirmedProdnRsceToolQtyUnit.UnitOfMeasureISOCode AS ConfirmedPRTQtyUnitISOCode,
  _ConfirmedProdnRsceToolQtyUnit.UnitOfMeasureSAPCode AS ConfirmedPRTQtyUnitSAPCode,
  ProdnRsceToolUsageQuantityUnit,
  ProdnRsceToolUsageQuantity,
  _ProdnRsceToolUsageQtyUnit.UnitOfMeasureISOCode AS PRTUsageQtyUnitISOCode,
  _ProdnRsceToolUsageQtyUnit.UnitOfMeasureSAPCode AS PRTUsageQtyUnitSAPCode,
  PlndProdnRsceToolUsageQtyUnit,
  PlannedProdnRsceToolUsageQty,
  _PlndProdnRsceToolUsageQtyUnit.UnitOfMeasureISOCode AS PlannedPRTUsageQtyUnitISOCode,
  _PlndProdnRsceToolUsageQtyUnit.UnitOfMeasureSAPCode AS PlannedPRTUsageQtyUnitSAPCode,
  ConfdProdnRsceToolUsageQtyUnit,
  ConfirmedProdnRsceToolUsageQty,
  _ConfdProdnRsceToolUsgeQtyUnit.UnitOfMeasureISOCode AS ConfdPRTUsageQtyUnitISOCode,
  _ConfdProdnRsceToolUsgeQtyUnit.UnitOfMeasureSAPCode AS ConfdPRTUsageQtyUnitSAPCode,
  _ProdnRsceToolMasterData.ProdnRsceToolBaseUnit AS ProdnRsceToolBaseUnit,
  _ProdnRsceToolMasterData._ProdnRsceToolBaseUnit.UnitOfMeasureISOCode AS ProdnRsceToolBaseUnitISOCode,
  _ProdnRsceToolMasterData._ProdnRsceToolBaseUnit.UnitOfMeasureSAPCode AS ProdnRsceToolBaseUnitSAPCode
FROM I_MfgOrderOperationPRT
;