I_MaintOrderOpProdnRsceTool

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_MaintOrderOpProdnRsceTool.
-- 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: IMAINTOPPRT

CREATE VIEW I_MaintOrderOpProdnRsceTool AS
SELECT
  afih.aufnr AS MaintenanceOrder,
  cast( afvc.vornr as maintenanceorderoperation preserving type ) AS MaintenanceOrderOperation,
  cast( ' ' as maintenanceordersuboperation preserving type ) AS MaintenanceOrderSubOperation,
  affh.psnfh AS ProdnRsceToolItemNumber,
  affh.pzlfh AS OrderProdnRsceToolInternalID,
  cast(concat(concat(affh.mandt,affh.aufpl),affh.pzlfh) as tdobname ) AS TextObjectKey,
  affh.txtz1 AS OrderProdnRsceToolText,
  affh.objty AS ProductionResourceType,
  affh.objid AS ProductionResourceInternalID,
  affh.steuf AS ProdnRsceToolControlProfile,
  cast( crfh.fhmar as mpe_fhmar preserving type ) AS ProdnRsceToolCategory,
  affh.mgvgw AS ProdnRsceToolStandardWorkQty,
  affh.mgeinh AS ProdnRsceToolStdWorkQtyUnit,
  affh.aufpl AS OrderInternalBillOfOperations,
  afvc.ltxa1 AS OrderOperationText,
  affh.ktsch AS ProdnRsceToolStandardTextCode,
  affh.objnr AS ObjectInternalID,
  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
FROM afih
INNER JOIN afvc ON /* join condition not captured in parsed metadata */
INNER JOIN affh ON /* join condition not captured in parsed metadata */
INNER JOIN crfh ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder  -- association [1..1]
;