How many fields does C_OpActyProcessingStatus have?

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

C_OpActyProcessingStatus

Q: Which tables does C_OpActyProcessingStatus use?

C_OpActyProcessingStatus reads from 4 data source(s): I_OpActyInstanceStatusBasic, I_OpActyNtwkElement, I_OpActyNtwkInstance, I_OrderOperationBasic.

DDL: C_OPACTYPROCESSINGSTATUS SQL: CMPEOAPROCGSTS Type: view CONSUMPTION

C_OpActyProcessingStatus is a Consumption CDS View in SAP S/4HANA. It reads from 4 data sources (I_OpActyInstanceStatusBasic, I_OpActyNtwkElement, I_OpActyNtwkInstance, I_OrderOperationBasic) and exposes 25 fields with key fields OpActyNtwkInstance, OpActyNtwkElement. It has 2 associations to related views.

Data Sources (4)

Source	Alias	Join Type
I_OpActyInstanceStatusBasic	OpActyInstanceStatusBasic	inner
I_OpActyNtwkElement	OpActyNtwkElement	inner
I_OpActyNtwkInstance	OpActyNtwkInstance	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 (10)

Name	Value	Level
AbapCatalog.sqlViewName	CMPEOAPROCGSTS	view
AbapCatalog.compiler.compareFilter	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 (25)

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

@AbapCatalog.sqlViewName: 'CMPEOAPROCGSTS'
@AbapCatalog.compiler.compareFilter: 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_OpActyNtwkInstance        as OpActyNtwkInstance
    inner join             I_OpActyInstanceStatusBasic as OpActyInstanceStatusBasic on OpActyInstanceStatusBasic.OpActyNtwkInstance = OpActyNtwkInstance.OpActyNtwkInstance
    inner join             I_OpActyNtwkElement         as OpActyNtwkElement         on  OpActyNtwkElement.OperationActivityNetwork = OpActyNtwkInstance.OperationActivityNetwork
                                                                                    and OpActyNtwkElement.OpActyNtwkVersionCounter = OpActyNtwkInstance.OpActyNtwkVersionCounter
                                                                                    and OpActyNtwkElement.OpActyNtwkElement        = OpActyInstanceStatusBasic.OpActyNtwkElement
    inner join             I_OrderOperationBasic       as OrderOperationBasic       on  OrderOperationBasic.OrderInternalID          = OpActyNtwkInstance.OrderInternalID
                                                                                    and OrderOperationBasic.OrderOperationInternalID = OpActyNtwkInstance.OrderOperationInternalID
    left outer to one join I_OpActyNtwkGroupElement    as OpActyNtwkGroupElementRel on  OpActyNtwkInstance.OperationActivityNetwork = OpActyNtwkGroupElementRel.OperationActivityNetwork
                                                                                    and OpActyNtwkInstance.OpActyNtwkVersionCounter = OpActyNtwkGroupElementRel.OpActyNtwkVersionCounter
                                                                                    and OpActyInstanceStatusBasic.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 OpActyInstanceStatusBasic.OpActyNtwkInstance                                                     as OpActyNtwkInstance,
  key OpActyInstanceStatusBasic.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._SASStatus.SASStatusCategory                                           as SASStatusCategory,
      OpActyInstanceStatusBasic.OpActyIsSeldForRtactvPostg                                             as OpActyIsSeldForRtactvPostg,
      OpActyNtwkElement.OANElementDisplaySqncNumber                                                    as OANElementDisplaySqncNumber,
      OpActyNtwkInstance.OpActyNtwkSegmentType                                                         as OpActyNtwkSegmentType,
      OpActyNtwkElement.OpActyNtwkElementExternalID,
      cast(OpActyNtwkInstance.OpActyConfIsSFIBased as boolean preserving type)                         as OpActyConfIsSFIBased,
      cast(OpActyNtwkGroupElement.OpActyNtwkElementExternalID as mpe_group_number_ext preserving type) as OpActyNtwkGroupExternalID,
      @ObjectModel.foreignKey.association: '_MfgOrder'
      OpActyNtwkInstance.ManufacturingOrder                                                            as ManufacturingOrder,
      @ObjectModel.foreignKey.association: '_OrderInternalID'
      OpActyNtwkInstance.OrderInternalID                                                               as OrderInternalID,
      OpActyNtwkInstance.OrderOperationInternalID                                                      as OrderOperationInternalID,

      @ObjectModel.text.element: ['MfgOrderOperationText']
      cast(OrderOperationBasic.Operation_2 as manufacturingorderoperation 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,


      OpActyInstanceStatusBasic._OperationActivityInstance,
      OpActyInstanceStatusBasic._OpActyNtwkInstance,
      OpActyInstanceStatusBasic._SASStatus,
      OpActyInstanceStatusBasic._SASStatus._SASStatusCategory,
      OpActyNtwkInstance._MfgOrder,
      OpActyNtwkInstance._OrderInternalID,
      OpActyNtwkInstance._OANSegmentType,
      OrderOperationBasic._WorkCenterByInternalID,
      _ProductionPlant

}

Depth:

C_OpActyProcessingStatus view