INSPSUBSETRESULT

42 Fields

INSPSUBSETRESULT is an SAP database table in S/4HANA. It contains 42 fields.

Fields (42)

KeyField CDS FieldsUsed in Views
_InspectionValuationResult _InspectionValuationResult 1
ChangedDateTime ChangedDateTime 1
CharacteristicAttributeCatalog CharacteristicAttributeCatalog 1
CharacteristicAttributeCode CharacteristicAttributeCode 1
CharacteristicAttributeCodeGrp CharacteristicAttributeCodeGrp 1
CreatedByUser CreatedByUser 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
InspectionResultHasLongText InspectionResultHasLongText 1
InspectionResultHasMeanValue InspectionResultHasMeanValue 1
InspectionResultMaximumValue InspectionResultMaximumValue 1
InspectionResultMeanValue InspectionResultMeanValue 2
InspectionResultMinimumValue InspectionResultMinimumValue 1
InspectionResultOrigin InspectionResultOrigin 1
InspectionResultOriginalValue InspectionResultOriginalValue 2
InspectionResultStatus InspectionResultStatus 1
InspectionResultText InspectionResultText 2
InspectionValuationResult InspectionValuationResult 2
Inspector Inspector 1
InspResultHasMaximumValue InspResultHasMaximumValue 1
InspResultHasMinimumValue InspResultHasMinimumValue 1
InspResultValidValuesNumber InspResultValidValuesNumber 2
InspResultVariance InspResultVariance 1
InspRsltAboveToleranceFraction InspRsltAboveToleranceFraction 1
InspRsltAboveToleranceValsNmbr InspRsltAboveToleranceValsNmbr 2
InspRsltBelowToleranceFraction InspRsltBelowToleranceFraction 1
InspRsltBelowToleranceValsNmbr InspRsltBelowToleranceValsNmbr 2
InspRsltFreeDefinedTestEquip InspRsltFreeDefinedTestEquip 2
InspRsltNonconformingValsNmbr InspRsltNonconformingValsNmbr 2
Language Language 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE INSPSUBSETRESULT (
    _INSPECTIONVALUATIONRESULT,
    CHANGEDDATETIME,
    CHARACTERISTICATTRIBUTECATALOG,
    CHARACTERISTICATTRIBUTECODE,
    CHARACTERISTICATTRIBUTECODEGRP,
    CREATEDBYUSER,
    INSPECTIONRESULTATTRIBUTE,
    INSPECTIONRESULTCATALOG2,
    INSPECTIONRESULTCATALOG3,
    INSPECTIONRESULTCATALOG4,
    INSPECTIONRESULTCATALOG5,
    INSPECTIONRESULTCODE2,
    INSPECTIONRESULTCODE3,
    INSPECTIONRESULTCODE4,
    INSPECTIONRESULTCODE5,
    INSPECTIONRESULTCODEGROUP2,
    INSPECTIONRESULTCODEGROUP3,
    INSPECTIONRESULTCODEGROUP4,
    INSPECTIONRESULTCODEGROUP5,
    INSPECTIONRESULTHASLONGTEXT,
    INSPECTIONRESULTHASMEANVALUE,
    INSPECTIONRESULTMAXIMUMVALUE,
    INSPECTIONRESULTMEANVALUE,
    INSPECTIONRESULTMINIMUMVALUE,
    INSPECTIONRESULTORIGIN,
    INSPECTIONRESULTORIGINALVALUE,
    INSPECTIONRESULTSTATUS,
    INSPECTIONRESULTTEXT,
    INSPECTIONVALUATIONRESULT,
    INSPECTOR,
    INSPRESULTHASMAXIMUMVALUE,
    INSPRESULTHASMINIMUMVALUE,
    INSPRESULTVALIDVALUESNUMBER,
    INSPRESULTVARIANCE,
    INSPRSLTABOVETOLERANCEFRACTION,
    INSPRSLTABOVETOLERANCEVALSNMBR,
    INSPRSLTBELOWTOLERANCEFRACTION,
    INSPRSLTBELOWTOLERANCEVALSNMBR,
    INSPRSLTFREEDEFINEDTESTEQUIP,
    INSPRSLTNONCONFORMINGVALSNMBR,
    LANGUAGE,
    LASTCHANGEDBYUSER
);

Learn More