I_ProcOrdOpsMgmtInspectionLot

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_ProcOrdOpsMgmtInspectionLot.
-- 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_ProcOrdOpsMgmtInspectionLot AS
SELECT
  InspectionLot,
  OrderInternalBillOfOperations,
  OrderIntBillOfOpItemOfPhase,
  _InspectionLot.Plant AS Plant,
  _InspectionLot.InspectionLotText AS InspectionLotText,
  _InspectionLot.InspectionLotType AS InspectionLotType,
  _InspectionLot._InspectionLotType._Text[1: Language=$session.system_language].InspectionLotTypeText AS InspectionLotTypeText,
  _InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _InspOpCharAgg.InspCharacteristicCount AS InspCharacteristicCount,
  _InspOpCharAgg.InspCharRejectedCount AS InspCharRejectedCount,
  _InspOpCharAgg.InspCharAcceptedCount AS InspCharAcceptedCount,
  _InspOpCharAgg.InspCharOpenCount AS InspCharOpenCount,
  _InspLotDefectsCount.InspectionNumberOfDefects AS InspectionNumberOfDefects,
  _InspLotUsageDecision.InspectionLotUsageDecisionCode AS InspectionLotUsageDecisionCode,
  _InspLotUsageDecision.InspLotUsageDecisionValuation AS InspLotUsageDecisionValuation,
  _InspLotUsageDecision._UsgeDcsnValuationText[1: Language=$session.system_language].InspLotUsgeDcsnValuationText AS InspLotUsgeDcsnValuationText
FROM P_ProcOrdOpsMgmtInspLotCalc
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_InspLotUsageDecision AS _InspLotUsageDecision ON InspectionLot = _InspLotUsageDecision.InspectionLot  -- association [0..1]
LEFT OUTER JOIN P_ProcOrdOpInspCharAggrgn AS _InspOpCharAgg ON InspectionLot = _InspOpCharAgg.InspectionLot AND OrderInternalBillOfOperations = _InspOpCharAgg.OrderInternalBillOfOperations AND OrderIntBillOfOpItemOfPhase = _InspOpCharAgg.OrderIntBillOfOpItemOfPhase  -- association [0..1]
LEFT OUTER JOIN P_ProcOrdOpInspLotDfctsCnt AS _InspLotDefectsCount ON InspectionLot = _InspLotDefectsCount.InspectionLot AND OrderInternalBillOfOperations = _InspLotDefectsCount.OrderInternalBillOfOperations AND OrderIntBillOfOpItemOfPhase = _InspLotDefectsCount.OrderIntBillOfOpItemOfPhase  -- association [0..1]
;