I_MasterRecipeActivity

Q: Which tables does I_MasterRecipeActivity use?

I_MasterRecipeActivity reads from 4 data source(s): I_BOOSqncOperationAssgmtChgSt, I_BillOfOperationsOpBasic, I_MfgBOOSequenceChangeState, I_BillOfOperationsOpBasic.

Q: How many fields does I_MasterRecipeActivity have?

I_MasterRecipeActivity has 84 fields. Key fields: BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsSequence, BOOOperationInternalID.

DDL: I_MASTERRECIPEACTIVITY SQL: IMSTRRCPACT Type: view_entity COMPOSITE Package: VDM_PP_MD_MRC

Master Recipe Activity(Opr,Phs,SecRes) Details

I_MasterRecipeActivity is a Composite CDS View that provides data about "Master Recipe Activity(Opr,Phs,SecRes) Details" in SAP S/4HANA. It reads from 4 data sources (I_BOOSqncOperationAssgmtChgSt, I_BillOfOperationsOpBasic, I_MfgBOOSequenceChangeState, I_BillOfOperationsOpBasic) and exposes 84 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsSequence, BOOOperationInternalID. It has 1 association to related views. Part of development package VDM_PP_MD_MRC.

Data Sources (4)

Source	Alias	Join Type
I_BOOSqncOperationAssgmtChgSt	_Activity	inner
I_BillOfOperationsOpBasic	_Operation	inner
I_MfgBOOSequenceChangeState	_Sequence	from
I_BillOfOperationsOpBasic	_SuperiorOp	left_outer

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_WorkCenter	_WorkCenter	`_WorkCenter.WorkCenterInternalID = $projection.WorkCenterInternalID and _WorkCenter.WorkCenterTypeCode = 'A'`

Annotations (9)

Name	Value	Level
VDM.viewType	#COMPOSITE	view
ObjectModel.representativeKey	BOOOpInternalVersionCounter	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Master Recipe Activity(Opr,Phs,SecRes) Details	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MASTER	view
Metadata.allowExtensions	true	view
AccessControl.personalData.blocking	#REQUIRED	view

Fields (84)

