I_InspOperationUsageDecision

DDL: I_INSPOPERATIONUSAGEDECISION SQL: IINSPOPERUSGDCSN Type: view BASIC

Usage Decision on Operation Level

I_InspOperationUsageDecision is a Basic CDS View that provides data about "Usage Decision on Operation Level" in SAP S/4HANA. It reads from 1 data source (qave) and exposes 20 fields with key fields InspectionLot, InspPlanOperationInternalID. It has 4 associations to related views.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
qave qave from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_InspectionLot _InspectionLot $projection.InspectionLot = _InspectionLot.InspectionLot
[1..1] I_InspectionOperation _InspectionOperation $projection.InspectionLot = _InspectionOperation.InspectionLot and $projection.InspPlanOperationInternalID = _InspectionOperation.InspPlanOperationInternalID
[0..1] I_UsageDecisionCodeGroup _UsageDecisionCodeGroup $projection.UsageDecisionCodeGroup = _UsageDecisionCodeGroup.UsageDecisionCodeGroup
[0..1] I_UsageDecisionCode _UsageDecisionCode $projection.UsageDecisionCodeGroup = _UsageDecisionCode.UsageDecisionCodeGroup and $projection.UsageDecisionCode = _UsageDecisionCode.UsageDecisionCode

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IINSPOPERUSGDCSN view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Usage Decision on Operation Level view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot qave prueflos
KEY InspPlanOperationInternalID qave vorglfnr
InspectionLotQualityScore qave qkennzahl
UsageDecisionCodeGroup qave vcodegrp
UsageDecisionCode qave vcode
InspOpUsageDecisionValuation qave vbewertung
InspOpUsgeDcsnDynValuation qave dbewertung
InspOpUsageDecisionChangedOn qave vaedatum
InspOpUsageDecisionChangedBy qave vaename
InspOpUsgeDcsnSelectedSet qave vauswahlmg
InspOpUsageDecidedOn qave vdatum
InspOpUsgeDcsnChangedTime qave vezeitaen
InspOpUsageDecisionTime qave vezeiterf
InspOpUsgeDcsnFollowUpAction qave vfolgeakti
InspOpUsageDecisionCatalog qave vkatart
InspectionOpUsageDecidedBy qave vname
_InspectionLot _InspectionLot
_InspectionOperation _InspectionOperation
_UsageDecisionCodeGroup _UsageDecisionCodeGroup
_UsageDecisionCode _UsageDecisionCode 
@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