SAP ABAP Table EHCSMS_SPC_IDN (Specification Identifier Structure)

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_IDN	Table Relationship Diagram
Short Description	Specification Identifier Structure

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	EHS: Standard Fields for EHS API Structures
2	ERRORMODE	☐	ESEERRMODE	CHAR1	CHAR	1	0	Indicator: Error or warning in an API function
3	ERRORINFO	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
4	ERRORCLASS	☐	SYMSGID	ARBGB	CHAR	20	0	Message Class	*
5	ERRORPARAM	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
6	LOGLOCKMOD	☐	ESELGLCKMD	CHAR1	CHAR	1	0	Logical Lock Mode
7	EXTINFO	☐	ESEEXTINFO	CHAR10	CHAR	10	0	External Information
8	LINEMOD	☐	ESELINEMOD	CHAR1	CHAR	1	0	Processing status or mode of a record/step loop line
9	.INCLUDE	☐				0	0	EHS: Structure for key info of master data
10	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
11	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
12	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
13	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
14	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
15	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
16	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
17	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
18	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
19	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
20	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
21	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
22	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
23	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
24	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
25	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
26	.INCLUDE	☐				0	0	Transient data for specification related admin data
27	CREATED_BY	☐	EHCSM_SPC_USER_CREATE	EHCSM_SPC_NAME	CHAR	60	0	User Name That Created the Data
28	CHANGED_BY	☐	EHCSM_SPC_USER_CHANGE	EHCSM_SPC_NAME	CHAR	60	0	User Name That Last Changed the Data
29	CHANGE_NR_DESC	☐	CC_AETXT	CC_TEXT40	CHAR	40	0	Change number description
30	IDTYPE	☐	ESEIDTYPE	ESDIDTYPE	CHAR	10	0	Identification Category	TCG21
31	IDCAT	☐	ESEIDCAT	ESDIDCAT	CHAR	10	0	Identification Type	TCG23
32	LANGU	☐	ESELANGU	SPRAS	LANG	1	0	Language	T002
33	IDENT	☐	ESEIDENT	TEXT132	CHAR	132	0	Identifier
34	IDENTNM	☐	ESEIDENTNM	CHAR132	CHAR	132	0	Normed identification (upper case, no special characters)
35	LTXTFLG	☐	ESELTXTFLG	ESDFLAG	CHAR	1	0	Long Text
36	FORMATFLG	☐	ESEFORMATFLG	ESDFLAG	CHAR	1	0	Formatting Available
37	ORD	☐	ESEORD	NUMC4	NUMC	4	0	Sort Sequence
38	.INCLUDE	☐				0	0	DDS: DMS document key
39	DOKAR	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	TDWA
40	DOKNR	☐	DOKNR	DOKNR	CHAR	25	0	Document number	ESD_DRAW
41	DOKVR	☐	DOKVR	DOKVR	CHAR	2	0	Document version	ESD_DRAW
42	DOKTL	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
43	FLG_INHSRC	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
44	FLG_INHOVR	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
45	FLG_INHEXCL	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
46	RECN_TPLH	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
47	RECNTRI_SRC	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
48	RECNTRI_ORIG	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
49	RECNROOT_ORIG	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
50	TPL_ORD	☐	ESEORD	NUMC4	NUMC	4	0	Sort Sequence
51	.INCLUDE	☐				0	0	Specification Identifier - transient data
52	LTXTUPD	☐	ESELTXTUPD	ESDFLAG	CHAR	1	0	Indicator: Long text changed
53	INH_ICON	☐	ESEINH_ICON	ESDICON	CHAR	60	0	Information on Inheritance Relationship
54	STATUS_ICON	☐	EHSBE_STATUS_ICON	ICON	CHAR	4	0	Specification Status	*
55	FLG_PROTECTED_BY_STATUS	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
56	VACLID_STATUS	☐	ESEVACLID	ESDVACLID	CHAR	10	0	Rating	*
57	LAND_STATUS	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
58	DETAIL_RVLID_STATUS	☐	ESERVLID	ESDRVLID	CHAR	10	0	Validity Area	*
59	VALFR_STATUS	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
60	FLG_STATUS_WARNING	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
61	SLST_COUNT	☐	ESESLST_COUNT	NUMC3	NUMC	3	0	Number of Assignments to Regulatory Lists
62	USAGE_COUNT	☐	ESEUSAGE_COUNT	NUMC3	NUMC	3	0	Number of Usages Assigned
63	NOAUTHFLG	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
64	STATUS_ICONQU	☐	EHSBE_STATUS_ICONQU	ESDICON	CHAR	60	0	Specification Status
65	LOCKED_IND	☐	EHCSM_SPC_LOCKED_IND	BOOLE	CHAR	1	0	Data Is Locked or Protected by Status
66	OBJTYPE	☐	ESEOBJTYPE	CHAR10	CHAR	10	0	Specification Category	*
67	OBJTYPE_NAME	☐	ESEOBJTYPENAM	TEXT40	CHAR	40	0	Short Description of Specification Category
68	IDTYPE_NAME	☐	ESEIDTNAM	TEXT40	CHAR	40	0	Description of Identification Category
69	IDCAT_NAME	☐	ESEIDCNAM	TEXT40	CHAR	40	0	Description of the Identification Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHCSMS_SPC_IDN	AENNR	AENR	AENNR	REF	1	CN
2	EHCSMS_SPC_IDN	DOKAR	TDWA	DOKAR	KEY	1	CN
3	EHCSMS_SPC_IDN	DOKNR	ESD_DRAW	DOKNR	KEY	1	CN
4	EHCSMS_SPC_IDN	DOKVR	ESD_DRAW	DOKVR	KEY	1	CN
5	EHCSMS_SPC_IDN	IDCAT	TCG23	IDCAT		1	CN
6	EHCSMS_SPC_IDN	IDTYPE	TCG21	IDTYPE	REF	1	CN
7	EHCSMS_SPC_IDN	LANGU	T002	SPRAS	REF	C	CN
8	EHCSMS_SPC_IDN	MANDT	T000	MANDT
9	EHCSMS_SPC_IDN	SRSID	TCG56	SRSID	REF	1	CN

History

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