Which tables does I_ProdnModOperationActivity use?

I_ProdnModOperationActivity reads from 6 data source(s): I_BillOfOperationsOpBasic, I_BOOOperationChgStOANBasic, I_OpActyNtwkElement, I_BillOfOperationsOperation, I_OperationActivity, I_ProductionModel.

I_ProdnModOperationActivity

Q: How many fields does I_ProdnModOperationActivity have?

I_ProdnModOperationActivity has 43 fields. Key fields: ProductionModelUUID, BOOOperationInternalID, OperationActivity, OperationActyVersionCounter.

DDL: I_PRODNMODOPERATIONACTIVITY Type: view_entity COMPOSITE

Production Model Operation Activity

I_ProdnModOperationActivity is a Composite CDS View that provides data about "Production Model Operation Activity" in SAP S/4HANA. It reads from 6 data sources and exposes 43 fields with key fields ProductionModelUUID, BOOOperationInternalID, OperationActivity, OperationActyVersionCounter. It has 6 associations to related views.

Data Sources (6)

Source	Alias	Join Type
I_BillOfOperationsOpBasic	BOOOpBasic	inner
I_BOOOperationChgStOANBasic	BOOOperationDetails	inner
I_OpActyNtwkElement	OpactivityNetworkElement	inner
I_BillOfOperationsOperation	Operation	inner
I_OperationActivity	OperationActivity	from
I_ProductionModel	ProductionModel	inner

Associations (6)

Cardinality	Target	Alias	Condition
[0..1]	I_ProductionModelOperation	_Operation	$projection.ProductionModelUUID = _Operation.ProductionModelUUID and $projection.BillOfMaterial = _Operation.BillOfMaterial and $projection.BillOfMaterialVariant = _Operation.BillOfMaterialVariant and $projection.BillOfMaterialCategory = _Operation.BillOfMaterialCategory and $projection.Plant = _Operation.Plant and $projection.BillOfOperationsType = _Operation.BillOfOperationsType and $projection.BillOfOperationsGroup = _Operation.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _Operation.BillOfOperationsVariant and $projection.BillOfOperationsVersion = _Operation.BillOfOperationsVersion and $projection.BOOOperationInternalID = _Operation.BOOOperationInternalID
[0..*]	I_ProdnModOpActyComponent	_OperationActivityComponent	`$projection.ProductionModelUUID = _OperationActivityComponent.ProductionModelUUID and $projection.BOOOperationInternalID = _OperationActivityComponent.BOOOperationInternalID and $projection.OperationActivity = _OperationActivityComponent.OperationActivity and $projection.OperationActyVersionCounter = _OperationActivityComponent.OperationActyVersionCounter`
[0..1]	I_ProductionModel	_ProductionModel	`$projection.ProductionModelUUID = _ProductionModel.ProductionModelUUID`
[0..1]	I_OANSegmentTypeText	_OpActyNtwkSegmentTypeText	`$projection.opactyntwksegmenttype = _OpActyNtwkSegmentTypeText.OpActyNtwkSegmentType and _OpActyNtwkSegmentTypeText.Language = $session.system_language`
[0..1]	I_SASSchemaText	_SASSchemaText	`$projection.OperationActStsAndActnSchema = _SASSchemaText.StatusAndActionSchema and _SASSchemaText.Language = $session.system_language`
[0..1]	I_SASSchemaText	_SFISchemaText	`$projection.SFIStatusAndActionSchema = _SFISchemaText.StatusAndActionSchema and _SFISchemaText.Language = $session.system_language`

Annotations (7)

Name	Value	Level
EndUserText.label	Production Model Operation Activity	view
AccessControl.authorizationCheck	#MANDATORY	view
VDM.viewType	#COMPOSITE	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view

Fields (43)

