I_INSPECTIONRESULTVALUETP

CDS View
50 Fields 1 CDS Views

Inspection Result Single Value

I_INSPECTIONRESULTVALUETP is a CDS View in S/4HANA. Inspection Result Single Value. It contains 50 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_InspectionResultValue view from COMPOSITE Single Inspection Results

Fields (50)

KeyField CDS FieldsUsed in Views
KEY InspectionCharacteristic InspectionCharacteristic 1
KEY InspectionLot InspectionLot 1
KEY InspPlanOperationInternalID InspPlanOperationInternalID 1
KEY InspResultValueInternalID InspResultValueInternalID 1
ChangedDateTime ChangedDateTime 1
ChangedTime ChangedTime 1
CharacteristicAttributeCatalog CharacteristicAttributeCatalog 1
CharacteristicAttributeCode CharacteristicAttributeCode 1
CharacteristicAttributeCodeGrp CharacteristicAttributeCodeGrp 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CreationTime CreationTime 1
DefectClass DefectClass 1
InspectionEndDate InspectionEndDate 1
InspectionEndTime InspectionEndTime 1
InspectionLotType InspectionLotType 1
InspectionNumberOfDefects InspectionNumberOfDefects 1
InspectionResultAttribute InspectionResultAttribute 1
InspectionResultCatalog2 InspectionResultCatalog2 1
InspectionResultCatalog3 InspectionResultCatalog3 1
InspectionResultCatalog4 InspectionResultCatalog4 1
InspectionResultCatalog5 InspectionResultCatalog5 1
InspectionResultCode2 InspectionResultCode2 1
InspectionResultCode3 InspectionResultCode3 1
InspectionResultCode4 InspectionResultCode4 1
InspectionResultCode5 InspectionResultCode5 1
InspectionResultCodeGroup2 InspectionResultCodeGroup2 1
InspectionResultCodeGroup3 InspectionResultCodeGroup3 1
InspectionResultCodeGroup4 InspectionResultCodeGroup4 1
InspectionResultCodeGroup5 InspectionResultCodeGroup5 1
InspectionResultItem InspectionResultItem 1
InspectionResultMeasuredValue InspectionResultMeasuredValue 1
InspectionResultOriginalValue InspectionResultOriginalValue 1
InspectionResultText InspectionResultText 1
InspectionStartDate InspectionStartDate 1
InspectionStartTime InspectionStartTime 1
InspectionSubsetInternalID InspectionSubsetInternalID 1
InspectionValuationResult InspectionValuationResult 1
Inspector Inspector 1
InspLotSingleUnitNumber InspLotSingleUnitNumber 1
InspResultFrmtdMeasuredValue InspResultFrmtdMeasuredValue 1
InspResultHasMeasuredValue InspResultHasMeasuredValue 1
InspResultItemInternalID InspResultItemInternalID 1
InspRsltFreeDefinedTestEquip InspRsltFreeDefinedTestEquip 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
MatlQualityAuthorizationGroup MatlQualityAuthorizationGroup 1
Plant Plant 1
WorkCenter WorkCenter 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.

-- Inspection Result Single Value
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSPECTIONRESULTVALUETP (
    INSPECTIONCHARACTERISTIC,
    INSPECTIONLOT,
    INSPPLANOPERATIONINTERNALID,
    INSPRESULTVALUEINTERNALID,
    CHANGEDDATETIME,
    CHANGEDTIME,
    CHARACTERISTICATTRIBUTECATALOG,
    CHARACTERISTICATTRIBUTECODE,
    CHARACTERISTICATTRIBUTECODEGRP,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DEFECTCLASS,
    INSPECTIONENDDATE,
    INSPECTIONENDTIME,
    INSPECTIONLOTTYPE,
    INSPECTIONNUMBEROFDEFECTS,
    INSPECTIONRESULTATTRIBUTE,
    INSPECTIONRESULTCATALOG2,
    INSPECTIONRESULTCATALOG3,
    INSPECTIONRESULTCATALOG4,
    INSPECTIONRESULTCATALOG5,
    INSPECTIONRESULTCODE2,
    INSPECTIONRESULTCODE3,
    INSPECTIONRESULTCODE4,
    INSPECTIONRESULTCODE5,
    INSPECTIONRESULTCODEGROUP2,
    INSPECTIONRESULTCODEGROUP3,
    INSPECTIONRESULTCODEGROUP4,
    INSPECTIONRESULTCODEGROUP5,
    INSPECTIONRESULTITEM,
    INSPECTIONRESULTMEASUREDVALUE,
    INSPECTIONRESULTORIGINALVALUE,
    INSPECTIONRESULTTEXT,
    INSPECTIONSTARTDATE,
    INSPECTIONSTARTTIME,
    INSPECTIONSUBSETINTERNALID,
    INSPECTIONVALUATIONRESULT,
    INSPECTOR,
    INSPLOTSINGLEUNITNUMBER,
    INSPRESULTFRMTDMEASUREDVALUE,
    INSPRESULTHASMEASUREDVALUE,
    INSPRESULTITEMINTERNALID,
    INSPRSLTFREEDEFINEDTESTEQUIP,
    ISBUSINESSPURPOSECOMPLETED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    MATLQUALITYAUTHORIZATIONGROUP,
    PLANT,
    WORKCENTER,
    PRIMARY KEY (INSPECTIONCHARACTERISTIC, INSPECTIONLOT, INSPPLANOPERATIONINTERNALID, INSPRESULTVALUEINTERNALID)
);

Learn More