Which tables does I_MasterRecipeOperationTP use?

I_MasterRecipeOperationTP reads from 1 data source(s): I_MasterRecipeOperation.

I_MasterRecipeOperationTP

Q: How many fields does I_MasterRecipeOperationTP have?

I_MasterRecipeOperationTP has 42 fields. Key fields: MasterRecipeGroup, MasterRecipe, MasterRecipeOperationIntID, MstrRcpOperationIntVersion.

DDL: I_MASTERRECIPEOPERATIONTP SQL: IMRCOPTP Type: view_entity TRANSACTIONAL

Master Recipe - Operations

I_MasterRecipeOperationTP is a Transactional CDS View that provides data about "Master Recipe - Operations" in SAP S/4HANA. It reads from 1 data source (I_MasterRecipeOperation) and exposes 42 fields with key fields MasterRecipeGroup, MasterRecipe, MasterRecipeOperationIntID, MstrRcpOperationIntVersion. It has 5 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_MasterRecipeOperation	I_MasterRecipeOperation	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..*]	I_MasterRecipePhaseTP	_Phase	`$projection.MasterRecipeGroup = _Phase.MasterRecipeGroup and $projection.MasterRecipe = _Phase.MasterRecipe and $projection.MasterRecipeOperationIntID = _Phase.BOOPhaseSuperiorOpInternalID and $projection.MstrRcpOperationIntVersion = _Phase.MstrRcpOperationIntVersion and $projection.ValidityEndDate >= _Phase.ValidityStartDate and $projection.ValidityStartDate <= _Phase.ValidityEndDate -- to Operations Component Allocations`
[0..*]	I_MasterRecipeOpCompAllocTP	_OpCompAlloc	`$projection.MasterRecipeGroup = _OpCompAlloc.MasterRecipeGroup and $projection.MasterRecipe = _OpCompAlloc.MasterRecipe and $projection.MasterRecipeOperationIntID = _OpCompAlloc.MasterRecipeOperationIntID and $projection.ValidityEndDate >= _OpCompAlloc.ValidityStartDate and $projection.ValidityStartDate <= _OpCompAlloc.ValidityEndDate -- to Operations Secondary Resouces`
[0..*]	I_MasterRecipeOpSecdryRsceTP	_OpSecdryRsce	`$projection.MasterRecipeGroup = _OpSecdryRsce.MasterRecipeGroup and $projection.MasterRecipe = _OpSecdryRsce.MasterRecipe and $projection.MstrRcpOperationIntVersion = _OpSecdryRsce.SuperiorOperationInternalID and $projection.ValidityEndDate >= _OpSecdryRsce.ValidityStartDate and $projection.ValidityStartDate <= _OpSecdryRsce.ValidityEndDate -- for Plain Long Text`
[0..1]	I_TaskListOperationLongText	_LongText	`$projection.MasterRecipeGroup = _LongText.TaskListGroup and $projection.MasterRecipeOperationIntID = _LongText.BOOOperationInternalID and $projection.MstrRcpOperationIntVersion = _LongText.BOOInternalVersionCounter and $projection.LongTextLanguageCode is not null and _LongText.TaskListType = '2' -- for DCLS`
[1..*]	I_MasterRecipeHeaderTP	_Header	`$projection.MasterRecipeGroup = _Header.MasterRecipeGroup and $projection.MasterRecipe = _Header.MasterRecipe and $projection.ValidityEndDate >= _Header.ValidityStartDate and $projection.ValidityStartDate <= _Header.ValidityEndDate -- to top root node`

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Master Recipe - Operations	view
ObjectModel.representativeKey	MstrRcpOperationIntVersion	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (42)

