I_INSPECTIONRESULT

CDS View
67 Fields 16 CDS Views

Summarized Insp Result for an Insp Charc

I_INSPECTIONRESULT is a CDS View in S/4HANA. Summarized Insp Result for an Insp Charc. It contains 67 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
C_InspCharcMltplRsltRec view left_outer CONSUMPTION Insp Charac for Mltpl Rslt Recording
C_InspResultMltplRsltRec view left_outer CONSUMPTION Recorded Results for Mltpl Rslt Rec
C_Qm_Charsresults view left_outer CONSUMPTION Characteristic list of record results
C_QM_InspCharInfo view left_outer CONSUMPTION Characteristic details- More information
I_InspCharacteristicAggregate view left_outer COMPOSITE Aggregation on inspection characteristic level
I_InspCharQuantitativeCube view from COMPOSITE Chracteristics Analytics - Quantitative Analysis
I_InspectionCharacteristicFact view left_outer COMPOSITE Inspection Characteristic Fact
I_InspectionResultHistory view from COMPOSITE Inspection Result History
I_InspectionResultTP view from TRANSACTIONAL Summarized Insp Result for an Insp Charc
I_MfgInspCharcHistory view inner COMPOSITE Inspection Characteristic History
I_MfgOrdPlanInspCharInfo view left_outer COMPOSITE Order PIC Info
P_Inspcharresultdet_Wo_Smpl view left_outer COMPOSITE
P_MfgInspCharcSumzdRslt view_entity inner COMPOSITE
P_MPEOrdILOperOpenCharcCount view_entity left_outer CONSUMPTION Number of Open Characteristics in Inspection Lot Operation
P_MPEOrdInspLotOpenCharcCount view_entity left_outer CONSUMPTION Number of Open Characteristics in Inspection Lot
R_InspectionResultTP view_entity from TRANSACTIONAL Inspection Result TP

Fields (67)

