INSPSAMPLERESULT

INSPSAMPLERESULT is an SAP database table in S/4HANA. It contains 22 fields.

Fields (22)

KeyField CDS FieldsUsed in Views
CharacteristicAttributeCode CharacteristicAttributeCode 1
CharacteristicAttributeCodeGrp CharacteristicAttributeCodeGrp 2
CreatedByUser CreatedByUser 1
InspectionResultAttribute InspectionResultAttribute 2
InspectionResultHasLongText InspectionResultHasLongText 2
InspectionResultHasMeanValue InspectionResultHasMeanValue 2
InspectionResultMeanValue InspectionResultMeanValue 2
InspectionResultOriginalValue InspectionResultOriginalValue 2
InspectionResultStatus InspectionResultStatus 1
InspectionResultText InspectionResultText 2
InspectionValuationResult InspectionValuationResult 2
Inspector Inspector 1
InspResultNrOfAddlDcmlsPlaces InspResultNrOfAddlDcmlsPlaces 2
InspResultValidValuesNumber InspResultValidValuesNumber 2
InspResultVariance InspResultVariance 1
InspRsltAboveToleranceFraction InspRsltAboveToleranceFraction 1
InspRsltAboveToleranceValsNmbr InspRsltAboveToleranceValsNmbr 2
InspRsltBelowToleranceFraction InspRsltBelowToleranceFraction 1
InspRsltBelowToleranceValsNmbr InspRsltBelowToleranceValsNmbr 2
InspRsltFreeDefinedTestEquip InspRsltFreeDefinedTestEquip 1
InspRsltNonconformingValsNmbr InspRsltNonconformingValsNmbr 2
LastChangedByUser LastChangedByUser 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE INSPSAMPLERESULT (
    CHARACTERISTICATTRIBUTECODE,
    CHARACTERISTICATTRIBUTECODEGRP,
    CREATEDBYUSER,
    INSPECTIONRESULTATTRIBUTE,
    INSPECTIONRESULTHASLONGTEXT,
    INSPECTIONRESULTHASMEANVALUE,
    INSPECTIONRESULTMEANVALUE,
    INSPECTIONRESULTORIGINALVALUE,
    INSPECTIONRESULTSTATUS,
    INSPECTIONRESULTTEXT,
    INSPECTIONVALUATIONRESULT,
    INSPECTOR,
    INSPRESULTNROFADDLDCMLSPLACES,
    INSPRESULTVALIDVALUESNUMBER,
    INSPRESULTVARIANCE,
    INSPRSLTABOVETOLERANCEFRACTION,
    INSPRSLTABOVETOLERANCEVALSNMBR,
    INSPRSLTBELOWTOLERANCEFRACTION,
    INSPRSLTBELOWTOLERANCEVALSNMBR,
    INSPRSLTFREEDEFINEDTESTEQUIP,
    INSPRSLTNONCONFORMINGVALSNMBR,
    LASTCHANGEDBYUSER
);