I_InspCharcsQtyCube

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_InspCharcsQtyCube.
-- 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_InspCharcsQtyCube AS
SELECT
  _InspSubsetCharcs.InspectionLot AS InspectionLot,
  _InspSubsetCharcs.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _InspSubsetCharcs.InspectionCharacteristic AS InspectionCharacteristic,
  _InspSubsetCharcs.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _ILot.InspectionLotOrigin AS InspectionLotOrigin,
  _IOperation.WorkCenterInternalID AS WorkCenterInternalID,
  _IOperation.InspectionOperation AS InspectionOperation,
  concat(concat(concat(concat(concat( concat ( concat (concat( _ILot.BillOfOperationsType, '-'), ltrim( _ILot.BillOfOperationsGroup , '0') ), '-'), _ILot.BillOfOperationsVariant), '-'), _IOperation.InspectionOperation), '-'), _InspSubsetCharcs.InspectionCharacteristic) AS InspResultHistoryCharc,
  concat( concat ( concat (concat( _ICharacteristic.InspectionSpecification, '-'), _ICharacteristic.InspectionSpecificationPlant), '-'), ltrim(_ICharacteristic.InspectionSpecificationVersion, '0') ) AS MasterInspCharcsKey,
  _ICharacteristic.InspectionSpecification AS InspectionSpecification,
  _ICharacteristic.InspectionSpecificationText AS InspectionSpecificationText,
  _ILot.Plant AS Plant,
  _ILot.Material AS Material,
  _ILot.Supplier AS Supplier,
  _ILot.Customer AS Customer,
  _IOperation._WorkCenter.WorkCenter AS WorkCenter,
  _IOperation.InspectionOperationPlant AS InspectionOperationPlant,
  _IOperation._Plant.PlantName AS WorkCenterPlantName,
  _ILot.BillOfOperationsType AS BillOfOperationsType,
  _ILot.BillOfOperationsGroup AS BillOfOperationsGroup,
  _ILot.BillOfOperationsVariant AS BillOfOperationsVariant,
  _IOperation.BOOOperationInternalID AS BOOOperationInternalID,
  _ICharacteristic.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  _ICharacteristic.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  _ILot.InspectionLotQuantityUnit AS InspectionLotQuantityUnit,
  _ILot.InspectionLotQuantityUnit AS InspectionLotSampleUnit,
  _ILot.InspectionLotQuantity AS InspectionLotQuantity,
  case when (_ILot.InspLotHasSubsets = 'X' and (_InspSubsetCharcs.InspectionCharacteristicStatus = '4' or _ISubsetResult.InspectionResultStatus = '4' )) or (_ILot.InspLotHasSubsets <> 'X' and (_ICharacteristic.InspectionCharacteristicStatus = '4'or _ICharacteristic._InspectionResult.InspectionResultStatus = '4' ) ) then cast( 100 as abap.int4 ) else cast( 0 as abap.int4 ) end as InspLotSkipQuantityInPercent AS int4endasInspLotSkipQuantityInPercent,
  case when (_ILot.InspLotHasSubsets = 'X' and _ISubsetResult.InspectionValuationResult = 'R' and (_ISubsetResult.InspectionResultStatus <> '4' and _InspSubsetCharcs.InspectionCharacteristicStatus <> '4' )) or (_ILot.InspLotHasSubsets <> 'X' and _ICharacteristic._InspectionResult.InspectionValuationResult = 'R' and (_ICharacteristic._InspectionResult.InspectionResultStatus <> '4' and _ICharacteristic.InspectionCharacteristicStatus <> '4' )) then cast( 100 as abap.int4 ) else cast( 0 as abap.int4 ) end as InspLotRjctdQuantityInPercent AS int4endasInspLotRjctdQuantityInPercent,
  _ILot.InspectionLotType AS InspectionLotType,
  _ILot.InspectionSubsetType AS InspectionSubsetType,
  _ILot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _ILot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _ILot._Plant AS _Plant,
  _ILot._Supplier AS _Supplier,
  _ILot._Customer AS _Customer,
  _IOperation._WorkCenter AS _WorkCenter
FROM I_InspSubsetCharacteristic AS _InspSubsetCharcs
LEFT OUTER JOIN I_InspectionLot AS _ILot ON InspectionLot = _ILot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_InspectionOperation AS _IOperation ON InspectionLot = _IOperation.InspectionLot AND InspPlanOperationInternalID = _IOperation.InspPlanOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_InspectionCharacteristic AS _ICharacteristic ON InspectionLot = _ICharacteristic.InspectionLot AND InspPlanOperationInternalID = _ICharacteristic.InspPlanOperationInternalID AND InspectionCharacteristic = _ICharacteristic.InspectionCharacteristic  -- association [1..1]
LEFT OUTER JOIN I_InspSubsetResult AS _ISubsetResult ON InspectionLot = _ISubsetResult.InspectionLot AND InspPlanOperationInternalID = _ISubsetResult.InspPlanOperationInternalID AND InspectionSubsetInternalID = _ISubsetResult.InspectionSubsetInternalID AND InspectionCharacteristic = _ISubsetResult.InspectionCharacteristic  -- association [0..1]
LEFT OUTER JOIN I_InspSpecificationVersion AS _InspSpecificationVersion ON inspectionspecificationplant = _InspSpecificationVersion.InspectionSpecificationPlant AND inspectionspecification = _InspSpecificationVersion.InspectionSpecification AND inspectionspecificationversion = _InspSpecificationVersion.InspectionSpecificationVersion  -- association [0..1]
;