Key	Field	Source Table	Source Field
KEY	BillOfOperationsType	I_MfgBOOSequenceChangeState	BillOfOperationsType
KEY	BillOfOperationsGroup	I_MfgBOOSequenceChangeState	BillOfOperationsGroup
KEY	BillOfOperationsVariant	I_MfgBOOSequenceChangeState	BillOfOperationsVariant
KEY	BillOfOperationsSequence	I_MfgBOOSequenceChangeState	BillOfOperationsSequence
KEY	BOOOperationInternalID	I_BillOfOperationsOpBasic	BOOOperationInternalID
KEY	BOOOpInternalVersionCounter	I_BillOfOperationsOpBasic	BOOOpInternalVersionCounter
	ValidityStartDate	I_BillOfOperationsOpBasic	ValidityStartDate
	ValidityEndDateendasValidityEndDate
	ChangeNumber	I_BillOfOperationsOpBasic	ChangeNumber
	IsDeletedendasIsDeleted
	Operation	I_BillOfOperationsOpBasic	Operation
	SuperiorOperation	I_BillOfOperationsOpBasic	Operation
	BOOSuperiorOperationIsPhase	I_BillOfOperationsOpBasic	BOOOperationIsPhase
	WorkCenterendasWorkCenter
	Plant	I_BillOfOperationsOpBasic	Plant
	OperationText	I_BillOfOperationsOpBasic	OperationText
	LongTextLanguageCode	I_BillOfOperationsOpBasic	LongTextLanguageCode
	OperationReferenceQuantity	I_BillOfOperationsOpBasic	OperationReferenceQuantity
	OperationUnit	I_BillOfOperationsOpBasic	OperationUnit
	OpRefQtyUnitISOCode
	FactoryCalendar	I_BillOfOperationsOpBasic	FactoryCalendar
	OpQtyToBaseQtyNmrtr	I_BillOfOperationsOpBasic	OpQtyToBaseQtyNmrtr
	OpQtyToBaseQtyDnmntr	I_BillOfOperationsOpBasic	OpQtyToBaseQtyDnmntr
	OperationStandardTextCode	I_BillOfOperationsOpBasic	OperationStandardTextCode
	OperationSetupType	I_BillOfOperationsOpBasic	OperationSetupType
	OperationSetupGroup	I_BillOfOperationsOpBasic	OperationSetupGroup
	OperationSetupGroupCategory	I_BillOfOperationsOpBasic	OperationSetupGroupCategory
	StandardWorkFormulaParamGroup
	CostCtrActivityType1	I_BillOfOperationsOpBasic	CostCtrActivityType1
	StandardWorkFormulaParam1
	StandardWorkFormulaParamName1
	StandardWorkQuantity1	I_BillOfOperationsOpBasic	StandardWorkQuantity1
	StandardWorkQuantityUnit1	I_BillOfOperationsOpBasic	StandardWorkQuantityUnit1
	StdWrkQtyUnit1ISOCode
	CostCtrActivityType2	I_BillOfOperationsOpBasic	CostCtrActivityType2
	StandardWorkFormulaParam2
	StandardWorkFormulaParamName2
	StandardWorkQuantity2	I_BillOfOperationsOpBasic	StandardWorkQuantity2
	StandardWorkQuantityUnit2	I_BillOfOperationsOpBasic	StandardWorkQuantityUnit2
	StdWrkQtyUnit2ISOCode
	CostCtrActivityType3	I_BillOfOperationsOpBasic	CostCtrActivityType3
	StandardWorkFormulaParam3
	StandardWorkFormulaParamName3
	StandardWorkQuantity3	I_BillOfOperationsOpBasic	StandardWorkQuantity3
	StandardWorkQuantityUnit3	I_BillOfOperationsOpBasic	StandardWorkQuantityUnit3
	StdWrkQtyUnit3ISOCode
	CostCtrActivityType4	I_BillOfOperationsOpBasic	CostCtrActivityType4
	StandardWorkFormulaParam4
	StandardWorkFormulaParamName4
	StandardWorkQuantity4	I_BillOfOperationsOpBasic	StandardWorkQuantity4
	StandardWorkQuantityUnit4	I_BillOfOperationsOpBasic	StandardWorkQuantityUnit4
	StdWrkQtyUnit4ISOCode
	CostCtrActivityType5	I_BillOfOperationsOpBasic	CostCtrActivityType5
	StandardWorkFormulaParam5
	StandardWorkFormulaParamName5
	StandardWorkQuantity5	I_BillOfOperationsOpBasic	StandardWorkQuantity5
	StandardWorkQuantityUnit5	I_BillOfOperationsOpBasic	StandardWorkQuantityUnit5
	StdWrkQtyUnit5ISOCode
	CostCtrActivityType6	I_BillOfOperationsOpBasic	CostCtrActivityType6
	StandardWorkFormulaParam6
	StandardWorkFormulaParamName6
	StandardWorkQuantity6	I_BillOfOperationsOpBasic	StandardWorkQuantity6
	StandardWorkQuantityUnit6	I_BillOfOperationsOpBasic	StandardWorkQuantityUnit6
	StdWrkQtyUnit6ISOCode
	_BillOfOperationsType	I_MfgBOOSequenceChangeState	_BillOfOperationsType
	_BillOfOperations	I_MfgBOOSequenceChangeState	_BillOfOperations
	_BillOfOperationsGroup	I_MfgBOOSequenceChangeState	_BillOfOperationsGroup
	_BillOfOperationsSequence	I_MfgBOOSequenceChangeState	_BillOfOperationsSequence
	_ChangeMaster	I_BillOfOperationsOpBasic	_ChangeMaster
	_Plant	I_BillOfOperationsOpBasic	_Plant
	_FactoryCalendar	I_BillOfOperationsOpBasic	_FactoryCalendar
	_OperationUnit	I_BillOfOperationsOpBasic	_OperationUnit
	_OperationStandardText	I_BillOfOperationsOpBasic	_OperationStandardText
	_OperationSetupType	I_BillOfOperationsOpBasic	_OperationSetupType
	_OperationSetupGroup	I_BillOfOperationsOpBasic	_OperationSetupGroup
	_OperationSetupGroupCategory	I_BillOfOperationsOpBasic	_OperationSetupGroupCategory
	_StandardWorkFmlaParamGroup
	_StandardWorkQuantityUnit1	I_BillOfOperationsOpBasic	_StandardWorkQuantityUnit1
	_StandardWorkQuantityUnit2	I_BillOfOperationsOpBasic	_StandardWorkQuantityUnit2
	_StandardWorkQuantityUnit3	I_BillOfOperationsOpBasic	_StandardWorkQuantityUnit3
	_StandardWorkQuantityUnit4	I_BillOfOperationsOpBasic	_StandardWorkQuantityUnit4
	_StandardWorkQuantityUnit5	I_BillOfOperationsOpBasic	_StandardWorkQuantityUnit5
	_StandardWorkQuantityUnit6	I_BillOfOperationsOpBasic	_StandardWorkQuantityUnit6
	_WorkCenter		_WorkCenter

