SAP ABAP Table /TDAG/CPS_SELSCR (CP: Suchkriterien)

Hierarchy

☛ TDAGBCA (Software Component) TechniData Basic Components
   ⤷ EHS (Application Component) Environment, Health and Safety
     ⤷ /TDAG/CP (Package) Compliance for products

Basic Data

Table Category	INTTAB	Structure
Structure	/TDAG/CPS_SELSCR	Table Relationship Diagram
Short Description	CP: Suchkriterien

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: Data structure for sel. screen (access) subs. proc.
2	.INCLUDE	☐				0	0	EHS: Data structure for "Substance header" initial screen
3	SUBID	☐	ESESUBID	ESDSUBID	CHAR	12	0	Specification
4	SUBCAT	☐	ESESUBCAT	ESDSUBCAT	CHAR	10	0	Specification Type	TCG31
5	SUBNAM	☐	ESESUBNAM	TEXT40	CHAR	40	0	Description of Specification Type
6	SUBCHAR	☐	ESESUBCHAR	ESDSUBCHAR	CHAR	10	0	Identification of Substance Nature	*
7	SUBCHARNAM	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
8	AUTHGRP	☐	ESEAUTHGRP	ESDAUTHGRP	CHAR	10	0	Authorization Group	TCG36
9	AUTHNAM	☐	ESEAUTHNAM	TEXT40	CHAR	40	0	Description of Authorization Group
10	SEARCHMODE	☐	ESESEARCHMODE	ESDSEARCHMODE	CHAR	1	0	Search mode to find historical data
11	VALDAT	☐	ESEDIAGVD	DATUM	DATS	8	0	Key Date
12	.INCLUDE	☐				0	0	EHS: Struct. for searching via time frame (historical data)
13	VALFR	☐	ESEDIAGVF	DATUM	DATS	8	0	From-Date for Specification Search Over Time Period
14	VALTO	☐	ESEDIAGVT	DATUM	DATS	8	0	To-Date for Specification Search Over Time Period
15	STATUS	☐	CHAR15	CHAR15	CHAR	15	0	Char 15
16	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
17	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
18	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
19	BUTTON	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
20	.INCLUDE	☐				0	0	EHS: Data structure for "Search term" initial screen
21	NAMCAT	☐	ESEIDCAT	ESDIDCAT	CHAR	10	0	Identification Type	TCG23
22	NAMLANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
23	INAME	☐	ESEIDENT	TEXT132	CHAR	132	0	Identifier
24	NUMCAT	☐	ESEIDCAT	ESDIDCAT	CHAR	10	0	Identification Type	TCG23
25	NUMLANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
26	INUMBER	☐	ESEIDENT	TEXT132	CHAR	132	0	Identifier
27	FRMCAT	☐	ESEIDCAT	ESDIDCAT	CHAR	10	0	Identification Type	TCG23
28	FRMLANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
29	IFORMULA	☐	ESEIDENT	TEXT132	CHAR	132	0	Identifier
30	SLSTID	☐	ESESLSTID	ESDSLSTID	CHAR	10	0	Regulatory List	TCG81
31	SLSTNAM	☐	ESESLSTNAM	TEXT80	CHAR	80	0	Description of Regulatory List
32	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
33	MATLANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
34	MATNAM	☐	MAKTX	TEXT40	CHAR	40	0	Material description
35	SUBSTAT	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status
36	SUBSTAT_ON_SCREEN	☐	EHSBE_SCPSTAT_ON_SCREEN	EHSBD_SCPSTAT_ON_SCREEN	CHAR	5	0	Status
37	.INCLUDE	☐				0	0	CP: Additonal search criteria
38	LIFNR	☐	/TDAG/CPE_SUPPLIER	LIFNR	CHAR	10	0	Supplier	LFA1
39	LIFNR_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
40	MAXSEL	☐	TBMAXSEL	SYST_LONG	INT4	10	0	Maximum Number of Selected Entries

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/TDAG/CPS_SELSCR	AENNR	AENR	AENNR	KEY	1	1
2	/TDAG/CPS_SELSCR	AUTHGRP	TCG36	AUTHGRP
3	/TDAG/CPS_SELSCR	FRMCAT	TCG23	IDCAT
4	/TDAG/CPS_SELSCR	FRMLANGU	T002	SPRAS
5	/TDAG/CPS_SELSCR	LIFNR	LFA1	LIFNR		1	CN
6	/TDAG/CPS_SELSCR	MATLANGU	T002	SPRAS
7	/TDAG/CPS_SELSCR	MATNR	MARA	MATNR	REF	1	CN
8	/TDAG/CPS_SELSCR	NAMCAT	TCG23	IDCAT
9	/TDAG/CPS_SELSCR	NAMLANGU	T002	SPRAS
10	/TDAG/CPS_SELSCR	NUMCAT	TCG23	IDCAT
11	/TDAG/CPS_SELSCR	NUMLANGU	T002	SPRAS
12	/TDAG/CPS_SELSCR	SLSTID	TCG81	SLSTID
13	/TDAG/CPS_SELSCR	SUBCAT	TCG31	SUBCAT

History

Last changed by/on	SAP	20141109
SAP Release Created in	0207B0406C