I_INSPSUBSETCHARCRESULTTP

CDS View

Insp Charc & Summ. Values for Insp Point

I_INSPSUBSETCHARCRESULTTP is a CDS View in S/4HANA. Insp Charc & Summ. Values for Insp Point. It contains 56 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_InspSubsetCharcResult view from CONSUMPTION IPRR: Inspection Point Results
P_InspSubsetCharcAggregate view_entity from CONSUMPTION Progress of Characteristics

Fields (56)

KeyField CDS FieldsUsed in Views
KEY InspectionCharacteristic InspectionCharacteristic 1
KEY InspectionLot InspectionLot 2
KEY InspectionSubsetInternalID InspectionSubsetInternalID 2
KEY InspPlanOperationInternalID InspPlanOperationInternalID 2
ChangedDateTime ChangedDateTime 1
CharacteristicAttributeCatalog CharacteristicAttributeCatalog 1
CharacteristicAttributeCode CharacteristicAttributeCode 1
CharacteristicAttributeCodeGrp CharacteristicAttributeCodeGrp 1
CreatedByUser CreatedByUser 1
InspectionCharacteristicStatus InspectionCharacteristicStatus 1
InspectionOperation InspectionOperation 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 1
InspectionResultMinimumValue InspectionResultMinimumValue 1
InspectionResultOrigin InspectionResultOrigin 1
InspectionResultOriginalValue InspectionResultOriginalValue 1
InspectionResultStatus InspectionResultStatus 1
InspectionResultText InspectionResultText 1
InspectionSampleSize InspectionSampleSize 1
InspectionSeverity InspectionSeverity 1
InspectionValuationResult InspectionValuationResult 1
Inspector Inspector 1
InspLotDynRuleStage InspLotDynRuleStage 1
InspResultHasMaximumValue InspResultHasMaximumValue 1
InspResultHasMinimumValue InspResultHasMinimumValue 1
InspResultValidValuesNumber InspResultValidValuesNumber 1
InspResultVariance InspResultVariance 1
InspRsltAboveToleranceFraction InspRsltAboveToleranceFraction 1
InspRsltAboveToleranceValsNmbr InspRsltAboveToleranceValsNmbr 1
InspRsltBelowToleranceFraction InspRsltBelowToleranceFraction 1
InspRsltBelowToleranceValsNmbr InspRsltBelowToleranceValsNmbr 1
InspRsltFreeDefinedTestEquip InspRsltFreeDefinedTestEquip 1
InspRsltNonconformingValsNmbr InspRsltNonconformingValsNmbr 1
InspSampleAcceptanceNumber InspSampleAcceptanceNumber 1
InspSampleRejectionNumber InspSampleRejectionNumber 1
InspSampleValuationRule InspSampleValuationRule 1
InspSpecAddlDecimalPlaces InspSpecAddlDecimalPlaces 1
InspSpecSummarizedDcmlPlaces InspSpecSummarizedDcmlPlaces 1
Language Language 1
LastChangedByUser LastChangedByUser 1
QualityControlChart QualityControlChart 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.

-- Insp Charc & Summ. Values for Insp Point
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSPSUBSETCHARCRESULTTP (
    INSPECTIONCHARACTERISTIC,
    INSPECTIONLOT,
    INSPECTIONSUBSETINTERNALID,
    INSPPLANOPERATIONINTERNALID,
    CHANGEDDATETIME,
    CHARACTERISTICATTRIBUTECATALOG,
    CHARACTERISTICATTRIBUTECODE,
    CHARACTERISTICATTRIBUTECODEGRP,
    CREATEDBYUSER,
    INSPECTIONCHARACTERISTICSTATUS,
    INSPECTIONOPERATION,
    INSPECTIONRESULTATTRIBUTE,
    INSPECTIONRESULTCATALOG2,
    INSPECTIONRESULTCATALOG3,
    INSPECTIONRESULTCATALOG4,
    INSPECTIONRESULTCATALOG5,
    INSPECTIONRESULTCODE2,
    INSPECTIONRESULTCODE3,
    INSPECTIONRESULTCODE4,
    INSPECTIONRESULTCODE5,
    INSPECTIONRESULTCODEGROUP2,
    INSPECTIONRESULTCODEGROUP3,
    INSPECTIONRESULTCODEGROUP4,
    INSPECTIONRESULTCODEGROUP5,
    INSPECTIONRESULTHASLONGTEXT,
    INSPECTIONRESULTHASMEANVALUE,
    INSPECTIONRESULTMAXIMUMVALUE,
    INSPECTIONRESULTMEANVALUE,
    INSPECTIONRESULTMINIMUMVALUE,
    INSPECTIONRESULTORIGIN,
    INSPECTIONRESULTORIGINALVALUE,
    INSPECTIONRESULTSTATUS,
    INSPECTIONRESULTTEXT,
    INSPECTIONSAMPLESIZE,
    INSPECTIONSEVERITY,
    INSPECTIONVALUATIONRESULT,
    INSPECTOR,
    INSPLOTDYNRULESTAGE,
    INSPRESULTHASMAXIMUMVALUE,
    INSPRESULTHASMINIMUMVALUE,
    INSPRESULTVALIDVALUESNUMBER,
    INSPRESULTVARIANCE,
    INSPRSLTABOVETOLERANCEFRACTION,
    INSPRSLTABOVETOLERANCEVALSNMBR,
    INSPRSLTBELOWTOLERANCEFRACTION,
    INSPRSLTBELOWTOLERANCEVALSNMBR,
    INSPRSLTFREEDEFINEDTESTEQUIP,
    INSPRSLTNONCONFORMINGVALSNMBR,
    INSPSAMPLEACCEPTANCENUMBER,
    INSPSAMPLEREJECTIONNUMBER,
    INSPSAMPLEVALUATIONRULE,
    INSPSPECADDLDECIMALPLACES,
    INSPSPECSUMMARIZEDDCMLPLACES,
    LANGUAGE,
    LASTCHANGEDBYUSER,
    QUALITYCONTROLCHART,
    PRIMARY KEY (INSPECTIONCHARACTERISTIC, INSPECTIONLOT, INSPECTIONSUBSETINTERNALID, INSPPLANOPERATIONINTERNALID)
);