C_QualityLevelAnalysis

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_QualityLevelAnalysis.
-- 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.
-- Parameters: hidden : true, P_StartDate : mm_a_delivery_date, hidden : true, P_EndDate : mm_a_delivery_date, P_DateFunction : datefunctionid

CREATE VIEW C_QualityLevelAnalysis AS
SELECT
  hidden: true AS hiddentrueP_StartDatemm_a_delivery_date,
  hidden: true AS P_StartDate,
  Material,
  Plant,
  cast(InspectionCharacteristic as vdm_qmerknrp ) AS InspectionCharacteristic,
  InspectionSpecificationText,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  Supplier,
  Customer,
  Manufacturer,
  InspectionLotType,
  InspectionLotUsageDecisionCode,
  InspLotDynamicRule,
  InspectionDynamicStage,
  cast( IsInspectionLotSkippedText as vdm_qinsplotisskipped preserving type ) AS IsInspectionLotSkippedText,
  InspectionLotCreatedOn,
  InspPlanOperationInternalID,
  InspectionLotDynamicLevel,
  InspectionSeverity,
  cast( InspectionLotCount as vdm_qinspectionlotcount preserving type ) AS InspectionLotCount,
  cast( InspCharCount as vdm_qinspcharccnt preserving type ) AS InspCharCount,
  cast( InspectionLotIsSkipped as vdm_qinsplotskipped preserving type ) AS InspectionLotIsSkipped,
  cast( InspectionLotIsNotSkipped as vdm_qinsplotnotskipped preserving type ) AS InspectionLotIsNotSkipped,
  cast( InspCharcSkipCount as vdm_qinspcharcskipcount preserving type ) AS InspCharcSkipCount,
  cast( InspCharcNotSkipCount as vdm_qinspcharcnskipcount preserving type ) AS InspCharcNotSkipCount,
  cast( InspectionNotSkippedCount as vdm_qminspnotskippedcount preserving type ) AS InspectionNotSkippedCount,
  cast( QualityLevelCount as vdm_qltylvlcnt preserving type ) AS QualityLevelCount,
  1 AS InspectionSkipRate,
  CalendarYear,
  CalendarQuarter,
  CalendarMonth,
  CalendarWeek
FROM I_QualityLevelAnalysisCube
;