ESH_S_SPECIFICATION

Search view -SPECIFICATION | view: ESH_U_SPEC | Extraction: Not supported | Component: Specification
Tables used: /PLMB/AUTH_OBSID, /PLMB/AUTH_SIDRP, /PLMB/AUTH_UGUSR, /PLMB/AUTH_UGSID, /PLMB/SAM_OBJST, ESH_SR_LTXT, DRAD, UST10S, UST12, HRP7600, /PLMB/RFO_FRMITM, /PLMB/RCP_TY_GEN, ESTMJ, TCG36, TCG37, /PLMB/SAM_NODE_T, ESTRI, /PLMB/SEA_OBJMAP, ESTRH, TCG31, TCG32, USR21, /PLMB/SEA_OBJMAP, DRAD_LAST_CHANGE, /PLMB/RCP_RECIPE, AGR_1016, /PLMB/AUTH_OT_AC, /PLMB/AUTH_ACT_E, /PLMI/SPC_TYPVAL, TCG31OBJ
Column Name Description
SPECIFICATIONINTERNALID Sequential Number of Data Record
Column Name Description
Column Name Description
Column Name Description
SPECIFICATIONCREATIONDATE Date of Creation
SPECIFICATIONVALIDITYENDDATE Valid-To Date
SPECIFICATIONVALIDITYSTARTDATE Valid-From Date
Column Name Description
LOGACCMOBJECTTYPEISACTIVE Access Control Activated for Object Type Show values
RCPFMLAITEMTYPE Formula Item Type Show values
Column Name Description Domain name
LOGACCMCONTEXT Context
LOGACCMOBJECTTYPE Object Type /PLMB/GOS_OBJECT_TYPE
PLAINLONGTEXT Long Text
RCPFMLAITEMUUID Formula Item GUID SYSUUID
RCPFMLAUUID Formula GUID SYSUUID
SPECIDFGDESCTEXT Identifier TEXT132
SPECIFICATION Specification /PLMB/SPC_EXT_ID_API
SPECIFICATIONAUTHZNGROUPDESC Authorization Group Description TEXT40
SPECIFICATIONHEADERSTATUS Status Identification /PLMB/SAM_STATUS_ID_D
SPECIFICATIONHEADERSTATUSDESC Status Description /PLMB/SAM_ACTION_DESCRIPTION_D
SPECIFICATIONTYPEDESCRIPTION Specification Type Description TEXT40
SPECIFICATIONCREATEDBYNAME User Description
Master Data Relations Join Conditions
Document number
  • ?
  • ?
  • Client
  • ?
  • Document number
  • ESH_S_SPECIFICATION.[column in domain "DOKAR"] == DRAW.DOKAR
  • ESH_S_SPECIFICATION.[column in domain "DOKTL_D"] == DRAW.DOKTL
  • ESH_S_SPECIFICATION.MANDT == DRAW.MANDT
  • ESH_S_SPECIFICATION.[column in domain "DOKVR"] == DRAW.DOKVR
  • ESH_S_SPECIFICATION.DOCUMENTINFORECORDDOCNUMBER == DRAW.DOKNR
Foreign key for material
  • Client
  • Material Number
  • ESH_S_SPECIFICATION.MANDT == MARA.MANDT
  • ESH_S_SPECIFICATION.MATERIAL == MARA.MATNR
Foreign key for identification category ESH_S_SPECIFICATION.SPECIDFGDESCCATEGORY == TCG21.IDTYPE
Foreign Key for Language Identifier ESH_S_SPECIFICATION.SPECIDFGDESCLANGUAGE == T002.SPRAS
Identification Type
  • Identification Type
  • Client
  • Identification Category
  • ESH_S_SPECIFICATION.SPECIDFGDESCTYPE == TCG23.IDCAT
  • ESH_S_SPECIFICATION.MANDT == TCG23.MANDT
  • ESH_S_SPECIFICATION.SPECIDFGDESCCATEGORY == TCG23.IDTYPE
Recipe Authorization Group
  • Recipe Authorization Group
  • Client
  • ESH_S_SPECIFICATION.SPECIFICATIONAUTHZNGROUP == TCG36.AUTHGRP
  • ESH_S_SPECIFICATION.MANDT == TCG36.MANDT
Specification Category ESH_S_SPECIFICATION.SPECIFICATIONCATEGORY == TCGOBJ.OBJTYPE
Foreign Key for Change Number
  • Change number
  • Client
  • ESH_S_SPECIFICATION.SPECIFICATIONCHANGENUMBER == AENR.AENNR
  • ESH_S_SPECIFICATION.MANDT == AENR.MANDT
Address key assignment to users
  • Client
  • User ID
  • ESH_S_SPECIFICATION.MANDT == USR02.MANDT
  • ESH_S_SPECIFICATION.SPECIFICATIONCREATEDBYUSER == USR02.BNAME
Foreign Key for Substance Nature
  • Client
  • Substance Nature
  • ESH_S_SPECIFICATION.MANDT == TCG34.MANDT
  • ESH_S_SPECIFICATION.SPECIFICATIONSUBSTANCENATR == TCG34.SUBCHAR
Foreign key for substance type
  • Client
  • Specification Type
  • ESH_S_SPECIFICATION.MANDT == TCG31.MANDT
  • ESH_S_SPECIFICATION.SPECIFICATIONTYPE == TCG31.SUBCAT