How many fields does C_OpActyProcessingStatus have?

C_OpActyProcessingStatus has 21 fields. Key fields: OpActyNtwkInstance, OpActyNtwkElement.

C_OpActyProcessingStatus

Q: Which tables does C_OpActyProcessingStatus use?

C_OpActyProcessingStatus reads from 3 data source(s): I_OpActyInstanceStatusBasic, I_OpActyInstceOpActyNtwkElmnt, I_OrderOperationBasic.

DDL: C_OPACTYPROCESSINGSTATUS SQL: CMPEOAPROCGSTS Type: view CONSUMPTION Package: MPE_EXEC_CONF

Current Processing Status Operation Activity

C_OpActyProcessingStatus is a Consumption CDS View that provides data about "Current Processing Status Operation Activity" in SAP S/4HANA. It reads from 3 data sources (I_OpActyInstanceStatusBasic, I_OpActyInstceOpActyNtwkElmnt, I_OrderOperationBasic) and exposes 21 fields with key fields OpActyNtwkInstance, OpActyNtwkElement. It has 2 associations to related views. Part of development package MPE_EXEC_CONF.

Data Sources (3)

Source	Alias	Join Type
I_OpActyInstanceStatusBasic	OpActyInstanceStatusBasic	inner
I_OpActyInstceOpActyNtwkElmnt	OpActyInstceOpActyNtwkElmnt	from
I_OrderOperationBasic	OrderOperationBasic	inner

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	P_OpActyNrOfMandComponents	_OpActyNrOfMandComponents	`$projection.OpActyNtwkInstance = _OpActyNrOfMandComponents.OpActyNtwkInstance and $projection.OpActyNtwkElement = _OpActyNrOfMandComponents.OpActyNtwkElement`
[1..1]	I_Plant	_ProductionPlant	`$projection.ProductionPlant = _ProductionPlant.Plant`

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	CMPEOAPROCGSTS	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
VDM.viewType	#CONSUMPTION	view
Metadata.allowExtensions	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (21)

Key	Field	Source Table	Source Field
KEY	OpActyNtwkInstance	I_OpActyInstceOpActyNtwkElmnt	OpActyNtwkInstance
KEY	OpActyNtwkElement	I_OpActyInstceOpActyNtwkElmnt	OpActyNtwkElement
	ProductionPlant	I_OrderOperationBasic	Plant
	WorkCenterInternalID	I_OrderOperationBasic	WorkCenterInternalID
	OpActyIsSeldForRtactvPostg	I_OpActyInstanceStatusBasic	OpActyIsSeldForRtactvPostg
	OANElementDisplaySqncNumber	I_OpActyInstceOpActyNtwkElmnt	OANElementDisplaySqncNumber
	OpActyNtwkSegmentType	I_OpActyInstceOpActyNtwkElmnt	OpActyNtwkSegmentType
	OpActyNtwkElementExternalID	I_OpActyInstceOpActyNtwkElmnt	OpActyNtwkElementExternalID
	OpActyConfIsSFIBased
	OpActyNtwkGroupExternalID
	ManufacturingOrder	I_OpActyInstceOpActyNtwkElmnt	ManufacturingOrder
	OrderInternalID	I_OpActyInstceOpActyNtwkElmnt	OrderInternalID
	OrderOperationInternalID	I_OpActyInstceOpActyNtwkElmnt	OrderOperationInternalID
	ManufacturingOrderOperation
	MfgOrderOperationText	I_OrderOperationBasic	OperationText
	_OpActyNtwkInstance	I_OpActyInstceOpActyNtwkElmnt	_OpActyNtwkInstance
	_SASStatus	I_OpActyInstanceStatusBasic	_SASStatus
	_MfgOrder	I_OpActyInstceOpActyNtwkElmnt	_MfgOrder
	_OrderInternalID	I_OpActyInstceOpActyNtwkElmnt	_OrderInternalID
	_WorkCenterByInternalID	I_OrderOperationBasic	_WorkCenterByInternalID
	_ProductionPlant		_ProductionPlant

@AbapCatalog.sqlViewName: 'CMPEOAPROCGSTS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking:#BLOCKED_DATA_EXCLUDED
@VDM.viewType: #CONSUMPTION
//@EndUserText.label: 'Current Procg Status Operation Activity'

@Metadata.allowExtensions: true

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}


