SAP Table EQUZ
Equipment time segment
EQUZ (Equipment time segment) 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 EQUZ to other SAP tables.
EQUZ table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
EQUNR
Equipment Number
|
EQUNR | EQUI |
CHAR
|
18 | 0 | |||||||||||
|
DATBI
Valid To Date
|
DATBI |
DATS
|
8 | 0 | ||||||||||||
|
EQLFN
Consecutive numbering of EquipUsagePeriods on same day
|
EQLFN |
NUMC
|
3 | 0 | ||||||||||||
|
EQUZN
Number of next EquipUsagePeriod on same day
|
EQNNR |
NUMC
|
3 | 0 | ||||||||||||
|
ERDAT
Date on Which Record Was Created
|
ERDAT |
DATS
|
8 | 0 | ||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||||||
|
AEDAT
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||||
|
AENAM
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||||||
|
TIMBI
Equipment usage period time stamp
|
TIMBI |
TIMS
|
6 | 0 | ||||||||||||
|
ESTAI
SAP Development Reserve: Format CHAR, Length 1
|
RESERVE_CHAR_001 |
CHAR
|
1 | 0 | ||||||||||||
|
ESTAE
SAP Development reserve: Format CHAR, length 4
|
RESERVE_CHAR_004 |
CHAR
|
4 | 0 | ||||||||||||
|
STNAM
SAP Development Reserve: Format CHAR, Length 12
|
RESERVE_CHAR_012 |
CHAR
|
12 | 0 | ||||||||||||
|
LVORM
SAP Development Reserve: Format CHAR, Length 1
|
RESERVE_CHAR_001 |
CHAR
|
1 | 0 | ||||||||||||
|
DATAB
Valid-From Date
|
DATAB |
DATS
|
8 | 0 | ||||||||||||
|
IWERK
Maintenance Planning Plant
|
IWERK | T399I |
CHAR
|
4 | 0 | |||||||||||
|
IWERKI
Data origin indicator
|
INHER |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
SUBMT
Construction type material of the object
|
SUBMT | MARA |
CHAR
|
18 | 0 | |||||||||||
|
MAPAR
Manufacturer part number
|
MAPAR |
CHAR
|
30 | 0 | ||||||||||||
|
HEQUI
Superordinate Equipment
|
HEQUI | EQUI |
CHAR
|
18 | 0 | |||||||||||
|
HEQNR
Equipment position at InstallLoc (Superior Equip./FunctLoc)
|
HEQNR |
CHAR
|
4 | 0 | ||||||||||||
|
INGRP
Planner Group for Customer Service and Plant Maintenance
|
INGRP | T024I |
CHAR
|
3 | 0 | |||||||||||
|
INGRPI
Data origin indicator
|
INHER |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
PM_OBJTY
Object Type of CIM Resources for Work Center
|
PM_OBJTY |
CHAR
|
2 | 0 | ||||||||||||
|
||||||||||||||||
|
GEWRK
Object ID of the Work Center
|
LGWID | CRID |
NUMC
|
8 | 0 | |||||||||||
|
GEWRKI
Data origin indicator
|
INHER |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
TIDNR
Technical identification number
|
TIDNR |
CHAR
|
25 | 0 | ||||||||||||
|
TIDNRI
Data origin indicator
|
INHER |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
ILOAN
Location and account assignment for technical object
|
ILOAN | ILOA |
CHAR
|
12 | 0 | |||||||||||
|
KUND1
Customer number
|
KUND1 | KNA1 |
CHAR
|
10 | 0 | |||||||||||
|
KUND2
End customer number
|
KUND2 | KNA1 |
CHAR
|
10 | 0 | |||||||||||
|
KUND3
Operator
|
KUND3 | KNA1 |
CHAR
|
10 | 0 | |||||||||||
|
LIZNR
Equipment license number
|
LIZNR |
CHAR
|
20 | 0 | ||||||||||||
|
RBNR
Catalog Profile
|
RBNR | T352B |
CHAR
|
9 | 0 | |||||||||||
|
EZDAT
Date, intended for SAP internal use
|
EQDAT |
DATS
|
8 | 0 | ||||||||||||
|
EZBER
Technical information, intended for SAP internal use
|
EQBER |
CHAR
|
30 | 0 | ||||||||||||
|
EZNUM
Numerical field, intended for SAP internal use
|
EQNUM |
NUMC
|
9 | 0 | ||||||||||||
|
RBNR_I
Data origin indicator
|
INHER |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
IBLNR
Physical Inventory Document
|
IBLNR |
CHAR
|
10 | 0 | ||||||||||||
|
BLDAT
Document Date in Document
|
BLDAT |
DATS
|
8 | 0 | ||||||||||||
|
PVS_FOCUS
Internal Identification for PVS Objects
|
PVS_GUID_CCC |
RAW
|
16 | 0 | ||||||||||||
|
PPEGUID
Internal Identification for PVS Objects
|
PVS_GUID_CCC |
RAW
|
16 | 0 | ||||||||||||
|
TECHS
Parameter Variant/Standard Variant
|
TECHS |
CHAR
|
12 | 0 | ||||||||||||
|
FUNCID
Function Identifier
|
CCC_FUNCID |
CHAR
|
40 | 0 | ||||||||||||
|
FRCFIT
Indicator: Forced Installation/Dismantling
|
CCC_FRCFIT |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
FRCRMV
Force Dismantling Flag
|
CCC_FRCRMV |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
EQUZ foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| EQUZ | EQUNR | EQUZ | MANDT |
EQUI
Equipment master data
|
MANDT |
| EQUZ | EQUNR | EQUZ | EQUNR |
EQUI
Equipment master data
|
EQUNR |
| EQUZ | GEWRK | EQUZ | MANDT |
CRID
CIM Resource - Entities
|
MANDT |
| EQUZ | GEWRK | EQUZ | PM_OBJTY |
CRID
CIM Resource - Entities
|
OBJTY |
| EQUZ | GEWRK | EQUZ | GEWRK |
CRID
CIM Resource - Entities
|
OBJID |
| EQUZ | HEQUI | EQUZ | HEQUI |
EQUI
Equipment master data
|
EQUNR |
| EQUZ | HEQUI | EQUZ | MANDT |
EQUI
Equipment master data
|
MANDT |
| EQUZ | ILOAN | EQUZ | MANDT |
ILOA
PM Object Location and Account Assignment
|
MANDT |
| EQUZ | ILOAN | EQUZ | ILOAN |
ILOA
PM Object Location and Account Assignment
|
ILOAN |
| EQUZ | INGRP | EQUZ | MANDT |
T024I
Maintenance planner groups
|
MANDT |
| EQUZ | INGRP | EQUZ | IWERK |
T024I
Maintenance planner groups
|
IWERK |
| EQUZ | INGRP | EQUZ | INGRP |
T024I
Maintenance planner groups
|
INGRP |
| EQUZ | IWERK | EQUZ | MANDT |
T399I
Planning plant parameters
|
MANDT |
| EQUZ | IWERK | EQUZ | IWERK |
T399I
Planning plant parameters
|
IWERK |
| EQUZ | KUND1 | EQUZ | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| EQUZ | KUND1 | EQUZ | KUND1 |
KNA1
General Data in Customer Master
|
KUNNR |
| EQUZ | KUND2 | EQUZ | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| EQUZ | KUND2 | EQUZ | KUND2 |
KNA1
General Data in Customer Master
|
KUNNR |
| EQUZ | KUND3 | EQUZ | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| EQUZ | KUND3 | EQUZ | KUND3 |
KNA1
General Data in Customer Master
|
KUNNR |
| EQUZ | MANDT | EQUZ | MANDT |
T000
Clients
|
MANDT |
| EQUZ | RBNR | EQUZ | RBNR |
T352B
Technical report
|
RBNR |
| EQUZ | RBNR | EQUZ | MANDT |
T352B
Technical report
|
MANDT |
| EQUZ | SUBMT | EQUZ | SUBMT |
MARA
General Material Data
|
MATNR |
| EQUZ | SUBMT | EQUZ | MANDT |
MARA
General Material Data
|
MANDT |