I_OpActyInstceStdVH

DDL: I_OPACTYINSTCESTDVH SQL: IOAI__VH Type: view COMPOSITE
6 Fields 1 Data Sources

Operation Activity Instance

I_OpActyInstceStdVH is a Composite CDS View that provides data about "Operation Activity Instance" in SAP S/4HANA. It reads from 1 data source (I_OperationActivityInstance) and exposes 6 fields with key fields OpActyNtwkInstance, OpActyNtwkElement.

Data Sources (1)

SourceAliasJoin Type
I_OperationActivityInstance I_OperationActivityInstance from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IOAI__VH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey OpActyNtwkElement view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
Consumption.ranked true view
EndUserText.label Operation Activity Instance view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement OpActyNtwkElement Element Number
ManufacturingOrder _OpActyNtwkInstanceBasic ManufacturingOrder Order
_OpActyNtwkInstance _OpActyNtwkInstance
_OpActyNtwkInstanceBasic _OpActyNtwkInstanceBasic
_MfgOrder _OpActyNtwkInstanceBasic _MfgOrder

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_OpActyInstceStdVH.
-- 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: IOAI__VH

CREATE VIEW I_OpActyInstceStdVH AS
SELECT
  OpActyNtwkInstance,
  OpActyNtwkElement,
  _OpActyNtwkInstanceBasic.ManufacturingOrder AS ManufacturingOrder,
  _OpActyNtwkInstanceBasic._MfgOrder AS _MfgOrder
FROM I_OperationActivityInstance
;

Learn More