Key	Field	Source Table	Source Field
KEY	ProductionModelUUID	I_ProductionModel	ProductionModelUUID
KEY	BOOOperationInternalID	I_BillOfOperationsOperation	BOOOperationInternalID
KEY	OperationActivity	I_OperationActivity	OperationActivity
KEY	OperationActyVersionCounter	I_OperationActivity	OperationActyVersionCounter
	BillOfMaterial	I_ProductionModel	BillOfMaterial
	BillOfMaterialVariant	I_ProductionModel	BillOfMaterialVariant
	BillOfMaterialCategory	I_ProductionModel	BillOfMaterialCategory
	BillOfMaterialVariantUsage	I_ProductionModel	BillOfMaterialVariantUsage
	Plant	I_ProductionModel	Plant
	BillOfOperationsGroup	I_ProductionModel	BillOfOperationsGroup
	BillOfOperationsType	I_ProductionModel	BillOfOperationsType
	BillOfOperationsVariant	I_ProductionModel	BillOfOperationsVariant
	OpActyNtwkElementExternalID	I_OpActyNtwkElement	OpActyNtwkElementExternalID
	OperationActivityName
	BOOOpInternalVersionCounter	I_BillOfOperationsOpBasic	BOOOpInternalVersionCounter
	BillOfOperationsVersion	I_BillOfOperationsOpBasic	BillOfOperationsVersion
	OperationExternalID	I_BillOfOperationsOpBasic	OperationExternalID
	Operation	I_BillOfOperationsOpBasic	Operation_2
	OperationText	I_BillOfOperationsOpBasic	OperationText
	LongTextLanguageCode	I_BillOfOperationsOpBasic	LongTextLanguageCode
	OpActyNtwkSegmentType
	OperationActivityNetworkName
	OperationControlProfile	I_BillOfOperationsOpBasic	OperationControlProfile
	OperationActStsAndActnSchema	I_OperationActivity	OperationActStsAndActnSchema
	SFIStatusAndActionSchema	I_OperationActivity	SFIStatusAndActionSchema
	AssemblySqncCheckIsRequired	I_OperationActivity	AssemblySqncCheckIsRequired
	IsReleased	I_OperationActivity	IsReleased
	OpActyInspectionRelevance	I_OperationActivity	OpActyInspectionRelevance
	OriginalChgAlertCount	I_OperationActivity	OriginalChgAlertCount
	OpActyNtwkGroupExternalID	BOOOpActygrp	OpActyNtwkGroupExternalID
	OANElementDisplaySqncNumber	I_OpActyNtwkElement	OANElementDisplaySqncNumber
	OpActyNtwkElement	I_OpActyNtwkElement	OpActyNtwkElement
	OpActyNtwkGroupName	BOOOpActygrp	OpActyNtwkGroupName
	CreatedByUser	I_OperationActivity	CreatedByUser
	CreationDateTime	I_OperationActivity	CreationDateTime
	ChangedBy	I_OperationActivity	ChangedBy
	LastChangeDateTime	I_OperationActivity	LastChangeDateTime
	_Operation		_Operation
	_OperationActivityComponent		_OperationActivityComponent
	_OpActyNtwkSegmentTypeText		_OpActyNtwkSegmentTypeText
	_SASSchemaText		_SASSchemaText
	_SFISchemaText		_SFISchemaText
	_ProductionModel		_ProductionModel