Key	Field	Source Table	Source Field
KEY	MasterRecipeGroup		BillOfOperationsGroup
KEY	MasterRecipe		BillOfOperationsVariant
KEY	MasterRecipeOperationIntID		BOOOperationInternalID
KEY	MstrRcpOperationIntVersion		BOOOpInternalVersionCounter
	Operation		Operation
	OperationText		OperationText
	LongTextLanguageCode		LongTextLanguageCode
	PlainLongText	_LongText	PlainLongText
	WorkCenterTypeCode		WorkCenterTypeCode
	WorkCenterInternalID		WorkCenterInternalID
	OperationStandardTextCode		OperationStandardTextCode
	Plant		Plant
	OperationControlProfile		OperationControlProfile
	OperationReferenceQuantity		OperationReferenceQuantity
	OperationUnit		OperationUnit
	OpQtyToBaseQtyNmrtr		OpQtyToBaseQtyNmrtr
	OpQtyToBaseQtyDnmntr		OpQtyToBaseQtyDnmntr
	NumberOfTimeTickets		NumberOfTimeTickets
	EmployeeWageType		EmployeeWageType
	EmployeeWageGroup		EmployeeWageGroup
	NumberOfConfirmationSlips		NumberOfConfirmationSlips
	NumberOfEmployees		NumberOfEmployees
	OperationCostingRelevancyType		OperationCostingRelevancyType
	BusinessProcess		BusinessProcess
	OperationSetupType		OperationSetupType
	OperationSetupGroupCategory		OperationSetupGroupCategory
	OperationSetupGroup		OperationSetupGroup
	CapacityCategoryCode		CapacityCategoryCode
	CreationDate		CreationDate
	CreatedByUser		CreatedByUser
	LastChangeDate		LastChangeDate
	LastChangedByUser		LastChangedByUser
	ValidityStartDate		ValidityStartDate
	ValidityEndDate		ValidityEndDate
	ChangeNumber		ChangeNumber
	ChangedDateTime	_ActyTP	ChangedDateTime
	_Phase		_Phase
	_OpCompAlloc		_OpCompAlloc
	_OpSecdryRsce		_OpSecdryRsce
	_Header		_Header
	_ActyTP		_ActyTP
	_RcpTP		_RcpTP

