I_MasterRecipeActivity
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 | Field |
|---|---|---|---|
| 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 | Description |
|---|---|---|---|---|
| KEY | BillOfOperationsType | I_MfgBOOSequenceChangeState | BillOfOperationsType | Task List Type |
| KEY | BillOfOperationsGroup | I_MfgBOOSequenceChangeState | BillOfOperationsGroup | Group |
| KEY | BillOfOperationsVariant | I_MfgBOOSequenceChangeState | BillOfOperationsVariant | Group Counter |
| KEY | BillOfOperationsSequence | I_MfgBOOSequenceChangeState | BillOfOperationsSequence | Sequence |
| KEY | BOOOperationInternalID | I_BillOfOperationsOpBasic | BOOOperationInternalID | Task list node |
| KEY | BOOOpInternalVersionCounter | I_BillOfOperationsOpBasic | BOOOpInternalVersionCounter | Counter |
| ValidityStartDate | I_BillOfOperationsOpBasic | ValidityStartDate | Validity Start Date | |
| ValidityEndDateendasValidityEndDate | ||||
| ChangeNumber | I_BillOfOperationsOpBasic | ChangeNumber | Change Number | |
| IsDeletedendasIsDeleted | ||||
| Operation | I_BillOfOperationsOpBasic | Operation | Transaction | |
| SuperiorOperation | I_BillOfOperationsOpBasic | Operation | Transaction | |
| BOOSuperiorOperationIsPhase | I_BillOfOperationsOpBasic | BOOOperationIsPhase | Ind.: Phase | |
| WorkCenterendasWorkCenter | ||||
| Plant | I_BillOfOperationsOpBasic | Plant | Valuation Area | |
| OperationText | I_BillOfOperationsOpBasic | OperationText | Description | |
| LongTextLanguageCode | I_BillOfOperationsOpBasic | LongTextLanguageCode | Language | |
| OperationReferenceQuantity | I_BillOfOperationsOpBasic | OperationReferenceQuantity | Base Quantity | |
| OperationUnit | I_BillOfOperationsOpBasic | OperationUnit | Act/op UoM | |
| OpRefQtyUnitISOCode | ||||
| FactoryCalendar | I_BillOfOperationsOpBasic | FactoryCalendar | Factory Calendar | |
| OpQtyToBaseQtyNmrtr | I_BillOfOperationsOpBasic | OpQtyToBaseQtyNmrtr | Numerator | |
| OpQtyToBaseQtyDnmntr | I_BillOfOperationsOpBasic | OpQtyToBaseQtyDnmntr | Denominator | |
| OperationStandardTextCode | I_BillOfOperationsOpBasic | OperationStandardTextCode | Std Text Key | |
| OperationSetupType | I_BillOfOperationsOpBasic | OperationSetupType | Setup Type Key | |
| OperationSetupGroup | I_BillOfOperationsOpBasic | OperationSetupGroup | Setup group key | |
| OperationSetupGroupCategory | I_BillOfOperationsOpBasic | OperationSetupGroupCategory | Setup group cat | |
| StandardWorkFormulaParamGroup | ||||
| CostCtrActivityType1 | I_BillOfOperationsOpBasic | CostCtrActivityType1 | Activity Type | |
| StandardWorkFormulaParam1 | ||||
| StandardWorkFormulaParamName1 | ||||
| StandardWorkQuantity1 | I_BillOfOperationsOpBasic | StandardWorkQuantity1 | Standard Value | |
| StandardWorkQuantityUnit1 | I_BillOfOperationsOpBasic | StandardWorkQuantityUnit1 | Std value unit | |
| StdWrkQtyUnit1ISOCode | ||||
| CostCtrActivityType2 | I_BillOfOperationsOpBasic | CostCtrActivityType2 | Activity Type | |
| StandardWorkFormulaParam2 | ||||
| StandardWorkFormulaParamName2 | ||||
| StandardWorkQuantity2 | I_BillOfOperationsOpBasic | StandardWorkQuantity2 | Standard Value | |
| StandardWorkQuantityUnit2 | I_BillOfOperationsOpBasic | StandardWorkQuantityUnit2 | Std value unit | |
| StdWrkQtyUnit2ISOCode | ||||
| CostCtrActivityType3 | I_BillOfOperationsOpBasic | CostCtrActivityType3 | Activity Type | |
| StandardWorkFormulaParam3 | ||||
| StandardWorkFormulaParamName3 | ||||
| StandardWorkQuantity3 | I_BillOfOperationsOpBasic | StandardWorkQuantity3 | Standard Value | |
| StandardWorkQuantityUnit3 | I_BillOfOperationsOpBasic | StandardWorkQuantityUnit3 | Std value unit | |
| StdWrkQtyUnit3ISOCode | ||||
| CostCtrActivityType4 | I_BillOfOperationsOpBasic | CostCtrActivityType4 | Activity Type | |
| StandardWorkFormulaParam4 | ||||
| StandardWorkFormulaParamName4 | ||||
| StandardWorkQuantity4 | I_BillOfOperationsOpBasic | StandardWorkQuantity4 | Standard Value | |
| StandardWorkQuantityUnit4 | I_BillOfOperationsOpBasic | StandardWorkQuantityUnit4 | Std value unit | |
| StdWrkQtyUnit4ISOCode | ||||
| CostCtrActivityType5 | I_BillOfOperationsOpBasic | CostCtrActivityType5 | Activity Type | |
| StandardWorkFormulaParam5 | ||||
| StandardWorkFormulaParamName5 | ||||
| StandardWorkQuantity5 | I_BillOfOperationsOpBasic | StandardWorkQuantity5 | Standard Value | |
| StandardWorkQuantityUnit5 | I_BillOfOperationsOpBasic | StandardWorkQuantityUnit5 | Std value unit | |
| StdWrkQtyUnit5ISOCode | ||||
| CostCtrActivityType6 | I_BillOfOperationsOpBasic | CostCtrActivityType6 | Activity Type | |
| StandardWorkFormulaParam6 | ||||
| StandardWorkFormulaParamName6 | ||||
| StandardWorkQuantity6 | I_BillOfOperationsOpBasic | StandardWorkQuantity6 | Standard Value | |
| StandardWorkQuantityUnit6 | I_BillOfOperationsOpBasic | StandardWorkQuantityUnit6 | Std value unit | |
| 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 |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view I_MasterRecipeActivity.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IMSTRRCPACT
CREATE VIEW I_MasterRecipeActivity AS
SELECT
_Sequence.BillOfOperationsType AS BillOfOperationsType,
_Sequence.BillOfOperationsGroup AS BillOfOperationsGroup,
_Sequence.BillOfOperationsVariant AS BillOfOperationsVariant,
_Sequence.BillOfOperationsSequence AS BillOfOperationsSequence,
_Operation.BOOOperationInternalID AS BOOOperationInternalID,
_Operation.BOOOpInternalVersionCounter AS BOOOpInternalVersionCounter,
_Operation.ValidityStartDate AS ValidityStartDate,
case when _Activity.ValidityEndDate < _Operation.ValidityEndDate then _Activity.ValidityEndDate else _Operation.ValidityEndDate end as ValidityEndDate AS ValidityEndDateendasValidityEndDate,
_Operation.ChangeNumber AS ChangeNumber,
case when _Operation.SuperiorOperationInternalID <> '00000000' then _Operation.IsDeleted else _Activity.IsDeleted end as IsDeleted AS IsDeletedendasIsDeleted,
_Operation.Operation AS Operation,
_SuperiorOp.Operation AS SuperiorOperation,
_SuperiorOp.BOOOperationIsPhase AS BOOSuperiorOperationIsPhase,
case when _Operation.BOOPhaseSuperiorOpInternalID <> '00000000' then _SuperiorOp._WorkCenter.WorkCenter else _Operation._WorkCenter.WorkCenter end as WorkCenter AS WorkCenterendasWorkCenter,
_Operation.Plant AS Plant,
_Operation.OperationText AS OperationText,
_Operation.LongTextLanguageCode AS LongTextLanguageCode,
_Operation.OperationReferenceQuantity AS OperationReferenceQuantity,
_Operation.OperationUnit AS OperationUnit,
_Operation._OperationUnit.UnitOfMeasureISOCode AS OpRefQtyUnitISOCode,
_Operation.FactoryCalendar AS FactoryCalendar,
_Operation.OpQtyToBaseQtyNmrtr AS OpQtyToBaseQtyNmrtr,
_Operation.OpQtyToBaseQtyDnmntr AS OpQtyToBaseQtyDnmntr,
_Operation.OperationStandardTextCode AS OperationStandardTextCode,
_Operation.OperationSetupType AS OperationSetupType,
_Operation.OperationSetupGroup AS OperationSetupGroup,
_Operation.OperationSetupGroupCategory AS OperationSetupGroupCategory,
_SuperiorOp._WorkCenter.StandardWorkFormulaParamGroup AS StandardWorkFormulaParamGroup,
_Operation.CostCtrActivityType1 AS CostCtrActivityType1,
_SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter1.StandardWorkFormulaParameter AS StandardWorkFormulaParam1,
_SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter1._Text[1:Language = $session.system_language].StandardWorkFormulaParamName AS StandardWorkFormulaParamName1,
_Operation.StandardWorkQuantity1 AS StandardWorkQuantity1,
_Operation.StandardWorkQuantityUnit1 AS StandardWorkQuantityUnit1,
_Operation._StandardWorkQuantityUnit1.UnitOfMeasureISOCode AS StdWrkQtyUnit1ISOCode,
_Operation.CostCtrActivityType2 AS CostCtrActivityType2,
_SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter2.StandardWorkFormulaParameter AS StandardWorkFormulaParam2,
_SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter2._Text[1:Language = $session.system_language].StandardWorkFormulaParamName AS StandardWorkFormulaParamName2,
_Operation.StandardWorkQuantity2 AS StandardWorkQuantity2,
_Operation.StandardWorkQuantityUnit2 AS StandardWorkQuantityUnit2,
_Operation._StandardWorkQuantityUnit2.UnitOfMeasureISOCode AS StdWrkQtyUnit2ISOCode,
_Operation.CostCtrActivityType3 AS CostCtrActivityType3,
_SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter3.StandardWorkFormulaParameter AS StandardWorkFormulaParam3,
_SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter3._Text[1:Language = $session.system_language].StandardWorkFormulaParamName AS StandardWorkFormulaParamName3,
_Operation.StandardWorkQuantity3 AS StandardWorkQuantity3,
_Operation.StandardWorkQuantityUnit3 AS StandardWorkQuantityUnit3,
_Operation._StandardWorkQuantityUnit3.UnitOfMeasureISOCode AS StdWrkQtyUnit3ISOCode,
_Operation.CostCtrActivityType4 AS CostCtrActivityType4,
_SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter4.StandardWorkFormulaParameter AS StandardWorkFormulaParam4,
_SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter4._Text[1:Language = $session.system_language].StandardWorkFormulaParamName AS StandardWorkFormulaParamName4,
_Operation.StandardWorkQuantity4 AS StandardWorkQuantity4,
_Operation.StandardWorkQuantityUnit4 AS StandardWorkQuantityUnit4,
_Operation._StandardWorkQuantityUnit4.UnitOfMeasureISOCode AS StdWrkQtyUnit4ISOCode,
_Operation.CostCtrActivityType5 AS CostCtrActivityType5,
_SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter5.StandardWorkFormulaParameter AS StandardWorkFormulaParam5,
_SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter5._Text[1:Language = $session.system_language].StandardWorkFormulaParamName AS StandardWorkFormulaParamName5,
_Operation.StandardWorkQuantity5 AS StandardWorkQuantity5,
_Operation.StandardWorkQuantityUnit5 AS StandardWorkQuantityUnit5,
_Operation._StandardWorkQuantityUnit5.UnitOfMeasureISOCode AS StdWrkQtyUnit5ISOCode,
_Operation.CostCtrActivityType6 AS CostCtrActivityType6,
_SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter6.StandardWorkFormulaParameter AS StandardWorkFormulaParam6,
_SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter6._Text[1:Language = $session.system_language].StandardWorkFormulaParamName AS StandardWorkFormulaParamName6,
_Operation.StandardWorkQuantity6 AS StandardWorkQuantity6,
_Operation.StandardWorkQuantityUnit6 AS StandardWorkQuantityUnit6,
_Operation._StandardWorkQuantityUnit6.UnitOfMeasureISOCode AS StdWrkQtyUnit6ISOCode,
_Sequence._BillOfOperationsType AS _BillOfOperationsType,
_Sequence._BillOfOperations AS _BillOfOperations,
_Sequence._BillOfOperationsGroup AS _BillOfOperationsGroup,
_Sequence._BillOfOperationsSequence AS _BillOfOperationsSequence,
_Operation._ChangeMaster AS _ChangeMaster,
_Operation._Plant AS _Plant,
_Operation._FactoryCalendar AS _FactoryCalendar,
_Operation._OperationUnit AS _OperationUnit,
_Operation._OperationStandardText AS _OperationStandardText,
_Operation._OperationSetupType AS _OperationSetupType,
_Operation._OperationSetupGroup AS _OperationSetupGroup,
_Operation._OperationSetupGroupCategory AS _OperationSetupGroupCategory,
_SuperiorOp._WorkCenter._StandardWorkFmlaParamGroup AS _StandardWorkFmlaParamGroup,
_Operation._StandardWorkQuantityUnit1 AS _StandardWorkQuantityUnit1,
_Operation._StandardWorkQuantityUnit2 AS _StandardWorkQuantityUnit2,
_Operation._StandardWorkQuantityUnit3 AS _StandardWorkQuantityUnit3,
_Operation._StandardWorkQuantityUnit4 AS _StandardWorkQuantityUnit4,
_Operation._StandardWorkQuantityUnit5 AS _StandardWorkQuantityUnit5,
_Operation._StandardWorkQuantityUnit6 AS _StandardWorkQuantityUnit6
FROM I_MfgBOOSequenceChangeState AS _Sequence
INNER JOIN I_BOOSqncOperationAssgmtChgSt AS _Activity ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillOfOperationsOpBasic AS _Operation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BillOfOperationsOpBasic AS _SuperiorOp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON _WorkCenter.WorkCenterInternalID = WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = 'A' -- association [0..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA