C_Inspectionoperation

DDL: C_INSPECTIONOPERATION SQL: CMPEINSPOPR Type: view CONSUMPTION
23 Fields 1 Data Sources 2 Associations

Inspection Lot for Operations

C_Inspectionoperation is a Consumption CDS View that provides data about "Inspection Lot for Operations" in SAP S/4HANA. It reads from 1 data source (I_InspectionOperation) and exposes 23 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] P_InspectionOperationHeader _InspOpHeader $projection.InspectionLot = _InspOpHeader.InspectionLot and $projection.InspPlanOperationInternalID = _InspOpHeader.InspPlanOperationInternalID
[1..1] P_MPEOrdILOperOpenCharcCount _InspOpenCharCount $projection.InspectionLot = _InspOpenCharCount.InspectionLot and $projection.InspPlanOperationInternalID = _InspOpenCharCount.InspPlanOperationInternalID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CMPEINSPOPR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Inspection Lot for Operations view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value InspectionLot view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value InspectionOperation view
UI.headerInfo.typeName Operation Inspection Lot view
UI.headerInfo.typeNamePlural Operation Inspection Lots view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot
KEY InspPlanOperationInternalID InspPlanOperationInternalID Node Number
InspectionOperation InspectionOperation Operation
OperationText OperationText Description
InspectionLotText _InspectionLot InspectionLotText
ManufacturingOrder _InspectionLot ManufacturingOrder Order
InspectionLotQuantity _InspectionLot InspectionLotQuantity
InspectionLotActualQuantity _InspectionLot InspectionLotActualQuantity
InspectionLotQuantityUnit _InspectionLot InspectionLotQuantityUnit
InspectionLotType _InspectionLot InspectionLotType Inspection Type
InspectionLotTypeText
InspOpHasCharc _InspOpHeader InspOpHasCharc
InspCharOpenCount _InspOpenCharCount InspCharOpenCount
InspCharAcceptedCount _InspOpHeader InspCharAcceptedCount
InspCharRejectedCount _InspOpHeader InspCharRejectedCount
InspCharacteristicCount _InspOpHeader InspCharCount
InspCharOpenCountendasInspCharCount
InspLotHasSubsets _InspOpHeader InspLotHasSubsets
InspSubsetCharcOpenCount _InspOpHeader InspSubsetCharcOpenCount
InspSubsetCharcAcceptedCount _InspOpHeader InspSubsetCharcAcceptedCount
InspSubsetCharcRejectedCount _InspOpHeader InspSubsetCharcRejectedCount
InspectionOperationPlant InspectionOperationPlant Receiving Plant
_InspectionLot _InspectionLot

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_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: CMPEINSPOPR

CREATE VIEW C_Inspectionoperation AS
SELECT
  InspectionLot,
  InspPlanOperationInternalID,
  InspectionOperation,
  OperationText,
  _InspectionLot.InspectionLotText AS InspectionLotText,
  _InspectionLot.ManufacturingOrder AS ManufacturingOrder,
  _InspectionLot.InspectionLotQuantity AS InspectionLotQuantity,
  _InspectionLot.InspectionLotActualQuantity AS InspectionLotActualQuantity,
  _InspectionLot.InspectionLotQuantityUnit AS InspectionLotQuantityUnit,
  _InspectionLot.InspectionLotType AS InspectionLotType,
  _InspectionLot._InspectionLotType._Text[1: Language=$session.system_language].InspectionLotTypeText AS InspectionLotTypeText,
  _InspOpHeader.InspOpHasCharc AS InspOpHasCharc,
  _InspOpenCharCount.InspCharOpenCount AS InspCharOpenCount,
  _InspOpHeader.InspCharAcceptedCount AS InspCharAcceptedCount,
  _InspOpHeader.InspCharRejectedCount AS InspCharRejectedCount,
  _InspOpHeader.InspCharCount AS InspCharacteristicCount,
  case when _InspOpenCharCount.InspCharOpenCount is null then _InspOpHeader.InspCharCount else (_InspOpHeader.InspCharCount - _InspOpenCharCount.InspCharOpenCount) end as InspCharCount AS InspCharOpenCountendasInspCharCount,
  _InspOpHeader.InspLotHasSubsets AS InspLotHasSubsets,
  _InspOpHeader.InspSubsetCharcOpenCount AS InspSubsetCharcOpenCount,
  _InspOpHeader.InspSubsetCharcAcceptedCount AS InspSubsetCharcAcceptedCount,
  _InspOpHeader.InspSubsetCharcRejectedCount AS InspSubsetCharcRejectedCount,
  InspectionOperationPlant
FROM I_InspectionOperation
LEFT OUTER JOIN P_InspectionOperationHeader AS _InspOpHeader ON InspectionLot = _InspOpHeader.InspectionLot AND InspPlanOperationInternalID = _InspOpHeader.InspPlanOperationInternalID  -- association [1..1]
LEFT OUTER JOIN P_MPEOrdILOperOpenCharcCount AS _InspOpenCharCount ON InspectionLot = _InspOpenCharCount.InspectionLot AND InspPlanOperationInternalID = _InspOpenCharCount.InspPlanOperationInternalID  -- association [1..1]
;

Learn More