I_InspectionOperation

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_InspectionOperation.
-- 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: IINSPOPERATION

CREATE VIEW I_InspectionOperation AS
SELECT
  qaop.prueflos AS InspectionLot,
  qaop.vorglfnr AS InspPlanOperationInternalID,
  qaop.aufpl AS OrderInternalBillOfOperations,
  afvc.aplzl AS OrderOperationInternalID,
  afvc.vornr AS InspectionOperation,
  afvc.werks AS InspectionOperationPlant,
  afvc.plnty AS BillOfOperationsType,
  afvc.plnnr AS BillOfOperationsGroup,
  afvc.plnal AS BillOfOperationsVariant,
  afvc.plnkn AS BOOOperationInternalID,
  afvc.tl_versn AS BillOfOperationsVersion,
  afvc.arbid AS WorkCenterInternalID,
  afvc.objnr AS StatusObject,
  afvc.steus AS OperationControlProfile,
  afvc.rueck AS OperationConfirmation,
  afvc.subsys AS InspectionSubSystem,
  afvc.ltxa1 AS OperationText,
  afvc.qkzprzeit AS InspSbstIsTimeRelated,
  afvc.qkzprfrei AS InspSbstHasNoTimeOrQuantity,
  afvc.aplfl AS Sequence
FROM qaop
INNER JOIN afvc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_InspectionCharacteristic AS _InspectionCharacteristic ON InspectionLot = _InspectionCharacteristic.InspectionLot AND InspPlanOperationInternalID = _InspectionCharacteristic.InspPlanOperationInternalID  -- association [0..*]
LEFT OUTER JOIN I_InspectionSubset AS _InspectionSubset ON InspectionLot = _InspectionSubset.InspectionLot AND InspPlanOperationInternalID = _InspectionSubset.InspPlanOperationInternalID  -- association [0..*]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = 'A'  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON InspectionOperationPlant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_InspectionOperationStatus AS _InspectionOperationStatus ON OrderInternalBillOfOperations = _InspectionOperationStatus.OrderInternalBillOfOperations AND InspPlanOperationInternalID = _InspectionOperationStatus.InspPlanOperationInternalID  -- association [0..1]
LEFT OUTER JOIN E_InspectionOperation AS _Extension ON InspectionLot = _Extension.InspectionLot AND InspPlanOperationInternalID = _Extension.InspPlanOperationInternalID  -- association [1..1]
;