SAP Table
T370T Equipment categories
SAP table T370T has 2 primary key fields being MANDT,EQTYP.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
T370T columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||
| KeyEQTYP | Equipment category | CHAR | 1 | 0 | EQTYP | ||||||||
| REFTP | Equipment reference category | CHAR | 1 | 0 | REFTP | ||||||||
|
|||||||||||||
| NUMKI | Number Range of Internal Number Assignment | CHAR | 2 | 0 | NUMKI | ||||||||
| NUMKE | Number Range of External Number Assignment | CHAR | 2 | 0 | NUMKE | ||||||||
| ZEIIN | Record usage history for equipment | CHAR | 1 | 0 | DZEIIN | ||||||||
| TPEIN | Installation at functional location permitted | CHAR | 1 | 0 | TPEIN | ||||||||
| MSTKZ | Indicator for maintaining multi-lingual texts | CHAR | 1 | 0 | MSTKZ | ||||||||
| AEBKZ | Indicator showing equipment category with change documents | CHAR | 1 | 0 | AEBKZ | ||||||||
| PUEMA | No Alphanumeric Equipment Numbers | CHAR | 1 | 0 | PUEMA | ||||||||
| STADY | Indicator for a fixed screen sequence | CHAR | 1 | 0 | STADY | ||||||||
| STSMA | Status Profile | CHAR | 8 | 0 | TJ20 | J_STSMA | |||||||
| SDEQT | Equipment Category for Serial Numbers | CHAR | 1 | 0 | SDEQT | ||||||||
| PARGR | Partner Determination Procedure | CHAR | 4 | 0 | TVPG | PARGR | |||||||
| PARK1 | Partner Function for Current Customer in Serial Number | CHAR | 2 | 0 | TPAR | PARK1 | |||||||
| PARK2 | Partner Function for Equipment Vendor | CHAR | 2 | 0 | TPAR | PARK2 | |||||||
| PARK3 | Partner Function for Customer in Equipment Usage Period | CHAR | 2 | 0 | TPAR | PARK3 | |||||||
| PARK4 | Partner Function for Endcustomer in Equipment Usage Period | CHAR | 2 | 0 | TPAR | PARK4 | |||||||
| PARK5 | Partner Function for Operator in Equipment Usage Period | CHAR | 2 | 0 | TPAR | PARK5 | |||||||
| INFOW | Parameter ID Object Info | CHAR | 10 | 0 | TQ80O | I_INFOWIND | |||||||
| AMKNZ | Asset relevant indicator | CHAR | 1 | 0 | AMKNZ | ||||||||
| WFKNZ | Indicator: Generate Event for Workflow | CHAR | 1 | 0 | WFKNZ | ||||||||
| PASYN | Partner synchronization activated | CHAR | 1 | 0 | PASYN | ||||||||
| KZKSD | Serial data when maintaining equipment | CHAR | 1 | 0 | KZKSD | ||||||||
| KONFKNZ | Configuration supported | CHAR | 1 | 0 | KONFKNZ | ||||||||
| SDKNZ | Sales equipment | CHAR | 1 | 0 | SDKNZ | ||||||||
| FHMKZ | Equip. category relevant to production resources and tools | CHAR | 1 | 0 | FHMKZ | ||||||||
| ELSE_KNZ | Indicator: Other Data Active | CHAR | 1 | 0 | ELSE_KNZ | ||||||||
| ISU_KNZ | IS-U data | CHAR | 1 | 0 | ISU_KNZ | ||||||||
| TSEGTP | Template | CHAR | 10 | 0 | TSEGTEMPLA | ||||||||
| VIEW_PROF | View profile for tab index Customizing | CHAR | 8 | 0 | TITOBPROF | ITOBVIEW_PROFILE | |||||||
| NO_SER_ENQ | No Block when Assigning Serial Numbers | CHAR | 1 | 0 | NO_SER_ENQ | ||||||||
| BTMNS | Keep construction type and material number synchronous | CHAR | 1 | 0 | BTMNS | ||||||||
|
|||||||||||||
| CC_KNZ | Configuration Control Data | CHAR | 1 | 0 | CCC_KNZ | ||||||||
| AEBKZ_INS | Equipment Type with Change Documents During Creation | CHAR | 1 | 0 | AEBKZ_INS | ||||||||
| LFE_IND | Indicator: Object Belongs to Linear Asset Management | CHAR | 1 | 0 | EAML_LFE_IND | ||||||||
| IDMS_TYPE | Level at Which the Object is Represented | CHAR | 1 | 0 | EAME_IDMS_TYPE | ||||||||
| J_3GBAUKNZ | CEM Equipment | CHAR | 1 | 0 | J_3GBAUKNZ | ||||||||
/ Relationships
T370T foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| T370T | INFOW | TQ80O | Object info parameters | MANDT |
| T370T | INFOW | TQ80O | Object info parameters | INFO_WIND |
| T370T | MANDT | T000 | Clients | MANDT |
| T370T | PARGR | TVPG | Partner Function Groups | PARGR |
| T370T | PARK1 | TPAR | Business Partner: Functions | PARVW |
| T370T | PARK2 | TPAR | Business Partner: Functions | PARVW |
| T370T | PARK3 | TPAR | Business Partner: Functions | PARVW |
| T370T | PARK4 | TPAR | Business Partner: Functions | PARVW |
| T370T | PARK5 | TPAR | Business Partner: Functions | PARVW |
| T370T | STSMA | TJ20 | Status profiles | MANDT |
| T370T | STSMA | TJ20 | Status profiles | STSMA |
| T370T | VIEW_PROF | TITOBPROF | Technical Objects: View Profiles for Tab Index Customizing | MANDT |
| T370T | VIEW_PROF | TITOBPROF | Technical Objects: View Profiles for Tab Index Customizing | SUBGRP |
| T370T | VIEW_PROF | TITOBPROF | Technical Objects: View Profiles for Tab Index Customizing | PROFILE |