I_InspOperationUsageDecision

DDL: I_INSPOPERATIONUSAGEDECISION SQL: IINSPOPERUSGDCSN Type: view BASIC
20 Fields 1 Data Sources 4 Associations

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.

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 Inspection Lot
KEY InspPlanOperationInternalID qave vorglfnr Node Number
InspectionLotQualityScore qave qkennzahl Quality Score
UsageDecisionCodeGroup qave vcodegrp UD Code Group
UsageDecisionCode qave vcode UD Code
InspOpUsageDecisionValuation qave vbewertung Code Valuation
InspOpUsgeDcsnDynValuation qave dbewertung DynModValuation
InspOpUsageDecisionChangedOn qave vaedatum Date of UD
InspOpUsageDecisionChangedBy qave vaename UD Changed By
InspOpUsgeDcsnSelectedSet qave vauswahlmg UD Selected Set
InspOpUsageDecidedOn qave vdatum UD Code Date
InspOpUsgeDcsnChangedTime qave vezeitaen Time
InspOpUsageDecisionTime qave vezeiterf Syst. Time
InspOpUsgeDcsnFollowUpAction qave vfolgeakti Follow-Up Actn
InspOpUsageDecisionCatalog qave vkatart Catalog
InspectionOpUsageDecidedBy qave vname Volatility Name
_InspectionLot _InspectionLot
_InspectionOperation _InspectionOperation
_UsageDecisionCodeGroup _UsageDecisionCodeGroup
_UsageDecisionCode _UsageDecisionCode

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_InspOperationUsageDecision.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IINSPOPERUSGDCSN

CREATE VIEW I_InspOperationUsageDecision AS
SELECT
  qave.prueflos AS InspectionLot,
  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
FROM qave
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_InspectionOperation AS _InspectionOperation ON InspectionLot = _InspectionOperation.InspectionLot AND InspPlanOperationInternalID = _InspectionOperation.InspPlanOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_UsageDecisionCodeGroup AS _UsageDecisionCodeGroup ON UsageDecisionCodeGroup = _UsageDecisionCodeGroup.UsageDecisionCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_UsageDecisionCode AS _UsageDecisionCode ON UsageDecisionCodeGroup = _UsageDecisionCode.UsageDecisionCodeGroup AND UsageDecisionCode = _UsageDecisionCode.UsageDecisionCode  -- association [0..1]
;

Learn More