A_InspectionOperation

DDL: A_INSPECTIONOPERATION SQL: AINSPOPER Type: view CONSUMPTION
15 Fields 1 Data Sources 2 Associations

Inspection Operations

A_InspectionOperation is a Consumption CDS View that provides data about "Inspection Operations" in SAP S/4HANA. It reads from 1 data source (I_InspectionOperation) and exposes 15 fields with key fields InspectionLot, InspPlanOperationInternalID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InspectionOperation I_InspectionOperation from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_InspectionLot _InspectionLot $projection.InspectionLot = _InspectionLot.InspectionLot
[0..1] A_WorkCenters _WorkCenter $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID and _WorkCenter.WorkCenterTypeCode = 'A'

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName AINSPOPER view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Inspection Operations view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot
KEY InspPlanOperationInternalID InspPlanOperationInternalID Node Number
OrderInternalBillOfOperations OrderInternalBillOfOperations Order Internal Bill of Operations
InspectionOperation InspectionOperation Operation
InspectionOperationPlant InspectionOperationPlant Receiving Plant
BillOfOperationsType BillOfOperationsType Task List Type
BOOOperationInternalID BOOOperationInternalID Task list node
WorkCenterInternalID WorkCenterInternalID Work Center
StatusObject StatusObject Status Object
OperationControlProfile OperationControlProfile Control Key
OperationConfirmation OperationConfirmation Return Agmt
InspectionSubSystem InspectionSubSystem QDR System
OperationText OperationText Description
_InspectionLot _InspectionLot
_WorkCenter _WorkCenter

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 A_InspectionOperation.
-- 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: AINSPOPER

CREATE VIEW A_InspectionOperation AS
SELECT
  InspectionLot,
  InspPlanOperationInternalID,
  OrderInternalBillOfOperations,
  InspectionOperation,
  InspectionOperationPlant,
  BillOfOperationsType,
  BOOOperationInternalID,
  WorkCenterInternalID,
  StatusObject,
  OperationControlProfile,
  OperationConfirmation,
  InspectionSubSystem,
  OperationText
FROM I_InspectionOperation
LEFT OUTER JOIN A_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN A_WorkCenters AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = 'A'  -- association [0..1]
;

Learn More