SAP Table BAPI_EQALL
BAPI Structure for all Relevant Data of an Equipment
BAPI_EQALL (BAPI Structure for all Relevant Data of an Equipment) 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 BAPI_EQALL to other SAP tables.
BAPI_EQALL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| EQUIPMENT | Equipment Number | EQUNR | EQUI | CHAR | 18 | 0 | ||
| EQUICATGRY | Equipment category | EQTYP | T370T | CHAR | 1 | 0 | ||
| EQUITYPE | Type of Technical Object | EQART | T370K | CHAR | 10 | 0 | ||
| INVENTORY | Inventory number | INVNR | CHAR | 25 | 0 | |||
| VENDOR | Vendor number | ELIEF | LFA1 | CHAR | 10 | 0 | ||
| WARRANTY | Date on which the warranty ends | GWLEN | DATS | 8 | 0 | |||
| MANFACTURE | Manufacturer of asset | HERST | CHAR | 30 | 0 | |||
| MANCOUNTRY | Country of manufacture | HERLD | T005 | CHAR | 3 | 0 | ||
| MANMODEL | Manufacturer model number | TYPBZ | CHAR | 20 | 0 | |||
| MATERIAL | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
| SERIALNO | Serial Number | GERNR | CHAR | 18 | 0 | |||
| MATERIAL_EXTERNAL | Long Material Number for MATERIAL Field | MGV_MATERIAL_EXTERNAL | CHAR | 40 | 0 | |||
| MATERIAL_GUID | External GUID for MATERIAL Field | MGV_MATERIAL_GUID | CHAR | 32 | 0 | |||
| MATERIAL_VERSION | Version Number for MATERIAL Field | MGV_MATERIAL_VERSION | CHAR | 10 | 0 | |||
| UII | Unique Item Identifier | UII_CHAR72 | CHAR | 72 | 0 | |||
| PLANPLANT | Maintenance Planning Plant | IWERK | T001W | CHAR | 4 | 0 | ||
| PLANGROUP | Planner Group for Customer Service and Plant Maintenance | INGRP | T024I | CHAR | 3 | 0 | ||
| EQUIDESCR | Description of technical object | KTX01 | CHAR | 40 | 0 | |||
| ABCINDIC | ABC indicator for technical object | ABCKZ | T370C | CHAR | 1 | 0 | ||
| SORTFIELD | Sort field | EQFNR | CHAR | 30 | 0 | |||
| MAINTPLANT | Maintenance plant | SWERK | T001W | CHAR | 4 | 0 | ||
| MAINTLOC | Location of maintenance object | PMLOC | T499S | CHAR | 10 | 0 | ||
| MAINTROOM | Room | RAUMNR | CHAR | 8 | 0 | |||
| BUS_AREA | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||
| COSTCENTER | Cost Center | KOSTL | CSKS | CHAR | 10 | 0 | ||
| COMP_CODE | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||
| SALESORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||
| DISTR_CHAN | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||
| DIVISION | Division | SPART | TSPA | CHAR | 2 | 0 | ||
| CUSTOMER | Customer number | KUND1 | KNA1 | CHAR | 10 | 0 | ||
| ENDCUSTOM | End customer number | KUND2 | KNA1 | CHAR | 10 | 0 | ||
| OPERATOR | Operator | KUND3 | KNA1 | CHAR | 10 | 0 | ||
| FUNCLOC | Functional Location | TPLNR | IFLOT | CHAR | 30 | 0 | ||
| SUPEREQUI | Superordinate Equipment | HEQUI | EQUI | CHAR | 18 | 0 | ||
| POSEQUI | Equipment position at InstallLoc (Superior Equip./FunctLoc) | HEQNR | CHAR | 4 | 0 | |||
| CONTAREA | Controlling Area | KOKRS | TKA01 | CHAR | 4 | 0 | ||
BAPI_EQALL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| BAPI_EQALL | ABCINDIC | BAPI_EQALL | ABCINDIC | T370C | ABC indicator for technical objects | ABCKZ |
| BAPI_EQALL | ABCINDIC | SY | MANDT | T370C | ABC indicator for technical objects | MANDT |
| BAPI_EQALL | BUS_AREA | SY | MANDT | TGSB | Business Areas | MANDT |
| BAPI_EQALL | BUS_AREA | BAPI_EQALL | BUS_AREA | TGSB | Business Areas | GSBER |
| BAPI_EQALL | COMP_CODE | SY | MANDT | T001 | Company Codes | MANDT |
| BAPI_EQALL | COMP_CODE | BAPI_EQALL | COMP_CODE | T001 | Company Codes | BUKRS |
| BAPI_EQALL | CONTAREA | BAPI_EQALL | CONTAREA | TKA01 | Controlling Areas | KOKRS |
| BAPI_EQALL | CONTAREA | SY | MANDT | TKA01 | Controlling Areas | MANDT |
| BAPI_EQALL | COSTCENTER | SY | MANDT | CSKS | Cost Center Master Data | MANDT |
| BAPI_EQALL | COSTCENTER | * | CSKS | Cost Center Master Data | KOKRS | |
| BAPI_EQALL | COSTCENTER | BAPI_EQALL | COSTCENTER | CSKS | Cost Center Master Data | KOSTL |
| BAPI_EQALL | COSTCENTER | * | CSKS | Cost Center Master Data | DATBI | |
| BAPI_EQALL | CUSTOMER | BAPI_EQALL | CUSTOMER | KNA1 | General Data in Customer Master | KUNNR |
| BAPI_EQALL | CUSTOMER | SY | MANDT | KNA1 | General Data in Customer Master | MANDT |
| BAPI_EQALL | DISTR_CHAN | SY | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| BAPI_EQALL | DISTR_CHAN | BAPI_EQALL | DISTR_CHAN | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| BAPI_EQALL | DIVISION | SY | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| BAPI_EQALL | DIVISION | BAPI_EQALL | DIVISION | TSPA | Organizational Unit: Sales Divisions | SPART |
| BAPI_EQALL | ENDCUSTOM | SY | MANDT | KNA1 | General Data in Customer Master | MANDT |
| BAPI_EQALL | ENDCUSTOM | BAPI_EQALL | ENDCUSTOM | KNA1 | General Data in Customer Master | KUNNR |
| BAPI_EQALL | EQUICATGRY | SY | MANDT | T370T | Equipment categories | MANDT |
| BAPI_EQALL | EQUICATGRY | BAPI_EQALL | EQUICATGRY | T370T | Equipment categories | EQTYP |
| BAPI_EQALL | EQUIPMENT | SY | MANDT | EQUI | Equipment master data | MANDT |
| BAPI_EQALL | EQUIPMENT | BAPI_EQALL | EQUIPMENT | EQUI | Equipment master data | EQUNR |
| BAPI_EQALL | EQUITYPE | SY | MANDT | T370K | Type of technical object | MANDT |
| BAPI_EQALL | EQUITYPE | BAPI_EQALL | EQUITYPE | T370K | Type of technical object | EQART |
| BAPI_EQALL | FUNCLOC | SY | MANDT | IFLOT | Functional Location (Table) | MANDT |
| BAPI_EQALL | FUNCLOC | BAPI_EQALL | FUNCLOC | IFLOT | Functional Location (Table) | TPLNR |
| BAPI_EQALL | MAINTLOC | BAPI_EQALL | MAINTPLANT | T499S | Location | WERKS |
| BAPI_EQALL | MAINTLOC | BAPI_EQALL | MAINTLOC | T499S | Location | STAND |
| BAPI_EQALL | MAINTLOC | SY | MANDT | T499S | Location | MANDT |
| BAPI_EQALL | MAINTPLANT | SY | MANDT | T001W | Plants/Branches | MANDT |
| BAPI_EQALL | MAINTPLANT | BAPI_EQALL | MAINTPLANT | T001W | Plants/Branches | WERKS |
| BAPI_EQALL | MANCOUNTRY | BAPI_EQALL | MANCOUNTRY | T005 | Countries | LAND1 |
| BAPI_EQALL | MANCOUNTRY | SY | MANDT | T005 | Countries | MANDT |
| BAPI_EQALL | MATERIAL | SY | MANDT | MARA | General Material Data | MANDT |
| BAPI_EQALL | MATERIAL | BAPI_EQALL | MATERIAL | MARA | General Material Data | MATNR |
| BAPI_EQALL | OPERATOR | SY | MANDT | KNA1 | General Data in Customer Master | MANDT |
| BAPI_EQALL | OPERATOR | BAPI_EQALL | OPERATOR | KNA1 | General Data in Customer Master | KUNNR |
| BAPI_EQALL | PLANGROUP | SY | MANDT | T024I | Maintenance planner groups | MANDT |
| BAPI_EQALL | PLANGROUP | BAPI_EQALL | PLANPLANT | T024I | Maintenance planner groups | IWERK |
| BAPI_EQALL | PLANGROUP | BAPI_EQALL | PLANGROUP | T024I | Maintenance planner groups | INGRP |
| BAPI_EQALL | PLANPLANT | SY | MANDT | T001W | Plants/Branches | MANDT |
| BAPI_EQALL | PLANPLANT | BAPI_EQALL | PLANPLANT | T001W | Plants/Branches | WERKS |
| BAPI_EQALL | SALESORG | SY | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| BAPI_EQALL | SALESORG | BAPI_EQALL | SALESORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| BAPI_EQALL | SUPEREQUI | SY | MANDT | EQUI | Equipment master data | MANDT |
| BAPI_EQALL | SUPEREQUI | BAPI_EQALL | SUPEREQUI | EQUI | Equipment master data | EQUNR |
| BAPI_EQALL | VENDOR | SY | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| BAPI_EQALL | VENDOR | BAPI_EQALL | VENDOR | LFA1 | Vendor Master (General Section) | LIFNR |
