I_InspectionCharacteristic

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_InspectionCharacteristic.
-- 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: IINSPCHAR

CREATE VIEW I_InspectionCharacteristic AS
SELECT
  qamv.prueflos AS InspectionLot,
  qamv.vorglfnr AS InspPlanOperationInternalID,
  qamv.merknr AS InspectionCharacteristic,
  cast( qamv.kurztext as vdm_qmkkurztxt preserving type ) AS InspectionSpecificationText,
  cast( qamv.kurztext as vdm_qmkkurztxt preserving type ) AS InspectionCharacteristicText,
  qamv.ltextspr AS InspCharcLongTextLanguage,
  qamv.tstichprkz AS HasInspCharcPrtlSmpl,
  qamv.char_relevance AS BOOCharacteristicInspRelevance,
  qamv.aktppkt AS InspCharcUnplannedProcessing,
  cast(substring(qamv.steuerkz,1,1) as vdm_qkzqunmk preserving type ) AS InspSpecIsQuantitative,
  cast(substring(qamv.steuerkz,2,1) as qkzqumk preserving type ) AS InspSpecIsMeasuredValueRqd,
  cast(substring(qamv.steuerkz,3,1) as qkzpkat preserving type ) AS InspSpecIsSelectedSetRequired,
  cast(substring(qamv.steuerkz,8,1) as qlzeitkz preserving type ) AS InspSpecIsLongTermInspection,
  cast(substring(qamv.steuerkz,9,1) as qestukz preserving type ) AS InspSpecRecordingType,
  cast(substring(qamv.steuerkz,10,1) as qdokukz preserving type ) AS InspResultIsDocumentationRqd,
  cast(substring(qamv.steuerkz,11,1) as qrzwang preserving type ) AS InspSpecCharcCategory,
  cast(substring(qamv.steuerkz,15,1) as qkzformel preserving type ) AS InspSpecResultCalculation,
  cast(substring(qamv.steuerkz,16,1) as qstichpr preserving type ) AS InspSpecHasSamplingProcedure,
  cast( substring(qamv.steuerkz,19,1) as qbfhlzhl preserving type ) AS InspSpecIsDefectRecordingRqd,
  cast( substring(qamv.steuerkz,23,1) as qfehlrec preserving type ) AS InspSpecIsDefectsRecgAutomatic,
  cast(substring(qamv.steuerkz,24,1) as qkzaenbel preserving type ) AS InspSpecIsChgDocRequired,
  cast(substring(qamv.steuerkz,25,1) as qspcmk preserving type ) AS InspSpecHasControlChart,
  cast( niplanmkkz as vdm_qniplanmk preserving type ) AS InspCharcIsNotPlanned,
  qamv.pmethode AS InspectionMethod,
  cast( qamv.qmtb_werks as vdm_qmtb_werks preserving type ) AS InspectionMethodPlant,
  qamv.pmtversion AS InspectionMethodVersion,
  qamv.qpmk_ref AS InspCharcInspSpecRefType,
  cast( qamv.qpmk_werks as vdm_qpmk_werks preserving type ) AS InspectionSpecificationPlant,
  qamv.verwmerkm AS InspectionSpecification,
  qamv.mkversion AS InspectionSpecificationVersion,
  qamv.physprobe AS InspCharcPrtlSmpl,
  qamv.satzstatus AS InspectionCharacteristicStatus,
  qamv.stellen AS InspSpecDecimalPlaces,
  qamv.stichprver AS SamplingProcedure,
  qamv.masseinhsw AS InspectionSpecificationUnit,
  qamv.fakplanme AS BOOCharcMatlToSampleUnitRate,
  qamv.fakprobme AS BOOCharcSampleToMatlUnitRate,
  qamv.antverf AS DefectFractionEstimationProced,
  qamv.bewregel AS InspSampleValuationRule,
  qamv.probemgeh AS QuantityUnit,
  qamv.sollstpumf AS InspCharacteristicSampleSize,
  qamv.probemgeh AS InspCharacteristicSampleUnit,
  qamv.probmgfak AS InspSpecSampleQuantityFactor,
  qamv.sollwert AS InspSpecTargetValue,
  qamv.sollwni AS InspSpecHasTargetValue,
  qamv.toleranzob AS InspSpecUpperLimit,
  qamv.tolobni AS InspSpecHasUpperLimit,
  qamv.toleranzun AS InspSpecLowerLimit,
  qamv.tolunni AS InspSpecHasLowerLimit,
  qamv.plausioben AS InspSpecUpperPlausibilityLimit,
  qamv.plausiobni AS InspSpecHasUprPlausibilityLmt,
  qamv.plausiunte AS InspSpecLowerPlausibilityLimit,
  qamv.plausiunni AS InspSpecHasLowrPlausibilityLmt,
  qamv.merkgew AS InspSpecImportanceCode,
  qamv.pzlfh AS InspLotTestEquipInternalID,
  qamv.katalgart1 AS CharacteristicAttributeCatalog,
  qamv.auswmenge1 AS SelectedCodeSet,
  qamv.auswmgwrk1 AS SelectedCodeSetPlant,
  qamv.katalgart2 AS InspSpecAdditionalCatalog2,
  qamv.katalgart3 AS InspSpecAdditionalCatalog3,
  qamv.katalgart4 AS InspSpecAdditionalCatalog4,
  qamv.katalgart5 AS InspSpecAdditionalCatalog5,
  qamv.auswmgwrk2 AS InspSpecAddlSeldCodeSetPlant2,
  qamv.auswmgwrk3 AS InspSpecAddlSeldCodeSetPlant3,
  qamv.auswmgwrk4 AS InspSpecAddlSeldCodeSetPlant4,
  qamv.auswmgwrk5 AS InspSpecAddlSeldCodeSetPlant5,
  cast( qamv.ltextkz as vdm_qkz preserving type ) AS InspSpecificationHasLongText,
  qamv.pruefquali AS InspectorQualification,
  qamv.formelsl AS InspSpecHasFormula,
  qamv.formel1 AS InspSpecFormula1,
  qamv.formel2 AS InspSpecFormula2,
  qamv.dummy10 AS InspSpecInformationField1,
  qamv.dummy20 AS InspSpecInformationField2,
  qamv.dummy40 AS InspSpecInformationField3,
  qamv.codegr9u AS InspSpecDefectCodeGrpRjcnLower,
  qamv.code9u AS InspSpecDefectCodeRjcnLower,
  qamv.codegr9o AS InspSpecDefectCodeGrpRjcnUpper,
  qamv.code9o AS InspSpecDefectCodeRjcnUpper,
  qamv.codegrqual AS InspSpecDefectCodeGrpRejection,
  qamv.codequal AS InspSpecDefectCodeRejection,
  qamv.pruefumf AS InspectionScope,
  qamv.pruefumf AS InspCharcQuantity,
  qamv.mengeneinh AS InspectionLotSampleUnit,
  qamv.steuerkz AS InspSpecControlIndicators,
  qamv.ppktungemk AS UnplndCharcInspSubsetIntID,
  cast( qamv.qdynregel as vdm_qdynregel preserving type ) AS InspLotDynamicRule,
  qamv.zaehlerql AS QualityLevelInternalID,
  qamv.kzrast AS SamplingProcedureInspSubset,
  qamv.raster AS InspectionsNotSkippedDnmntr,
  qamv.spckrit AS QltyCtrlChartAggrgnCriterion,
  qamv.chargroup AS BOOCharcGroup,
  qamv.chargroup_cref AS BOOCharcSourceCharc,
  qamv.divisionint AS BOOCharcGroupDivision,
  qamv.oa_id AS ProductionOrderOperationActy,
  qamv.oa_version_no AS ProductionOrderOpActyVers,
  qamv.rueckmelnr AS InspCharcConfirmationNumber,
  qamv.zaehl AS BOOCharacteristicVersion,
  qamv.erstelldat AS InspCharcCreationDate,
  qamv.ersteller AS InspCharcCreatedBy,
  qamv.inpproc AS InspSpecInputProcedure
