PM Program Custom development Mass upload

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

  • IE01 Create Equipment. Creates one equipment; it does not read files or install in bulk.
  • LSMW Legacy System Migration Workbench. Can load from files but needs technical setup; not recommended in S/4HANA.

Tables used

The tables the program reads and updates. ECC and S/4HANA differences are marked separately.

TableRoleAccessSystem
EQUIEquipment Master DataEquipment general data: category, object type, manufacturer, model, serial numberWriteECC + S/4
EQKTEquipment Short TextsEquipment description (per language)WriteECC + S/4
EQUZEquipment Time SegmentTime segment: planning plant, planner group, installationWriteECC + S/4
ILOAPM Object Location and Account AssignmentLocation and account assignment: functional location, cost centerWriteECC + S/4
IFLOTFunctional LocationCheck of the functional location for installationReadECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
P_FILEUpload file (XLSX or CSV)Single value—YesC:\temp\ekipmanlar.xlsx
P_TESTTest mode (check without posting)Checkbox—NoX
P_INSTALInstall when a functional location is givenCheckbox—NoX
P_DUPSERDuplicate check on manufacturer + serial numberCheckbox—NoX

Input file columns

The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.

#ColumnTarget fieldRequired
1Equipment (blank = internal number)EQUI-EQUNRNo
2Equipment categoryEQUI-EQTYPYes
3DescriptionEQKT-EQKTXYes
4Object typeEQUI-EQARTNo
5ManufacturerEQUI-HERSTNo
6Model numberEQUI-TYPBZNo
7Manufacturer serial numberEQUI-SERGENo
8Construction yearEQUI-BAUJJNo
9Start-up dateEQUI-INBDTNo
10Maintenance planning plantEQUZ-IWERKYes
11Planner groupEQUZ-INGRPNo
12Cost centerILOA-KOSTLNo
13Functional location (installation)ILOA-TPLNRNo

Sample upload file

1Equipment (blank = internal number)Equipment category *Description *Object typeManufacturerModel numberManufacturer serial numberConstruction yearStart-up dateMaintenance planning plant *Planner groupCost centerFunctional location (installation)
2MHydraulic press 250 tPRESKuzey MakinaHP-250KM24-0187202402/10/20251000M01410100TR01-URT-PRS
3MScrew compressor 55 kWKOMPBoğaziçi Hava SistemleriVK-55BHS-55-3321202306/01/20241000M01410300TR01-YRD-KMP
4MFrequency inverter 7.5 kWINVRTrakya ElektronikFI-75TE75-9041220251000M02410100
A view built with fictional sample data; not real system data.

Result list columns

#ColumnSource
1RowCalculated Row number in the file
2EquipmentEQUI-EQUNR
3Functional locationILOA-TPLNR
4StatusCalculated From the BAPI return messages: created, created and installed or error
5MessageCalculated First error or success message from the BAPI return table

Sample result list

RowEquipmentFunctional locationStatusMessage
210000215TR01-URT-PRSCreated, installedEquipment 10000215 created and installed at TR01-URT-PRS
310000216TR01-YRD-KMPCreated, installedEquipment 10000216 created and installed at TR01-YRD-KMP
4ErrorObject type INVR is not defined
A view built with fictional sample data; not real system data.

How does the program work?

  1. The file (XLSX or CSV) is read; the first row is skipped as the header.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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

CA Package Custom

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 …

5 components · v1.0

Related reports

PM Report Custom ALV report

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 …

AFIH · AUFK · COEP · QMIH

PM Report Custom ALV report

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 …

QMIH · QMEL · QMFE · QMUR

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.

Related report: Mass Equipment Master Upload and Functional Location Installation Program