P_ProcOrdOpsInspLot

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 P_ProcOrdOpsInspLot.
-- 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: PPOROPINSPLOT

CREATE VIEW P_ProcOrdOpsInspLot AS
SELECT
  qaop.prueflos AS InspectionLot,
  qaop.vorglfnr AS InspPlanOperationInternalID,
  _Order.OrderID AS ProcessOrder,
  qaop.aufpl AS OrderInternalBillOfOperations,
  afvc.aplzl AS OrderOperationInternalID,
  afvc.vornr AS InspectionOperation,
  afvc.werks AS InspectionOperationPlant,
  afvc.plnty AS BillOfOperationsType,
  afvc.plnkn AS BOOOperationInternalID,
  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,
  _InspectionLot.InspectionLotOrigin AS InspectionLotOrigin,
  _InspectionLot._InspectionLotOrigin AS _InspectionLotOrigin
FROM qaop
INNER JOIN afvc ON /* join condition not captured in parsed metadata */
INNER JOIN I_LogisticsOrder AS _Order 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]
;