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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| SUBCAT | Specification Type | ESESUBCAT | CHAR | 10 | 0 | |||||||
| REFFLG | ***OBSOLETE*** Maintenance Via TCG31REF | ESEREFFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| MATFLG | Material Assignment Permitted | ESEMATFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| 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 |
Possible values
|
||||||
| 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 |
Possible values
|
||||||
| SUBFLG | ** Obsolete ** Entry is a Specification Type | ESESUBFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| EXPFLG | *** Obsolete*** Entry is a Spec. Type for Spec. Cat. Agent | ESEEXPFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| INTRFLG | Only for Use in Industrial Hygiene and Safety | ESEINTERFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| 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 |
Possible values
|
||||||
| 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 | MANDT | TCG11 | EHS: Value Assignment Type | MANDT |
| TCG31 | DEFROLESTCAT | TCG31 | DEFROLESTCAT | TCG11 | EHS: Value Assignment Type | ESTCAT |
| 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 |
