C_InspLotForInspSpecRsltRecg

DDL: C_INSPLOTFORINSPSPECRSLTRECG Type: view_entity CONSUMPTION Package: ODATA_QM_RSLT_RECG

InspSpec Keys with Inspection Lot

C_InspLotForInspSpecRsltRecg is a Consumption CDS View that provides data about "InspSpec Keys with Inspection Lot" in SAP S/4HANA. It reads from 2 data sources (I_InspectionLot, I_InspectionOperation) and exposes 8 fields with key fields InspectionSpecificationPlant, InspectionSpecification, InspectionSpecificationVersion, InspectionLot. It is exposed through 1 OData service (UI_INSPLOT_RSLTRECG). It is used in 1 Fiori application: Record Inspection Results (Version 2). Part of development package ODATA_QM_RSLT_RECG.

2 data source(s) Exposed by 1 service(s) Used in 1 Fiori app(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_InspectionLot _InspectionLot inner
I_InspectionOperation _InspectionOp inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label InspSpec Keys with Inspection Lot view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_INSPLOT_RSLTRECG UI_INSPLOT_RSLTRECG V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F1685A Record Inspection Results (Version 2) Transactional An application to record results for inspection characteristics.

Record Inspection Results (Version 2)

Business Role: Quality Technician

With the new Record Inspection Results app, you can record and process results for characteristics for one or more inspection lots effectively. You can also use this app to create defects manually for different categories, such as inspection lots, inspection operations, and characteristics.

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY InspectionSpecificationPlant _Characteristic InspectionSpecificationPlant
KEY InspectionSpecification _Characteristic InspectionSpecification
KEY InspectionSpecificationVersion _Characteristic InspectionSpecificationVersion
KEY InspectionLot _Characteristic InspectionLot
Plant I_InspectionLot Plant
MatlQualityAuthorizationGroup I_InspectionLot MatlQualityAuthorizationGroup
WorkCenter
InspectionLotType I_InspectionLot InspectionLotType 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'InspSpec Keys with Inspection Lot'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #CONSUMPTION
define view entity C_InspLotForInspSpecRsltRecg
  as select distinct from I_InspectionCharacteristic as _Characteristic
    inner join            I_InspectionLot            as _InspectionLot on _Characteristic.InspectionLot = _InspectionLot.InspectionLot
    inner join            I_InspectionOperation      as _InspectionOp  on  _Characteristic.InspectionLot               = _InspectionOp.InspectionLot
                                                                       and _Characteristic.InspPlanOperationInternalID = _InspectionOp.InspPlanOperationInternalID
{
  key _Characteristic.InspectionSpecificationPlant,
  key _Characteristic.InspectionSpecification,
  key _Characteristic.InspectionSpecificationVersion,
  key _Characteristic.InspectionLot,
      _InspectionLot.Plant,
      _InspectionLot.MatlQualityAuthorizationGroup,
      _InspectionOp._WorkCenter.WorkCenter,
      _InspectionLot.InspectionLotType
}
where
      _InspectionLot.BillOfOperationsType   <> 'V'
  and _Characteristic.InspectionSpecification <> ' '
  and _Characteristic.InspSpecRecordingType <> '*'
  and _Characteristic.InspSpecRecordingType <> '-'

Learn More