Which tables does I_ProdnModOperationActivity use?

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

I_ProdnModOperationActivity

Q: How many fields does I_ProdnModOperationActivity have?

I_ProdnModOperationActivity has 31 fields. Key fields: ProductionModelUUID, BillOfMaterial, BillOfMaterialVariant, BillOfMaterialCategory, BillOfMaterialVariantUsage.

DDL: I_PRODNMODOPERATIONACTIVITY Type: view_entity COMPOSITE Package: MPE_PRODUCTION_MODEL_CDS

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 8 data sources and exposes 31 fields with key fields ProductionModelUUID, BillOfMaterial, BillOfMaterialVariant, BillOfMaterialCategory, BillOfMaterialVariantUsage. It has 2 associations to related views. Part of development package MPE_PRODUCTION_MODEL_CDS.

Data Sources (8)

Source	Alias	Join Type
I_BillOfOperationsOpBasic	BOOOanBasic	inner
I_BillOfOperationsOperation	BOOOperation	inner
I_BOOOperationChgStOANBasic	BOOOperationDetails	inner
P_BOOVersBOMAssgmtLatest	LatestBOMAssignment	inner
I_OpActyNtwkElement	OpactivityNetworkElement	inner
I_OperationActivity	OperationActivity	from
I_OperationActivityText	OperationActivitytext	inner
I_ProductionModel	ProductionModel	inner

Associations (2)

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..1]	I_ProductionModel	_ProductionModel	`$projection.ProductionModelUUID = _ProductionModel.ProductionModelUUID`

Annotations (7)

Name	Value	Level
EndUserText.label	Production Model Operation Activity	view
AccessControl.authorizationCheck	#NOT_REQUIRED	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 (31)

Key	Field	Source Table	Source Field
KEY	ProductionModelUUID	I_ProductionModel	ProductionModelUUID
KEY	BillOfMaterial
KEY	BillOfMaterialVariant	P_BOOVersBOMAssgmtLatest	BillOfMaterialVariant
KEY	BillOfMaterialCategory	P_BOOVersBOMAssgmtLatest	BillOfMaterialCategory
KEY	BillOfMaterialVariantUsage	P_BOOVersBOMAssgmtLatest	BillOfMaterialVariantUsage
KEY	Plant	P_BOOVersBOMAssgmtLatest	Plant
KEY	BillOfOperationsGroup	P_BOOVersBOMAssgmtLatest	BillOfOperationsGroup
KEY	BillOfOperationsType	P_BOOVersBOMAssgmtLatest	BillOfOperationsType
KEY	BillOfOperationsVariant	P_BOOVersBOMAssgmtLatest	BillOfOperationsVariant
KEY	BOOOperationInternalID	I_BillOfOperationsOpBasic	BOOOperationInternalID
KEY	OperationActivity	I_OperationActivity	OperationActivity
	OperationActivityName
	OperationActyVersionCounter	I_OperationActivity	OperationActyVersionCounter
	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
	OperationControlProfile	I_BillOfOperationsOpBasic	OperationControlProfile
	OperationActStsAndActnSchema	I_OperationActivity	OperationActStsAndActnSchema
	SFIStatusAndActionSchema	I_OperationActivity	SFIStatusAndActionSchema
	AssemblySqncCheckIsRequired	I_OperationActivity	AssemblySqncCheckIsRequired
	IsReleased	I_OperationActivity	IsReleased
	OriginalChgAlertCount	I_OperationActivity	OriginalChgAlertCount
	CreatedByUser	I_OperationActivity	CreatedByUser
	CreationDateTime	I_OperationActivity	CreationDateTime
	ChangedBy	I_OperationActivity	ChangedBy
	LastChangeDateTime	I_OperationActivity	LastChangeDateTime
	_Operation		_Operation
	_ProductionModel		_ProductionModel