FROM qamv
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_InspectionOperation AS _InspectionOperation ON InspectionLot = _InspectionOperation.InspectionLot AND InspPlanOperationInternalID = _InspectionOperation.InspPlanOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_InspectionResult AS _InspectionResult ON InspectionLot = _InspectionResult.InspectionLot AND InspPlanOperationInternalID = _InspectionResult.InspPlanOperationInternalID AND InspectionCharacteristic = _InspectionResult.InspectionCharacteristic  -- association [0..1]
LEFT OUTER JOIN I_CharcAttribSelectedCodeSet AS _CharcAttribSelectedCodeSet ON SelectedCodeSet = _CharcAttribSelectedCodeSet.SelectedCodeSet AND SelectedCodeSetPlant = _CharcAttribSelectedCodeSet.SelectedCodeSetPlant  -- association [0..1]
LEFT OUTER JOIN I_InspSpecImportanceCode AS _InspSpecImportanceCode ON InspSpecImportanceCode = _InspSpecImportanceCode.InspSpecImportanceCode  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _InspectionSpecificationUnit ON InspectionSpecificationUnit = _InspectionSpecificationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _InspCharacteristicSampleUnit ON InspCharacteristicSampleUnit = _InspCharacteristicSampleUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnit ON QuantityUnit = _QuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_InspectionResultStatus AS _InspCharacteristicStatus ON InspectionCharacteristicStatus = _InspCharacteristicStatus.InspectionResultStatus  -- association [0..1]
LEFT OUTER JOIN I_InspSubsetCharacteristic AS _InspCharacteristic ON InspectionLot = _InspCharacteristic.InspectionLot AND InspPlanOperationInternalID = _InspCharacteristic.InspPlanOperationInternalID AND InspectionCharacteristic = _InspCharacteristic.InspectionCharacteristic AND _InspCharacteristic.InspectionSubsetInternalID = '000000'  -- association [0..1]
LEFT OUTER JOIN I_InspSubsetCharacteristic AS _InspSubsetCharacteristic ON InspectionLot = _InspSubsetCharacteristic.InspectionLot AND InspPlanOperationInternalID = _InspSubsetCharacteristic.InspPlanOperationInternalID AND InspectionCharacteristic = _InspSubsetCharacteristic.InspectionCharacteristic  -- association [0..*]
LEFT OUTER JOIN I_InspSubsetResult AS _InspSampleResult ON InspectionLot = _InspSampleResult.InspectionLot AND InspPlanOperationInternalID = _InspSampleResult.InspPlanOperationInternalID AND InspectionCharacteristic = _InspSampleResult.InspectionCharacteristic AND HasInspCharcPrtlSmpl = 'X'  -- association [0..*]
LEFT OUTER JOIN I_InspectionResultValue AS _InspectionResultValue ON InspectionLot = _InspectionResultValue.InspectionLot AND InspPlanOperationInternalID = _InspectionResultValue.InspPlanOperationInternalID AND InspectionCharacteristic = _InspectionResultValue.InspectionCharacteristic AND ( _InspectionResultValue.InspectionSubsetInternalID = '000000' OR HasInspCharcPrtlSmpl = 'X' )  -- association [0..*]
LEFT OUTER JOIN I_InspSpecificationVersion AS _InspSpecificationVersion ON InspectionSpecification = _InspSpecificationVersion.InspectionSpecification AND InspectionSpecificationPlant = _InspSpecificationVersion.InspectionSpecificationPlant AND InspectionSpecificationVersion = _InspSpecificationVersion.InspectionSpecificationVersion  -- association [0..1]
LEFT OUTER JOIN I_InspectionSpecification AS _InspectionSpecification ON InspectionSpecification = _InspectionSpecification.InspectionSpecification AND InspectionSpecificationPlant = _InspectionSpecification.InspectionSpecificationPlant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _InspectionSpecificationPlant ON InspectionSpecificationPlant = _InspectionSpecificationPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_InspectionMethodVersion AS _InspectionMethodVersion ON InspectionMethod = _InspectionMethodVersion.InspectionMethod AND InspectionMethodPlant = _InspectionMethodVersion.InspectionMethodPlant AND InspectionMethodVersion = _InspectionMethodVersion.InspectionMethodVersion  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _InspectionMethodPlant ON InspectionMethodPlant = _InspectionMethodPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_InspLotDynamicRule AS _InspLotDynamicRule ON InspLotDynamicRule = _InspLotDynamicRule.InspLotDynamicRule  -- association [0..1]
LEFT OUTER JOIN I_BOOCharcInspRelevance AS _BOOCharcInspRelevance ON BOOCharacteristicInspRelevance = _BOOCharcInspRelevance.BOOCharacteristicInspRelevance  -- association [0..1]
LEFT OUTER JOIN E_InspectionCharacteristic AS _Extension ON InspectionLot = _Extension.InspectionLot AND InspPlanOperationInternalID = _Extension.InspPlanOperationInternalID AND InspectionCharacteristic = _Extension.InspectionCharacteristic  -- association [1..1]
;