SAP table TCG31 (Specification Type)
SAP table TCG31 has 2 primary key fields being MANDT,SUBCAT.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| SUBCAT | Specification Type | CHAR | 10 | 0 | ESESUBCAT | ||
| REFFLG | ***OBSOLETE*** Maintenance Via TCG31REF | CHAR | 1 | 0 | ESEREFFLG | ||
| MATFLG | Material Assignment Permitted | CHAR | 1 | 0 | ESEMATFLG | ||
| CHECKF | Specification Key Check Function | CHAR | 30 | 0 | ESECHECKFS | ||
| NUMRNGE | Number Range Object | CHAR | 10 | 0 | TNRO | NROBJ | |
| NUMINTI | Internal Number Range Interval | CHAR | 2 | 0 | ESENUMINTI | ||
| NUMINTE | External Number Range Interval | CHAR | 2 | 0 | ESENUMINTE | ||
| IEDFLG | Use Value as Default for Import/Export | CHAR | 1 | 0 | ESEIEDFLG | ||
| USEXNAM | Language-Independent User Exit Key | CHAR | 10 | 0 | ESD_TCGUFU | ESEUSEXNAM | |
| MENID | Property Tree | CHAR | 10 | 0 | TCG51 | ESEMENID | |
| PROPFLG | Default Property Tree | CHAR | 1 | 0 | ESEPROPFLG | ||
| SUBFLG | ** Obsolete ** Entry is a Specification Type | CHAR | 1 | 0 | ESESUBFLG | ||
| EXPFLG | *** Obsolete*** Entry is a Spec. Type for Spec. Cat. Agent | CHAR | 1 | 0 | ESEEXPFLG | ||
| INTRFLG | Only for Use in Industrial Hygiene and Safety | CHAR | 1 | 0 | ESEINTERFLG | ||
| DEFROLESTCAT | Value Assignment Type of Standard Component Type | CHAR | 30 | 0 | TCG11 | ESEDEFROLESTCAT | |
| DEFROLCHARACT | Characteristic of Standard Component Type | CHAR | 30 | 0 | ESEDEFROLCHARACT | ||
| LABELFLG | Preferred Specification Type for Labeling | CHAR | 1 | 0 | CBGLE_LABELFLG | ||
| WB_ICON | Icon in Text Fields | CHAR | 4 | 0 | ICON | HRPDV_ICON |
TCG31 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TCG31 | DEFROLESTCAT | TCG11 | EHS: Value Assignment Type | MANDT |
| 0 TCG31 | DEFROLESTCAT | TCG11 | EHS: Value Assignment Type | ESTCAT |
| 1 TCG31 | MENID | TCG51 | Property Tree | MANDT |
| 1 TCG31 | MENID | TCG51 | Property Tree | MENID |
| 0 TCG31 | NUMRNGE | TNRO | Definition of number range objects | OBJECT |
| 1 TCG31 | USEXNAM | ESD_TCGUFU | Generated Table for View | USEXTYP |
| 1 TCG31 | USEXNAM | ESD_TCGUFU | Generated Table for View | USEXNAM |
| 0 TCG31 | WB_ICON | ICON | Icons table | ID |