I_MfgOrdInspPointRsltAggrg

DDL: I_MFGORDINSPPOINTRSLTAGGRG SQL: IORDINSPPTAGGRG Type: view BASIC Package: MPE_EXEC_RESULT_REC
8 Fields 1 Data Sources

Interface view for char aggrg rslts on Insp Pt

I_MfgOrdInspPointRsltAggrg is a Basic CDS View that provides data about "Interface view for char aggrg rslts on Insp Pt" in SAP S/4HANA. It reads from 1 data source (I_InspSubsetResult) and exposes 8 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic. Part of development package MPE_EXEC_RESULT_REC.

Data Sources (1)

SourceAliasJoin Type
I_InspSubsetResult I_InspSubsetResult from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IORDINSPPTAGGRG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
EndUserText.label Interface view for char aggrg rslts on Insp Pt view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot
KEY InspPlanOperationInternalID InspPlanOperationInternalID Node Number
KEY InspectionCharacteristic InspectionCharacteristic Characteristic
NumberOfInspCharcs
InspSubsetCharcAcceptedCount
InspSubsetCharcRejectedCount
_InspectionLot _InspectionLot
_InspectionOperation _InspectionOperation

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_MfgOrdInspPointRsltAggrg.
-- 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: IORDINSPPTAGGRG

CREATE VIEW I_MfgOrdInspPointRsltAggrg AS
SELECT
  InspectionLot,
  InspPlanOperationInternalID,
  InspectionCharacteristic,
  count(*) AS NumberOfInspCharcs,
  sum( case when InspectionValuationResult='A' then 1 else 0 end) AS InspSubsetCharcAcceptedCount,
  sum( case when InspectionValuationResult='R' then 1 else 0 end) AS InspSubsetCharcRejectedCount
FROM I_InspSubsetResult
;

Learn More