I_INSPECTIONOPERATION

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);