SAP ABAP Table EHCSMS_SPC_USAGE (Specification Usage)

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_USAGE	Table Relationship Diagram
Short Description	Specification Usage

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: Standard Fields for EHS API Structures
6	ERRORMODE	☐	ESEERRMODE	CHAR1	CHAR	1	0	Indicator: Error or warning in an API function
7	ERRORINFO	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
8	ERRORCLASS	☐	SYMSGID	ARBGB	CHAR	20	0	Message Class	*
9	ERRORPARAM	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
10	LOGLOCKMOD	☐	ESELGLCKMD	CHAR1	CHAR	1	0	Logical Lock Mode
11	EXTINFO	☐	ESEEXTINFO	CHAR10	CHAR	10	0	External Information
12	LINEMOD	☐	ESELINEMOD	CHAR1	CHAR	1	0	Processing status or mode of a record/step loop line
13	.INCLUDE	☐				0	0	EHS: Structure for key info of master data
14	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
15	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
16	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
17	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
18	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
19	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
20	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
21	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
22	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
23	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
24	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
25	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
26	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
27	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
28	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
29	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
30	NAMEMST	☐	ESENAMEMST	CHAR30	CHAR	30	0	Name of Master Table
31	RECNMST	☐	ESERECNMST	ESDRECN	NUMC	20	0	Reference to Master Table
32	VACLID	☐	ESEVACLID	ESDVACLID	CHAR	10	0	Rating	TCG86
33	VACLNAM	☐	ESEVACLNAM	TEXT40	CHAR	40	0	Description for Rating
34	RVLID	☐	ESERVLID	ESDRVLID	CHAR	10	0	Validity Area	TCG91
35	RVLNAM	☐	ESERVLNAM	TEXT40	CHAR	40	0	Description for Validity Area
36	RVLTYPE	☐	ESERVLTYPE	ESDRVLTYPE	CHAR	10	0	Validity Area Category	*
37	RVLTYPENAM	☐	ESERVLTYPENAM	TEXT40	CHAR	40	0	Language-Dependent Description for Validity Area Category
38	EXCLFLG	☐	ESEEXCLFLG	ESDFLAG	CHAR	1	0	Validity Area is Excluded
39	ACTVFLG	☐	ESEACTVFLG	ESDFLAG	CHAR	1	0	Activate Usage
40	ESNTFLG	☐	ESEESNTFLG	ESDFLAG	CHAR	1	0	Relevant Change Has Been Made
41	RECN_REFRH	☐	ESERECNREF	ESDRECN	NUMC	20	0	Reference to Reference Specification Header
42	USAGECHECK	☐	ESEUSGCCK	ESDUSGCCK	CHAR	1	0	Selection for Usage Check
43	USAGE_TYPE	☐	EHCSM_SPC_USAGE_TYPE	EHCSM_SPC_USAGE_TYPE_CODE	CHAR	1	0	Usage Type of EHS Specification

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHCSMS_SPC_USAGE	AENNR	AENR	AENNR	REF	1	CN
2	EHCSMS_SPC_USAGE	MANDT	T000	MANDT
3	EHCSMS_SPC_USAGE	RVLID	TCG91	RVLID
4	EHCSMS_SPC_USAGE	SRSID	TCG56	SRSID	REF	1	CN
5	EHCSMS_SPC_USAGE	VACLID	TCG86	VACLID

History

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