ESH_S_RECIPE

Search view -RECIPE | view: ESH_U_RECIPE | Extraction: Not supported | Component: Recipe
Tables used: /PLMB/AUTH_OBSID, /PLMB/AUTH_SIDRP, /PLMB/AUTH_UGUSR, /PLMB/AUTH_UGSID, ESH_SR_LTXT, DRAD, CABN, CABNT, CAWN, CAWNT, KLAH, SWOR, AUSP, KSSK, UST10S, UST12, HRP7600, /PLMB/RCP_PLNT, /PLMB/RFO_FRMITM, /PLMB/RPR_PE, /PLMB/RCP_DESCR, /PLMB/RCP_DESCR, /PLMB/RPR_PP_M, /PLMB/RCP_DESCR, /PLMB/RPR_PP_VAL, /PLMB/RCP_DESCR, /PLMB/RCP_DESCR, /PLMB/RCP_TY_GEN, /PLMB/RCP_TY_DES, ESTRH, /PLMB/SAM_NODE_T, USR21, CLF_HDR, DRAD_LAST_CHANGE, /PLMB/RCP_RECIPE, /PLMB/RPR_EQR, AGR_1016, /PLMB/AUTH_OT_AC, /PLMB/AUTH_ACT_E, /PLMI/SPC_TYPVAL
Column Name Description
RECIPEUUID Common Recipe GUID
Column Name Description
💲 Currency Key (CURRENCY):
CHARCFROMAMOUNT Lower Boundary for Currency Field
CHARCTOAMOUNT Upper Boundary for Currency Field
Column Name Description
Column Name Description
CHARCFROMDATE Lower Boundary for Date-Interval
CHARCFROMTIME Lower Boundary for Time-Interval
CHARCTODATE Upper Boundary for Date-Interval
CHARCTOTIME Upper Boundary for Time-Interval
RECIPEVALIDITYENDDATE Valid-To Date of a Recipe
RECIPEVALIDITYSTARTDATE Valid-From Date of a Recipe
Column Name Description
PRIMOUTPLOGACCMOBJTYPEISACTV Access Control Activated for Object Type Show values
LOGACCMOBJECTTYPEISACTIVE Access Control Activated for Object Type Show values
RECIPEISARCHIVED Marked for Archiving Show values
RECIPEISDELETED Marked for Deletion Show values
Column Name Description Domain name
CHARACTERISTIC Characteristic Name
CHARCDESCRIPTION Characteristic Description
CHARCFROMDECIMALVALUE Lower Boundary for Numeric Field
CHARCTODECIMALVALUE Upper Boundary for Numeric Field
CHARCVALUE Characteristic Value
CHARCVALUEDESCRIPTION Characteristic value description
CLASS Class number KLASSE
CLASSKEYWORDTEXT Keywords
LOGACCMCONTEXT Context
PRIMOUTPLOGACCMOBJECTTYPE Object Type /PLMB/GOS_OBJECT_TYPE
LOGACCMOBJECTTYPE Object Type /PLMB/GOS_OBJECT_TYPE
INPUTMATERIAL Material Number
MATERIAL Material Number
OUTPUTSTREAMMATERIAL Material Number
SECONDARYOUTPUTMATERIAL Material Number
PLAINLONGTEXT Long Text
PLANT Plant WERKS
RECIPE Recipe ID
RECIPEALTERNATIVENUMBER Alternative Recipe Identifier CHAR3
RECIPEAUTHORIZATIONGROUP Recipe Authorization Group
RECIPECHANGENUMBER Change Number AENNR
RECIPECREATEDBYUSER User Who Created Object (Item) USNAM
RECIPECREATIONDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
RECIPEDESCRIPTION Recipe Description TEXT132
RECIPELASTCHANGEDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
RECIPELASTCHANGEDBYUSER User Who Last Changed Object
RECIPEPROCESSELEMENTDESC Recipe Description
RECIPEPROCESSEQUIPRQMTDESC Recipe Description
RECIPEPROCESSPARAM Process Parameter Master Data - Legible Name / ID
RECIPEPROCESSPARAMDESC Recipe Description
RECIPEPROCESSPARAMTGTVAL Target Value
RECIPEPROCESSPARAMVALUEDESC Recipe Description
RECIPEPURPOSE Recipe Purpose /PLMB/RCP_USAGE_ID
RECIPESTATUS Recipe Status /PLMB/SAM_STATUS_ID_D
RECIPETYPEDESCRIPTION Description of Recipe Type
RECIPEVALIDITYMAXQUANTITY Quantity To /PLMB/RCP_DECFLOAT_34
RECIPEVALIDITYMINQUANTITY Quantity From /PLMB/RCP_DECFLOAT_34
RECIPEVERSIONNUMBER Recipe Version CHAR3
SPECIFICATION Specification
STREAMOUTPUTSPECIFICATION Specification
SECOUTPUTFORMULASPECIFICATION Specification
INPUTFORMULASPECIFICATION Specification
STSACTNMGMTSTATUSTEXT Status Description
USERDESCRIPTION User Description
LASTCHANGEDBYUSERDESC User Description
Master Data Relations Join Conditions
Class Number
  • Client
  • Internal Class Number
  • ESH_S_RECIPE.MANDT == KLAH.MANDT
  • ESH_S_RECIPE.CLASSINTERNALID == KLAH.CLINT
Class Type
  • Class Type
  • Client
  • ESH_S_RECIPE.CLASSTYPE == TCLA.KLART
  • ESH_S_RECIPE.MANDT == TCLA.MANDT
Document number
  • ?
  • ?
  • ?
  • Client
  • Document number
  • ESH_S_RECIPE.[column in domain "DOKAR"] == DRAW.DOKAR
  • ESH_S_RECIPE.[column in domain "DOKVR"] == DRAW.DOKVR
  • ESH_S_RECIPE.[column in domain "DOKTL_D"] == DRAW.DOKTL
  • ESH_S_RECIPE.MANDT == DRAW.MANDT
  • ESH_S_RECIPE.DOCUMENTINFORECORDDOCNUMBER == DRAW.DOKNR
Recipe Type
  • Client
  • Recipe Type
Recipe Authorization Group
  • Recipe Authorization Group
  • Recipe Authorization Group
  • Client
  • ESH_S_RECIPE.SPECIFICATIONAUTHZNGROUP == TCG36.AUTHGRP
  • ESH_S_RECIPE.RECIPEAUTHORIZATIONGROUP == TCG36.AUTHGRP
  • ESH_S_RECIPE.MANDT == TCG36.MANDT
Foreign key for substance type
  • Client
  • Specification Type
  • ESH_S_RECIPE.MANDT == TCG31.MANDT
  • ESH_S_RECIPE.SPECIFICATIONTYPE == TCG31.SUBCAT