I_QM_InspCharResultdetail

DDL: I_QM_INSPCHARRESULTDETAIL SQL: IQMRESULTDETAIL Type: view COMPOSITE
85 Fields 4 Data Sources

Inspection characteristics result details

I_QM_InspCharResultdetail is a Composite CDS View that provides data about "Inspection characteristics result details" in SAP S/4HANA. It reads from 4 data sources (I_CharcAttributeCodeText, I_CharcAttributeCodeText, P_Inspcharresultdet_With_Smpl, P_Inspcharresultdet_Wo_Smpl) and exposes 85 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspectionSubsetInternalID, InspResultItemInternalID.

Data Sources (4)

SourceAliasJoin Type
I_CharcAttributeCodeText I_CharcAttributeCodeText left_outer
I_CharcAttributeCodeText I_CharcAttributeCodeText left_outer
P_Inspcharresultdet_With_Smpl P_Inspcharresultdet_With_Smpl union
P_Inspcharresultdet_Wo_Smpl P_Inspcharresultdet_Wo_Smpl from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IQMRESULTDETAIL view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Inspection characteristics result details view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view

Fields (85)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot _Inspcharresultdetail InspectionLot Inspection Lot
KEY InspPlanOperationInternalID _Inspcharresultdetail InspPlanOperationInternalID
KEY InspectionCharacteristic _Inspcharresultdetail InspectionCharacteristic
KEY InspectionSubsetInternalID _Inspcharresultdetail InspectionSubsetInternalID
KEY InspResultItemInternalID _Inspcharresultdetail InspResultItemInternalID
Plant _Inspcharresultdetail Plant Valuation Area
InspectionSpecification _Inspcharresultdetail InspectionSpecification Master IC
InspectionOperation _Inspcharresultdetail InspectionOperation
InspCharacteristicSampleUnit _Inspcharresultdetail InspCharacteristicSampleUnit
InspectionMethod _Inspcharresultdetail InspectionMethod Insp. Method
InspSpecLowerLimit _Inspcharresultdetail InspSpecLowerLimit Lower Limit
InspSpecUpperLimit _Inspcharresultdetail InspSpecUpperLimit Upper Limit
InspSpecTargetValue _Inspcharresultdetail InspSpecTargetValue Target Value
InspSpecDecimalPlaces _Inspcharresultdetail InspSpecDecimalPlaces
InspectionMethodVersion _Inspcharresultdetail InspectionMethodVersion
InspectionSpecificationUnit _Inspcharresultdetail InspectionSpecificationUnit Unit of Meas.
InspCharacteristicSampleSize _Inspcharresultdetail InspCharacteristicSampleSize
InspSpecControlIndicators _Inspcharresultdetail InspSpecControlIndicators
Inspector _Inspcharresultdetail Inspector Inspector
InspectionResultMeanValue _Inspcharresultdetail InspectionResultMeanValue
InspResultValidValuesNumber _Inspcharresultdetail InspResultValidValuesNumber
InspResultValueInternalID _Inspcharresultdetail InspResultValueInternalID
InspectionResultOriginalValue _Inspcharresultdetail InspectionResultOriginalValue
InspectionResultMeasuredValue _Inspcharresultdetail InspectionResultMeasuredValue
InspectionResultItem _Inspcharresultdetail InspectionResultItem
LastChangedByUser _Inspcharresultdetail LastChangedByUser User Name
CreatedByUser _Inspcharresultdetail CreatedByUser User Name
InspSpecAddlDecimalPlaces _Inspcharresultdetail InspSpecAddlDecimalPlaces
InspSpecSummarizedDcmlPlaces _Inspcharresultdetail InspSpecSummarizedDcmlPlaces
InspSpecRecordingType _Inspcharresultdetail InspSpecRecordingType
InspectionResultAttribute _Inspcharresultdetail InspectionResultAttribute
InspectionResultAttributeText _Inspcharresultdetail InspectionResultAttributeText
InspResultAttributeIsValid _Inspcharresultdetail InspResultAttributeIsValid
InspectionValuationResult _Inspcharresultdetail InspectionValuationResult
InspRsltFreeDefinedTestEquip _Inspcharresultdetail InspRsltFreeDefinedTestEquip
InspectionResultText _Inspcharresultdetail InspectionResultText
InspSpecIsQuantitative _Inspcharresultdetail InspSpecIsQuantitative Quant.charac.
CharacteristicAttributeCatalog _Inspcharresultdetail CharacteristicAttributeCatalog
CharacteristicAttributeCode _Inspcharresultdetail CharacteristicAttributeCode Water Hazard Cl.
CharacteristicAttributeCodeGrp _Inspcharresultdetail CharacteristicAttributeCodeGrp Code Group
CharacteristicAttributeCodeTxt _CharcAttribute CharacteristicAttributeCodeTxt
InspectionLotType _Inspcharresultdetail InspectionLotType Inspection Type
InspectionLot Inspection Lot
KEY InspPlanOperationInternalID _Inspcharresultdetail InspPlanOperationInternalID
KEY InspectionCharacteristic _Inspcharresultdetail InspectionCharacteristic
KEY InspectionSubsetInternalID _Inspcharresultdetail InspectionSubsetInternalID
KEY InspResultItemInternalID _Inspcharresultdetail InspResultItemInternalID
Plant _Inspcharresultdetail Plant Valuation Area
InspectionSpecification _Inspcharresultdetail InspectionSpecification Master IC
InspectionOperation _Inspcharresultdetail InspectionOperation
InspCharacteristicSampleUnit _Inspcharresultdetail InspCharacteristicSampleUnit
InspectionMethod _Inspcharresultdetail InspectionMethod Insp. Method
InspSpecLowerLimit _Inspcharresultdetail InspSpecLowerLimit Lower Limit
InspSpecUpperLimit _Inspcharresultdetail InspSpecUpperLimit Upper Limit
InspSpecTargetValue _Inspcharresultdetail InspSpecTargetValue Target Value
InspSpecDecimalPlaces _Inspcharresultdetail InspSpecDecimalPlaces
InspectionMethodVersion _Inspcharresultdetail InspectionMethodVersion
InspectionSpecificationUnit _Inspcharresultdetail InspectionSpecificationUnit Unit of Meas.
InspCharacteristicSampleSize _Inspcharresultdetail InspCharacteristicSampleSize
InspSpecControlIndicators _Inspcharresultdetail InspSpecControlIndicators
Inspector _Inspcharresultdetail Inspector Inspector
InspectionResultMeanValue _Inspcharresultdetail InspectionResultMeanValue
InspResultValidValuesNumber _Inspcharresultdetail InspResultValidValuesNumber
InspResultValueInternalID _Inspcharresultdetail InspResultValueInternalID
InspectionResultOriginalValue _Inspcharresultdetail InspectionResultOriginalValue
InspectionResultMeasuredValue _Inspcharresultdetail InspectionResultMeasuredValue
InspectionResultItem _Inspcharresultdetail InspectionResultItem
LastChangedByUser _Inspcharresultdetail LastChangedByUser User Name
CreatedByUser _Inspcharresultdetail CreatedByUser User Name
InspSpecAddlDecimalPlaces _Inspcharresultdetail InspSpecAddlDecimalPlaces
InspSpecSummarizedDcmlPlaces _Inspcharresultdetail InspSpecSummarizedDcmlPlaces
InspSpecRecordingType _Inspcharresultdetail InspSpecRecordingType
InspectionResultAttribute _Inspcharresultdetail InspectionResultAttribute
InspectionResultAttributeText _Inspcharresultdetail InspectionResultAttributeText
InspResultAttributeIsValid _Inspcharresultdetail InspResultAttributeIsValid
InspectionValuationResult _Inspcharresultdetail InspectionValuationResult
InspRsltFreeDefinedTestEquip _Inspcharresultdetail InspRsltFreeDefinedTestEquip
InspectionResultText _Inspcharresultdetail InspectionResultText
InspSpecIsQuantitative _Inspcharresultdetail InspSpecIsQuantitative Quant.charac.
CharacteristicAttributeCatalog _Inspcharresultdetail CharacteristicAttributeCatalog
CharacteristicAttributeCode _Inspcharresultdetail CharacteristicAttributeCode Water Hazard Cl.
CharacteristicAttributeCodeGrp _Inspcharresultdetail CharacteristicAttributeCodeGrp Code Group
CharacteristicAttributeCodeTxt _CharcAttribute CharacteristicAttributeCodeTxt
InspectionLotType _Inspcharresultdetail InspectionLotType Inspection Type
MatlQualityAuthorizationGroup _Inspcharresultdetail MatlQualityAuthorizationGroup QM Matl Auth.

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_QM_InspCharResultdetail.
-- 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: IQMRESULTDETAIL

