I_INSPECTIONOPERATION
Inspection Operation
I_INSPECTIONOPERATION is a CDS View in S/4HANA. Inspection Operation. It contains 21 fields. 48 CDS views read from this table.
CDS Views using this table (48)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_InspectionOperation | view_entity | from | CONSUMPTION | Inspection Operations |
| C_Inspectionoperation | view | from | CONSUMPTION | Inspection Lot for Operations |
| C_InspectionResultHistoryValue | view | inner | CONSUMPTION | Inspection Result History value |
| C_InspLotForInspSpecRsltRecg | view_entity | inner | CONSUMPTION | InspSpec Keys with Inspection Lot |
| C_InspLotOpRsltRecg | view_entity | inner | CONSUMPTION | Inspection Lot Operation |
| C_InspLotRsltRec | view | inner | CONSUMPTION | Insp. Points Rslt. Rec.: Inspection Lots |
| C_Inspoperation_Object | view_entity | from | CONSUMPTION | Inspection Lot Operations |
| C_InspOperationHeader | view | from | CONSUMPTION | Header of Inspection Operation |
| C_InspWorkCenterRsltRec | view_entity | from | CONSUMPTION | Inspection Operation |
| C_QltyLvlHistCharcs | view | left_outer | CONSUMPTION | Quality Level History by Characteristics |
| C_Qm_Charsresults | view | inner | CONSUMPTION | Characteristic list of record results |
| C_Qm_Insp_Characteristic | view | left_outer | CONSUMPTION | Inspection Characteristic |
| C_QM_InspCharInfo | view | inner | CONSUMPTION | Characteristic details- More information |
| C_QM_InspectionLotsByOperation | view | inner | CONSUMPTION | Inspection lots for main page - group by operation |
| C_QM_InspectionOperationChars | view | from | CONSUMPTION | Inspection operation with char counts |
| ESH_N_INSPECTIONOPERATION | view | from | Anchor view -INSPECTIONOPERATION | |
| I_DefectCube | view | left_outer | COMPOSITE | Defect Analytics Cube View |
| I_DefectKeyFigCube | view | left_outer | COMPOSITE | Key Figure view for Defect Analytics |
| I_InspCharacteristicAggregate | view | inner | COMPOSITE | Aggregation on inspection characteristic level |
| I_InspCharacteristicTP | view_entity | inner | TRANSACTIONAL | Characteristic in Inspection Lot |
| I_InspCharQuantitativeCube | view | inner | COMPOSITE | Chracteristics Analytics - Quantitative Analysis |
| I_InspectionIssuesByOperation | view_entity | from | COMPOSITE | Inspection Issues By Operation |
| I_InspectionLotValueHelp | view | inner | COMPOSITE | Inspection Lot |
| I_InspectionOperationStatus | view | from | BASIC | Inspection Operation Status |
| I_InspectionOperationStdVH | view_entity | from | COMPOSITE | Inspection Operation |
| I_InspectionResultHistory | view | inner | COMPOSITE | Inspection Result History |
| I_InspectionResultTP | view | inner | TRANSACTIONAL | Summarized Insp Result for an Insp Charc |
| I_InspectionResultValueTP | view_entity | inner | TRANSACTIONAL | Inspection Result Single Value |
| I_InspectionSubsetTP_2 | view | inner | TRANSACTIONAL | Inspection Subset 2 |
| I_InspLotMatlSmplCharcRsltRecg | view_entity | inner | COMPOSITE | Characteristic Details |
| I_InspOperationAggregate | view_entity | from | COMPOSITE | Aggregation on inspection operation lvl |
| I_InspOperMatlSampleAggregate | view | from | COMPOSITE | Aggregation on insp op mat sample level |
| I_InspSampleCharcTP | view | inner | TRANSACTIONAL | Inspection Characteristic for Inspection Point |
| I_InspSampleResultTP | view | inner | TRANSACTIONAL | Inspection Result for Inspection Point |
| I_MfgOrderOpActyInspCharcs | view | inner | COMPOSITE | Inspection Char for OA in MfgOrder |
| I_MfgOrdPlanInspCharInfo | view | inner | COMPOSITE | Order PIC Info |
| I_OpActyPlanInspCharInfo | view | inner | COMPOSITE | Order PIC Info |
| I_SFIPlanInspCharInfo | view | inner | COMPOSITE | SFI Plan Insp Char Info Interface |
| P_HierarchicRsltRecgInspOp | view_entity | from | CONSUMPTION | Inspection operations for QE51n |
| P_Inspcharresultdet_With_Smpl | view | inner | COMPOSITE | Inspection characteristic result details for sample lots |
| P_Inspcharresultdet_Wo_Smpl | view | inner | COMPOSITE | Inspection characteristic result details for no-sample lots |
| P_InspectionOperationHeader | view_entity | from | CONSUMPTION | Header of Inspection Operation |
| P_InspOpAggr | view_entity | left_outer | CONSUMPTION | Inspection Operation Aggregate |
| P_MfgInspCharcHistory | view | inner | COMPOSITE | Inspection Characteristic Action History |
| P_MfgInspOperation | view_entity | from | COMPOSITE | Inspection Issues By Operation |
| P_MfgOrdOpActyPlanInspChar | view | inner | CONSUMPTION | Planned Inspection Characteristics for OA of Order |
| P_Qm_Headerwithoperations | view | left_outer | BASIC | Private CDS - QALS with V_QAPO |
| R_InspectionOperationTP | view_entity | from | TRANSACTIONAL | Inspection Operation - TP |
Fields (21)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InspectionLot | InspectionLot | 8 |
| KEY | InspectionOperation | InspectionOperation,Operation | 14 |
| KEY | InspPlanOperationInternalID | InspPlanOperationInternalID | 13 |
| KEY | OrderInternalBillOfOperations | OrderInternalBillOfOperations | 4 |
| _InspectionCharacteristic | _InspectionCharacteristic | 1 | |
| _InspectionLot | _InspectionLot | 2 | |
| _InspectionOperationStatus | _InspectionOperationStatus | 1 | |
| _InspectionSubset | _InspectionSubset | 1 | |
| _WorkCenter | _WorkCenter | 3 | |
| BOOOperationInternalID | BOOOperationInternalID | 6 | |
| InspectionOperationPlant | InspectionOperationPlant,Plant | 7 | |
| InspectionSubSystem | InspectionSubSystem | 1 | |
| InspSbstCompletionConfirmation | InspSbstCompletionConfirmation | 1 | |
| InspSbstHasNoTimeOrQuantity | InspSbstHasNoTimeOrQuantity | 1 | |
| InspSbstIsTimeRelated | InspSbstIsTimeRelated | 1 | |
| OperationConfirmation | OperationConfirmation | 1 | |
| OperationControlProfile | OperationControlProfile | 1 | |
| OperationText | MfgOrderOperationText,OperationText | 12 | |
| OrderOperationInternalID | OrderOperationInternalID | 1 | |
| Sequence | Sequence | 1 | |
| WorkCenterInternalID | WorkCenterInternalID | 6 |
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 Operation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INSPECTIONOPERATION (
INSPECTIONLOT,
INSPECTIONOPERATION,
INSPPLANOPERATIONINTERNALID,
ORDERINTERNALBILLOFOPERATIONS,
_INSPECTIONCHARACTERISTIC,
_INSPECTIONLOT,
_INSPECTIONOPERATIONSTATUS,
_INSPECTIONSUBSET,
_WORKCENTER,
BOOOPERATIONINTERNALID,
INSPECTIONOPERATIONPLANT,
INSPECTIONSUBSYSTEM,
INSPSBSTCOMPLETIONCONFIRMATION,
INSPSBSTHASNOTIMEORQUANTITY,
INSPSBSTISTIMERELATED,
OPERATIONCONFIRMATION,
OPERATIONCONTROLPROFILE,
OPERATIONTEXT,
ORDEROPERATIONINTERNALID,
SEQUENCE,
WORKCENTERINTERNALID,
PRIMARY KEY (INSPECTIONLOT, INSPECTIONOPERATION, INSPPLANOPERATIONINTERNALID, ORDERINTERNALBILLOFOPERATIONS)
);
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