I_INSPECTIONRESULTVALUE

CDS View
57 Fields 26 CDS Views

Single Value of an Inspection Charc Rslt

I_INSPECTIONRESULTVALUE is a CDS View in S/4HANA. Single Value of an Inspection Charc Rslt. It contains 57 fields. 26 CDS views read from this table.

CDS Views using this table (26)

ViewTypeJoinVDMDescription
C_DefectMngCharcRslts view left_outer CONSUMPTION Defect: Charcteristics Single Results
C_DefectMngCharcsSbstSglRslts view left_outer CONSUMPTION Defect: Charcs Without Insp. Point for Single Results
C_InspCharSingleRslt view left_outer CONSUMPTION Inspection Characteristic Single Result
C_InspRsltValueMltplRsltRec view from CONSUMPTION Single Results for Mltpl Rslt Recording
C_InspSubsetCharSingleRslt view left_outer CONSUMPTION Inspection Characteristic Single Result for Insp. Points
C_InspUsgeSbstRslt view left_outer CONSUMPTION Insp Usage Decision Subset Rslt
C_InspUsgeSingleRslt view left_outer CONSUMPTION Insp Usage Decision Charcs Rslt
C_MfgOrdInspCharResultRec view from CONSUMPTION Order Result Record Details
C_QltyCtrlChtCharcsRslts view left_outer CONSUMPTION Quality Control Chart Charcs Rslts
C_QualityMngCharcsRslts view left_outer CONSUMPTION Charcs for Sgl. Rslts
C_QualityMngCharcsSbstRslt view left_outer CONSUMPTION Charcs With Inspection Point for Sgl. Results
C_SFIPlanInspCharResultRec view from CONSUMPTION Result recording details of Single IC
I_InspCharcValidValueAggr view from COMPOSITE Insp. Characteristic Value Aggregate
I_InspCharcValueAggregate view inner COMPOSITE Insp. Characteristic Value Aggregate
I_InspectionResultValidValue view from COMPOSITE Valid Single Value of an Insp Charc Rslt
I_InspectionResultValueTP view from TRANSACTIONAL Inspection Result Single Value
I_InspLotResultValueRsltRecg view_entity from COMPOSITE Result Value Details
I_InspSubsetResultValueTP view from TRANSACTIONAL Single Value of an Inspection Charc Rslt
I_MfgInspCharcHistory view inner COMPOSITE Inspection Characteristic History
I_MfgOrderInspCharcRsltsAggrg view from BASIC Interface View to aggrg rslts for Insp Char
P_Inspcharresultdet_With_Smpl view left_outer COMPOSITE
P_Inspcharresultdet_Wo_Smpl view left_outer COMPOSITE
P_MfgInspCharcInitialInsert view_entity inner COMPOSITE IC Recorded Result Initial Insert values
P_MfgInspCharcResultAll view_entity inner COMPOSITE Insp Charcs Recording Results
P_MfgOrderInspCharcRsltsAggrg view_entity from COMPOSITE Private View to Aggrg rslt for Insp Char
R_InspectionResultValueTP view_entity from TRANSACTIONAL Single Inspection Result - TP

Fields (57)

