A_InspectionOperation

DDL: A_INSPECTIONOPERATION SQL: AINSPOPER Type: view CONSUMPTION

Inspection Operations

A_InspectionOperation is a Consumption CDS View that provides data about "Inspection Operations" in SAP S/4HANA. It reads from 1 data source (I_InspectionOperation) and exposes 15 fields with key fields InspectionLot, InspPlanOperationInternalID. It has 2 associations to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_InspectionOperation I_InspectionOperation from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_InspectionLot _InspectionLot $projection.InspectionLot = _InspectionLot.InspectionLot
[0..1] A_WorkCenters _WorkCenter $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID and _WorkCenter.WorkCenterTypeCode = 'A'

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName AINSPOPER view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Inspection Operations view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot
KEY InspPlanOperationInternalID InspPlanOperationInternalID
OrderInternalBillOfOperations OrderInternalBillOfOperations
InspectionOperation InspectionOperation
InspectionOperationPlant InspectionOperationPlant
BillOfOperationsType BillOfOperationsType
BOOOperationInternalID BOOOperationInternalID
WorkCenterInternalID WorkCenterInternalID
StatusObject StatusObject
OperationControlProfile OperationControlProfile
OperationConfirmation OperationConfirmation
InspectionSubSystem InspectionSubSystem
OperationText OperationText
_InspectionLot _InspectionLot
_WorkCenter _WorkCenter 
@AbapCatalog.sqlViewName: 'AINSPOPER'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@EndUserText.label: 'Inspection Operations'
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: {
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #L,
        serviceQuality: #A
    },
    createEnabled: false,
    updateEnabled: false,
    deleteEnabled: false
}


define view A_InspectionOperation
  as select from I_InspectionOperation
  association [1..1] to A_InspectionLot             as _InspectionLot             on  $projection.InspectionLot = _InspectionLot.InspectionLot  
  association [0..1] to A_WorkCenters               as _WorkCenter                on  $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
                                                                                  and _WorkCenter.WorkCenterTypeCode   = 'A'  
{
  key InspectionLot,
  key InspPlanOperationInternalID,
      OrderInternalBillOfOperations,
      InspectionOperation,  
      InspectionOperationPlant,
      BillOfOperationsType,
      BOOOperationInternalID,
      WorkCenterInternalID,
      StatusObject,
      OperationControlProfile,
      OperationConfirmation,
      InspectionSubSystem,
      OperationText,
      _InspectionLot,
      _WorkCenter      
}
  
  
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONOPERATION"
],
"ASSOCIATED":
[
"A_INSPECTIONLOT",
"A_WORKCENTERS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More