ESH_N_SPEC_INT

Anchor view -SPEC_INT | view: ESH_L_SPEC_INT | 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, TCGTPLH, TCGTPLU, TCG31, TCG32, USR21, DRAD_LAST_CHANGE, /PLMB/RCP_RECIPE, ESTDU, 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
EACHSPECUSAGEISINHERITED All Usages Contained in Inheritance Template Show values
INHTDSPECIDFGDESCISPERMCHGD Truth Value Show values
INHTDSPECIDFGDESCISTMPCHGD Truth Value Show values
LOGACCMOBJECTTYPEISACTIVE Access Control Activated for Object Type Show values
RCPFMLAITEMTYPE Formula Item Type Show values
ORIGSPECIDFGUSAGEISACTIVE Activate Usage Show values
SPECIDFGUSAGEISACTIVE Activate Usage Show values
ORIGSPECIDFGUSAGEISEXCLUDED Validity Area is Excluded Show values
SPECIDFGUSAGEISEXCLUDED Validity Area is Excluded Show values
ORIGSPECIDFGUSAGEISRELEVANT Relevant Change Has Been Made Show values
SPECIDFGUSAGEISRELEVANT Relevant Change Has Been Made Show values
Column Name Description Domain name
DOCUMENTINFORECORDDOCPART Document Part DOKTL
DOCUMENTINFORECORDDOCVERSION Document Version DOKVR
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
SPECINHERITANCETEMPLATE Sequential Number of Data Record ESDRECN
SPECIFICATIONCREATEDBYNAME User Description SUIDTECHDESC
Master Data Relations Join Conditions
Document number
  • Document Version
  • Document Type
  • Client
  • Document number
  • Document Part
  • ESH_N_SPEC_INT.DOCUMENTINFORECORDDOCVERSION == DRAW.DOKVR
  • ESH_N_SPEC_INT.DOCUMENTINFORECORDDOCTYPE == DRAW.DOKAR
  • ESH_N_SPEC_INT.MANDT == DRAW.MANDT
  • ESH_N_SPEC_INT.DOCUMENTINFORECORDDOCNUMBER == DRAW.DOKNR
  • ESH_N_SPEC_INT.DOCUMENTINFORECORDDOCPART == DRAW.DOKTL
Document Type
  • Document Type
  • Client
  • ESH_N_SPEC_INT.DOCUMENTINFORECORDDOCTYPE == TDWA.DOKAR
  • ESH_N_SPEC_INT.MANDT == TDWA.MANDT
Foreign key for material
  • Client
  • Material Number
  • ESH_N_SPEC_INT.MANDT == MARA.MANDT
  • ESH_N_SPEC_INT.MATERIAL == MARA.MATNR
Rating
  • Rating
  • Rating
  • Client
  • ESH_N_SPEC_INT.SPECIFICATIONRATING == TCG86.VACLID
  • ESH_N_SPEC_INT.ORIGSPECIFICATIONRATING == TCG86.VACLID
  • ESH_N_SPEC_INT.MANDT == TCG86.MANDT
Validity Area
  • Client
  • Validity Area
  • Validity Area
  • Validity Area
  • ESH_N_SPEC_INT.MANDT == TCG91.MANDT
  • ESH_N_SPEC_INT.ORIGSPECIFICATIONVALIDITYAREA == TCG91.RVLID
  • ESH_N_SPEC_INT.SPECINHTNCTEMPLATEVALIDITYAREA == TCG91.RVLID
  • ESH_N_SPEC_INT.SPECIFICATIONVALIDITYAREA == TCG91.RVLID
Foreign key for plant
  • Client
  • Plant
  • ESH_N_SPEC_INT.MANDT == T001W.MANDT
  • ESH_N_SPEC_INT.PLANT == T001W.WERKS
Foreign key for identification category ESH_N_SPEC_INT.SPECIDFGDESCCATEGORY == TCG21.IDTYPE
Foreign Key for Language Identifier ESH_N_SPEC_INT.SPECIDFGDESCLANGUAGE == T002.SPRAS
Identification Type
  • Identification Category
  • Identification Type
  • Client
  • ESH_N_SPEC_INT.SPECIDFGDESCCATEGORY == TCG23.IDTYPE
  • ESH_N_SPEC_INT.SPECIDFGDESCTYPE == TCG23.IDCAT
  • ESH_N_SPEC_INT.MANDT == TCG23.MANDT
Recipe Authorization Group
  • Client
  • Recipe Authorization Group
  • ESH_N_SPEC_INT.MANDT == TCG36.MANDT
  • ESH_N_SPEC_INT.SPECIFICATIONAUTHZNGROUP == TCG36.AUTHGRP
Specification Category ESH_N_SPEC_INT.SPECIFICATIONCATEGORY == TCGOBJ.OBJTYPE
Foreign Key for Change Number
  • Change number
  • Client
  • ESH_N_SPEC_INT.SPECIFICATIONCHANGENUMBER == AENR.AENNR
  • ESH_N_SPEC_INT.MANDT == AENR.MANDT
Address key assignment to users
  • User ID
  • Client
  • ESH_N_SPEC_INT.SPECIFICATIONCREATEDBYUSER == USR02.BNAME
  • ESH_N_SPEC_INT.MANDT == USR02.MANDT
Rating
  • Rating
  • Rating
  • Client
  • ESH_N_SPEC_INT.SPECIFICATIONRATING == TCG86.VACLID
  • ESH_N_SPEC_INT.ORIGSPECIFICATIONRATING == TCG86.VACLID
  • ESH_N_SPEC_INT.MANDT == TCG86.MANDT
Foreign Key for Substance Nature
  • Client
  • Substance Nature
  • ESH_N_SPEC_INT.MANDT == TCG34.MANDT
  • ESH_N_SPEC_INT.SPECIFICATIONSUBSTANCENATR == TCG34.SUBCHAR
Foreign key for substance type
  • Client
  • Specification Type
  • ESH_N_SPEC_INT.MANDT == TCG31.MANDT
  • ESH_N_SPEC_INT.SPECIFICATIONTYPE == TCG31.SUBCAT
Validity Area
  • Client
  • Validity Area
  • Validity Area
  • Validity Area
  • ESH_N_SPEC_INT.MANDT == TCG91.MANDT
  • ESH_N_SPEC_INT.ORIGSPECIFICATIONVALIDITYAREA == TCG91.RVLID
  • ESH_N_SPEC_INT.SPECINHTNCTEMPLATEVALIDITYAREA == TCG91.RVLID
  • ESH_N_SPEC_INT.SPECIFICATIONVALIDITYAREA == TCG91.RVLID
Validity Area
  • Client
  • Validity Area
  • Validity Area
  • Validity Area
  • ESH_N_SPEC_INT.MANDT == TCG91.MANDT
  • ESH_N_SPEC_INT.ORIGSPECIFICATIONVALIDITYAREA == TCG91.RVLID
  • ESH_N_SPEC_INT.SPECINHTNCTEMPLATEVALIDITYAREA == TCG91.RVLID
  • ESH_N_SPEC_INT.SPECIFICATIONVALIDITYAREA == TCG91.RVLID