KeyField CDS FieldsUsed in Views
KEY InspectionCharacteristic InspectionCharacteristic 9
KEY InspectionLot InspectionLot 6
KEY InspectionSubsetInternalID InspectionSubsetInternalID 8
KEY InspPlanOperationInternalID InspPlanOperationInternalID 9
KEY InspResultItemInternalID InspResultItemInternalID 5
KEY InspResultValueInternalID InspResultValueInternalID 13
_CharcAttributeCode _CharcAttributeCode 2
_CharcAttributeCodeGrp _CharcAttributeCodeGrp 2
_InspectionCharacteristic _InspectionCharacteristic 1
_InspectionLot _InspectionLot 1
_InspectionOperation _InspectionOperation 1
_InspectionResultAttribute _InspectionResultAttribute 1
_InspectionValuationResult _InspectionValuationResult 1
_InspSubsetCharacteristic _InspSubsetCharacteristic 1
ChangedTime ChangedTime 1
CharacteristicAttributeCatalog CharacteristicAttributeCatalog 2
CharacteristicAttributeCode CharacteristicAttributeCode 5
CharacteristicAttributeCodeGrp CharacteristicAttributeCodeGrp 14
CharcAttributeCodeVers CharcAttributeCodeVers 2
CreatedByUser CreatedByUser 4
CreationDate CreationDate 5
CreationTime CreationTime 4
DefectClass DefectClass 1
InspectionEndDate InspectionEndDate 2
InspectionEndTime InspectionEndTime 2
InspectionNumberOfDefects InspectionNumberOfDefects 1
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
InspectionResultItem InspectionResultItem 5
InspectionResultMeasuredValue InspectionResultMeasuredValue 6
InspectionResultOriginalValue InspectionResultOriginalValue 4
InspectionResultText InspectionResultText 2
InspectionStartDate InspectionStartDate 2
InspectionStartTime InspectionStartTime 2
InspectionValuationResult InspectionValuationResult 4
Inspector Inspector 2
InspLotSingleUnitNumber InspLotSingleUnitNumber 2
InspResultHasMeasuredValue InspResultHasMeasuredValue 12
InspResultNrOfAddlDcmlsPlaces InspResultNrOfAddlDcmlsPlaces 2
InspRsltFreeDefinedTestEquip InspRsltFreeDefinedTestEquip 3
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1

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.

-- Single Value of an Inspection Charc Rslt
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSPECTIONRESULTVALUE (
    INSPECTIONCHARACTERISTIC,
    INSPECTIONLOT,
    INSPECTIONSUBSETINTERNALID,
    INSPPLANOPERATIONINTERNALID,
    INSPRESULTITEMINTERNALID,
    INSPRESULTVALUEINTERNALID,
    _CHARCATTRIBUTECODE,
    _CHARCATTRIBUTECODEGRP,
    _INSPECTIONCHARACTERISTIC,
    _INSPECTIONLOT,
    _INSPECTIONOPERATION,
    _INSPECTIONRESULTATTRIBUTE,
    _INSPECTIONVALUATIONRESULT,
    _INSPSUBSETCHARACTERISTIC,
    CHANGEDTIME,
    CHARACTERISTICATTRIBUTECATALOG,
    CHARACTERISTICATTRIBUTECODE,
    CHARACTERISTICATTRIBUTECODEGRP,
    CHARCATTRIBUTECODEVERS,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DEFECTCLASS,
    INSPECTIONENDDATE,
    INSPECTIONENDTIME,
    INSPECTIONNUMBEROFDEFECTS,
    INSPECTIONRESULTATTRIBUTE,
    INSPECTIONRESULTCATALOG2,
    INSPECTIONRESULTCATALOG3,
    INSPECTIONRESULTCATALOG4,
    INSPECTIONRESULTCATALOG5,
    INSPECTIONRESULTCODE2,
    INSPECTIONRESULTCODE2VERS,
    INSPECTIONRESULTCODE3,
    INSPECTIONRESULTCODE3VERS,
    INSPECTIONRESULTCODE4,
    INSPECTIONRESULTCODE4VERS,
    INSPECTIONRESULTCODE5,
    INSPECTIONRESULTCODE5VERS,
    INSPECTIONRESULTCODEGROUP2,
    INSPECTIONRESULTCODEGROUP3,
    INSPECTIONRESULTCODEGROUP4,
    INSPECTIONRESULTCODEGROUP5,
    INSPECTIONRESULTITEM,
    INSPECTIONRESULTMEASUREDVALUE,
    INSPECTIONRESULTORIGINALVALUE,
    INSPECTIONRESULTTEXT,
    INSPECTIONSTARTDATE,
    INSPECTIONSTARTTIME,
    INSPECTIONVALUATIONRESULT,
    INSPECTOR,
    INSPLOTSINGLEUNITNUMBER,
    INSPRESULTHASMEASUREDVALUE,
    INSPRESULTNROFADDLDCMLSPLACES,
    INSPRSLTFREEDEFINEDTESTEQUIP,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    PRIMARY KEY (INSPECTIONCHARACTERISTIC, INSPECTIONLOT, INSPECTIONSUBSETINTERNALID, INSPPLANOPERATIONINTERNALID, INSPRESULTITEMINTERNALID, INSPRESULTVALUEINTERNALID)
);

Learn More