I_INSPSUBSETCHARCRESULTTP
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_InspSubsetCharcResult | view | from | CONSUMPTION | IPRR: Inspection Point Results |
| P_InspSubsetCharcAggregate | view_entity | from | CONSUMPTION | Progress of Characteristics |
Fields (56)
| Key | Field | CDS Fields | Used 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)
);
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