C_MasterRecipeActivity

DDL: C_MASTERRECIPEACTIVITY Type: view_entity CONSUMPTION
37 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Master Recipe Activity

C_MasterRecipeActivity is a Consumption CDS View that provides data about "Master Recipe Activity" in SAP S/4HANA. It reads from 1 data source (I_MasterRecipeActivity) and exposes 37 fields with key fields BillOfOperationsType, MasterRecipeGroup, MasterRecipe, BillOfOperationsSequence, BOOOperationInternalID. It has 1 association to related views. It is exposed through 1 OData service (UI_PRODUCTIONVERSION). It is used in 1 Fiori application: Process Production Versions.

Data Sources (1)

SourceAliasJoin Type
I_MasterRecipeActivity I_MasterRecipeActivity from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_RoutingHeader _RoutingHeader _RoutingHeader.BillOfOperationsType = $projection.BillOfOperationsType and _RoutingHeader.BillOfOperationsGroup = $projection.MasterRecipeGroup and _RoutingHeader.BillOfOperationsVariant = $projection.MasterRecipe and _RoutingHeader.ValidityStartDate <= $session.system_date and _RoutingHeader.ValidityEndDate >= $session.system_date

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Master Recipe Activity view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PRODUCTIONVERSION UI_PRODUCTIONVERSION V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F6400 Process Production Versions Transactional With this app, you can view the following details: Existing production versions Proposals for creating a new production version if a new BOM / Task List is created or if a production version does not exist for a BOM/Task list combination Production versions if there are any inconsistencies related to missing information

Process Production Versions

Business Role: Others

With this app, you can achieve the following: View and edit existing production versions Create new production versions Mass lock and unlock of Production versions Mass consistency check of existing production versions View all proposals that are generated when a new production version if a new BOM / Task List is created or if a production version does not exist for a BOM/Task list combination. Accept or Reject Proposals in a individual manner or through mass action. Delete selected production versions

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType BillOfOperationsType Task List Type
KEY MasterRecipeGroup BillOfOperationsGroup Group
KEY MasterRecipe BillOfOperationsVariant Group Counter
KEY BillOfOperationsSequence BillOfOperationsSequence Sequence
KEY BOOOperationInternalID BOOOperationInternalID Task list node
KEY BOOOpInternalVersionCounter BOOOpInternalVersionCounter Counter
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
Operation Transaction
SuperiorOperationInternalID SuperiorOperationInternalID Sup. Op. Node
SuperiorOperation Transaction
StandardWorkFormulaParamName1 StandardWorkFormulaParamName1
StandardWorkQuantity1 StandardWorkQuantity1 Standard Value
StandardWorkQuantityUnit1 StandardWorkQuantityUnit1 Std value unit
StandardWorkFormulaParamName2 StandardWorkFormulaParamName2
StandardWorkQuantity2 StandardWorkQuantity2 Standard Value
StandardWorkQuantityUnit2 StandardWorkQuantityUnit2 Std value unit
StandardWorkFormulaParamName3 StandardWorkFormulaParamName3
StandardWorkQuantity3 StandardWorkQuantity3 Standard Value
StandardWorkQuantityUnit3 StandardWorkQuantityUnit3 Std value unit
StandardWorkFormulaParamName4 StandardWorkFormulaParamName4
StandardWorkQuantity4 StandardWorkQuantity4 Standard Value
StandardWorkQuantityUnit4 StandardWorkQuantityUnit4 Std value unit
StandardWorkFormulaParamName5 StandardWorkFormulaParamName5
StandardWorkQuantity5 StandardWorkQuantity5 Standard Value
StandardWorkQuantityUnit5 StandardWorkQuantityUnit5 Std value unit
StandardWorkFormulaParamName6 StandardWorkFormulaParamName6
StandardWorkQuantity6 StandardWorkQuantity6 Standard Value
StandardWorkQuantityUnit6 StandardWorkQuantityUnit6 Std value unit
BOOOperationIsPhase BOOOperationIsPhase
OperationText OperationText Description
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenter WorkCenter Work Center
Plant Plant Valuation Area
WorkCenterDesc
_RoutingHeader _RoutingHeader
_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 C_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.

CREATE VIEW C_MasterRecipeActivity AS
SELECT
  BillOfOperationsType,
  BillOfOperationsGroup AS MasterRecipeGroup,
  BillOfOperationsVariant AS MasterRecipe,
  BillOfOperationsSequence,
  BOOOperationInternalID,
  BOOOpInternalVersionCounter,
  ValidityStartDate,
  ValidityEndDate,
  cast( Operation as abap.char( 4 ) ) AS Operation,
  SuperiorOperationInternalID,
  cast( SuperiorOperation as abap.char( 4 ) ) AS SuperiorOperation,
  StandardWorkFormulaParamName1,
  StandardWorkQuantity1,
  StandardWorkQuantityUnit1,
  StandardWorkFormulaParamName2,
  StandardWorkQuantity2,
  StandardWorkQuantityUnit2,
  StandardWorkFormulaParamName3,
  StandardWorkQuantity3,
  StandardWorkQuantityUnit3,
  StandardWorkFormulaParamName4,
  StandardWorkQuantity4,
  StandardWorkQuantityUnit4,
  StandardWorkFormulaParamName5,
  StandardWorkQuantity5,
  StandardWorkQuantityUnit5,
  StandardWorkFormulaParamName6,
  StandardWorkQuantity6,
  StandardWorkQuantityUnit6,
  BOOOperationIsPhase,
  OperationText,
  WorkCenterInternalID,
  WorkCenter,
  Plant,
  _WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterDesc
FROM I_MasterRecipeActivity
LEFT OUTER JOIN I_RoutingHeader AS _RoutingHeader ON _RoutingHeader.BillOfOperationsType = BillOfOperationsType AND _RoutingHeader.BillOfOperationsGroup = MasterRecipeGroup AND _RoutingHeader.BillOfOperationsVariant = MasterRecipe AND _RoutingHeader.ValidityStartDate <= $session.system_date AND _RoutingHeader.ValidityEndDate >= $session.system_date  -- association [1..1]
;

Learn More