SAP table T370T (Equipment categories)

SAP table T370T has 2 primary key fields being MANDT,EQTYP.

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
EQTYP Equipment category CHAR 1 0 EQTYP
REFTP Equipment reference category CHAR 1 0 REFTP
M Machines
P Production resources/tools
S Customer equipment
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
No check if construction type & material no. are synchronous
1 Warning if construction type & material no. not synchronous
2 Error, if construction type and material no. not synchronous
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

T370T foreign key relationships

Table Field Check Table Check Field
0 T370T INFOW TQ80O Object info parameters MANDT
0 T370T INFOW TQ80O Object info parameters INFO_WIND
1 T370T MANDT T000 Clients MANDT
0 T370T PARGR TVPG Partner Function Groups PARGR
1 T370T PARK1 TPAR Business Partner: Functions PARVW
0 T370T PARK2 TPAR Business Partner: Functions PARVW
1 T370T PARK3 TPAR Business Partner: Functions PARVW
0 T370T PARK4 TPAR Business Partner: Functions PARVW
1 T370T PARK5 TPAR Business Partner: Functions PARVW
0 T370T STSMA TJ20 Status profiles MANDT
0 T370T STSMA TJ20 Status profiles STSMA
1 T370T VIEW_PROF TITOBPROF Technical Objects: View Profiles for Tab Index Customizing MANDT
1 T370T VIEW_PROF TITOBPROF Technical Objects: View Profiles for Tab Index Customizing SUBGRP
1 T370T VIEW_PROF TITOBPROF Technical Objects: View Profiles for Tab Index Customizing PROFILE