E_InspectionOperation

DDL: E_INSPECTIONOPERATION SQL: EINSPOPERATION Type: view EXTENSION

Inspection Operation Extension

E_InspectionOperation is a Extension CDS View that provides data about "Inspection Operation Extension" in SAP S/4HANA. It reads from 2 data sources (afvc, qaop) and exposes 2 fields with key fields InspectionLot, InspPlanOperationInternalID.

Data Sources (2)

SourceAliasJoin Type
afvc Persistence inner
qaop qaop from

Annotations (8)

NameValueLevelField
EndUserText.label Inspection Operation Extension view
AbapCatalog.sqlViewName EINSPOPERATION view
ClientHandling.algorithm #AUTOMATED view
VDM.viewType #EXTENSION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot qaop prueflos
KEY InspPlanOperationInternalID qaop vorglfnr
@EndUserText.label: 'Inspection Operation Extension'
@AbapCatalog.sqlViewName: 'EINSPOPERATION'
@ClientHandling.algorithm: #AUTOMATED  
@VDM.viewType: #EXTENSION
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ObjectModel.usageType: {
    dataClass: #MIXED,
    sizeCategory: #L,
    serviceQuality: #C 
}
define view E_InspectionOperation
  as select from qaop
    inner join   afvc as Persistence on  qaop.aufpl = Persistence.aufpl
                                     and qaop.aplzl = Persistence.aplzl
{
  key qaop.prueflos as InspectionLot,
  key qaop.vorglfnr as InspPlanOperationInternalID
}      
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"AFVC",
"QAOP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/