I_INSPECTIONCHARACTERISTICFACT
Inspection Characteristic Fact
I_INSPECTIONCHARACTERISTICFACT is a CDS View in S/4HANA. Inspection Characteristic Fact. It contains 28 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InspectionCharacteristicCube | view | from | COMPOSITE | Inspection Characteristic Cube |
Fields (28)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InspectionCharacteristic | InspectionCharacteristic | 1 |
| KEY | InspectionLot | InspectionLot | 1 |
| KEY | InspectionSubsetInternalID | InspectionSubsetInternalID | 1 |
| KEY | InspPlanOperationInternalID | InspPlanOperationInternalID | 1 |
| BillOfOperationsChangeStateID | BillOfOperationsChangeStateID | 1 | |
| BillOfOperationsGroup | BillOfOperationsGroup | 1 | |
| BillOfOperationsType | BillOfOperationsType | 1 | |
| BillOfOperationsUsage | BillOfOperationsUsage | 1 | |
| BillOfOperationsVariant | BillOfOperationsVariant | 1 | |
| Customer | Customer | 1 | |
| InspCharcAcceptedSampleCount | InspCharcAcceptedSampleCount | 1 | |
| InspCharOpenSampleCount | InspCharOpenSampleCount | 1 | |
| InspCharRejectedSampleCount | InspCharRejectedSampleCount | 1 | |
| InspectionLotType | InspectionLotType | 1 | |
| InspectionOperation | InspectionOperation | 1 | |
| InspectionResultMaximumValue | InspectionResultMaximumValue | 1 | |
| InspectionResultMeanValueSum | InspectionResultMeanValueSum | 1 | |
| InspectionResultMinimumValue | InspectionResultMinimumValue | 1 | |
| InspectionSpecification | InspectionSpecification | 1 | |
| InspectionSpecificationPlant | InspectionSpecificationPlant | 1 | |
| InspectionSpecificationUnit | InspectionSpecificationUnit | 1 | |
| InspectionSpecificationVersion | InspectionSpecificationVersion | 1 | |
| InspResultValidValuesNumber | InspResultValidValuesNumber | 1 | |
| InspRsltNonconformingValsNmbr | InspRsltNonconformingValsNmbr | 1 | |
| Material | Material | 1 | |
| MatlQualityAuthorizationGroup | MatlQualityAuthorizationGroup | 1 | |
| Plant | Plant | 1 | |
| Supplier | Supplier | 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.
-- Inspection Characteristic Fact
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSPECTIONCHARACTERISTICFACT (
INSPECTIONCHARACTERISTIC,
INSPECTIONLOT,
INSPECTIONSUBSETINTERNALID,
INSPPLANOPERATIONINTERNALID,
BILLOFOPERATIONSCHANGESTATEID,
BILLOFOPERATIONSGROUP,
BILLOFOPERATIONSTYPE,
BILLOFOPERATIONSUSAGE,
BILLOFOPERATIONSVARIANT,
CUSTOMER,
INSPCHARCACCEPTEDSAMPLECOUNT,
INSPCHAROPENSAMPLECOUNT,
INSPCHARREJECTEDSAMPLECOUNT,
INSPECTIONLOTTYPE,
INSPECTIONOPERATION,
INSPECTIONRESULTMAXIMUMVALUE,
INSPECTIONRESULTMEANVALUESUM,
INSPECTIONRESULTMINIMUMVALUE,
INSPECTIONSPECIFICATION,
INSPECTIONSPECIFICATIONPLANT,
INSPECTIONSPECIFICATIONUNIT,
INSPECTIONSPECIFICATIONVERSION,
INSPRESULTVALIDVALUESNUMBER,
INSPRSLTNONCONFORMINGVALSNMBR,
MATERIAL,
MATLQUALITYAUTHORIZATIONGROUP,
PLANT,
SUPPLIER,
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