I_RecipeProcessElementAssgmt

DDL: I_RECIPEPROCESSELEMENTASSGMT SQL: IRPRASSIGN Type: view BASIC Package: VDM_PLMB_RFO

Recipe Process Element Assignment

I_RecipeProcessElementAssgmt is a Basic CDS View that provides data about "Recipe Process Element Assignment" in SAP S/4HANA. It reads from 1 data source (/plmb/rcp_assign) and exposes 6 fields with key fields RecipeUUID, RcpFmlaItemSourceFmlaItemUUID. It has 3 associations to related views. Part of development package VDM_PLMB_RFO.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
/plmb/rcp_assign /plmb/rcp_assign from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Recipe _Recipe $projection.RecipeUUID = _Recipe.RecipeUUID
[1..1] I_RecipeFormulaItem _RecipeFormulaItem $projection.RcpFmlaItemSourceFmlaItemUUID = _RecipeFormulaItem.RcpFmlaItemSourceFmlaItemUUID and $projection.RecipeUUID = _RecipeFormulaItem.RecipeUUID
[1..1] I_RecipeProcessElement _RecipeProcessElement $projection.RecipeProcessElementUUID = _RecipeProcessElement.RecipeProcessElementUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRPRASSIGN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view
EndUserText.label Recipe Process Element Assignment view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY RecipeUUID rcp_guid
KEY RcpFmlaItemSourceFmlaItemUUID item_guid
RecipeProcessElementUUID pe_guid
_Recipe _Recipe
_RecipeFormulaItem _RecipeFormulaItem
_RecipeProcessElement _RecipeProcessElement 
@AbapCatalog.sqlViewName: 'IRPRASSIGN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #BASIC

@EndUserText.label: 'Recipe Process Element Assignment'

define view I_RecipeProcessElementAssgmt
  as select from /plmb/rcp_assign
  association [1..1] to I_Recipe               as _Recipe               on  $projection.RecipeUUID = _Recipe.RecipeUUID
  association [1..1] to I_RecipeFormulaItem    as _RecipeFormulaItem    on  $projection.RcpFmlaItemSourceFmlaItemUUID = _RecipeFormulaItem.RcpFmlaItemSourceFmlaItemUUID
                                                                        and $projection.RecipeUUID                    = _RecipeFormulaItem.RecipeUUID
  association [1..1] to I_RecipeProcessElement as _RecipeProcessElement on  $projection.RecipeProcessElementUUID = _RecipeProcessElement.RecipeProcessElementUUID
{
  key rcp_guid  as RecipeUUID,
  key item_guid as RcpFmlaItemSourceFmlaItemUUID,
      pe_guid   as RecipeProcessElementUUID,

      _Recipe,
      _RecipeFormulaItem,
      _RecipeProcessElement
}

Learn More