I_ProdnModOperationActivity

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 51 fields with key fields ProductionModelUUID, BillOfOperationsVersion, BOOOperationInternalID, OperationActivity, OperationActyVersionCounter. It has 8 associations to related views.

6 data source(s) 51 fields

Data Sources (6)

SourceAliasJoin Type
I_BOOOperationChgStOANBasic BOOOperationDetails inner
I_ProdnModBOOVersBOMAssgmt BOOVersion inner
I_OpActyNtwkElement OpactivityNetworkElement inner
P_ProdnModBOOOperation Operation inner
I_OperationActivity OperationActivity from
I_ProductionModelBasic ProductionModel inner

Associations (8)

CardinalityTargetAliasCondition
[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.BillOfOperationsVersion = _OperationActivityComponent.BillOfOperationsVersion and $projection.BOOOperationInternalID = _OperationActivityComponent.BOOOperationInternalID and $projection.OperationActivity = _OperationActivityComponent.OperationActivity and $projection.OperationActyVersionCounter = _OperationActivityComponent.OperationActyVersionCounter
[0..1] I_ProductionModel _ProductionModel $projection.ProductionModelUUID = _ProductionModel.ProductionModelUUID and $projection.BillOfOperationsVersion = _ProductionModel.BillOfOperationsVersion
[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
[0..1] I_BOOOpActyGroupTypeText _BOOOpActyGrpTypeText $projection.OpActyNtwkGroupType = _BOOOpActyGrpTypeText.OpActyNtwkGroupType and _BOOOpActyGrpTypeText.Language = $session.system_language
[0..1] I_OpActyNtwkGroupText _GroupText $projection.OperationActivityNetworkGroup = _GroupText.OperationActivityNetworkGroup and $projection.OpActyNtwkGroupVersionCounter = _GroupText.OpActyNtwkGroupVersionCounter and _GroupText.Language = $session.system_language

Annotations (7)

NameValueLevelField
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 (51)

KeyFieldSource TableSource FieldDescription
KEY ProductionModelUUID I_ProductionModelBasic ProductionModelUUID
KEY BillOfOperationsVersion I_ProdnModBOOVersBOMAssgmt BillOfOperationsVersion
KEY BOOOperationInternalID P_ProdnModBOOOperation BOOOperationInternalID
KEY OperationActivity I_OperationActivity OperationActivity
KEY OperationActyVersionCounter I_OperationActivity OperationActyVersionCounter
BOOOpInternalVersionCounter P_ProdnModBOOOperation BOOOpInternalVersionCounter
BillOfMaterial I_ProductionModelBasic BillOfMaterial
BillOfMaterialVariant I_ProductionModelBasic BillOfMaterialVariant
BillOfMaterialCategory I_ProductionModelBasic BillOfMaterialCategory
BillOfMaterialVariantUsage I_ProductionModelBasic BillOfMaterialVariantUsage
Plant I_ProductionModelBasic Plant
BillOfOperationsGroup I_ProductionModelBasic BillOfOperationsGroup
BillOfOperationsType I_ProductionModelBasic BillOfOperationsType
BillOfOperationsVariant I_ProductionModelBasic BillOfOperationsVariant
OpActyNtwkElementExternalID I_OpActyNtwkElement OpActyNtwkElementExternalID
OperationActivityName
OperationExternalID P_ProdnModBOOOperation OperationExternalID
Operation P_ProdnModBOOOperation Operation_2
OperationText P_ProdnModBOOOperation OperationText
LongTextLanguageCode P_ProdnModBOOOperation LongTextLanguageCode
OpActyNtwkSegmentType
OperationControlProfile P_ProdnModBOOOperation 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
OperationActivityNetworkGroup BOOOpActyGrp OperationActivityNetworkGroup
OpActyNtwkGroupVersionCounter BOOOpActyGrp OpActyNtwkGroupVersionCounter
OpActyNtwkGroupType BOOOpActyGrp OpActyNtwkGroupType
OpActyNtwkGroupParentElement BOOOpActyGrp OpActyNtwkGroupParentElement
ShopFloorRoutingTemplateType BOORoutingTemplate ShopFloorRoutingTemplateType
ShopFloorRtgTemplateGroup I_OperationActivity ShopFloorRtgTemplateGroup
ShopFloorRtgTemplateGrpVariant I_OperationActivity ShopFloorRtgTemplateGrpVariant
ShopFloorRtgTemplateVersion I_OperationActivity ShopFloorRtgTemplateVersion
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
_BOOOpActyGrpTypeText _BOOOpActyGrpTypeText
_GroupText _GroupText
_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             P_ProdnModBOOOperation      as Operation                on  Operation.BillOfOperationsType    = BOOOperationDetails.BillOfOperationsType
                                                                                   and Operation.BillOfOperationsGroup   = BOOOperationDetails.BillOfOperationsGroup
                                                                                   and Operation.BOOOperationInternalID  = BOOOperationDetails.BOOOperationInternalID
                                                                                   and Operation.BillOfOperationsVersion = BOOOperationDetails.BillOfOperationsVersion
    inner join             I_ProdnModBOOVersBOMAssgmt  as BOOVersion               on  BOOVersion.BillOfOperationsType    = Operation.BillOfOperationsType
                                                                                   and BOOVersion.BillOfOperationsGroup   = Operation.BillOfOperationsGroup
                                                                                   and BOOVersion.BillOfOperationsVariant = Operation.BillOfOperationsVariant
                                                                                   and BOOVersion.BillOfOperationsVersion = Operation.BillOfOperationsVersion
    inner join             I_ProductionModelBasic      as ProductionModel          on  ProductionModel.BillOfOperationsType    = BOOVersion.BillOfOperationsType
                                                                                   and ProductionModel.BillOfOperationsGroup   = BOOVersion.BillOfOperationsGroup
                                                                                   and ProductionModel.BillOfOperationsVariant = BOOVersion.BillOfOperationsVariant
    left outer to one join P_ProdnModBOOOPActyGroup    as BOOOpActyGrp             on  BOOOpActyGrp.OpActyNtwkElementElement       = OperationActivity.OperationActivity
                                                                                   and BOOOpActyGrp.OpActyNtwkElementElmntVersCntr = OperationActivity.OperationActyVersionCounter
    left outer to one join I_BillOfOperations          as BOORoutingTemplate       on  BOORoutingTemplate.BillOfOperationsType    = OperationActivity.ShopFloorRtgTmplTaskListType
                                                                                   and BOORoutingTemplate.BillOfOperationsGroup   = OperationActivity.ShopFloorRtgTemplateGroup
                                                                                   and BOORoutingTemplate.BillOfOperationsVariant = OperationActivity.ShopFloorRtgTemplateGrpVariant
  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.BillOfOperationsVersion     = _OperationActivityComponent.BillOfOperationsVersion
                                                                                  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
                                                                                  and $projection.BillOfOperationsVersion = _ProductionModel.BillOfOperationsVersion
  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
  association [0..1] to I_BOOOpActyGroupTypeText   as _BOOOpActyGrpTypeText       on  $projection.OpActyNtwkGroupType = _BOOOpActyGrpTypeText.OpActyNtwkGroupType
                                                                                  and _BOOOpActyGrpTypeText.Language  = $session.system_language
  association [0..1] to I_OpActyNtwkGroupText      as _GroupText                  on  $projection.OperationActivityNetworkGroup = _GroupText.OperationActivityNetworkGroup
                                                                                  and $projection.OpActyNtwkGroupVersionCounter = _GroupText.OpActyNtwkGroupVersionCounter
                                                                                  and _GroupText.Language                       = $session.system_language

{
  key ProductionModel.ProductionModelUUID,
  key BOOVersion.BillOfOperationsVersion,
  key Operation.BOOOperationInternalID,
  key OperationActivity.OperationActivity,
  key OperationActivity.OperationActyVersionCounter,
      Operation.BOOOpInternalVersionCounter,
      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,
      Operation.OperationExternalID,
      Operation.Operation_2 as Operation,
      Operation.OperationText,
      Operation.LongTextLanguageCode,
      OpactivityNetworkElement._OperationActivityNetwork.OpActyNtwkSegmentType,
      Operation.OperationControlProfile,
      OperationActivity.OperationActStsAndActnSchema,
      OperationActivity.SFIStatusAndActionSchema,
      OperationActivity.AssemblySqncCheckIsRequired,
      OperationActivity.IsReleased,
      OperationActivity.OpActyInspectionRelevance,
      OperationActivity.OriginalChgAlertCount,
      BOOOpActyGrp.OpActyNtwkGroupExternalID,
      OpactivityNetworkElement.OANElementDisplaySqncNumber,
      OpactivityNetworkElement.OpActyNtwkElement,
      BOOOpActyGrp.OperationActivityNetworkGroup,
      BOOOpActyGrp.OpActyNtwkGroupVersionCounter,
      //  BOOOpActyGrp.OpActyNtwkGroupName,

      BOOOpActyGrp.OpActyNtwkGroupType,
      BOOOpActyGrp.OpActyNtwkGroupParentElement,
      BOORoutingTemplate.ShopFloorRoutingTemplateType,
      OperationActivity.ShopFloorRtgTemplateGroup,
      OperationActivity.ShopFloorRtgTemplateGrpVariant,
      OperationActivity.ShopFloorRtgTemplateVersion,
      OperationActivity.CreatedByUser,
      OperationActivity.CreationDateTime,
      OperationActivity.ChangedBy,
      OperationActivity.LastChangeDateTime,
      _Operation,
      _OperationActivityComponent,
      _OpActyNtwkSegmentTypeText,
      _SASSchemaText,
      _SFISchemaText,
      _BOOOpActyGrpTypeText,
      _GroupText,
      _ProductionModel
}

Learn More