P_SFIAtOperationActivityBasic

DDL: P_SFIATOPERATIONACTIVITYBASIC Type: view_entity COMPOSITE

P_SFIAtOperationActivityBasic is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_OpActyNtwkInstance, I_OrderOperationBasic, I_ShopFloorItemStatus) and exposes 13 fields with key fields ShopFloorItem, OpActyNtwkInstance, OpActyNtwkElement.

3 data source(s) 13 fields

Data Sources (3)

SourceAliasJoin Type
I_OpActyNtwkInstance OpActyNtwkInstance inner
I_OrderOperationBasic OrderOperationBasic inner
I_ShopFloorItemStatus ShopFloorItemStatus from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ShopFloorItem I_ShopFloorItemStatus ShopFloorItem
KEY OpActyNtwkInstance I_ShopFloorItemStatus OpActyNtwkInstance
KEY OpActyNtwkElement I_ShopFloorItemStatus OpActyNtwkElement
OrderInternalID I_OpActyNtwkInstance OrderInternalID
OrderOperationInternalID I_OpActyNtwkInstance OrderOperationInternalID
OperationActivityNetwork I_OpActyNtwkInstance OperationActivityNetwork
OpActyNtwkVersionCounter I_OpActyNtwkInstance OpActyNtwkVersionCounter
ManufacturingOrderOperation
OpActyNtwkSegmentType I_OpActyNtwkInstance OpActyNtwkSegmentType
SFIIsInactiveAtOpActy I_ShopFloorItemStatus SFIIsInactiveAtOpActy
_ShopFloorItem I_ShopFloorItemStatus _ShopFloorItem
_OpActyNtwkInstance I_ShopFloorItemStatus _OpActyNtwkInstance
_OperationActivityInstance I_ShopFloorItemStatus _OperationActivityInstance 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_SFIAtOperationActivityBasic
  as select from I_ShopFloorItemStatus as ShopFloorItemStatus
    inner join   I_OpActyNtwkInstance  as OpActyNtwkInstance  on OpActyNtwkInstance.OpActyNtwkInstance = ShopFloorItemStatus.OpActyNtwkInstance
    inner join   I_OrderOperationBasic as OrderOperationBasic on  OrderOperationBasic.OrderInternalID          = OpActyNtwkInstance.OrderInternalID
                                                              and OrderOperationBasic.OrderOperationInternalID = OpActyNtwkInstance.OrderOperationInternalID
{
  key ShopFloorItemStatus.ShopFloorItem                                     as ShopFloorItem,
  key ShopFloorItemStatus.OpActyNtwkInstance                                as OpActyNtwkInstance,
  key ShopFloorItemStatus.OpActyNtwkElement                                 as OpActyNtwkElement,
      OpActyNtwkInstance.OrderInternalID                                    as OrderInternalID,
      OpActyNtwkInstance.OrderOperationInternalID                           as OrderOperationInternalID,
      OpActyNtwkInstance.OperationActivityNetwork                           as OperationActivityNetwork,
      OpActyNtwkInstance.OpActyNtwkVersionCounter                           as OpActyNtwkVersionCounter,
      cast(OrderOperationBasic.Operation as mpe_vornr_char preserving type) as ManufacturingOrderOperation,
      OpActyNtwkInstance.OpActyNtwkSegmentType                              as OpActyNtwkSegmentType,
      ShopFloorItemStatus.SFIIsInactiveAtOpActy                             as SFIIsInactiveAtOpActy,

      ShopFloorItemStatus._ShopFloorItem,
      ShopFloorItemStatus._OpActyNtwkInstance,
      ShopFloorItemStatus._OperationActivityInstance
}

Learn More