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_QM_InspCharInfo.
-- 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: CQMINSPINFO
CREATE VIEW C_QM_InspCharInfo AS
SELECT
_Inspcharspecification.InspectionLot AS InspectionLot,
_Inspcharspecification.InspPlanOperationInternalID AS InspPlanOperationInternalID,
_Inspcharspecification.InspectionCharacteristic AS InspectionCharacteristic,
_InspSubsetCharacteristic.InspectionSubsetInternalID AS InspectionSubsetInternalID,
I_InspectionLot.BillOfOperationsType AS BillOfOperationsType,
I_InspectionLot.BillOfOperationsGroup AS BillOfOperationsGroup,
I_InspectionLot.BillOfOperationsVariant AS BillOfOperationsVariant,
_InspectionOperation.BOOOperationInternalID AS BOOOperationInternalID,
_InspSubsetCharacteristic._InspectionCharacteristic.InspectionSpecificationText AS InspectionSpecificationText,
_InspectionOperation.OperationText AS OperationText,
_InspectionResult.CharacteristicAttributeCatalog AS CharacteristicAttributeCatalog,
_InspSubsetCharacteristic._InspectionSubset.MaterialSample AS MaterialSample,
_Inspcharspecification.HasInspCharcPrtlSmpl AS HasInspCharcPrtlSmpl,
_Inspcharspecification.InspCharcIsNotPlanned AS InspCharcIsNotPlanned,
I_InspectionLot.Plant AS Plant,
I_InspectionLot.Batch AS Batch,
I_InspectionLot.Material AS Material,
I_InspectionLot.InspectionLotStartTime AS InspectionLotStartTime,
I_InspectionLot.InspectionLotEndDate AS InspectionLotEndDate,
I_InspectionLot.InspectionLotType AS InspectionLotType,
I_InspectionLot.ManufacturingOrder AS ManufacturingOrder,
I_InspectionLot.InspectionLotQuantity AS InspectionLotQuantity,
I_InspectionLot.InspectionLotQuantityUnit AS InspectionLotQuantityUnit,
I_InspectionLot._InspectionLotType._Text[1:Language=$session.system_language].InspectionLotTypeText AS InspectionLotTypeText,
I_InspectionLot.InspLotHasSubsets AS InspLotHasSubsets,
I_InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
I_InspectionLot.SerialNumberProfile AS SerialNumberProfile,
I_InspectionLot.InspLotIsSerialNmbrPossible AS InspLotIsSerialNmbrPossible,
I_InspectionLot.NumberOfSerialNumbers AS NumberOfSerialNumbers,
_OrderProdnResourceTool._ProdnRsceToolByInternalKey.ProductionResourceTool AS ProductionResourceTool,
_OrderProdnResourceTool._ProdnRsceToolByInternalKey._ProdnRsceToolText[1:Language = $session.system_language].ProductionResourceToolDesc AS ProductionResourceToolDesc,
_Inspcharspecification.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
_Inspcharspecification.QuantityUnit AS QuantityUnit,
_Inspcharspecification.InspLotTestEquipInternalID AS InspLotTestEquipInternalID,
_Inspcharspecification.InspCharcQuantity AS InspectionScope,
_Inspcharspecification._InspectionMethodVersion.InspectionMethod AS InspectionMethod,
_Inspcharspecification._InspectionMethodVersion._InspectionMethodText[1:Language = $session.system_language].InspectionMethodText AS InspectionMethodText,
_Inspcharspecification.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
_Inspcharspecification.InspSpecHasTargetValue AS InspSpecHasTargetValue,
_Inspcharspecification.InspSpecHasUpperLimit AS InspSpecHasUpperLimit,
_Inspcharspecification.InspSpecHasLowerLimit AS InspSpecHasLowerLimit,
_Inspcharspecification.InspectionMethodPlant AS InspectionMethodPlant,
_Inspcharspecification.InspectionMethodVersion AS InspectionMethodVersion,
_Inspcharspecification.InspCharacteristicSampleSize AS InspCharacteristicSampleSize,
_Inspcharspecification.InspSpecSampleQuantityFactor AS InspSpecSampleQuantityFactor,
_Inspcharspecification.InspSpecControlIndicators AS InspSpecControlIndicators,
_Inspcharspecification.InspSpecIsMeasuredValueRqd AS InspSpecIsMeasuredValueRqd,
_Inspcharspecification.InspSpecTargetValue AS InspSpecTargetValue,
_Inspcharspecification.InspSpecUpperLimit AS InspSpecUpperLimit,
_Inspcharspecification.InspSpecLowerLimit AS InspSpecLowerLimit,
_Inspcharspecification.InspectionSpecificationUnit AS InspectionSpecificationUnit,
_Inspcharspecification._InspectionSpecificationUnit._Text[1:Language=$session.system_language].UnitOfMeasureTechnicalName AS UnitOfMeasureTechnicalName,
_Inspcharspecification.InspectionSpecification AS InspectionSpecification,
_Inspcharspecification.InspectionSpecificationPlant AS InspectionSpecificationPlant,
_Inspcharspecification.InspectionSpecificationVersion AS InspectionSpecificationVersion,
_Inspcharspecification.SelectedCodeSet AS SelectedCodeSet,
_Inspcharspecification._CharcAttribSelectedCodeSet.SelectedCodeSetText AS SelectedCodeSetText,
_InspSubsetCharacteristic.InspSampleAcceptanceNumber AS InspSampleAcceptanceNumber,
_InspSubsetCharacteristic.InspSampleRejectionNumber AS InspSampleRejectionNumber,
_InspSubsetCharacteristic.InspectionSampleSize AS InspectionSampleSize,
_InspectionOperation._WorkCenter.WorkCenter AS WorkCenter,
_InspectionOperation._WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterText,
_InspectionOperation.InspectionOperation AS InspectionOperation,
case when InspLotHasSubsets = 'X' then _InspSampleResult.LastChangedByUser else _InspectionResult.LastChangedByUser end as LastChangedByUser AS LastChangedByUserendasLastChangedByUser,
case when InspLotHasSubsets = 'X' then _InspSampleResult.CreatedByUser else _InspectionResult.CreatedByUser end as CreatedByUser AS CreatedByUserendasCreatedByUser,
case when InspLotHasSubsets = 'X' then _InspSampleResult.Inspector else _InspectionResult.Inspector end as Inspector AS InspectorendasInspector,
case when InspLotHasSubsets = 'X' then case when _InspSampleResult.InspResultValidValuesNumber = 0 or _InspSampleResult.InspectionValuationResult = '' or _InspSampleResult.InspectionValuationResult is null then 0 else cast(_InspSampleResult.InspRsltNonconformingValsNmbr as abap.fltp) / cast(_InspSampleResult.InspResultValidValuesNumber as abap.fltp) end else case when _InspectionResult.InspResultValidValuesNumber = 0 or _InspectionResult.InspectionValuationResult = '' or _InspectionResult.InspectionValuationResult is null then 0 else cast(_InspectionResult.InspRsltNonconformingValsNmbr as abap.fltp) / cast(_InspectionResult.InspResultValidValuesNumber as abap.fltp) end end as InspectionNonconformingRatio AS fltpendendasInspectionNonconformingRatio,
_MaterialText.MaterialName AS MaterialName,
_Configuration.InspSpecAddlDecimalPlaces AS InspSpecAddlDecimalPlaces,
_Configuration.InspSpecAddlDecimalPlaces + _InspSubsetCharacteristic._InspectionCharacteristic. InspSpecDecimalPlaces AS InspSpecSummarizedDcmlPlaces,
_InspSubsetCharacteristic._InspectionSubset.InspectionSubsetLongCharKey AS InspectionSubsetLongCharKey,
concat(concat(_Inspcharspecification.InspectionMethodPlant, _Inspcharspecification.InspectionMethod), _Inspcharspecification.InspectionMethodVersion) AS LinkedSAPObjectKey,
cast( coalesce(_InspResultAggrgt.InspResultValueCount, 0) as abap.int4 ) AS InspResultValueCount,
_Inspcharspecification.InspSpecImportanceCode AS InspSpecImportanceCode,
_Inspcharspecification._InspSpecImportanceCode.InspSpecImportanceCodeText AS InspSpecImportanceCodeText,
_Inspcharspecification.InspResultIsDocumentationRqd AS InspResultIsDocumentationRqd,
I_InspectionLot.InspectionSubsetType AS InspectionSubsetType,
_InspSubsetCharacteristic.QualityControlChart AS QualityControlChart,
_Inspcharspecification.InspSpecHasSamplingProcedure AS InspSpecHasSamplingProcedure,
_Inspcharspecification.InspSpecHasControlChart AS InspSpecHasControlChart,
_Inspcharspecification.InspectionCharacteristicStatus AS InspectionCharacteristicStatus
FROM I_InspectionLot
INNER JOIN I_InspectionOperation AS _InspectionOperation ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspectionCharacteristic AS _Inspcharspecification ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspectionLotWithStatus AS _inspectionLotWithStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspSubsetCharacteristic AS _InspSubsetCharacteristic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OrderProdnResourceTool AS _OrderProdnResourceTool ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspSubsetResult AS _InspSampleResult ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspectionResult AS _InspectionResult ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CharcAttributeCodeText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspCharcValueAggregate AS _InspResultAggrgt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_QltyMgmtPlantLvlConfign AS _Configuration ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN C_CharacteristicDocument AS _DocumentInfoRecord ON LinkedSAPObjectKey = _DocumentInfoRecord.LinkedSAPObjectKey -- association [0..*]
;