C_Inspoperation_Object

DDL: C_INSPOPERATION_OBJECT SQL: CINSPOPERAOBJECT Type: view CONSUMPTION
20 Fields 1 Data Sources

Inspection Lot Operations

C_Inspoperation_Object is a Consumption CDS View that provides data about "Inspection Lot Operations" in SAP S/4HANA. It reads from 1 data source (I_InspectionOperation) and exposes 20 fields with key fields InspectionOperation, InspectionLot.

Data Sources (1)

SourceAliasJoin Type
I_InspectionOperation _Operation from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CINSPOPERAOBJECT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
EndUserText.label Inspection Lot Operations view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY InspectionOperation I_InspectionOperation InspectionOperation Operation
KEY InspectionLot I_InspectionOperation InspectionLot Inspection Lot
OrderInternalBillOfOperations I_InspectionOperation OrderInternalBillOfOperations Order Internal Bill of Operations
InspPlanOperationInternalID I_InspectionOperation InspPlanOperationInternalID Node Number
WorkCenter
OperationText I_InspectionOperation OperationText Description
WorkCenterText
InspCharOpenCount _InspOperationAggregate InspCharOpenCount
InspCharAcceptedCount _InspOperationAggregate InspCharAcceptedCount
InspCharRejectedCount _InspOperationAggregate InspCharRejectedCount
InspCharcAcceptedSampleCount _InspOperationAggregate InspCharcAcceptedSampleCount
InspCharOpenSampleCount _InspOperationAggregate InspCharOpenSampleCount
InspCharRejectedSampleCount _InspOperationAggregate InspCharRejectedSampleCount
MaterialSampleCount _InspOperationAggregate MaterialSampleCount
InspSubsetCharcAcceptedCount _InspOperationAggregate InspSubsetCharcAcceptedCount
InspSubsetCharcRejectedCount _InspOperationAggregate InspSubsetCharcRejectedCount
InspSubsetCharcOpenCount _InspOperationAggregate InspSubsetCharcOpenCount
InspectionOperationPlant I_InspectionOperation InspectionOperationPlant Receiving Plant
InspectionLotType
MatlQualityAuthorizationGroup

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 C_Inspoperation_Object.
-- 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: CINSPOPERAOBJECT

CREATE VIEW C_Inspoperation_Object AS
SELECT
  _Operation.InspectionOperation AS InspectionOperation,
  _Operation.InspectionLot AS InspectionLot,
  _Operation.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  _Operation.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _Operation._WorkCenter.WorkCenter AS WorkCenter,
  _Operation.OperationText AS OperationText,
  _Operation._WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterText,
  _InspOperationAggregate.InspCharOpenCount AS InspCharOpenCount,
  _InspOperationAggregate.InspCharAcceptedCount AS InspCharAcceptedCount,
  _InspOperationAggregate.InspCharRejectedCount AS InspCharRejectedCount,
  _InspOperationAggregate.InspCharcAcceptedSampleCount AS InspCharcAcceptedSampleCount,
  _InspOperationAggregate.InspCharOpenSampleCount AS InspCharOpenSampleCount,
  _InspOperationAggregate.InspCharRejectedSampleCount AS InspCharRejectedSampleCount,
  _InspOperationAggregate.MaterialSampleCount AS MaterialSampleCount,
  _InspOperationAggregate.InspSubsetCharcAcceptedCount AS InspSubsetCharcAcceptedCount,
  _InspOperationAggregate.InspSubsetCharcRejectedCount AS InspSubsetCharcRejectedCount,
  _InspOperationAggregate.InspSubsetCharcOpenCount AS InspSubsetCharcOpenCount,
  _Operation.InspectionOperationPlant AS InspectionOperationPlant,
  _Operation._InspectionLot.InspectionLotType AS InspectionLotType,
  _Operation._InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup
FROM I_InspectionOperation AS _Operation
;

Learn More