I_QualityLevelAnalysisCube

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_QualityLevelAnalysisCube.
-- 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: P_StartDate : mm_a_delivery_date, P_EndDate : mm_a_delivery_date

CREATE VIEW I_QualityLevelAnalysisCube AS
SELECT
  _InspLot.InspectionLot AS InspectionLot,
  _InspChar.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  cast(_InspChar.InspectionCharacteristic as vdm_qmerknrp) AS InspectionCharacteristic,
  _InspLot.Material AS Material,
  _InspLot.Plant AS Plant,
  _InspChar.InspectionSpecificationText AS InspectionSpecificationText,
  _InspLot.BillOfOperationsType AS BillOfOperationsType,
  _InspLot.BillOfOperationsGroup AS BillOfOperationsGroup,
  _InspLot.BillOfOperationsVariant AS BillOfOperationsVariant,
  Supplier,
  Customer,
  Manufacturer,
  _InspLot.InspectionLotType AS InspectionLotType,
  _InspLotUsageDecision.InspectionLotUsageDecisionCode AS InspectionLotUsageDecisionCode,
  _InspLot.InspectionLotIsSkipped AS InspectionLotStatusSkip,
  InspectionLotCreatedOn,
  InspectionLotDynamicLevel,
  _InspLotUsageDecision.InspLotUsageDecisionCodeGroup AS InspLotUsageDecisionCodeGroup,
  _InspectionLotIsSkipped.IndicatorValue AS IndicatorValue,
  MatlQualityAuthorizationGroup,
  case when ( InspectionLotDynamicLevel = '0' or InspectionLotDynamicLevel = '1' ) then cast( 1 as abap.int4 ) else cast( 0 as abap.int4 ) end as InspectionLotCount AS int4endasInspectionLotCount,
  case when InspectionLotDynamicLevel = '3' then cast( 1 as abap.int4 ) else cast( 0 as abap.int4 ) end as InspCharCount AS int4endasInspCharCount,
  case when ( InspectionLotDynamicLevel = '0' or InspectionLotDynamicLevel = '1' ) and InspectionLotIsSkipped = 'X' then cast( 1 as abap.int4 ) else cast( 0 as abap.int4 ) end as InspectionLotIsSkipped AS int4endasInspectionLotIsSkipped,
  case when ( InspectionLotDynamicLevel = '0' or InspectionLotDynamicLevel = '1' ) and InspectionLotIsSkipped = '' then cast( 1 as abap.int4 ) else cast( 0 as abap.int4 ) end as InspectionLotIsNotSkipped AS int4endasInspectionLotIsNotSkipped,
  case when _InspChar.InspLotDynamicRule != '' and _InspChar.InspectionCharacteristicStatus = '4' then cast( 1 as abap.int4 ) else cast( 0 as abap.int4 ) end as InspCharcSkipCount AS int4endasInspCharcSkipCount,
  case when _InspChar.InspLotDynamicRule != '' and ( _InspChar.InspectionCharacteristicStatus = '0' or _InspChar.InspectionCharacteristicStatus = '1' or _InspChar.InspectionCharacteristicStatus = '2' or _InspChar.InspectionCharacteristicStatus = '3' ) then cast( 1 as abap.int4 ) else cast( 0 as abap.int4 ) end as InspCharcNotSkipCount AS int4endasInspCharcNotSkipCount,
  case when ( InspectionLotDynamicLevel = '0' or InspectionLotDynamicLevel = '1' ) and InspectionLotIsSkipped = '' then cast( 1 as abap.int4 ) when _InspChar.InspLotDynamicRule != '' and ( _InspChar.InspectionCharacteristicStatus = '0' or _InspChar.InspectionCharacteristicStatus = '1' or _InspChar.InspectionCharacteristicStatus = '2' or _InspChar.InspectionCharacteristicStatus = '3' ) then cast( 1 as abap.int4 ) else cast( 0 as abap.int4 ) end as InspectionNotSkippedCount AS int4endasInspectionNotSkippedCount,
  cast( 1 as abap.int4 ) AS QualityLevelCount,
  _InspLot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _CalendarDate.CalendarYear AS CalendarYear,
  _CalendarDate.CalendarQuarter AS CalendarQuarter,
  _CalendarDate.CalendarMonth AS CalendarMonth,
  _CalendarDate.CalendarWeek AS CalendarWeek,
  _InspLot._Plant AS _Plant,
  _InspLot._Material AS _Material,
  _InspLotUsageDecision._UsageDecisionCode AS _UsageDecisionCode,
  _InspLotUsageDecision._UsageDecisionCodeGroup AS _UsageDecisionCodeGroup,
  _InspectionLotIsSkipped._IndicatorText AS _IndicatorText
FROM I_InspectionLot AS _InspLot
LEFT OUTER JOIN I_InspectionCharacteristic AS _InspChar ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspLotDynamicRule AS _InspLotDynamicRule ON InspLotDynamicRule = _InspLotDynamicRule.InspLotDynamicRule  -- association [1..1]
LEFT OUTER JOIN I_InspectionLotDynamicLevel AS _InspectionLotDynamicLevel ON InspectionLotDynamicLevel = _InspectionLotDynamicLevel.InspectionLotDynamicLevel  -- association [1..1]
LEFT OUTER JOIN I_InspectionSeverity AS _InspectionSeverity ON InspectionSeverity = _InspectionSeverity.InspectionSeverity  -- association [1..1]
LEFT OUTER JOIN I_InspLotDynRuleStage AS _InspLotDynRuleStage ON InspLotDynamicRule = _InspLotDynRuleStage.InspLotDynamicRule AND InspectionDynamicStage = _InspLotDynRuleStage.InspLotDynRuleStage  -- association [1..1]
LEFT OUTER JOIN I_Indicator AS _InspectionLotIsSkipped ON InspectionLotStatusSkip = _InspectionLotIsSkipped.IndicatorValue  -- association [1..1]
LEFT OUTER JOIN I_InspectionCharacteristic AS _InspectionCharacteristic ON InspectionLot = _InspectionCharacteristic.InspectionLot AND InspPlanOperationInternalID = _InspectionCharacteristic.InspPlanOperationInternalID AND InspectionCharacteristic = _InspectionCharacteristic.InspectionCharacteristic  -- association [1..1]
;