P_MFGINSPOPERATION

CDS View

Inspection Issues By Operation

P_MFGINSPOPERATION is a CDS View in S/4HANA. Inspection Issues By Operation. It contains 4 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 4 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_InspCharcRejection view_entity inner COMPOSITE Rejections for insp. characteristic
P_MPEInspectionSubset view_entity inner COMPOSITE Inspection Point of Inspection Operation
P_MPEInspIssuesByOperation view_entity from COMPOSITE Inspection Issues By Operation
P_MPEInspOpUsageDecision view_entity inner COMPOSITE Usage Decision on Operation Level

Fields (4)

KeyField CDS FieldsUsed in Views
KEY InspectionLot InspectionLot 1
KEY InspPlanOperationInternalID InspPlanOperationInternalID 1
OrderInternalBillOfOperations OrderInternalBillOfOperations 4
Plant Plant 4 
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #TRANSACTIONAL }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Inspection Issues By Operation'
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_MfgInspOperation as select from I_InspectionOperation as inspo
  inner join P_MfgOperationsList as _List         on  _List.OrderInternalID = inspo.OrderInternalBillOfOperations
                                                  and _List.OrderOperationInternalID  = inspo.InspPlanOperationInternalID
                                                  and _List.OrderOperationInternalID  = inspo.OrderOperationInternalID          

{
  key inspo.InspectionLot                 as InspectionLot,
  key inspo.InspPlanOperationInternalID   as InspPlanOperationInternalID,   // = afvc.aplzl = qaop.vorglfnr !

  
      inspo.OrderInternalBillOfOperations as OrderInternalBillOfOperations, // = afvc.aufpl

      _List.Plant,
      
      // Associations

//      inspo._WorkCenter,

      inspo._InspectionLot,
      inspo._InspectionCharacteristic,
      inspo._InspectionSubset,
      inspo._InspectionOperationStatus
//      inspo._Plant,

//      inspo._BillOfOperationsType


}

Learn More