ESH_S_SPEC_INT

Search view -SPEC_INT | view: ESH_U_SPEC_INT | Extraction: Not supported | Component: Specification

🔑 Keys
💰 Amounts
∑ Quantities
📅 Dates (3)
☰ Categorical (11)
Other (16)
🔗 Relations (18)

Column Name	Description

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
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
SPECIFICATIONINTERNALID	Sequential Number of Data Record	ESDRECN
SPECIFICATIONTYPEDESCRIPTION	Specification Type Description	TEXT40
SPECINHERITANCETEMPLATE	Sequential Number of Data Record	ESDRECN
SPECIFICATIONCREATEDBYNAME	User Description

Master Data Relations	Join Conditions
Document number Document Type Document number Document Part Client Document Version	`ESH_S_SPEC_INT.DOCUMENTINFORECORDDOCTYPE == DRAW.DOKAR` `ESH_S_SPEC_INT.DOCUMENTINFORECORDDOCNUMBER == DRAW.DOKNR` `ESH_S_SPEC_INT.DOCUMENTINFORECORDDOCPART == DRAW.DOKTL` `ESH_S_SPEC_INT.MANDT == DRAW.MANDT` `ESH_S_SPEC_INT.DOCUMENTINFORECORDDOCVERSION == DRAW.DOKVR`
Document Type Document Type Client	`ESH_S_SPEC_INT.DOCUMENTINFORECORDDOCTYPE == TDWA.DOKAR` `ESH_S_SPEC_INT.MANDT == TDWA.MANDT`
Foreign key for material Client Material Number	`ESH_S_SPEC_INT.MANDT == MARA.MANDT` `ESH_S_SPEC_INT.MATERIAL == MARA.MATNR`
Rating Client Rating Rating	`ESH_S_SPEC_INT.MANDT == TCG86.MANDT` `ESH_S_SPEC_INT.ORIGSPECIFICATIONRATING == TCG86.VACLID` `ESH_S_SPEC_INT.SPECIFICATIONRATING == TCG86.VACLID`
Validity Area Client Validity Area Validity Area Validity Area	`ESH_S_SPEC_INT.MANDT == TCG91.MANDT` `ESH_S_SPEC_INT.ORIGSPECIFICATIONVALIDITYAREA == TCG91.RVLID` `ESH_S_SPEC_INT.SPECIFICATIONVALIDITYAREA == TCG91.RVLID` `ESH_S_SPEC_INT.SPECINHTNCTEMPLATEVALIDITYAREA == TCG91.RVLID`
Foreign key for plant Client Plant	`ESH_S_SPEC_INT.MANDT == T001W.MANDT` `ESH_S_SPEC_INT.PLANT == T001W.WERKS`
Foreign key for identification category	`ESH_S_SPEC_INT.SPECIDFGDESCCATEGORY == TCG21.IDTYPE`
Foreign Key for Language Identifier	`ESH_S_SPEC_INT.SPECIDFGDESCLANGUAGE == T002.SPRAS`
Identification Type Identification Type Identification Category Client	`ESH_S_SPEC_INT.SPECIDFGDESCTYPE == TCG23.IDCAT` `ESH_S_SPEC_INT.SPECIDFGDESCCATEGORY == TCG23.IDTYPE` `ESH_S_SPEC_INT.MANDT == TCG23.MANDT`
Recipe Authorization Group Client Recipe Authorization Group	`ESH_S_SPEC_INT.MANDT == TCG36.MANDT` `ESH_S_SPEC_INT.SPECIFICATIONAUTHZNGROUP == TCG36.AUTHGRP`
Specification Category	`ESH_S_SPEC_INT.SPECIFICATIONCATEGORY == TCGOBJ.OBJTYPE`
Foreign Key for Change Number Client Change number	`ESH_S_SPEC_INT.MANDT == AENR.MANDT` `ESH_S_SPEC_INT.SPECIFICATIONCHANGENUMBER == AENR.AENNR`
Address key assignment to users Client User ID	`ESH_S_SPEC_INT.MANDT == USR02.MANDT` `ESH_S_SPEC_INT.SPECIFICATIONCREATEDBYUSER == USR02.BNAME`
Rating Client Rating Rating	`ESH_S_SPEC_INT.MANDT == TCG86.MANDT` `ESH_S_SPEC_INT.ORIGSPECIFICATIONRATING == TCG86.VACLID` `ESH_S_SPEC_INT.SPECIFICATIONRATING == TCG86.VACLID`
Foreign Key for Substance Nature Client Substance Nature	`ESH_S_SPEC_INT.MANDT == TCG34.MANDT` `ESH_S_SPEC_INT.SPECIFICATIONSUBSTANCENATR == TCG34.SUBCHAR`
Foreign key for substance type Client Specification Type	`ESH_S_SPEC_INT.MANDT == TCG31.MANDT` `ESH_S_SPEC_INT.SPECIFICATIONTYPE == TCG31.SUBCAT`
Validity Area Client Validity Area Validity Area Validity Area	`ESH_S_SPEC_INT.MANDT == TCG91.MANDT` `ESH_S_SPEC_INT.ORIGSPECIFICATIONVALIDITYAREA == TCG91.RVLID` `ESH_S_SPEC_INT.SPECIFICATIONVALIDITYAREA == TCG91.RVLID` `ESH_S_SPEC_INT.SPECINHTNCTEMPLATEVALIDITYAREA == TCG91.RVLID`
Validity Area Client Validity Area Validity Area Validity Area	`ESH_S_SPEC_INT.MANDT == TCG91.MANDT` `ESH_S_SPEC_INT.ORIGSPECIFICATIONVALIDITYAREA == TCG91.RVLID` `ESH_S_SPEC_INT.SPECIFICATIONVALIDITYAREA == TCG91.RVLID` `ESH_S_SPEC_INT.SPECINHTNCTEMPLATEVALIDITYAREA == TCG91.RVLID`