Mass Equipment Master Upload and Functional Location Installation Program
Short answer: A custom program that creates hundreds of equipment records from an Excel or CSV file with manufacturer, model, serial number, location and account assignment data when a new line or site goes live, and installs them at a functional location if requested. It checks everything in test mode first and stops duplicate serial numbers.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
IE01 creates one equipment; IL01 and IK01 are separate dialogs for functional locations and measuring points. When a new line goes live, hundreds of equipment records have to be created with serial number, manufacturer, location and installation data. LSMW recordings need technical skills and are not recommended in S/4HANA; the Migration Cockpit is meant for the initial data migration. Ongoing commissioning needs a templated upload with a test mode that the maintenance team can run on its own.
Who uses it? Maintenance master data teams, PM consultants, investment and commissioning projects.
Closest standard alternatives
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| EQUIEquipment Master Data | Equipment general data: category, object type, manufacturer, model, serial number | Write | ECC + S/4 |
| EQKTEquipment Short Texts | Equipment description (per language) | Write | ECC + S/4 |
| EQUZEquipment Time Segment | Time segment: planning plant, planner group, installation | Write | ECC + S/4 |
| ILOAPM Object Location and Account Assignment | Location and account assignment: functional location, cost center | Write | ECC + S/4 |
| IFLOTFunctional Location | Check of the functional location for installation | Read | ECC + S/4 |
BAPIs and functions used
- BAPI_EQUI_CREATECreate Equipment. Creates the equipment for each row
- BAPI_EQUI_INSTALLInstall Equipment. Installs the equipment at the functional location
- BAPI_OBJCL_CREATEClassification: Create Object Assignment. Writes optional classification characteristics
- BAPI_TRANSACTION_COMMITCommit a BAPI transaction. Saves successful rows permanently
- BAPI_TRANSACTION_ROLLBACKRoll Back BAPI Transaction. Rolls back changes in test mode and after an error
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_FILE | Upload file (XLSX or CSV) | Single value | — | Yes | C:\temp\ekipmanlar.xlsx |
| P_TEST | Test mode (check without posting) | Checkbox | — | No | X |
| P_INSTAL | Install when a functional location is given | Checkbox | — | No | X |
| P_DUPSER | Duplicate check on manufacturer + serial number | Checkbox | — | No | X |
Input file columns
The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.
| # | Column | Target field | Required |
|---|---|---|---|
| 1 | Equipment (blank = internal number) | EQUI-EQUNR | No |
| 2 | Equipment category | EQUI-EQTYP | Yes |
| 3 | Description | EQKT-EQKTX | Yes |
| 4 | Object type | EQUI-EQART | No |
| 5 | Manufacturer | EQUI-HERST | No |
| 6 | Model number | EQUI-TYPBZ | No |
| 7 | Manufacturer serial number | EQUI-SERGE | No |
| 8 | Construction year | EQUI-BAUJJ | No |
| 9 | Start-up date | EQUI-INBDT | No |
| 10 | Maintenance planning plant | EQUZ-IWERK | Yes |
| 11 | Planner group | EQUZ-INGRP | No |
| 12 | Cost center | ILOA-KOSTL | No |
| 13 | Functional location (installation) | ILOA-TPLNR | No |
Sample upload file
| 1 | Equipment (blank = internal number) | Equipment category * | Description * | Object type | Manufacturer | Model number | Manufacturer serial number | Construction year | Start-up date | Maintenance planning plant * | Planner group | Cost center | Functional location (installation) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | M | Hydraulic press 250 t | PRES | Kuzey Makina | HP-250 | KM24-0187 | 2024 | 02/10/2025 | 1000 | M01 | 410100 | TR01-URT-PRS | |
| 3 | M | Screw compressor 55 kW | KOMP | Boğaziçi Hava Sistemleri | VK-55 | BHS-55-3321 | 2023 | 06/01/2024 | 1000 | M01 | 410300 | TR01-YRD-KMP | |
| 4 | M | Frequency inverter 7.5 kW | INVR | Trakya Elektronik | FI-75 | TE75-90412 | 2025 | 1000 | M02 | 410100 |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Row | Calculated Row number in the file |
| 2 | Equipment | EQUI-EQUNR |
| 3 | Functional location | ILOA-TPLNR |
| 4 | Status | Calculated From the BAPI return messages: created, created and installed or error |
| 5 | Message | Calculated First error or success message from the BAPI return table |
Sample result list
| Row | Equipment | Functional location | Status | Message |
|---|---|---|---|---|
| 2 | 10000215 | TR01-URT-PRS | Created, installed | Equipment 10000215 created and installed at TR01-URT-PRS |
| 3 | 10000216 | TR01-YRD-KMP | Created, installed | Equipment 10000216 created and installed at TR01-YRD-KMP |
| 4 | Error | Object type INVR is not defined |
How does the program work?
- The file (XLSX or CSV) is read; the first row is skipped as the header.
- Every row is checked: equipment category, object type, maintenance planning plant, planner group and cost center must exist in the system. When a functional location is given, it exists in IFLOT and allows equipment installation. If the same manufacturer and serial number already exist in EQUI, the row is stopped as a duplicate.
- The equipment is created with BAPI_EQUI_CREATE: general data (description, object type, manufacturer, model, serial number, construction year, start-up date), location and account assignment (planning plant, planner group, cost center). When the equipment number is blank, an internal number is assigned.
- When the functional location is filled, the equipment is installed there with BAPI_EQUI_INSTALL; a new time segment is opened in EQUZ and the location data in ILOA can be inherited from the functional location.
- In test mode the BAPIs are called and rolled back with BAPI_TRANSACTION_ROLLBACK; in a real run BAPI_TRANSACTION_COMMIT is called after every successful row. If classification characteristics are needed, they are added to the template and written with BAPI_OBJCL_CREATE.
- The result list shows the created equipment number, the functional location it was installed at and the message; failed rows can be downloaded as a separate file.
Performance notes
Run files above a few thousand rows as a background job. Committing per row isolates failed rows and lets an interrupted upload continue where it stopped.
Features
- Test mode (check without posting)
- Line-by-line result and error log
- Download failed lines as a separate file The corrected file can be uploaded again with the same template.
- Export to Excel An empty upload template can be downloaded as Excel.
- Runs as a background job
Authorization objects
- I_SWERKTechnical object maintenance authorization by maintenance plant
- I_BEGRPAuthorization by technical object authorization group
Frequently asked questions
Can functional locations and measuring points be loaded as well?
Yes. Functional location (BAPI_FUNCLOC_CREATE) and measuring point uploads can be added as separate tabs with the same template logic, so the structure of a new line is built from one program in sequence. Each extra object increases the effort range.
Can existing equipment be updated?
Yes. When the equipment number is filled and exists in the system, the row can be processed as an update with BAPI_EQUI_CHANGE; this option is enabled during installation.
Can it be used on S/4HANA?
Yes. BAPI_EQUI_CREATE and BAPI_EQUI_INSTALL are supported on S/4HANA as well. The Migration Cockpit is recommended for the initial migration; this program is for the ongoing need during commissioning.
Packages that include this solution
Excel Mass Data Upload Pack
A pack that puts the five bulk uploads key users run most often into one upload structure: material master, equipment master with installation at a …
Related reports
Maintenance Cost and Downtime by Equipment Report
A custom ALV report that splits the actual cost of maintenance orders per equipment in a period into labor, material, external services and other, and …
MTBF and MTTR Reliability Report by Equipment
A custom ALV report that calculates, from breakdown notifications, the number of breakdowns, total downtime, mean time to repair (MTTR), mean time …
Let us build this program for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.