I_OpActyInstanceBasic

DDL: I_OPACTYINSTANCEBASIC Type: view_entity COMPOSITE

Basic data of an Operation Activity Instance

I_OpActyInstanceBasic is a Composite CDS View that provides data about "Basic data of an Operation Activity Instance" in SAP S/4HANA. It reads from 2 data sources (I_OpActyInstceOpActyNtwkElmnt, I_OrderOperationBasic) and exposes 10 fields with key fields OpActyNtwkInstance, OpActyNtwkElement.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_OpActyInstceOpActyNtwkElmnt OpActyInstceOpActyNtwkElmnt from
I_OrderOperationBasic OrderOperationBasic inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Basic data of an Operation Activity Instance view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance I_OpActyInstceOpActyNtwkElmnt OpActyNtwkInstance
KEY OpActyNtwkElement I_OpActyInstceOpActyNtwkElmnt OpActyNtwkElement
ManufacturingOrder I_OpActyInstceOpActyNtwkElmnt ManufacturingOrder
OrderInternalID I_OpActyInstceOpActyNtwkElmnt OrderInternalID
OrderOperationInternalID I_OpActyInstceOpActyNtwkElmnt OrderOperationInternalID
ManufacturingOrderOperation
OpActyNtwkSegmentType I_OpActyInstceOpActyNtwkElmnt OpActyNtwkSegmentType
OpActyNtwkElementExternalID I_OpActyInstceOpActyNtwkElmnt OpActyNtwkElementExternalID
_OpActyNtwkInstance I_OpActyInstceOpActyNtwkElmnt _OpActyNtwkInstance
_OperationActivityInstance I_OpActyInstceOpActyNtwkElmnt _OperationActivityInstance 
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Basic data of an Operation Activity Instance'
define view entity I_OpActyInstanceBasic 
  as select from I_OpActyInstceOpActyNtwkElmnt as OpActyInstceOpActyNtwkElmnt
    inner join   I_OrderOperationBasic         as OrderOperationBasic on  OrderOperationBasic.OrderInternalID          = OpActyInstceOpActyNtwkElmnt.OrderInternalID
                                                                      and OrderOperationBasic.OrderOperationInternalID = OpActyInstceOpActyNtwkElmnt.OrderOperationInternalID
{
  key OpActyInstceOpActyNtwkElmnt.OpActyNtwkInstance                        as OpActyNtwkInstance,
  key OpActyInstceOpActyNtwkElmnt.OpActyNtwkElement                         as OpActyNtwkElement,
      OpActyInstceOpActyNtwkElmnt.ManufacturingOrder                        as ManufacturingOrder,
      OpActyInstceOpActyNtwkElmnt.OrderInternalID                           as OrderInternalID,
      OpActyInstceOpActyNtwkElmnt.OrderOperationInternalID                  as OrderOperationInternalID,
      cast(OrderOperationBasic.Operation as mpe_vornr_char preserving type) as ManufacturingOrderOperation,
      OpActyInstceOpActyNtwkElmnt.OpActyNtwkSegmentType                     as OpActyNtwkSegmentType,
      OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementExternalID               as OpActyNtwkElementExternalID,

      OpActyInstceOpActyNtwkElmnt._OpActyNtwkInstance,
      OpActyInstceOpActyNtwkElmnt._OperationActivityInstance
}

Learn More