I_ProcOrdOpsMgmtInspLotsBasic

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_ProcOrdOpsMgmtInspLotsBasic.
-- 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: IPOROPINSPLOTBSC

CREATE VIEW I_ProcOrdOpsMgmtInspLotsBasic AS
SELECT
  qaop.prueflos AS InspectionLot,
  qaop.vorglfnr AS InspPlanOperationInternalID,
  _Order.OrderID AS ProcessOrder,
  _Order.OrderCategory AS ManufacturingOrderCategory,
  _Order.OrderType AS ManufacturingOrderType,
  _Order.Plant AS ProductionPlant,
  _Order.ProductionSupervisor AS ProductionSupervisor,
  qaop.aufpl AS OrderInternalBillOfOperations,
  afvc.aplzl AS OrderOperationInternalID,
  case when afvc.pvzkn is not initial then afvc.pvzkn else qaop.vorglfnr end as OrderIntBillOfOpItemOfPhase AS vorglfnrendasOrderIntBillOfOpItemOfPhase,
  cast (afvc.vornr as text4 preserving type) 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.aplfl AS Sequence,
  _InspectionLot.InspectionLotOrigin AS InspectionLotOrigin,
  _InspectionLot.Plant AS Plant,
  _InspectionLot.InspectionLotText AS InspectionLotText,
  _InspectionLot.InspectionLotType AS InspectionLotType,
  _InspectionLot._InspectionLotType._Text[1: Language=$session.system_language].InspectionLotTypeText AS InspectionLotTypeText,
  _InspLotUsageDecision.InspectionLotUsageDecisionCode AS InspectionLotUsageDecisionCode,
  _InspLotUsageDecision.InspLotUsageDecisionValuation AS InspLotUsageDecisionValuation,
  _InspLotUsageDecision._UsgeDcsnValuationText[1: Language=$session.system_language].InspLotUsgeDcsnValuationText AS InspLotUsgeDcsnValuationText,
  _InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _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]
LEFT OUTER JOIN I_InspLotUsageDecision AS _InspLotUsageDecision ON InspectionLot = _InspLotUsageDecision.InspectionLot  -- association [0..1]
;