I_InspectionOperationStatus

DDL: I_INSPECTIONOPERATIONSTATUS SQL: IINSPOPERATIONST Type: view BASIC
8 Fields 4 Data Sources

Inspection Operation Status

I_InspectionOperationStatus (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Manufacturing

I_InspectionOperationStatus is a Basic CDS View that provides data about "Inspection Operation Status" in SAP S/4HANA. It reads from 4 data sources (I_InspectionLot, I_InspectionOperation, I_StatusObjectStatusBasic, tqec30) and exposes 8 fields with key fields OrderInternalBillOfOperations, InspPlanOperationInternalID.

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentQM-IM
CapabilitiesData Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides access to the status of an inspection operation.</p>

Documentation

Data Sources (4)

SourceAliasJoin Type
I_InspectionLot I_InspectionLot inner
I_InspectionOperation I_InspectionOperation from
I_StatusObjectStatusBasic I_StatusObjectStatusBasic left_outer
tqec30 tqec30 left_outer

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IINSPOPERATIONST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Inspection Operation Status view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations I_InspectionOperation OrderInternalBillOfOperations Routing number of operations in the order
KEY InspPlanOperationInternalID I_InspectionOperation InspPlanOperationInternalID Current Node Number from Order Counter
InspectionOpIsCompletionNeeded
MatlQualityAuthorizationGroup Material Authorization Group for Activities in QM
InspectionLotType Inspection Type
Plant Plant
_Plant
_InspectionLotType

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_InspectionOperationStatus.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IINSPOPERATIONST

CREATE VIEW I_InspectionOperationStatus AS
SELECT
  I_InspectionOperation.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  I_InspectionOperation.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  max(tqec30.oper_completion) AS InspectionOpIsCompletionNeeded,
  I_InspectionOperation._InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  I_InspectionOperation._InspectionLot.InspectionLotType AS InspectionLotType,
  I_InspectionOperation._InspectionLot.Plant AS Plant,
  I_InspectionOperation._InspectionLot._Plant AS _Plant,
  I_InspectionOperation._InspectionLot._InspectionLotType AS _InspectionLotType
FROM I_InspectionOperation
INNER JOIN I_InspectionLot ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_StatusObjectStatusBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tqec30 ON /* join condition not captured in parsed metadata */
;

Learn More