CREATE VIEW I_QM_InspCharResultdetail AS
SELECT
  _Inspcharresultdetail.InspectionLot AS InspectionLot,
  _Inspcharresultdetail.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _Inspcharresultdetail.InspectionCharacteristic AS InspectionCharacteristic,
  _Inspcharresultdetail.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _Inspcharresultdetail.InspResultItemInternalID AS InspResultItemInternalID,
  _Inspcharresultdetail.Plant AS Plant,
  _Inspcharresultdetail.InspectionSpecification AS InspectionSpecification,
  _Inspcharresultdetail.InspectionOperation AS InspectionOperation,
  _Inspcharresultdetail.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
  _Inspcharresultdetail.InspectionMethod AS InspectionMethod,
  _Inspcharresultdetail.InspSpecLowerLimit AS InspSpecLowerLimit,
  _Inspcharresultdetail.InspSpecUpperLimit AS InspSpecUpperLimit,
  _Inspcharresultdetail.InspSpecTargetValue AS InspSpecTargetValue,
  _Inspcharresultdetail.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  _Inspcharresultdetail.InspectionMethodVersion AS InspectionMethodVersion,
  _Inspcharresultdetail.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  _Inspcharresultdetail.InspCharacteristicSampleSize AS InspCharacteristicSampleSize,
  _Inspcharresultdetail.InspSpecControlIndicators AS InspSpecControlIndicators,
  _Inspcharresultdetail.Inspector AS Inspector,
  _Inspcharresultdetail.InspectionResultMeanValue AS InspectionResultMeanValue,
  _Inspcharresultdetail.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  _Inspcharresultdetail.InspResultValueInternalID AS InspResultValueInternalID,
  _Inspcharresultdetail.InspectionResultOriginalValue AS InspectionResultOriginalValue,
  _Inspcharresultdetail.InspectionResultMeasuredValue AS InspectionResultMeasuredValue,
  _Inspcharresultdetail.InspectionResultItem AS InspectionResultItem,
  _Inspcharresultdetail.LastChangedByUser AS LastChangedByUser,
  _Inspcharresultdetail.CreatedByUser AS CreatedByUser,
  _Inspcharresultdetail.InspSpecAddlDecimalPlaces AS InspSpecAddlDecimalPlaces,
  _Inspcharresultdetail.InspSpecSummarizedDcmlPlaces AS InspSpecSummarizedDcmlPlaces,
  _Inspcharresultdetail.InspSpecRecordingType AS InspSpecRecordingType,
  _Inspcharresultdetail.InspectionResultAttribute AS InspectionResultAttribute,
  _Inspcharresultdetail.InspectionResultAttributeText AS InspectionResultAttributeText,
  _Inspcharresultdetail.InspResultAttributeIsValid AS InspResultAttributeIsValid,
  _Inspcharresultdetail.InspectionValuationResult AS InspectionValuationResult,
  _Inspcharresultdetail.InspRsltFreeDefinedTestEquip AS InspRsltFreeDefinedTestEquip,
  _Inspcharresultdetail.InspectionResultText AS InspectionResultText,
  _Inspcharresultdetail.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  _Inspcharresultdetail.CharacteristicAttributeCatalog AS CharacteristicAttributeCatalog,
  _Inspcharresultdetail.CharacteristicAttributeCode AS CharacteristicAttributeCode,
  _Inspcharresultdetail.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  _CharcAttribute.CharacteristicAttributeCodeTxt AS CharacteristicAttributeCodeTxt,
  _Inspcharresultdetail.InspectionLotType AS InspectionLotType,
  _Inspcharresultdetail.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup
FROM P_Inspcharresultdet_Wo_Smpl
LEFT OUTER JOIN I_CharcAttributeCodeText ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): P_Inspcharresultdet_With_Smpl
;

Learn More