SAP Table TCG31
EHS: Specification Type
TCG31 (EHS: Specification Type) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TCG31 to other SAP tables.
TCG31 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
SUBCAT
Specification Type
|
ESESUBCAT |
CHAR
|
10 | 0 | ||||||||
|
REFFLG
***OBSOLETE*** Maintenance Via TCG31REF
|
ESEREFFLG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
MATFLG
Material Assignment Permitted
|
ESEMATFLG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
CHECKF
Specification Key Check Function
|
ESECHECKFS |
CHAR
|
30 | 0 | ||||||||
|
NUMRNGE
Name of number range object
|
NROBJ | TNRO |
CHAR
|
10 | 0 | |||||||
|
NUMINTI
Internal Number Range Interval
|
ESENUMINTI |
CHAR
|
2 | 0 | ||||||||
|
NUMINTE
External Number Range Interval
|
ESENUMINTE |
CHAR
|
2 | 0 | ||||||||
|
IEDFLG
Use Value as Default for Import/Export
|
ESEIEDFLG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
USEXNAM
Language-Independent User Exit Key
|
ESEUSEXNAM | ESD_TCGUFU |
CHAR
|
10 | 0 | |||||||
|
MENID
Property Tree
|
ESEMENID | TCG51 |
CHAR
|
10 | 0 | |||||||
|
PROPFLG
Default Property Tree
|
ESEPROPFLG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
SUBFLG
** Obsolete ** Entry is a Specification Type
|
ESESUBFLG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
EXPFLG
*** Obsolete*** Entry is a Spec. Type for Spec. Cat. Agent
|
ESEEXPFLG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
INTRFLG
Only for Use in Industrial Hygiene and Safety
|
ESEINTERFLG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
DEFROLESTCAT
Value Assignment Type of Standard Component Type
|
ESEDEFROLESTCAT | TCG11 |
CHAR
|
30 | 0 | |||||||
|
DEFROLCHARACT
Characteristic of Standard Component Type
|
ESEDEFROLCHARACT |
CHAR
|
30 | 0 | ||||||||
|
LABELFLG
Preferred Specification Type for Labeling
|
CBGLE_LABELFLG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
WB_ICON
Icon in Text Fields
|
HRPDV_ICON | ICON |
CHAR
|
4 | 0 | |||||||
TCG31 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TCG31 | DEFROLESTCAT | TCG31 | DEFROLESTCAT |
TCG11
EHS: Value Assignment Type
|
ESTCAT |
| TCG31 | DEFROLESTCAT | TCG31 | MANDT |
TCG11
EHS: Value Assignment Type
|
MANDT |
| TCG31 | MANDT | TCG31 | MANDT |
T000
Clients
|
MANDT |
| TCG31 | MENID | TCG31 | MANDT |
TCG51
EHS: Property Tree
|
MANDT |
| TCG31 | MENID | TCG31 | MENID |
TCG51
EHS: Property Tree
|
MENID |
| TCG31 | NUMRNGE | TCG31 | NUMRNGE |
TNRO
Definition of number range objects
|
OBJECT |
| TCG31 | USEXNAM | SY | MANDT |
ESD_TCGUFU
Generated Table for View ESD_TCGUFU
|
MANDT |
| TCG31 | USEXNAM | * |
ESD_TCGUFU
Generated Table for View ESD_TCGUFU
|
USEXTYP | |
| TCG31 | USEXNAM | TCG31 | USEXNAM |
ESD_TCGUFU
Generated Table for View ESD_TCGUFU
|
USEXNAM |
| TCG31 | WB_ICON | TCG31 | WB_ICON |
ICON
Icons table
|
ID |