//@AbapCatalog.sqlViewName: 'IMRCOPTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Recipe - Operations'
//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.representativeKey: 'MstrRcpOperationIntVersion'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED }
define view entity I_MasterRecipeOperationTP
  as select from I_MasterRecipeOperation
  -- to Phases
  association [0..*] to I_MasterRecipePhaseTP               as _Phase        on  $projection.MasterRecipeGroup          =  _Phase.MasterRecipeGroup
                                                                             and $projection.MasterRecipe               =  _Phase.MasterRecipe
                                                                             and $projection.MasterRecipeOperationIntID =  _Phase.BOOPhaseSuperiorOpInternalID
                                                                             and $projection.MstrRcpOperationIntVersion =  _Phase.MstrRcpOperationIntVersion
                                                                             and $projection.ValidityEndDate            >= _Phase.ValidityStartDate
                                                                             and $projection.ValidityStartDate          <= _Phase.ValidityEndDate
  -- to Operations Component Allocations
  association [0..*] to I_MasterRecipeOpCompAllocTP         as _OpCompAlloc  on  $projection.MasterRecipeGroup          =  _OpCompAlloc.MasterRecipeGroup
                                                                             and $projection.MasterRecipe               =  _OpCompAlloc.MasterRecipe
                                                                             and $projection.MasterRecipeOperationIntID =  _OpCompAlloc.MasterRecipeOperationIntID
                                                                             and $projection.ValidityEndDate            >= _OpCompAlloc.ValidityStartDate
                                                                             and $projection.ValidityStartDate          <= _OpCompAlloc.ValidityEndDate
  -- to Operations Secondary Resouces
  association [0..*] to I_MasterRecipeOpSecdryRsceTP        as _OpSecdryRsce on  $projection.MasterRecipeGroup          =  _OpSecdryRsce.MasterRecipeGroup
                                                                             and $projection.MasterRecipe               =  _OpSecdryRsce.MasterRecipe
                                                                             and $projection.MstrRcpOperationIntVersion =  _OpSecdryRsce.SuperiorOperationInternalID
                                                                             and $projection.ValidityEndDate            >= _OpSecdryRsce.ValidityStartDate
                                                                             and $projection.ValidityStartDate          <= _OpSecdryRsce.ValidityEndDate
  -- for Plain Long Text
  association [0..1] to I_TaskListOperationLongText         as _LongText     on  $projection.MasterRecipeGroup          = _LongText.TaskListGroup
                                                                             and $projection.MasterRecipeOperationIntID = _LongText.BOOOperationInternalID
                                                                             and $projection.MstrRcpOperationIntVersion = _LongText.BOOInternalVersionCounter
                                                                             and $projection.LongTextLanguageCode       is not null
                                                                             and _LongText.TaskListType                 = '2'
  -- for DCLS
  association [1..*] to I_MasterRecipeHeaderTP              as _Header       on  $projection.MasterRecipeGroup =  _Header.MasterRecipeGroup
                                                                             and $projection.MasterRecipe      =  _Header.MasterRecipe
                                                                             and $projection.ValidityEndDate   >= _Header.ValidityStartDate
                                                                             and $projection.ValidityStartDate <= _Header.ValidityEndDate

  -- to top root node
  association        to I_MasterRecipeNonHistoricHdrTP      as _RcpTP        on  $projection.MasterRecipeGroup = _RcpTP.MasterRecipeGroup
                                                                             and $projection.MasterRecipe      = _RcpTP.MasterRecipe

  -- to root node
  association        to parent I_MasterRcpNonHistoricActyTP as _ActyTP       on  $projection.MasterRecipeGroup          = _ActyTP.MasterRecipeGroup
                                                                             and $projection.MasterRecipe               = _ActyTP.MasterRecipe
                                                                             and $projection.MasterRecipeOperationIntID = _ActyTP.MasterRecipeOperationIntID
{
  key BillOfOperationsGroup       as MasterRecipeGroup,
  key BillOfOperationsVariant     as MasterRecipe,
  key BOOOperationInternalID      as MasterRecipeOperationIntID,
  key BOOOpInternalVersionCounter as MstrRcpOperationIntVersion, // Operation Counter

      /* Operation Data */
      Operation,
      @Semantics.text: true
      OperationText,
      @Semantics.language: true
      LongTextLanguageCode,
      @Semantics.text: true
      _LongText.PlainLongText,
      /* Standard Values */
      WorkCenterTypeCode,
      WorkCenterInternalID,
      OperationStandardTextCode,
      Plant,
      OperationControlProfile,
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      OperationReferenceQuantity,
      //      @Semantics.unitOfMeasure: true

      OperationUnit,
      OpQtyToBaseQtyNmrtr,
      OpQtyToBaseQtyDnmntr,
      /* General Data */
      NumberOfTimeTickets,
      @Consumption.hidden: true // For Cloud

      EmployeeWageType,
      @Consumption.hidden: true // For Cloud

      EmployeeWageGroup,
      NumberOfConfirmationSlips,
      @Consumption.hidden: true // For Cloud

      NumberOfEmployees,
      OperationCostingRelevancyType,
      BusinessProcess,
      OperationSetupType,
      OperationSetupGroupCategory,
      OperationSetupGroup,
      CapacityCategoryCode,
      /* Administrative Data */
      CreationDate,
      CreatedByUser,
      LastChangeDate,
      LastChangedByUser,
      @Semantics.businessDate.from: true
      ValidityStartDate,
      @Semantics.businessDate.to: true
      ValidityEndDate,
      ChangeNumber,
      _ActyTP.ChangedDateTime,
      _Phase,
      _OpCompAlloc,
      _OpSecdryRsce,
      @Consumption.hidden: true
      _Header,
      _ActyTP,
      _RcpTP
}
where
      IsDeleted           <> 'X'
  and IsImplicitlyDeleted <> 'X'
  and BOOOperationIsPhase <> 'X'

Depth:

I_MasterRecipeOperationTP view_entity

I_MasterRecipeOperation view

A_MasterRecipeOperation view_entity