//@AbapCatalog.sqlViewName: 'IMSTRRCPACT'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'BOOOpInternalVersionCounter'
//@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Recipe Activity(Opr,Phs,SecRes) Details'
@ObjectModel.usageType: { serviceQuality: #D, sizeCategory: #XXL, dataClass: #MASTER }
@Metadata.allowExtensions: true
@AccessControl.personalData.blocking: #REQUIRED
//define view I_MasterRecipeActivity

define view entity I_MasterRecipeActivity
  as select from    I_MfgBOOSequenceChangeState   as _Sequence
    inner join      I_BOOSqncOperationAssgmtChgSt as _Activity   on  _Sequence.BillOfOperationsType     =  _Activity.BillOfOperationsType
                                                                 and _Sequence.BillOfOperationsGroup    =  _Activity.BillOfOperationsGroup
                                                                 and _Sequence.BillOfOperationsVariant  =  _Activity.BillOfOperationsVariant
                                                                 and _Sequence.BillOfOperationsSequence =  _Activity.BillOfOperationsSequence
                                                                 and _Activity.IsDeleted                <> 'X'
    inner join      I_BillOfOperationsOpBasic     as _Operation  on  _Activity.BillOfOperationsType     = _Operation.BillOfOperationsType
                                                                 and _Activity.BillOfOperationsGroup    = _Operation.BillOfOperationsGroup
                                                                 and (
                                                                    _Activity.BOOOperationInternalID    = _Operation.BOOOperationInternalID
                                                                    or _Activity.BOOOperationInternalID = _Operation.SuperiorOperationInternalID
                                                                  )
    left outer join I_BillOfOperationsOpBasic     as _SuperiorOp on  _Activity.BillOfOperationsType           = _SuperiorOp.BillOfOperationsType
                                                                 and _Activity.BillOfOperationsGroup          = _SuperiorOp.BillOfOperationsGroup
                                                                 and (
                                                                    _Operation.BOOPhaseSuperiorOpInternalID   = _SuperiorOp.BOOOperationInternalID
                                                                    or _Operation.SuperiorOperationInternalID = _SuperiorOp.BOOOperationInternalID
                                                                  )
                                                                 and _SuperiorOp.ValidityEndDate              >= $session.system_date
  //  -- to WorkCenter

  association [0..1] to I_WorkCenter as _WorkCenter on  _WorkCenter.WorkCenterInternalID = $projection.WorkCenterInternalID
                                                    and _WorkCenter.WorkCenterTypeCode   = 'A'
{
  key _Sequence.BillOfOperationsType,
  key _Sequence.BillOfOperationsGroup,
  key _Sequence.BillOfOperationsVariant,
  key _Sequence.BillOfOperationsSequence,
  key _Operation.BOOOperationInternalID,
  key _Operation.BOOOpInternalVersionCounter,
      _Operation.ValidityStartDate,
      case
      when _Activity.ValidityEndDate < _Operation.ValidityEndDate
      then _Activity.ValidityEndDate
      else _Operation.ValidityEndDate
      end                                                                                                                                                          as ValidityEndDate,
      _Operation.ChangeNumber,
      case
      when _Operation.SuperiorOperationInternalID <> '00000000'
      then _Operation.IsDeleted
      else _Activity.IsDeleted
      end                                                                                                                                                          as IsDeleted,
      case
      when _Operation.SuperiorOperationInternalID <> '00000000'
      then _Operation.IsImplicitlyDeleted
      else _Activity.IsImplicitlyDeleted
      end                                                                                                                                                          as IsImplicitlyDeleted,
      _Operation.Operation,
      case
      when _Operation.SuperiorOperationInternalID <> '00000000'
      then _Operation.SuperiorOperationInternalID
      else _Operation.BOOPhaseSuperiorOpInternalID
      end                                                                                                                                                          as SuperiorOperationInternalID,
      _SuperiorOp.Operation                                                                                                                                        as SuperiorOperation,
      _SuperiorOp.BOOOperationIsPhase                                                                                                                              as BOOSuperiorOperationIsPhase,
      case
      when _Operation.BOOPhaseSuperiorOpInternalID <> '00000000'
      then 'X'
      end                                                                                                                                                          as BOOOperationIsPhase,
      case
      when _Operation.SuperiorOperationInternalID <> '00000000'
      then 'X'
      end                                                                                                                                                          as BOOOperationIsSecdryRsce,
      case
      when _Operation.BOOPhaseSuperiorOpInternalID <> '00000000'
      then _SuperiorOp.WorkCenterInternalID
      else _Operation.WorkCenterInternalID
      end                                                                                                                                                          as WorkCenterInternalID,
      case
      when _Operation.BOOPhaseSuperiorOpInternalID <> '00000000'
      then _SuperiorOp._WorkCenter.WorkCenter
      else _Operation._WorkCenter.WorkCenter
      end                                                                                                                                                          as WorkCenter,
      _Operation.Plant,
      _Operation.OperationText,
      _Operation.LongTextLanguageCode,
      _Operation.OperationReferenceQuantity,
      _Operation.OperationUnit,
      _Operation._OperationUnit.UnitOfMeasureISOCode                                                                                                               as OpRefQtyUnitISOCode,
      _Operation.FactoryCalendar,
      case
      when _Operation._WorkCenter.OpControlProfileIsReferenced = 'X'
      then _Operation._WorkCenter.OperationControlProfile
      when _Operation.BOOOperationIsPhase = 'X' and _SuperiorOp._WorkCenter.OpControlProfileIsReferenced = 'X'
      then _SuperiorOp._WorkCenter.OperationControlProfile
      else _Operation.OperationControlProfile
      end                                                                                                                                                          as OperationControlProfile,
      _Operation.OpQtyToBaseQtyNmrtr,
      _Operation.OpQtyToBaseQtyDnmntr,
      _Operation.OperationStandardTextCode,
      _Operation.OperationSetupType,
      _Operation.OperationSetupGroup,
      _Operation.OperationSetupGroupCategory,
      _SuperiorOp._WorkCenter.StandardWorkFormulaParamGroup,
      _Operation.CostCtrActivityType1,
      _SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter1.StandardWorkFormulaParameter                                              as StandardWorkFormulaParam1,
      _SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter1._Text[1:Language = $session.system_language].StandardWorkFormulaParamName as StandardWorkFormulaParamName1,
      _Operation.StandardWorkQuantity1,
      _Operation.StandardWorkQuantityUnit1,
      _Operation._StandardWorkQuantityUnit1.UnitOfMeasureISOCode                                                                                                   as StdWrkQtyUnit1ISOCode,
      _Operation.CostCtrActivityType2,
      _SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter2.StandardWorkFormulaParameter                                              as StandardWorkFormulaParam2,
      _SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter2._Text[1:Language = $session.system_language].StandardWorkFormulaParamName as StandardWorkFormulaParamName2,
      _Operation.StandardWorkQuantity2,
      _Operation.StandardWorkQuantityUnit2,
      _Operation._StandardWorkQuantityUnit2.UnitOfMeasureISOCode                                                                                                   as StdWrkQtyUnit2ISOCode,
      _Operation.CostCtrActivityType3,
      _SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter3.StandardWorkFormulaParameter                                              as StandardWorkFormulaParam3,
      _SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter3._Text[1:Language = $session.system_language].StandardWorkFormulaParamName as StandardWorkFormulaParamName3,
      _Operation.StandardWorkQuantity3,
      _Operation.StandardWorkQuantityUnit3,
      _Operation._StandardWorkQuantityUnit3.UnitOfMeasureISOCode                                                                                                   as StdWrkQtyUnit3ISOCode,
      _Operation.CostCtrActivityType4,
      _SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter4.StandardWorkFormulaParameter                                              as StandardWorkFormulaParam4,
      _SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter4._Text[1:Language = $session.system_language].StandardWorkFormulaParamName as StandardWorkFormulaParamName4,
      _Operation.StandardWorkQuantity4,
      _Operation.StandardWorkQuantityUnit4,
      _Operation._StandardWorkQuantityUnit4.UnitOfMeasureISOCode                                                                                                   as StdWrkQtyUnit4ISOCode,
      _Operation.CostCtrActivityType5,
      _SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter5.StandardWorkFormulaParameter                                              as StandardWorkFormulaParam5,
      _SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter5._Text[1:Language = $session.system_language].StandardWorkFormulaParamName as StandardWorkFormulaParamName5,
      _Operation.StandardWorkQuantity5,
      _Operation.StandardWorkQuantityUnit5,
      _Operation._StandardWorkQuantityUnit5.UnitOfMeasureISOCode                                                                                                   as StdWrkQtyUnit5ISOCode,
      _Operation.CostCtrActivityType6,
      _SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter6.StandardWorkFormulaParameter                                              as StandardWorkFormulaParam6,
      _SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter6._Text[1:Language = $session.system_language].StandardWorkFormulaParamName as StandardWorkFormulaParamName6,
      _Operation.StandardWorkQuantity6,
      _Operation.StandardWorkQuantityUnit6,
      _Operation._StandardWorkQuantityUnit6.UnitOfMeasureISOCode                                                                                                   as StdWrkQtyUnit6ISOCode,
      /*                        Associations                                            */
      _Sequence._BillOfOperationsType,
      _Sequence._BillOfOperations,
      _Sequence._BillOfOperationsGroup,
      _Sequence._BillOfOperationsSequence,
      _Operation._ChangeMaster,
      _Operation._Plant,
      _Operation._FactoryCalendar,
      _Operation._OperationUnit,
      _Operation._OperationStandardText,
      _Operation._OperationSetupType,
      _Operation._OperationSetupGroup,
      _Operation._OperationSetupGroupCategory,
      _SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup,
      _Operation._StandardWorkQuantityUnit1,
      _Operation._StandardWorkQuantityUnit2,
      _Operation._StandardWorkQuantityUnit3,
      _Operation._StandardWorkQuantityUnit4,
      _Operation._StandardWorkQuantityUnit5,
      _Operation._StandardWorkQuantityUnit6,
      _WorkCenter
      //      _LongText.PlainLongText

}
where
      _Sequence.BillOfOperationsType =  '2'
  and _Operation.ValidityEndDate     >=  _Operation.ValidityStartDate
  and _Sequence.IsDeleted            <> 'X'

Depth:

I_MasterRecipeActivity view_entity

I_MfgBOOSequenceChangeState view
I_BillOfOperationsOpBasic view
I_BOOSqncOperationAssgmtChgSt view_entity
I_BillOfOperationsOpBasic view

C_MasterRecipeActivity view_entity