KeyField CDS FieldsUsed in Views
KEY InspectionCharacteristic InspectionCharacteristic 5
KEY InspectionLot InspectionLot 3
KEY InspPlanOperationInternalID InspPlanOperationInternalID 5
_CharcAttributeCode _CharcAttributeCode 1
_CharcAttributeCodeGrp _CharcAttributeCodeGrp 1
_InspectionResultAttribute _InspectionResultAttribute 1
_InspectionValuationResult _InspectionValuationResult 1
ChangedDateTime ChangedDateTime 2
ChangedTime ChangedTime 2
CharacteristicAttributeCatalog CharacteristicAttributeCatalog 2
CharacteristicAttributeCode CharacteristicAttributeCode 5
CharacteristicAttributeCodeGrp CharacteristicAttributeCodeGrp 5
CharcAttributeCodeVers CharcAttributeCodeVers 1
CreatedByUser CreatedByUser 5
CreationDate CreationDate 5
CreationTime CreationTime 4
DefectClass DefectClass 1
InspectionEndDate InspectionEndDate 2
InspectionEndTime InspectionEndTime 2
InspectionNumberOfDefects InspectionNumberOfDefects 1
InspectionPartialSampleSize InspectionPartialSampleSize 2
InspectionResultAttribute InspectionResultAttribute 3
InspectionResultCatalog2 InspectionResultCatalog2 2
InspectionResultCatalog3 InspectionResultCatalog3 2
InspectionResultCatalog4 InspectionResultCatalog4 2
InspectionResultCatalog5 InspectionResultCatalog5 2
InspectionResultCode2 InspectionResultCode2 2
InspectionResultCode2Vers InspectionResultCode2Vers 1
InspectionResultCode3 InspectionResultCode3 2
InspectionResultCode3Vers InspectionResultCode3Vers 1
InspectionResultCode4 InspectionResultCode4 2
InspectionResultCode4Vers InspectionResultCode4Vers 1
InspectionResultCode5 InspectionResultCode5 2
InspectionResultCode5Vers InspectionResultCode5Vers 1
InspectionResultCodeGroup2 InspectionResultCodeGroup2 2
InspectionResultCodeGroup3 InspectionResultCodeGroup3 2
InspectionResultCodeGroup4 InspectionResultCodeGroup4 2
InspectionResultCodeGroup5 InspectionResultCodeGroup5 2
InspectionResultHasLongText InspectionResultHasLongText 2
InspectionResultHasMeanValue InspectionResultHasMeanValue 4
InspectionResultMaximumValue InspectionResultMaximumValue 3
InspectionResultMeanValue InspectionResultMeanValue 5
InspectionResultMinimumValue InspectionResultMinimumValue 3
InspectionResultOrigin InspectionResultOrigin 2
InspectionResultOriginalValue InspectionResultOriginalValue 3
InspectionResultStatus InspectionResultStatus 2
InspectionResultText InspectionResultText 3
InspectionStartDate InspectionStartDate 2
InspectionStartTime InspectionStartTime 2
InspectionValuationResult InspectionValuationResult 5
Inspector Inspector 4
InspResultDynModifValuation InspResultDynModifValuation 1
InspResultHasMaximumValue InspResultHasMaximumValue 2
InspResultHasMinimumValue InspResultHasMinimumValue 2
InspResultHasVariance InspResultHasVariance 1
InspResultNmbrOfRecordedRslts InspResultNmbrOfRecordedRslts 1
InspResultNrOfAddlDcmlsPlaces InspResultNrOfAddlDcmlsPlaces 1
InspResultValidValuesNumber InspResultValidValuesNumber 5
InspResultVariance InspResultVariance 3
InspRsltAboveToleranceFraction InspRsltAboveToleranceFraction 3
InspRsltAboveToleranceValsNmbr InspRsltAboveToleranceValsNmbr 3
InspRsltBelowToleranceFraction InspRsltBelowToleranceFraction 3
InspRsltBelowToleranceValsNmbr InspRsltBelowToleranceValsNmbr 3
InspRsltFreeDefinedTestEquip InspRsltFreeDefinedTestEquip 3
InspRsltNonconformingValsNmbr InspRsltNonconformingValsNmbr 3
LastChangeDate LastChangeDate 2
LastChangedByUser LastChangedByUser 3

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Summarized Insp Result for an Insp Charc
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSPECTIONRESULT (
    INSPECTIONCHARACTERISTIC,
    INSPECTIONLOT,
    INSPPLANOPERATIONINTERNALID,
    _CHARCATTRIBUTECODE,
    _CHARCATTRIBUTECODEGRP,
    _INSPECTIONRESULTATTRIBUTE,
    _INSPECTIONVALUATIONRESULT,
    CHANGEDDATETIME,
    CHANGEDTIME,
    CHARACTERISTICATTRIBUTECATALOG,
    CHARACTERISTICATTRIBUTECODE,
    CHARACTERISTICATTRIBUTECODEGRP,
    CHARCATTRIBUTECODEVERS,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DEFECTCLASS,
    INSPECTIONENDDATE,
    INSPECTIONENDTIME,
    INSPECTIONNUMBEROFDEFECTS,
    INSPECTIONPARTIALSAMPLESIZE,
    INSPECTIONRESULTATTRIBUTE,
    INSPECTIONRESULTCATALOG2,
    INSPECTIONRESULTCATALOG3,
    INSPECTIONRESULTCATALOG4,
    INSPECTIONRESULTCATALOG5,
    INSPECTIONRESULTCODE2,
    INSPECTIONRESULTCODE2VERS,
    INSPECTIONRESULTCODE3,
    INSPECTIONRESULTCODE3VERS,
    INSPECTIONRESULTCODE4,
    INSPECTIONRESULTCODE4VERS,
    INSPECTIONRESULTCODE5,
    INSPECTIONRESULTCODE5VERS,
    INSPECTIONRESULTCODEGROUP2,
    INSPECTIONRESULTCODEGROUP3,
    INSPECTIONRESULTCODEGROUP4,
    INSPECTIONRESULTCODEGROUP5,
    INSPECTIONRESULTHASLONGTEXT,
    INSPECTIONRESULTHASMEANVALUE,
    INSPECTIONRESULTMAXIMUMVALUE,
    INSPECTIONRESULTMEANVALUE,
    INSPECTIONRESULTMINIMUMVALUE,
    INSPECTIONRESULTORIGIN,
    INSPECTIONRESULTORIGINALVALUE,
    INSPECTIONRESULTSTATUS,
    INSPECTIONRESULTTEXT,
    INSPECTIONSTARTDATE,
    INSPECTIONSTARTTIME,
    INSPECTIONVALUATIONRESULT,
    INSPECTOR,
    INSPRESULTDYNMODIFVALUATION,
    INSPRESULTHASMAXIMUMVALUE,
    INSPRESULTHASMINIMUMVALUE,
    INSPRESULTHASVARIANCE,
    INSPRESULTNMBROFRECORDEDRSLTS,
    INSPRESULTNROFADDLDCMLSPLACES,
    INSPRESULTVALIDVALUESNUMBER,
    INSPRESULTVARIANCE,
    INSPRSLTABOVETOLERANCEFRACTION,
    INSPRSLTABOVETOLERANCEVALSNMBR,
    INSPRSLTBELOWTOLERANCEFRACTION,
    INSPRSLTBELOWTOLERANCEVALSNMBR,
    INSPRSLTFREEDEFINEDTESTEQUIP,
    INSPRSLTNONCONFORMINGVALSNMBR,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    PRIMARY KEY (INSPECTIONCHARACTERISTIC, INSPECTIONLOT, INSPPLANOPERATIONINTERNALID)
);

Learn More