ESH_N_RECIPE

Anchor view -RECIPE | view: ESH_L_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 ATNAM
CHARCDESCRIPTION Characteristic Description TEXT30
CHARCFROMDECIMALVALUE Lower Boundary for Numeric Field
CHARCTODECIMALVALUE Upper Boundary for Numeric Field
CHARCVALUE Characteristic Value ATWRT
CHARCVALUEDESCRIPTION Characteristic value description ATWRT
CLASS Class number KLASSE
CLASSKEYWORDTEXT Keywords TEXT40
LOGACCMCONTEXT Context CHAR24
PRIMOUTPLOGACCMOBJECTTYPE Object Type /PLMB/GOS_OBJECT_TYPE
LOGACCMOBJECTTYPE Object Type /PLMB/GOS_OBJECT_TYPE
INPUTMATERIAL Material Number MATNR
MATERIAL Material Number MATNR
OUTPUTSTREAMMATERIAL Material Number MATNR
SECONDARYOUTPUTMATERIAL Material Number MATNR
PLAINLONGTEXT Long Text
PLANT Plant WERKS
RECIPE Recipe ID CHAR20
RECIPEALTERNATIVENUMBER Alternative Recipe Identifier CHAR3
RECIPEAUTHORIZATIONGROUP Recipe Authorization Group /PLMB/RCP_AUTHGRP
RECIPECHANGENUMBER Change Number AENNR
RECIPECREATEDBYUSER User Who Created Object (Item) USNAM
RECIPECREATIONDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
RECIPEDESCRIPTION Recipe Description TEXT132
RECIPELASTCHANGEDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
RECIPELASTCHANGEDBYUSER User Who Last Changed Object USNAM
RECIPEPROCESSELEMENTDESC Recipe Description TEXT132
RECIPEPROCESSEQUIPRQMTDESC Recipe Description TEXT132
RECIPEPROCESSPARAM Process Parameter Master Data - Legible Name / ID
RECIPEPROCESSPARAMDESC Recipe Description TEXT132
RECIPEPROCESSPARAMTGTVAL Target Value /PLMB/RPR_PP_VAL
RECIPEPROCESSPARAMVALUEDESC Recipe Description TEXT132
RECIPEPURPOSE Recipe Purpose /PLMB/RCP_USAGE_ID
RECIPESTATUS Recipe Status /PLMB/SAM_STATUS_ID_D
RECIPETYPEDESCRIPTION Description of Recipe Type /PLMB/RCP_TYPE_DESCR
RECIPEVALIDITYMAXQUANTITY Quantity To /PLMB/RCP_DECFLOAT_34
RECIPEVALIDITYMINQUANTITY Quantity From /PLMB/RCP_DECFLOAT_34
RECIPEVERSIONNUMBER Recipe Version CHAR3
SPECIFICATION Specification /PLMB/SPC_EXT_ID_API
STREAMOUTPUTSPECIFICATION Specification /PLMB/SPC_EXT_ID_API
SECOUTPUTFORMULASPECIFICATION Specification /PLMB/SPC_EXT_ID_API
INPUTFORMULASPECIFICATION Specification /PLMB/SPC_EXT_ID_API
STSACTNMGMTSTATUSTEXT Status Description /PLMB/SAM_ACTION_DESCRIPTION_D
USERDESCRIPTION User Description SUIDTECHDESC
LASTCHANGEDBYUSERDESC User Description SUIDTECHDESC
Master Data Relations Join Conditions
Class Number
  • Client
  • Internal Class Number
  • ESH_N_RECIPE.MANDT == KLAH.MANDT
  • ESH_N_RECIPE.CLASSINTERNALID == KLAH.CLINT
Class Type
  • Client
  • Class Type
  • ESH_N_RECIPE.MANDT == TCLA.MANDT
  • ESH_N_RECIPE.CLASSTYPE == TCLA.KLART
Document number
  • ?
  • Client
  • ?
  • Document number
  • ?
  • ESH_N_RECIPE.[column in domain "DOKAR"] == DRAW.DOKAR
  • ESH_N_RECIPE.MANDT == DRAW.MANDT
  • ESH_N_RECIPE.[column in domain "DOKVR"] == DRAW.DOKVR
  • ESH_N_RECIPE.DOCUMENTINFORECORDDOCNUMBER == DRAW.DOKNR
  • ESH_N_RECIPE.[column in domain "DOKTL_D"] == DRAW.DOKTL
Recipe Type
  • Client
  • Recipe Type
Recipe Authorization Group
  • Client
  • Recipe Authorization Group
  • Recipe Authorization Group
  • ESH_N_RECIPE.MANDT == TCG36.MANDT
  • ESH_N_RECIPE.RECIPEAUTHORIZATIONGROUP == TCG36.AUTHGRP
  • ESH_N_RECIPE.SPECIFICATIONAUTHZNGROUP == TCG36.AUTHGRP
Foreign key for substance type
  • Client
  • Specification Type
  • ESH_N_RECIPE.MANDT == TCG31.MANDT
  • ESH_N_RECIPE.SPECIFICATIONTYPE == TCG31.SUBCAT