@EndUserText.label: 'Production Model Operation Activity'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@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_OperationActivityText     as OperationActivitytext    on  OperationActivitytext.OperationActivity           = OperationActivity.OperationActivity
                                                                         and OperationActivitytext.OperationActyVersionCounter = OperationActivity.OperationActyVersionCounter
                                                                         and OperationActivitytext.Language                    = $session.system_language

    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
    inner join   I_BillOfOperationsOperation as BOOOperation

                                                                         on  BOOOperation.BillOfOperationsGroup  = BOOOperationDetails.BillOfOperationsGroup
                                                                         and BOOOperation.BillOfOperationsType   = BOOOperationDetails.BillOfOperationsType
                                                                         and BOOOperation.BOOOperationInternalID = BOOOperationDetails.BOOOperationInternalID

    inner join   I_BillOfOperationsOpBasic   as BOOOanBasic              on  BOOOanBasic.BillOfOperationsType        = BOOOperation.BillOfOperationsType
                                                                         and BOOOanBasic.BillOfOperationsGroup       = BOOOperation.BillOfOperationsGroup
                                                                         and BOOOanBasic.BOOOperationInternalID      = BOOOperation.BOOOperationInternalID
                                                                         and BOOOanBasic.BOOOpInternalVersionCounter = BOOOperationDetails.BOOOpInternalVersionCounter
                                                                         and BOOOanBasic.BillOfOperationsVersion     = BOOOperationDetails.BillOfOperationsVersion

    inner join   P_BOOVersBOMAssgmtLatest    as LatestBOMAssignment      on  LatestBOMAssignment.BillOfOperationsType    = BOOOperationDetails.BillOfOperationsType
                                                                         and LatestBOMAssignment.BillOfOperationsGroup   = BOOOperationDetails.BillOfOperationsGroup
                                                                         and LatestBOMAssignment.BillOfOperationsVariant = BOOOperation.BillOfOperationsVariant
                                                                         and LatestBOMAssignment.BillOfOperationsVersion = BOOOperationDetails.BillOfOperationsVersion
    inner join   I_ProductionModel           as ProductionModel          on  ProductionModel.BillOfMaterial          = LatestBOMAssignment.BillOfMaterial
                                                                         and ProductionModel.BillOfMaterialVariant   = LatestBOMAssignment.BillOfMaterialVariant
                                                                         and ProductionModel.BillOfMaterialCategory  = LatestBOMAssignment.BillOfMaterialCategory
                                                                         and ProductionModel.Plant                   = LatestBOMAssignment.Plant
                                                                         and ProductionModel.BillOfMaterialVersion   = LatestBOMAssignment.BillOfMaterialVersion
                                                                         and ProductionModel.BillOfOperationsType    = LatestBOMAssignment.BillOfOperationsType
                                                                         and ProductionModel.BillOfOperationsGroup   = LatestBOMAssignment.BillOfOperationsGroup
                                                                         and ProductionModel.BillOfOperationsVariant = LatestBOMAssignment.BillOfOperationsVariant
                                                                         and ProductionModel.BillOfOperationsVersion = LatestBOMAssignment.BillOfOperationsVersion
  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..1] to I_ProductionModel          as _ProductionModel on  $projection.ProductionModelUUID = _ProductionModel.ProductionModelUUID


{
  key ProductionModel.ProductionModelUUID,
  key cast( LatestBOMAssignment.BillOfMaterial as cs_stlnr ) as BillOfMaterial,
  key LatestBOMAssignment.BillOfMaterialVariant,
  key LatestBOMAssignment.BillOfMaterialCategory,
  key LatestBOMAssignment.BillOfMaterialVariantUsage,
  key LatestBOMAssignment.Plant,
  key LatestBOMAssignment.BillOfOperationsGroup,
  key LatestBOMAssignment.BillOfOperationsType,
  key LatestBOMAssignment.BillOfOperationsVariant,
  key BOOOanBasic.BOOOperationInternalID,
  key OperationActivity.OperationActivity,
      OperationActivity._Text[1:Language = $session.system_language ].OperationActivityName,
      OperationActivity.OperationActyVersionCounter,
      BOOOanBasic.BOOOpInternalVersionCounter,
      BOOOanBasic.BillOfOperationsVersion,
      BOOOanBasic.OperationExternalID,
      BOOOanBasic.Operation_2                                as Operation,
      BOOOanBasic.OperationText,
      BOOOanBasic.LongTextLanguageCode,
      BOOOanBasic.OperationControlProfile,
      OperationActivity.OperationActStsAndActnSchema,
      OperationActivity.SFIStatusAndActionSchema,
      OperationActivity.AssemblySqncCheckIsRequired,
      OperationActivity.IsReleased,
      OperationActivity.OriginalChgAlertCount,
      OperationActivity.CreatedByUser,
      OperationActivity.CreationDateTime,
      OperationActivity.ChangedBy,
      OperationActivity.LastChangeDateTime,
      _Operation,
      _ProductionModel
}

Depth:

I_ProdnModOperationActivity view_entity

R_ProdnModOperationActivityTP view_entity