define view C_OpActyProcessingStatus
  as select from           I_OpActyInstceOpActyNtwkElmnt as OpActyInstceOpActyNtwkElmnt
    inner join             I_OpActyInstanceStatusBasic   as OpActyInstanceStatusBasic on  OpActyInstanceStatusBasic.OpActyNtwkInstance = OpActyInstceOpActyNtwkElmnt.OpActyNtwkInstance
                                                                                      and OpActyInstanceStatusBasic.OpActyNtwkElement  = OpActyInstceOpActyNtwkElmnt.OpActyNtwkElement
    inner join             I_OrderOperationBasic         as OrderOperationBasic       on  OrderOperationBasic.OrderInternalID          = OpActyInstceOpActyNtwkElmnt.OrderInternalID
                                                                                      and OrderOperationBasic.OrderOperationInternalID = OpActyInstceOpActyNtwkElmnt.OrderOperationInternalID
  //inner join             I_SASStatus                    as SASStatus                    on SASStatus.StatusAndActionSchemaStatus = OpActyInstanceStatusBasic.StatusAndActionSchemaStatus

    left outer to one join I_OpActyNtwkGroupElement      as OpActyNtwkGroupElementRel on  OpActyInstceOpActyNtwkElmnt.OperationActivityNetwork = OpActyNtwkGroupElementRel.OperationActivityNetwork
                                                                                      and OpActyInstceOpActyNtwkElmnt.OpActyNtwkVersionCounter = OpActyNtwkGroupElementRel.OpActyNtwkVersionCounter
                                                                                      and OpActyInstceOpActyNtwkElmnt.OpActyNtwkElement        = OpActyNtwkGroupElementRel.OpActyNtwkGroupChildElement
    left outer to one join I_OpActyNtwkElement           as OpActyNtwkGroupElement    on  OpActyNtwkGroupElement.OperationActivityNetwork = OpActyNtwkGroupElementRel.OperationActivityNetwork
                                                                                      and OpActyNtwkGroupElement.OpActyNtwkVersionCounter = OpActyNtwkGroupElementRel.OpActyNtwkVersionCounter
                                                                                      and OpActyNtwkGroupElement.OpActyNtwkElement        = OpActyNtwkGroupElementRel.OpActyNtwkGroupParentElement
                                                                                      and OpActyNtwkGroupElement.OpActyNtwkElementType    = 5 //group


  association [0..1] to P_OpActyNrOfMandComponents as _OpActyNrOfMandComponents on  $projection.OpActyNtwkInstance = _OpActyNrOfMandComponents.OpActyNtwkInstance
                                                                                and $projection.OpActyNtwkElement  = _OpActyNrOfMandComponents.OpActyNtwkElement
  association [1..1] to I_Plant                    as _ProductionPlant          on  $projection.ProductionPlant = _ProductionPlant.Plant
  //association [0..1] to I_OANSegmentType               as _OANSegmentType           on  $projection.OpActyNtwkSegmentType = _OANSegmentType.OpActyNtwkSegmentType


{
      @ObjectModel.foreignKey.association: '_OpActyNtwkInstance'
  key OpActyInstceOpActyNtwkElmnt.OpActyNtwkInstance                                                   as OpActyNtwkInstance,
  key OpActyInstceOpActyNtwkElmnt.OpActyNtwkElement                                                    as OpActyNtwkElement,
      @ObjectModel.foreignKey.association: '_ProductionPlant'
      OrderOperationBasic.Plant                                                                        as ProductionPlant,
      OrderOperationBasic.WorkCenterInternalID                                                         as WorkCenterInternalID, --Needed for Association needed in DCL
      @ObjectModel.foreignKey.association: '_SASStatus'
      OpActyInstanceStatusBasic.StatusAndActionSchemaStatus                                            as StatusAndActionSchemaStatus,
      OpActyInstanceStatusBasic.OpActyIsSeldForRtactvPostg                                             as OpActyIsSeldForRtactvPostg,
      OpActyInstceOpActyNtwkElmnt.OANElementDisplaySqncNumber                                          as OANElementDisplaySqncNumber,
      OpActyInstceOpActyNtwkElmnt.OpActyNtwkSegmentType                                                as OpActyNtwkSegmentType,
      OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementExternalID,
      cast(OpActyInstceOpActyNtwkElmnt.OpActyConfIsSFIBased as boolean preserving type)                as OpActyConfIsSFIBased,
      cast(OpActyNtwkGroupElement.OpActyNtwkElementExternalID as mpe_group_number_ext preserving type) as OpActyNtwkGroupExternalID,
      @ObjectModel.foreignKey.association: '_MfgOrder'
      OpActyInstceOpActyNtwkElmnt.ManufacturingOrder                                                   as ManufacturingOrder,
      @ObjectModel.foreignKey.association: '_OrderInternalID'
      OpActyInstceOpActyNtwkElmnt.OrderInternalID                                                      as OrderInternalID,
      OpActyInstceOpActyNtwkElmnt.OrderOperationInternalID                                             as OrderOperationInternalID,

      @ObjectModel.text.element: ['MfgOrderOperationText']
      cast(OrderOperationBasic.Operation as mpe_vornr_char preserving type)                            as ManufacturingOrderOperation,
      OrderOperationBasic.OperationText                                                                as MfgOrderOperationText,
      cast(case
             when _OpActyNrOfMandComponents.NumberOfMandatoryComponents is not null and _OpActyNrOfMandComponents.NumberOfMandatoryComponents > 0 then 'X'
             else '' end as boolean preserving type)                                                   as OpActyHasMandatoryComponents,


      OpActyInstceOpActyNtwkElmnt._OpActyNtwkInstance,
      OpActyInstanceStatusBasic._SASStatus,
      OpActyInstceOpActyNtwkElmnt._MfgOrder,
      OpActyInstceOpActyNtwkElmnt._OrderInternalID,
      OrderOperationBasic._WorkCenterByInternalID,
      _ProductionPlant

}

Depth:

C_OpActyProcessingStatus view