P_OperationActivityInstanceBsc

DDL: P_OPERATIONACTIVITYINSTANCEBSC SQL: PMPEOAIOANIBSC Type: view BASIC Package: MPE_EXEC_COMMON

OA Instance with OA network instance

P_OperationActivityInstanceBsc is a Basic CDS View that provides data about "OA Instance with OA network instance" in SAP S/4HANA. It reads from 2 data sources (I_OperationActivityInstance, I_OpActyNtwkInstanceBasic) and exposes 34 fields with key fields OpActyNtwkInstance, OpActyNtwkElement. Part of development package MPE_EXEC_COMMON.

2 data source(s) 34 fields

Data Sources (2)

SourceAliasJoin Type
I_OperationActivityInstance oai from
I_OpActyNtwkInstanceBasic oani inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPEOAIOANIBSC view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.private true view
AbapCatalog.compiler.compareFilter true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance I_OperationActivityInstance OpActyNtwkInstance
KEY OpActyNtwkElement I_OperationActivityInstance OpActyNtwkElement
StatusAndActionSchema I_OperationActivityInstance StatusAndActionSchema
OpPlannedYieldQuantity I_OperationActivityInstance OpPlannedYieldQuantity
OpPlannedScrapQuantity I_OperationActivityInstance OpPlannedScrapQuantity
ProductionUnit I_OperationActivityInstance ProductionUnit
OpActyExpdExecDurnInSeconds I_OperationActivityInstance OpActyExpdExecDurnInSeconds
OpActyExpdExecLaborDurnInSecs I_OperationActivityInstance OpActyExpdExecLaborDurnInSecs
BillOfOperationsType I_OperationActivityInstance BillOfOperationsType
BillOfOperationsGroup I_OperationActivityInstance BillOfOperationsGroup
BillOfOperationsVariant I_OperationActivityInstance BillOfOperationsVariant
BOOOperationInternalID I_OperationActivityInstance BOOOperationInternalID
BillOfOperationsVersion I_OperationActivityInstance BillOfOperationsVersion
OperationActivityNetwork I_OpActyNtwkInstanceBasic OperationActivityNetwork
OpActyNtwkVersionCounter I_OpActyNtwkInstanceBasic OpActyNtwkVersionCounter
ManufacturingOrder I_OpActyNtwkInstanceBasic ManufacturingOrder
OrderInternalID I_OpActyNtwkInstanceBasic OrderInternalID
OrderOperationInternalID I_OpActyNtwkInstanceBasic OrderOperationInternalID
OpActyConfIsSFIBased I_OpActyNtwkInstanceBasic OpActyConfIsSFIBased
OpActyConfirmationIsAllowed I_OpActyNtwkInstanceBasic OpActyConfirmationIsAllowed
OpActyConfNotAllowedReason I_OpActyNtwkInstanceBasic OpActyConfNotAllowedReason
_OpActyInstanceStatusBasic I_OperationActivityInstance _OpActyInstanceStatusBasic
_OpActyNtwkInstance I_OperationActivityInstance _OpActyNtwkInstance
_OpActyNtwkInstanceBasic I_OperationActivityInstance _OpActyNtwkInstanceBasic
_SASSchema I_OperationActivityInstance _SASSchema
_UnitOfMeasure I_OperationActivityInstance _UnitOfMeasure
_MfgOrder I_OpActyNtwkInstanceBasic _MfgOrder
_ManufacturingOrder I_OpActyNtwkInstanceBasic _ManufacturingOrder
_MfgOrderOperation I_OpActyNtwkInstanceBasic _MfgOrderOperation
_OrderOperation I_OpActyNtwkInstanceBasic _OrderOperation
_OrderOperationBasic I_OpActyNtwkInstanceBasic _OrderOperationBasic
_OpActyNtwkInternalId I_OpActyNtwkInstanceBasic _OpActyNtwkInternalId
_OperationActivityNetwork I_OpActyNtwkInstanceBasic _OperationActivityNetwork
_OrderInternalID I_OpActyNtwkInstanceBasic _OrderInternalID 
@AbapCatalog.sqlViewName: 'PMPEOAIOANIBSC'
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
define view P_OperationActivityInstanceBsc
  as select from I_OperationActivityInstance as oai
    inner join   I_OpActyNtwkInstanceBasic   as oani on oai.OpActyNtwkInstance = oani.OpActyNtwkInstance
{
  key oai.OpActyNtwkInstance,
  key oai.OpActyNtwkElement,
      oai.StatusAndActionSchema,
      oai.OpPlannedYieldQuantity,
      oai.OpPlannedScrapQuantity,
      oai.ProductionUnit,
      oai.OpActyExpdExecDurnInSeconds,
      oai.OpActyExpdExecLaborDurnInSecs,
      oai.BillOfOperationsType,
      oai.BillOfOperationsGroup,
      oai.BillOfOperationsVariant,
      oai.BOOOperationInternalID,
      oai.BillOfOperationsVersion,
      oani.OperationActivityNetwork,
      oani.OpActyNtwkVersionCounter,
      oani.ManufacturingOrder,
      oani.OrderInternalID,
      oani.OrderOperationInternalID,
      oani.OpActyConfIsSFIBased,
      oani.OpActyConfirmationIsAllowed,
      oani.OpActyConfNotAllowedReason,

      // Associations

      oai._OpActyInstanceStatusBasic,
      oai._OpActyNtwkInstance,
      oai._OpActyNtwkInstanceBasic,
      oai._SASSchema,
      oai._UnitOfMeasure,
      oani._MfgOrder,
      oani._ManufacturingOrder,
      oani._MfgOrderOperation,
      oani._OrderOperation,
      oani._OrderOperationBasic,
      oani._OpActyNtwkInternalId,
      oani._OperationActivityNetwork,
      oani._OrderInternalID
}

Learn More