I_INSPSUBSETRESULT
Insp Result for an Inspection Point
I_INSPSUBSETRESULT is a CDS View in S/4HANA. Insp Result for an Inspection Point. It contains 62 fields. 11 CDS views read from this table.
CDS Views using this table (11)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_QM_InspCharInfo | view | left_outer | CONSUMPTION | Characteristic details- More information |
| I_InspCharacteristicAggregate | view | left_outer | COMPOSITE | Aggregation on inspection characteristic level |
| I_InspectionCharacteristicFact | view | left_outer | COMPOSITE | Inspection Characteristic Fact |
| I_InspSampleResultTP | view | from | TRANSACTIONAL | Inspection Result for Inspection Point |
| I_MfgInspCharcHistory | view | inner | COMPOSITE | Inspection Characteristic History |
| I_MfgOrdInspPointRsltAggrg | view | from | BASIC | Interface view for char aggrg rslts on Insp Pt |
| I_MfgOrdPlanInspCharInfo | view | left_outer | COMPOSITE | Order PIC Info |
| P_Inspcharresultdet_With_Smpl | view | inner | COMPOSITE | |
| P_InspectionPartialSampleSize | view | from | COMPOSITE | |
| P_InspMatlSmplCharAggregate | view | left_outer | COMPOSITE | |
| P_MfgInspCharcResultAll | view_entity | inner | COMPOSITE | Insp Charcs Recording Results |
Fields (62)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InspectionCharacteristic | InspectionCharacteristic | 5 |
| KEY | InspectionLot | InspectionLot | 3 |
| KEY | InspectionSubsetInternalID | InspectionSubsetInternalID | 4 |
| KEY | InspPlanOperationInternalID | InspPlanOperationInternalID | 4 |
| ChangedTime | ChangedTime | 1 | |
| CharacteristicAttributeCatalog | CharacteristicAttributeCatalog | 1 | |
| CharacteristicAttributeCode | CharacteristicAttributeCode | 3 | |
| CharacteristicAttributeCodeGrp | CharacteristicAttributeCodeGrp | 3 | |
| CharcAttributeCodeVers | CharcAttributeCodeVers | 1 | |
| CreatedByUser | CreatedByUser | 3 | |
| CreationDate | CreationDate | 3 | |
| CreationTime | CreationTime | 3 | |
| DefectClass | DefectClass | 1 | |
| InspectionEndDate | InspectionEndDate | 1 | |
| InspectionEndTime | InspectionEndTime | 1 | |
| InspectionNumberOfDefects | InspectionNumberOfDefects | 1 | |
| InspectionResultAttribute | InspectionResultAttribute | 1 | |
| InspectionResultCatalog2 | InspectionResultCatalog2 | 1 | |
| InspectionResultCatalog3 | InspectionResultCatalog3 | 1 | |
| InspectionResultCatalog4 | InspectionResultCatalog4 | 1 | |
| InspectionResultCatalog5 | InspectionResultCatalog5 | 1 | |
| InspectionResultCode2 | InspectionResultCode2 | 1 | |
| InspectionResultCode2Vers | InspectionResultCode2Vers | 1 | |
| InspectionResultCode3 | InspectionResultCode3 | 1 | |
| InspectionResultCode3Vers | InspectionResultCode3Vers | 1 | |
| InspectionResultCode4 | InspectionResultCode4 | 1 | |
| InspectionResultCode4Vers | InspectionResultCode4Vers | 1 | |
| InspectionResultCode5 | InspectionResultCode5 | 1 | |
| InspectionResultCode5Vers | InspectionResultCode5Vers | 1 | |
| InspectionResultCodeGroup2 | InspectionResultCodeGroup2 | 1 | |
| InspectionResultCodeGroup3 | InspectionResultCodeGroup3 | 1 | |
| InspectionResultCodeGroup4 | InspectionResultCodeGroup4 | 1 | |
| InspectionResultCodeGroup5 | InspectionResultCodeGroup5 | 1 | |
| InspectionResultHasLongText | InspectionResultHasLongText | 1 | |
| InspectionResultHasMeanValue | InspectionResultHasMeanValue | 1 | |
| InspectionResultMaximumValue | InspectionResultMaximumValue | 1 | |
| InspectionResultMeanValue | InspectionResultMeanValue | 3 | |
| InspectionResultMinimumValue | InspectionResultMinimumValue | 1 | |
| InspectionResultOrigin | InspectionResultOrigin | 1 | |
| InspectionResultOriginalValue | InspectionResultOriginalValue | 1 | |
| InspectionResultStatus | InspectionResultStatus | 1 | |
| InspectionResultText | InspectionResultText | 2 | |
| InspectionStartDate | InspectionStartDate | 1 | |
| InspectionStartTime | InspectionStartTime | 1 | |
| InspectionValuationResult | InspectionValuationResult | 3 | |
| Inspector | Inspector | 2 | |
| InspResultDynModifValuation | InspResultDynModifValuation | 1 | |
| InspResultHasMaximumValue | InspResultHasMaximumValue | 1 | |
| InspResultHasMinimumValue | InspResultHasMinimumValue | 1 | |
| InspResultNmbrOfRecordedRslts | InspResultNmbrOfRecordedRslts | 1 | |
| InspResultNrOfAddlDcmlsPlaces | InspResultNrOfAddlDcmlsPlaces | 1 | |
| InspResultValidValuesNumber | InspResultValidValuesNumber | 3 | |
| InspResultVariance | InspResultVariance | 1 | |
| InspRsltAboveToleranceFraction | InspRsltAboveToleranceFraction | 1 | |
| InspRsltAboveToleranceValsNmbr | InspRsltAboveToleranceValsNmbr | 1 | |
| InspRsltBelowToleranceFraction | InspRsltBelowToleranceFraction | 1 | |
| InspRsltBelowToleranceValsNmbr | InspRsltBelowToleranceValsNmbr | 1 | |
| InspRsltFreeDefinedTestEquip | InspRsltFreeDefinedTestEquip | 1 | |
| InspRsltNonconformingValsNmbr | InspRsltNonconformingValsNmbr | 1 | |
| Language | Language | 1 | |
| 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.
-- Insp Result for an Inspection Point
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSPSUBSETRESULT (
INSPECTIONCHARACTERISTIC,
INSPECTIONLOT,
INSPECTIONSUBSETINTERNALID,
INSPPLANOPERATIONINTERNALID,
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,
INSPECTIONRESULTHASLONGTEXT,
INSPECTIONRESULTHASMEANVALUE,
INSPECTIONRESULTMAXIMUMVALUE,
INSPECTIONRESULTMEANVALUE,
INSPECTIONRESULTMINIMUMVALUE,
INSPECTIONRESULTORIGIN,
INSPECTIONRESULTORIGINALVALUE,
INSPECTIONRESULTSTATUS,
INSPECTIONRESULTTEXT,
INSPECTIONSTARTDATE,
INSPECTIONSTARTTIME,
INSPECTIONVALUATIONRESULT,
INSPECTOR,
INSPRESULTDYNMODIFVALUATION,
INSPRESULTHASMAXIMUMVALUE,
INSPRESULTHASMINIMUMVALUE,
INSPRESULTNMBROFRECORDEDRSLTS,
INSPRESULTNROFADDLDCMLSPLACES,
INSPRESULTVALIDVALUESNUMBER,
INSPRESULTVARIANCE,
INSPRSLTABOVETOLERANCEFRACTION,
INSPRSLTABOVETOLERANCEVALSNMBR,
INSPRSLTBELOWTOLERANCEFRACTION,
INSPRSLTBELOWTOLERANCEVALSNMBR,
INSPRSLTFREEDEFINEDTESTEQUIP,
INSPRSLTNONCONFORMINGVALSNMBR,
LANGUAGE,
LASTCHANGEDATE,
LASTCHANGEDBYUSER,
PRIMARY KEY (INSPECTIONCHARACTERISTIC, INSPECTIONLOT, INSPECTIONSUBSETINTERNALID, INSPPLANOPERATIONINTERNALID)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA