SAP ABAP Table EHCSMS_SPC_REL (Specification relationship)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-SAF (Application Component) Product Safety
     ⤷ CBUI_BO (Package) Specification Management Web UI Enabling API

Basic Data

Table Category	INTTAB	Structure
Structure	EHCSMS_SPC_REL	Table Relationship Diagram
Short Description	Specification relationship

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Transient data for specification related admin data
2	CREATED_BY	☐	EHCSM_SPC_USER_CREATE	EHCSM_SPC_NAME	CHAR	60	0	User Name That Created the Data
3	CHANGED_BY	☐	EHCSM_SPC_USER_CHANGE	EHCSM_SPC_NAME	CHAR	60	0	User Name That Last Changed the Data
4	CHANGE_NR_DESC	☐	CC_AETXT	CC_TEXT40	CHAR	40	0	Change number description
5	.INCLUDE	☐				0	0	EHS: API Structure for Inheritance Relationships
6	.INCLUDE	☐				0	0	EHS: Standard Fields for EHS API Structures
7	ERRORMODE	☐	ESEERRMODE	CHAR1	CHAR	1	0	Indicator: Error or warning in an API function
8	ERRORINFO	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
9	ERRORCLASS	☐	SYMSGID	ARBGB	CHAR	20	0	Message Class	*
10	ERRORPARAM	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
11	LOGLOCKMOD	☐	ESELGLCKMD	CHAR1	CHAR	1	0	Logical Lock Mode
12	EXTINFO	☐	ESEEXTINFO	CHAR10	CHAR	10	0	External Information
13	LINEMOD	☐	ESELINEMOD	CHAR1	CHAR	1	0	Processing status or mode of a record/step loop line
14	.INCLUDE	☐				0	0	EHS: Inheritance Relationships
15	.INCLUDE	☐				0	0	EHS: Structure for key info of master data
16	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
17	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
18	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
19	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
20	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
21	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
22	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
23	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
24	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
25	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
26	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
27	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
28	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
29	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
30	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
31	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
32	FLG_SRCDEST_REQ	☐	ESEFLG_SRCDEST_REQ	ESDFLAG	CHAR	1	0	Request from Currently Called Specification
33	APPRV_STAT	☐	ESEAPPRV_STAT	ESDAPPRV_STAT	NUMC	1	0	Approval Status of an Inheritance Request
34	CONS_STAT	☐	ESECONS_STAT	ESDCONS_STAT	NUMC	1	0	Status of an Inheritance Relationship
35	FLG_INH	☐	ESEFLG_INH	ESDFLAG	CHAR	1	0	Inheritance Relationship Is Inactive
36	JOB_REQ_TIM	☐	ESEJOB_REQ_TIM	UZEIT	TIMS	6	0	Current Time of an Inheritance Request
37	JOB_REQ_DAT	☐	ESEJOB_REQ_DAT	DATUM	DATS	8	0	Date of an Inheritance Request
38	FLG_SUBCPY	☐	ESEFLG_SUBCPY	ESDFLAG	CHAR	1	0	Relationship Is Not Relevant for Inheritance
39	RECNROOT_SRC	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
40	RECNROOT_DST	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
41	RECN_TPLH	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
42	ESNTFLG	☐	ESEESNTFLG	ESDFLAG	CHAR	1	0	Relevant Change Has Been Made
43	SUBID	☐	ESESUBID	ESDSUBID	CHAR	12	0	Specification
44	IDENT	☐	ESEIDENT	TEXT132	CHAR	132	0	Identifier
45	GRPID	☐	ESEGRPID	ESDGRPID	CHAR	10	0	Group	*
46	OBJID	☐	ESEGRPOBJID	ESDGRPOBJID	CHAR	10	0	Group Entry
47	TEMPLDESCR	☐	ESEOBJNAM	TEXT40	CHAR	40	0	Short Description of Object
48	ICON_APPRV_STAT	☐	ESE_ICON_APPRV_STAT	SYCHAR132	CHAR	132	0	Approval Status of Relationship
49	APPRV_STAT_TXT	☐	EHCSM_SPC_REL_APPROVAL_TXT	CHAR30	CHAR	30	0	Approval Status of Relationship as Text
50	ICON_CONS_STAT	☐	ESE_ICON_CONS_STAT	SYCHAR132	CHAR	132	0	Status of Inheritance Relationship
51	CONS_STAT_TXT	☐	EHCSM_SPC_REL_STATUS_TXT	CHAR30	CHAR	30	0	Status of Inheritance Relationship as Text
52	ACTIVE_INH	☐	EHCSM_SPC_REL_ACTIVE_IND	BOOLE	CHAR	1	0	Active Relationship Indicator
53	ICON_ACTIVE_INH	☐	ESE_ICON_ACTIVE_INH	SYCHAR132	CHAR	132	0	Active Relationship
54	FLG_REQUEST	☐	ESEFLG_SRCDEST_REQ	ESDFLAG	CHAR	1	0	Request from Currently Called Specification
55	JOB_PLANNED_IND	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
56	JOB_NAME	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHCSMS_SPC_REL	AENNR	AENR	AENNR	REF	1	CN
2	EHCSMS_SPC_REL	MANDT	T000	MANDT
3	EHCSMS_SPC_REL	SRSID	TCG56	SRSID	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	605