C_QualityLvlCalc

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 C_QualityLvlCalc.
-- 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: CQLTYLVLCALC
-- Parameters: P_InspLotDynLvlPrimVal : qdynhead, P_InspLotDynLvlSecdryVal : qdynhead

CREATE VIEW C_QualityLvlCalc AS
SELECT
  Material,
  Plant,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BOOOperationInternalID,
  Sequence,
  QualityLevelInternalID,
  InspLotDynamicRule,
  QltyLevelNextDynRuleStage,
  cast ( _InspLotDynRuleStage.InspectionLotIsSkipped as xfeld ) AS InspectionLotIsSkipped,
  InspectionLot,
  _QualityLevelLastOpenInspLot.InspectionLotDynamicLevel AS InspectionLotDynamicLevel,
  _QualityLevelLastOpenInspLot.InspectionLotOrigin AS InspectionLotOrigin,
  _QualityLevelLastOpenInspLot.InspectionLotHasQuantity AS InspectionLotHasQuantity,
  _QualityLevelLastOpenInspLot.BatchStorageLocation AS BatchStorageLocation,
  _QualityLevelLastOpenInspLot.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  _QualityLevelLastOpenInspLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _QualityLevelLastOpenInspLot.PurchasingOrganization AS PurchasingOrganization,
  _QualityLevelLastOpenInspLot.SalesOrganization AS SalesOrganization,
  _QualityLevelLastOpenInspLot.SoldToParty AS SoldToParty,
  QualityLevelLastOpenInspLot,
  InspectionLotType,
  Manufacturer,
  Supplier,
  Customer
FROM I_QualityLevel
LEFT OUTER JOIN I_InspLotDynRuleStage AS _InspLotDynRuleStage ON InspLotDynamicRule = _InspLotDynRuleStage.InspLotDynamicRule AND QltyLevelNextDynRuleStage = _InspLotDynRuleStage.InspLotDynRuleStage  -- association [1..1]
LEFT OUTER JOIN C_InspectionSkipStatusVH AS _InspectionSkipStatusVH ON InspectionLotIsSkipped = _InspectionSkipStatusVH.InspectionLotIsSkipped  -- association [0..1]
LEFT OUTER JOIN I_Productplantqtmanagement AS _ProductPlantQtManagement ON Material = _ProductPlantQtManagement.Product AND Plant = _ProductPlantQtManagement.Plant  -- association [1..1]
;