ESH_N_SPECIFICATION

Anchor view -SPECIFICATION | view: ESH_L_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 CHAR24
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 SUIDTECHDESC
Master Data Relations Join Conditions
Document number
  • ?
  • Client
  • ?
  • ?
  • Document number
  • ESH_N_SPECIFICATION.[column in domain "DOKTL_D"] == DRAW.DOKTL
  • ESH_N_SPECIFICATION.MANDT == DRAW.MANDT
  • ESH_N_SPECIFICATION.[column in domain "DOKVR"] == DRAW.DOKVR
  • ESH_N_SPECIFICATION.[column in domain "DOKAR"] == DRAW.DOKAR
  • ESH_N_SPECIFICATION.DOCUMENTINFORECORDDOCNUMBER == DRAW.DOKNR
Foreign key for material
  • Client
  • Material Number
  • ESH_N_SPECIFICATION.MANDT == MARA.MANDT
  • ESH_N_SPECIFICATION.MATERIAL == MARA.MATNR
Foreign key for identification category ESH_N_SPECIFICATION.SPECIDFGDESCCATEGORY == TCG21.IDTYPE
Foreign Key for Language Identifier ESH_N_SPECIFICATION.SPECIDFGDESCLANGUAGE == T002.SPRAS
Identification Type
  • Identification Category
  • Client
  • Identification Type
  • ESH_N_SPECIFICATION.SPECIDFGDESCCATEGORY == TCG23.IDTYPE
  • ESH_N_SPECIFICATION.MANDT == TCG23.MANDT
  • ESH_N_SPECIFICATION.SPECIDFGDESCTYPE == TCG23.IDCAT
Recipe Authorization Group
  • Recipe Authorization Group
  • Client
  • ESH_N_SPECIFICATION.SPECIFICATIONAUTHZNGROUP == TCG36.AUTHGRP
  • ESH_N_SPECIFICATION.MANDT == TCG36.MANDT
Specification Category ESH_N_SPECIFICATION.SPECIFICATIONCATEGORY == TCGOBJ.OBJTYPE
Foreign Key for Change Number
  • Client
  • Change number
  • ESH_N_SPECIFICATION.MANDT == AENR.MANDT
  • ESH_N_SPECIFICATION.SPECIFICATIONCHANGENUMBER == AENR.AENNR
Address key assignment to users
  • Client
  • User ID
  • ESH_N_SPECIFICATION.MANDT == USR02.MANDT
  • ESH_N_SPECIFICATION.SPECIFICATIONCREATEDBYUSER == USR02.BNAME
Foreign Key for Substance Nature
  • Client
  • Substance Nature
  • ESH_N_SPECIFICATION.MANDT == TCG34.MANDT
  • ESH_N_SPECIFICATION.SPECIFICATIONSUBSTANCENATR == TCG34.SUBCHAR
Foreign key for substance type
  • Client
  • Specification Type
  • ESH_N_SPECIFICATION.MANDT == TCG31.MANDT
  • ESH_N_SPECIFICATION.SPECIFICATIONTYPE == TCG31.SUBCAT