P_OperationActivityInstance

DDL: P_OPERATIONACTIVITYINSTANCE SQL: PMPEOAIOANI Type: view COMPOSITE

P_OperationActivityInstance is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_OperationActivityInstance, I_OpActyNtwkInstance) and exposes 36 fields with key fields OpActyNtwkInstance, OpActyNtwkElement.

2 data source(s) 36 fields

Data Sources (2)

SourceAliasJoin Type
I_OperationActivityInstance oai from
I_OpActyNtwkInstance oani inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPEOAIOANI 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 #COMPOSITE view
VDM.private true view
AbapCatalog.compiler.compareFilter true view

Fields (36)

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_OpActyNtwkInstance OperationActivityNetwork
OpActyNtwkVersionCounter I_OpActyNtwkInstance OpActyNtwkVersionCounter
ManufacturingOrder I_OpActyNtwkInstance ManufacturingOrder
OrderInternalID I_OpActyNtwkInstance OrderInternalID
OrderOperationInternalID I_OpActyNtwkInstance OrderOperationInternalID
OpActyConfIsSFIBased I_OpActyNtwkInstance OpActyConfIsSFIBased
OpActyConfirmationIsAllowed I_OpActyNtwkInstance OpActyConfirmationIsAllowed
OpActyConfNotAllowedReason I_OpActyNtwkInstance OpActyConfNotAllowedReason
OpActyNtwkSegmentType I_OpActyNtwkInstance OpActyNtwkSegmentType
_OpActyInstanceStatusBasic I_OperationActivityInstance _OpActyInstanceStatusBasic
_OpActyNtwkInstance I_OperationActivityInstance _OpActyNtwkInstance
_OpActyNtwkInstanceBasic I_OperationActivityInstance _OpActyNtwkInstanceBasic
_SASSchema I_OperationActivityInstance _SASSchema
_UnitOfMeasure I_OperationActivityInstance _UnitOfMeasure
_MfgOrder I_OpActyNtwkInstance _MfgOrder
_ManufacturingOrder I_OpActyNtwkInstance _ManufacturingOrder
_MfgOrderOperation I_OpActyNtwkInstance _MfgOrderOperation
_OrderOperation I_OpActyNtwkInstance _OrderOperation
_OrderOperationBasic I_OpActyNtwkInstance _OrderOperationBasic
_OpActyNtwkInternalId I_OpActyNtwkInstance _OpActyNtwkInternalId
_OperationActivityNetwork I_OpActyNtwkInstance _OperationActivityNetwork
_OrderInternalID I_OpActyNtwkInstance _OrderInternalID
_OANSegmentType I_OpActyNtwkInstance _OANSegmentType 
@AbapCatalog.sqlViewName: 'PMPEOAIOANI'
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
define view P_OperationActivityInstance
  as select from I_OperationActivityInstance as oai
    inner join   I_OpActyNtwkInstance        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,
      @ObjectModel.foreignKey.association: '_OANSegmentType'
      oani.OpActyNtwkSegmentType,

      // 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,
      oani._OANSegmentType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPACTYNTWKINSTANCE",
"I_OPERATIONACTIVITYINSTANCE"
],
"ASSOCIATED":
[
"I_MANUFACTURINGORDER",
"I_MFGORDER",
"I_MFGORDEROPERATION",
"I_OANSEGMENTTYPE",
"I_OPACTYINSTANCESTATUSBASIC",
"I_OPACTYNTWKINSTANCE",
"I_OPACTYNTWKINSTANCEBASIC",
"I_OPACTYNTWKINTERNALID",
"I_OPERATIONACTIVITYNETWORK",
"I_ORDEROPERATION",
"I_ORDEROPERATIONBASIC",
"I_ORDINTERNALBILLOFOPERATIONS",
"I_SASSCHEMA",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_OPACTYNTWKINSTANCE",
"I_OPERATIONACTIVITYINSTANCE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More