@EndUserText.label: 'Production Model Operation Activity'
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
define view entity I_ProdnModOperationActivity
  as select from           I_OperationActivity         as OperationActivity
    inner join             I_OpActyNtwkElement         as OpactivityNetworkElement on  OpactivityNetworkElement.OpActyNtwkElementElement       = OperationActivity.OperationActivity
                                                                                   and OpactivityNetworkElement.OpActyNtwkElementElmntVersCntr = OperationActivity.OperationActyVersionCounter
                                                                                   and OpactivityNetworkElement.OpActyNtwkElementType          = 3
    inner join             I_BOOOperationChgStOANBasic as BOOOperationDetails      on  BOOOperationDetails.ProduceOpActyNtwk             = OpactivityNetworkElement.OperationActivityNetwork
                                                                                   and BOOOperationDetails.ProduceOpActyNtwkVersCounter  = OpactivityNetworkElement.OpActyNtwkVersionCounter
                                                                                   or  BOOOperationDetails.SetupOpActyNtwk               = OpactivityNetworkElement.OperationActivityNetwork
                                                                                   and BOOOperationDetails.SetupOpActyNtwkVersCounter    = OpactivityNetworkElement.OpActyNtwkVersionCounter
                                                                                   or  BOOOperationDetails.TeardownOpActyNtwk            = OpactivityNetworkElement.OperationActivityNetwork
                                                                                   and BOOOperationDetails.TeardownOpActyNtwkVersCounter = OpactivityNetworkElement.OpActyNtwkVersionCounter
    inner join             I_BillOfOperationsOperation as Operation                on  Operation.BillOfOperationsType   = BOOOperationDetails.BillOfOperationsType
                                                                                   and Operation.BillOfOperationsGroup  = BOOOperationDetails.BillOfOperationsGroup
                                                                                   and Operation.BOOOperationInternalID = BOOOperationDetails.BOOOperationInternalID

    inner join             I_BillOfOperationsOpBasic   as BOOOpBasic               on  BOOOpBasic.BillOfOperationsType    = Operation.BillOfOperationsType
                                                                                   and BOOOpBasic.BillOfOperationsGroup   = Operation.BillOfOperationsGroup
                                                                                   and BOOOpBasic.BOOOperationInternalID  = Operation.BOOOperationInternalID
                                                                                   and BOOOpBasic.BillOfOperationsVersion = BOOOperationDetails.BillOfOperationsVersion
    inner join             I_ProductionModel           as ProductionModel          on  ProductionModel.BillOfOperationsType    = Operation.BillOfOperationsType
                                                                                   and ProductionModel.BillOfOperationsGroup   = Operation.BillOfOperationsGroup
                                                                                   and ProductionModel.BillOfOperationsVariant = Operation.BillOfOperationsVariant
                                                                                   and ProductionModel.BillOfOperationsVersion = BOOOpBasic.BillOfOperationsVersion
    left outer to one join P_ProdnModBOOOPActyGroup    as BOOOpActygrp             on  BOOOpActygrp.OpActyNtwkElementElement       = OperationActivity.OperationActivity
                                                                                   and BOOOpActygrp.OpActyNtwkElementElmntVersCntr = OperationActivity.OperationActyVersionCounter
  association [0..1] to I_ProductionModelOperation as _Operation                  on  $projection.ProductionModelUUID     = _Operation.ProductionModelUUID
                                                                                  and $projection.BillOfMaterial          = _Operation.BillOfMaterial
                                                                                  and $projection.BillOfMaterialVariant   = _Operation.BillOfMaterialVariant
                                                                                  and $projection.BillOfMaterialCategory  = _Operation.BillOfMaterialCategory
                                                                                  and $projection.Plant                   = _Operation.Plant
                                                                                  and $projection.BillOfOperationsType    = _Operation.BillOfOperationsType
                                                                                  and $projection.BillOfOperationsGroup   = _Operation.BillOfOperationsGroup
                                                                                  and $projection.BillOfOperationsVariant = _Operation.BillOfOperationsVariant
                                                                                  and $projection.BillOfOperationsVersion = _Operation.BillOfOperationsVersion
                                                                                  and $projection.BOOOperationInternalID  = _Operation.BOOOperationInternalID
  association [0..*] to I_ProdnModOpActyComponent  as _OperationActivityComponent on  $projection.ProductionModelUUID         = _OperationActivityComponent.ProductionModelUUID
                                                                                  and $projection.BOOOperationInternalID      = _OperationActivityComponent.BOOOperationInternalID
                                                                                  and $projection.OperationActivity           = _OperationActivityComponent.OperationActivity
                                                                                  and $projection.OperationActyVersionCounter = _OperationActivityComponent.OperationActyVersionCounter
  association [0..1] to I_ProductionModel          as _ProductionModel            on  $projection.ProductionModelUUID = _ProductionModel.ProductionModelUUID
  association [0..1] to I_OANSegmentTypeText       as _OpActyNtwkSegmentTypeText  on $projection.opactyntwksegmenttype = _OpActyNtwkSegmentTypeText.OpActyNtwkSegmentType
                                                                                  and _OpActyNtwkSegmentTypeText.Language = $session.system_language
  association [0..1] to I_SASSchemaText            as _SASSchemaText              on $projection.OperationActStsAndActnSchema = _SASSchemaText.StatusAndActionSchema
                                                                                  and _SASSchemaText.Language = $session.system_language
  association [0..1] to I_SASSchemaText            as _SFISchemaText              on $projection.SFIStatusAndActionSchema = _SFISchemaText.StatusAndActionSchema
                                                                                  and _SFISchemaText.Language = $session.system_language
{
  key ProductionModel.ProductionModelUUID,
  key Operation.BOOOperationInternalID,
  key OperationActivity.OperationActivity,
  key OperationActivity.OperationActyVersionCounter,
      ProductionModel.BillOfMaterial,
      ProductionModel.BillOfMaterialVariant,
      ProductionModel.BillOfMaterialCategory,
      ProductionModel.BillOfMaterialVariantUsage,
      ProductionModel.Plant,
      ProductionModel.BillOfOperationsGroup,
      ProductionModel.BillOfOperationsType,
      ProductionModel.BillOfOperationsVariant,
      OpactivityNetworkElement.OpActyNtwkElementExternalID,
      OperationActivity._Text[1:Language = $session.system_language ].OperationActivityName,
      BOOOpBasic.BOOOpInternalVersionCounter,
      BOOOpBasic.BillOfOperationsVersion,
      BOOOpBasic.OperationExternalID,
      BOOOpBasic.Operation_2 as Operation,
      BOOOpBasic.OperationText,
      BOOOpBasic.LongTextLanguageCode,
      OpactivityNetworkElement._OperationActivityNetwork.OpActyNtwkSegmentType,
      OpactivityNetworkElement._OperationActivityNetwork._Text[ 1:Language = $session.system_language ].OperationActivityNetworkName,
      BOOOpBasic.OperationControlProfile,
      OperationActivity.OperationActStsAndActnSchema,
      OperationActivity.SFIStatusAndActionSchema,
      OperationActivity.AssemblySqncCheckIsRequired,
      OperationActivity.IsReleased,
      OperationActivity.OpActyInspectionRelevance,
      OperationActivity.OriginalChgAlertCount,
      BOOOpActygrp.OpActyNtwkGroupExternalID,
      OpactivityNetworkElement.OANElementDisplaySqncNumber,
      OpactivityNetworkElement.OpActyNtwkElement,
      BOOOpActygrp.OpActyNtwkGroupName,
      OperationActivity.CreatedByUser,
      OperationActivity.CreationDateTime,
      OperationActivity.ChangedBy,
      OperationActivity.LastChangeDateTime,
      _Operation,
      _OperationActivityComponent,
      _OpActyNtwkSegmentTypeText,
      _SASSchemaText,
      _SFISchemaText,
      _ProductionModel
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFOPERATIONSOPBASIC",
"I_BILLOFOPERATIONSOPERATION",
"I_BOOOPERATIONCHGSTOANBASIC",
"I_OPACTYNTWKELEMENT",
"I_OPERATIONACTIVITY",
"I_OPERATIONACTIVITYNETWORK",
"I_OPERATIONACTIVITYNTWKTEXT",
"I_OPERATIONACTIVITYTEXT",
"I_PRODUCTIONMODEL",
"P_PRODNMODBOOOPACTYGROUP"
],
"ASSOCIATED":
[
"I_OANSEGMENTTYPETEXT",
"I_PRODNMODOPACTYCOMPONENT",
"I_PRODUCTIONMODEL",
"I_PRODUCTIONMODELOPERATION",
"I_SASSCHEMATEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_ProdnModOperationActivity view_entity

R_ProdnModOperationActivityTP view_entity