P_InspectionOperationHeader

DDL: P_INSPECTIONOPERATIONHEADER Type: view_entity CONSUMPTION
12 Fields 1 Data Sources

Header of Inspection Operation

P_InspectionOperationHeader is a Consumption CDS View that provides data about "Header of Inspection Operation" in SAP S/4HANA. It reads from 1 data source (I_InspectionOperation) and exposes 12 fields with key fields InspectionLot, InspPlanOperationInternalID.

Data Sources (1)

SourceAliasJoin Type
I_InspectionOperation _InspOpHeader from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
EndUserText.label Header of Inspection Operation view
Search.searchable false view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
VDM.private true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionOperation InspectionLot Inspection Lot
KEY InspPlanOperationInternalID I_InspectionOperation InspPlanOperationInternalID Node Number
InspectionLotType
Plant
InspCharRejectedCountendasInspCharCount
InspSubsetCharcAcceptedCount _InspOperationAggregate InspSubsetCharcAcceptedCount
InspSubsetCharcRejectedCount _InspOperationAggregate InspSubsetCharcRejectedCount
InspSubsetCharcOpenCount _InspOperationAggregate InspSubsetCharcOpenCount
InspCharOpenCount _InspOperationAggregate InspCharOpenCount
InspCharAcceptedCount _InspOperationAggregate InspCharAcceptedCount
InspCharRejectedCount _InspOperationAggregate InspCharRejectedCount
_InspectionLot I_InspectionOperation _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 P_InspectionOperationHeader.
-- 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.

CREATE VIEW P_InspectionOperationHeader AS
SELECT
  _InspOpHeader.InspectionLot AS InspectionLot,
  _InspOpHeader.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _InspOpHeader._InspectionLot.InspectionLotType AS InspectionLotType,
  _InspOpHeader._Plant.Plant AS Plant,
  case _InspOpHeader._InspectionLot._InspSubsetFieldCombination.SamplingProcedureInspSubset when '2' then (_InspOperationAggregate.InspSubsetCharcAcceptedCount + _InspOperationAggregate.InspSubsetCharcRejectedCount + _InspOperationAggregate.InspSubsetCharcOpenCount) else (_InspOperationAggregate.InspCharOpenCount + _InspOperationAggregate.InspCharAcceptedCount + _InspOperationAggregate.InspCharRejectedCount) end as InspCharCount AS InspCharRejectedCountendasInspCharCount,
  _InspOperationAggregate.InspSubsetCharcAcceptedCount AS InspSubsetCharcAcceptedCount,
  _InspOperationAggregate.InspSubsetCharcRejectedCount AS InspSubsetCharcRejectedCount,
  _InspOperationAggregate.InspSubsetCharcOpenCount AS InspSubsetCharcOpenCount,
  _InspOperationAggregate.InspCharOpenCount AS InspCharOpenCount,
  _InspOperationAggregate.InspCharAcceptedCount AS InspCharAcceptedCount,
  _InspOperationAggregate.InspCharRejectedCount AS InspCharRejectedCount,
  _InspOpHeader._InspectionLot AS _InspectionLot
FROM I_InspectionOperation AS _InspOpHeader
;

Learn More