I_INSPOPERATIONUSAGEDECISION

CDS View

Usage Decision on Operation Level

I_INSPOPERATIONUSAGEDECISION is a CDS View in S/4HANA. Usage Decision on Operation Level. It contains 9 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 9 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_QM_InspectionOperationChars view left_outer CONSUMPTION Inspection operation with char counts
P_InspectionLotAggregate3 view from COMPOSITE
P_InspOpAggr view left_outer CONSUMPTION
P_MPEInspOpUsageDecision view_entity from COMPOSITE Usage Decision on Operation Level

Fields (9)

KeyField CDS FieldsUsed in Views
KEY InspectionLot InspectionLot 2
KEY InspPlanOperationInternalID InspPlanOperationInternalID 1
_InspectionLot _InspectionLot 1
_InspectionOperation _InspectionOperation 1
_UsageDecisionCode _UsageDecisionCode 1
_UsageDecisionCodeGroup _UsageDecisionCodeGroup 1
InspOpUsageDecisionValuation InspOpUsageDecisionValuation 1
UsageDecisionCode UsageDecisionCode 1
UsageDecisionCodeGroup UsageDecisionCodeGroup 1 
@AbapCatalog.sqlViewName: 'IINSPOPERUSGDCSN'
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Usage Decision on Operation Level'
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel.usageType: { dataClass: #TRANSACTIONAL, sizeCategory: #L, serviceQuality: #A }
define view I_InspOperationUsageDecision
  as select from qave
  association [1..1] to I_InspectionLot          as _InspectionLot          on  $projection.InspectionLot = _InspectionLot.InspectionLot
  association [1..1] to I_InspectionOperation    as _InspectionOperation    on  $projection.InspectionLot               = _InspectionOperation.InspectionLot
                                                                            and $projection.InspPlanOperationInternalID = _InspectionOperation.InspPlanOperationInternalID
  association [0..1] to I_UsageDecisionCodeGroup as _UsageDecisionCodeGroup on  $projection.UsageDecisionCodeGroup = _UsageDecisionCodeGroup.UsageDecisionCodeGroup
  association [0..1] to I_UsageDecisionCode      as _UsageDecisionCode      on  $projection.UsageDecisionCodeGroup = _UsageDecisionCode.UsageDecisionCodeGroup
                                                                            and $projection.UsageDecisionCode      = _UsageDecisionCode.UsageDecisionCode
{
  key qave.prueflos   as InspectionLot,
  key qave.vorglfnr   as InspPlanOperationInternalID,
      qave.qkennzahl  as InspectionLotQualityScore,
      qave.vcodegrp   as UsageDecisionCodeGroup,
      qave.vcode      as UsageDecisionCode,
      qave.vbewertung as InspOpUsageDecisionValuation,
      qave.dbewertung as InspOpUsgeDcsnDynValuation,
      qave.vaedatum   as InspOpUsageDecisionChangedOn,
      qave.vaename    as InspOpUsageDecisionChangedBy,
      qave.vauswahlmg as InspOpUsgeDcsnSelectedSet,
      qave.vdatum     as InspOpUsageDecidedOn,
      qave.vezeitaen  as InspOpUsgeDcsnChangedTime,
      qave.vezeiterf  as InspOpUsageDecisionTime,
      qave.vfolgeakti as InspOpUsgeDcsnFollowUpAction,
      qave.vkatart    as InspOpUsageDecisionCatalog,
      qave.vname      as InspectionOpUsageDecidedBy,
      // Associations

      _InspectionLot,
      _InspectionOperation,
      _UsageDecisionCodeGroup,
      _UsageDecisionCode
}
where
  kzart = 'O' 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"QAVE"
],
"ASSOCIATED":
[
"I_INSPECTIONLOT",
"I_INSPECTIONOPERATION",
"I_USAGEDECISIONCODE",
"I_USAGEDECISIONCODEGROUP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More