SAP ABAP Table EQUI (Equipment master data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷
IEQM (Package) Application Develoment R/3 Equipment Management

⤷

⤷

⤷

Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | EQUI |
![]() |
Short Description | Equipment master data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
![]() |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | ![]() |
EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | ||
3 | ![]() |
ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
4 | ![]() |
ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
5 | ![]() |
EQASP | SPRAS | LANG | 1 | 0 | Language in which the piece of equipment was entered | T002 | |
6 | ![]() |
AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
7 | ![]() |
AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
8 | ![]() |
IAUTG | IAUTG | CHAR | 4 | 0 | Authorization Group for Technical Object | T370B | |
9 | ![]() |
EQTYP | EQTYP | CHAR | 1 | 0 | Equipment Category | T370T | |
10 | ![]() |
EQART | EQART | CHAR | 10 | 0 | Type of Technical Object | T370K | |
11 | ![]() |
RESERVE_CHAR_001 | CHAR1 | CHAR | 1 | 0 | SAP Development Reserve: Format CHAR, Length 1 | ||
12 | ![]() |
INVNR | INVNR_ANLA | CHAR | 25 | 0 | Inventory number | ||
13 | ![]() |
GROSS | GROES | CHAR | 18 | 0 | Size/dimension | ||
14 | ![]() |
OBJ_WEIGHT | MENG13 | QUAN | 13 | 3 | Weight of object | ||
15 | ![]() |
WEIGHT_UNIT | MEINS | UNIT | 3 | 0 | Unit of weight | T006 | |
16 | ![]() |
ANDTI | DATUM | DATS | 8 | 0 | Acquisition date | ||
17 | ![]() |
ANSWT | WERT | CURR | 13 | 2 | Acquisition Value | ||
18 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
19 | ![]() |
ELIEF | LIFNR | CHAR | 10 | 0 | Vendor number | LFA1 | |
20 | ![]() |
GWLEN | DATUM | DATS | 8 | 0 | Date on which the warranty ends | ||
21 | ![]() |
GWLDT | DATUM | DATS | 8 | 0 | Guarantee date | ||
22 | ![]() |
WDBWT | WERT | CURR | 13 | 2 | Equipment replacement value | ||
23 | ![]() |
HERST | TEXT30 | CHAR | 30 | 0 | Manufacturer of asset | ||
24 | ![]() |
HERLD | LAND1 | CHAR | 3 | 0 | Country of manufacture | T005 | |
25 | ![]() |
HZEIN | HZEIN | CHAR | 30 | 0 | Manufacturer drawing number | ||
26 | ![]() |
SERGE | CHAR30 | CHAR | 30 | 0 | Manufacturer serial number | ||
27 | ![]() |
TYPBZ | TYPBZ | CHAR | 20 | 0 | Manufacturer model number | ||
28 | ![]() |
BAUJJ | CJAHR | CHAR | 4 | 0 | Year of construction | ||
29 | ![]() |
BAUMM | BAUMM | CHAR | 2 | 0 | Month of construction | ||
30 | ![]() |
APLKZ | APLKZ | CHAR | 1 | 0 | Indicator: Task List Exists | ||
31 | ![]() |
AULDT | DATUM | DATS | 8 | 0 | First delivery date of the equipment | ||
32 | ![]() |
ILOM_DATAB | DATUM | DATS | 8 | 0 | Start-up Date of the Technical Object | ||
33 | ![]() |
GERNR | GERNR | CHAR | 18 | 0 | Serial Number | ||
34 | ![]() |
EQLFN | NUM03 | NUMC | 3 | 0 | Consecutive numbering of EquipUsagePeriods on same day | ||
35 | ![]() |
GWLDV | DATUM | DATS | 8 | 0 | Warranty date for Sales and Distribution | ||
36 | ![]() |
EQDAT | DATUM | DATS | 8 | 0 | Date | ||
37 | ![]() |
EQBER | CHAR30 | CHAR | 30 | 0 | Text for Notes | ||
38 | ![]() |
EQNUM | NUM9 | NUMC | 9 | 0 | Numerical Field | ||
39 | ![]() |
J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
40 | ![]() |
EQSNR | EQSNR | CHAR | 18 | 0 | EQSE Number | EQSE | |
41 | ![]() |
CUOBJ | CUOBJ | NUMC | 18 | 0 | Configuration (internal object number) | ||
42 | ![]() |
KRFKZ | X | CHAR | 1 | 0 | Referenced Configuration | ||
43 | ![]() |
KMATN | MATNR | CHAR | 18 | 0 | Configurable Material | MARA | |
44 | ![]() |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
45 | ![]() |
GERNR | GERNR | CHAR | 18 | 0 | Serial Number | ||
46 | ![]() |
WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
47 | ![]() |
LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
48 | ![]() |
CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCH1 | |
49 | ![]() |
KUNDSE | KUNNR | CHAR | 10 | 0 | Customer to Whom Serial Number was Delivered | KNA1 | |
50 | ![]() |
WARPL | WARPL | CHAR | 12 | 0 | Maintenance Plan | MPLA | |
51 | ![]() |
IMRC_POINT | IMRC_POINT | CHAR | 12 | 0 | Measuring Point | IMPTT | |
52 | ![]() |
REVLV | REVLV | CHAR | 2 | 0 | Revision level | ||
53 | ![]() |
MGANR | MGANR | CHAR | 20 | 0 | Master warranty number | BGMK | |
54 | ![]() |
INH_BEGRUI | INHER | CHAR | 1 | 0 | Data origin for authorization group field | ||
55 | ![]() |
EQUIP_KNZ | X | CHAR | 1 | 0 | Equipment | ||
56 | ![]() |
KZKSD | X | CHAR | 1 | 0 | Serial data when maintaining equipment | ||
57 | ![]() |
KONFKNZ | XFELD | CHAR | 1 | 0 | Configuration supported | ||
58 | ![]() |
SDKNZ | XFELD | CHAR | 1 | 0 | Sales equipment | ||
59 | ![]() |
FHMKZ | XFLAG | CHAR | 1 | 0 | Equip. category relevant to production resources and tools | ||
60 | ![]() |
ELSE_KNZ | X | CHAR | 1 | 0 | Indicator: Other Data Active | ||
61 | ![]() |
ISU_KNZ | X | CHAR | 1 | 0 | IS-U data | ||
62 | ![]() |
KZEQBS | KZEQBS | CHAR | 1 | 0 | EQSI Exists | ||
63 | ![]() |
FLEET_KNZ | X | CHAR | 1 | 0 | Indicator: Fleet object active | ||
64 | ![]() |
BSTVP | BSTVP | CHAR | 1 | 0 | Stock Check for Serial Numbers | ||
65 | ![]() |
SPARTE | SPART | CHAR | 2 | 0 | Division | TSPA | |
66 | ![]() |
ITOBTMP_TSEGGUID | SYSUUID_22 | CHAR | 22 | 0 | SAP Development Reserve: Integration of Date Segment (Key) | ||
67 | ![]() |
ITOBTMP_TSEGTEMPLA | TSEGTEMPLA | CHAR | 10 | 0 | SAP Development Reserve: Integration Date Segment (Template) | * | |
68 | ![]() |
EMATN | MATNR | CHAR | 18 | 0 | Material number corresponding to manufacturer part number | * | |
69 | ![]() |
AAPM_ACT_CHANGE_AA | AAPM_ACT | CHAR | 1 | 0 | Change Equipment Master when Changing Asset | ||
70 | ![]() |
CCC_KNZ | X | CHAR | 1 | 0 | Configuration Control Data | ||
71 | ![]() |
DATLWB | DATS | DATS | 8 | 0 | Date of Last Goods Movement | ||
72 | ![]() |
UII_CHAR72 | UII_CHAR72 | CHAR | 72 | 0 | Unique Item Identifier | ||
73 | ![]() |
IUID_TYPE | IUID_TYPE | CHAR | 10 | 0 | Structure Type of UII | TIUID_TYPE | |
74 | ![]() |
UII_PLANT | WERKS | CHAR | 4 | 0 | Plant Responsible for UII | * | |
75 | ![]() |
0 | 0 | ||||||
76 | ![]() |
0 | 0 | Equipment Add On for Bw SDP | |||||
77 | ![]() |
/ISDFPS/DE_LM_DB_EQEXT_ACTIVE | XFELD | CHAR | 1 | 0 | Backpack Table /isdfps/lmeqext Active | ||
78 | ![]() |
0 | 0 | Enhancements to Shift Note/Report | |||||
79 | ![]() |
COCF_SR_SRTYPE | CHAR | 10 | 0 | Shift Report Type | COCF_CU_SRTYPE | ||
80 | ![]() |
COCF_SN_SNTYPE | QMART | CHAR | 2 | 0 | Shift Note Type | TQ80 | |
81 | ![]() |
0 | 0 | Logbook Equi Append | |||||
82 | ![]() |
DIACL_DUTY | XFLAG | CHAR | 1 | 0 | Logbook Duty | ||
83 | ![]() |
DIACL_HIDE | XFLAG | CHAR | 1 | 0 | Hide Logbook Display |
Foreign Keys
![]() |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
---|---|---|---|---|---|---|---|
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
1 | EQUI | BEGRU | ![]() |
![]() |
REF | C | CN |
2 | EQUI | CHARGE | ![]() |
![]() |
|||
3 | EQUI | ELIEF | ![]() |
![]() |
REF | 1 | CN |
4 | EQUI | EQART | ![]() |
![]() |
REF | C | CN |
5 | EQUI | EQASP | ![]() |
![]() |
KEY | 1 | CN |
6 | EQUI | EQSNR | ![]() |
![]() |
KEY | 1 | C |
7 | EQUI | EQTYP | ![]() |
![]() |
REF | 1 | CN |
8 | EQUI | EQUI_SNTYPE | ![]() |
![]() |
KEY | 1 | CN |
9 | EQUI | EQUI_SRTYPE | ![]() |
![]() |
KEY | 1 | CN |
10 | EQUI | GEWEI | ![]() |
![]() |
REF | 1 | CN |
11 | EQUI | HERLD | ![]() |
![]() |
REF | 1 | CN |
12 | EQUI | IMRC_POINT | ![]() |
![]() |
|||
13 | EQUI | IUID_TYPE | ![]() |
![]() |
|||
14 | EQUI | KMATN | ![]() |
![]() |
REF | 1 | CN |
15 | EQUI | KUNDE | ![]() |
![]() |
|||
16 | EQUI | LAGER | ![]() |
![]() |
|||
17 | EQUI | MANDT | ![]() |
![]() |
KEY | 1 | CN |
18 | EQUI | MATNR | ![]() |
![]() |
|||
19 | EQUI | MGANR | ![]() |
![]() |
|||
20 | EQUI | SPARTE | ![]() |
![]() |
KEY | 1 | CN |
21 | EQUI | WAERS | ![]() |
![]() |
REF | 1 | CN |
22 | EQUI | WARPL | ![]() |
![]() |
|||
23 | EQUI | WERK | ![]() |
![]() |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |