C_RecipeSearchItemQtyAnalysis

Recipe Analysis - Search Item Quantity | view: CRCPSRCHITMQTYA | Extraction: Not supported | Component: Recipe Development
Column Name Description
RecipeFinderCacheUUID Cache instance GUID
RecipeFinderCacheLineUUID Cache instance 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
Column Name Description Domain name
RecipeUUID Common Recipe GUID SYSUUID
SourceRecipeUUID Common Recipe GUID SYSUUID
RecipeUniqueID Recipe GUID in character format used in FRW linkage
RecipeDescription Recipe Description TEXT132
Recipe Recipe ID CHAR20
RecipeStatus Recipe Status /PLMB/SAM_STATUS_ID_D
RecipeAuthorizationGroup Recipe Authorization Group
Plant Plant WERKS
RecipePurpose Recipe Purpose /PLMB/RCP_USAGE_ID
RecipeCreatedByUser User Who Created Object (Item) USNAM
CreatedByUserName User Description
CreationDateYear Recipe Created On (Year) /PLMB/RCP_CREATED_YEAR
CreationDateYearMonth Recipe Created On (Year/Month) /PLMB/RCP_CREATED_YEAR_MONTH
RecipeLastChangedByUser User Who Last Changed Object USNAM
LastChangedByUserName User Description
LastChangeDateYear Recipe Changed On (Year) /PLMB/RCP_CHANGED_YEAR
LastChangeDateYearMonth Recipe Changed On (Year/Month) /PLMB/RCP_CHANGED_YEAR_MONTH
RcpValidityStartDateYear Recipe Valid From (Year) /PLMB/RCP_VALID_FRM_YEAR
RcpValidityStartDateYearMonth Recipe Valid From (Year/Month) /PLMB/RCP_VALID_FRM_YEAR_MONTH
RcpValidityEndDateYear Recipe Valid To (Year) /PLMB/RCP_VALID_TO_YEAR
RcpValidityEndDateYearMonth Recipe Valid To (Year / Month) /PLMB/RCP_VALID_TO_YEAR_MONTH
RecipePrimaryOutputInternalID Specification Key
RecipePrimaryOutput Primary Output ID CHAR12
RecipePrimaryOutputDesc Description for Primary Output Specification TEXT132
RecipeVersionNumber Recipe Version CHAR3
RecipeAlternativeNumber Alternative Recipe Identifier CHAR3
Material Material Number MATNR
Specification Specification ID CHAR12
SpecificationInternalID Specification Key
RecipeFinderSearchItem Search Item /PLMB/RCA_CALC_ITEM
RecipeFinderSearchItemDesc Search Item Description /PLMB/RCA_CALC_ITEM_DESC
RecipeWhereUsedResultQtyInPct Average Quantity in % /PLMB/RCA_PERCENT
RecipeFinderSrchItmIsUsdAsDesc Search Item Occurrence in Recipe /PLMB/RCA_SRCH_ITM_OCCRNC_DESC
NumberOfRecipes Number of Recipes /PLMB/RCA_NUMBER_OF_RECIPES
SourceRecipe Source Recipe ID
SourceRecipeDescription Source Recipe Description TEXT132
RecipePrimaryOutputMaterial Recipe Primary Output Material ID MATNR
RecipePrimOutputMaterialName Recipe Primary Output Material Description TEXT132
RecipePrimOutpSubstNatrDesc Specification Substance Nature Description TEXT60
Master Data Relations Join Conditions
Foreign key for substance type
  • Client
  • Recipe Primary Output Specification Type
  • C_RECIPESEARCHITEMQTYANALYSIS.MANDT == TCG31.MANDT
  • C_RECIPESEARCHITEMQTYANALYSIS.RECIPEPRIMOUTPSPECTYPE == TCG31.SUBCAT
Foreign Key for Substance Nature
  • Client
  • Primary Output Substance Nature
  • C_RECIPESEARCHITEMQTYANALYSIS.MANDT == TCG34.MANDT
  • C_RECIPESEARCHITEMQTYANALYSIS.RECIPEPRIMOUTPSUBSTNATR == TCG34.SUBCHAR
Recipe Type
  • Client
  • Recipe Type