C_RecipeFinderResult

Recipe Finder Result | view: CRCPFINDRES | Extraction: Not supported | Component: Recipe Development
Column Name Description
RecipeUUID Common Recipe GUID
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on Which Object (Item) Was Created
LastChangeDate Date on Which Object (Item) Was Last Changed
RecipeValidityStartDate Valid-From Date of a Recipe
RecipeValidityEndDate Valid-To Date of a Recipe
Column Name Description
HighestMessageSeverityLevel Message Severity Show values
RecipeHasValidityEndDate Checkbox Show values
RecipeIngredientIsUsedAs1 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs2 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs3 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs4 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs5 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs6 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs7 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs8 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs9 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs10 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs11 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs12 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs13 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs14 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs15 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs16 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs17 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs18 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs19 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
RecipeIngredientIsUsedAs20 Recipe Ingredient Is Used As (Direct, Indirect, Total) Show values
Column Name Description Domain name
RecipeUniqueID Recipe GUID in character format used in FRW linkage
RecipeFinderFilterRecipeUUID Common Recipe GUID SYSUUID
RecipeDescription Recipe Description
Recipe Recipe ID
NumberOfIssues Recipe Finder Number of Issues /PLMB/RCA_NUMBER_OF_ISSUES
RecipeStatus Recipe Status /PLMB/SAM_STATUS_ID_D
RecipeAuthorizationGroup Recipe Authorization Group
Plant Plant WERKS
RecipePurpose Recipe Purpose
RecipeCreatedByUser User Who Created Object (Item)
CreatedByUserName User Description
RecipeLastChangedByUser User Who Last Changed Object
LastChangedByUserName User Description
RecipePrimaryOutputInternalID Specification Key
RecipePrimaryOutput Primary Output ID CHAR12
RecipeVersionNumber Recipe Version CHAR3
RecipeAlternativeNumber Alternative Recipe Identifier CHAR3
SearchDate Character field, 8 characters long CHAR8
RecipeIngredient Recipe Ingredient ESDSUBID
RecipeIngredientMaterial Material Number MATNR
RecipePrimaryOutputMaterial Recipe Primary Output Material ID MATNR
RecipePrimOutputMaterialName Recipe Primary Output Material Description
RecipePrimOutpSubstNatrDesc Specification Substance Nature Description TEXT60
RecipeComponentItem Recipe Component Item ESDSUBID
RecipeIngredientIsUsedAsDesc1 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc2 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc3 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc4 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc5 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc6 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc7 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc8 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc9 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc10 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc11 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc12 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc13 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc14 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc15 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc16 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc17 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc18 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc19 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
RecipeIngredientIsUsedAsDesc20 Recipe Ingredient Is Used As Description /PLMB/RCP_INGR_IS_USED_AS_DESC
Master Data Relations Join Conditions
Foreign key for substance type
  • Client
  • Recipe Primary Output Specification Type
  • C_RECIPEFINDERRESULT.MANDT == TCG31.MANDT
  • C_RECIPEFINDERRESULT.RECIPEPRIMOUTPSPECTYPE == TCG31.SUBCAT
Foreign Key for Substance Nature
  • Client
  • Primary Output Substance Nature
  • C_RECIPEFINDERRESULT.MANDT == TCG34.MANDT
  • C_RECIPEFINDERRESULT.RECIPEPRIMOUTPSUBSTNATR == TCG34.SUBCHAR
Recipe Type
  • Client
  • Recipe Type