MM Program Custom development Mass upload

Purchasing Info Record and Source List Mass Upload from Excel Program

Short answer: A custom upload program that creates or updates purchasing info records (price, delivery time, standard quantity) from a single Excel file and also creates the source list entry from the same row. With yearly price agreements or when a new vendor is introduced, hundreds of materials are set up in one run without manual errors.

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?

ME11/ME12 maintain info records and ME01 maintains source lists, one at a time and in separate transactions; the standard system has no tool that loads both together from a file, tests first and returns the failed rows. LSMW or migration tools are meant for one-off use. The custom program loads both records from the same row, with pre-checks and a reusable template.

Who uses it? Buyers, purchasing master data teams and project migration teams.

Closest standard alternatives

  • ME11 Create Purchasing Info Record. Creates info records one at a time; no mass upload from file and no test mode.
  • ME01 Maintain Source List. Maintains the source list manually per material; cannot be loaded together with the info record.

Tables used

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

TableRoleAccessSystem
EINAPurchasing Info Record: General DataInfo record general data: material, vendor, vendor material numberWriteECC + S/4
EINEPurchasing Info Record: Purchasing Organization DataInfo record organizational data: price, price unit, delivery time, standard quantityWriteECC + S/4
EORDPurchasing Source ListSource list: validity, fixed vendor, blocked flagWriteECC + S/4
LFA1Vendor Master (General Section)Vendor existence and block checkReadECC + S/4
MARCPlant Data for MaterialWhether the material exists in the target plantReadECC + S/4

BAPIs and functions used

  • ME_DIRECT_INPUT_INFORECORDMaintain Purchasing Info Record via Direct Input. Creates or updates the info record and its price condition for each row
  • ME_DIRECT_INPUT_SOURCE_LISTMaintain Source List via Direct Input. Creates the source list entry with validity dates

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
P_FILEUpload file (XLSX or CSV)Single value—YesC:\temp\bilgi_kayitlari_2027.xlsx
P_UPDATEUpdate existing info recordsCheckbox—NoX
P_SRCLAlso create the source list entryCheckbox—NoX
P_TESTTest mode (check without saving)Checkbox—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
1MaterialEINA-MATNRYes
2VendorEINA-LIFNRYes
3Purchasing organizationEINE-EKORGYes
4PlantEINE-WERKSYes
5Info record categoryEINE-ESOKZNo
6Vendor material numberEINA-IDNLFNo
7Net priceEINE-NETPRYes
8Price unitEINE-PEINHNo
9CurrencyEINE-WAERSYes
10Planned delivery time (days)EINE-APLFZNo
11Standard order quantityEINE-NORBMNo
12Valid fromEORD-VDATUYes
13Valid toEORD-BDATUNo
14Fixed vendorEORD-FLIFNNo

Sample upload file

1Material *Vendor *Purchasing organization *Plant *Info record categoryVendor material numberNet price *Price unitCurrency *Planned delivery time (days)Standard order quantityValid from *Valid toFixed vendor
2RM-1001100245100010000ATL-K40301.701TRY75,00001/01/202712/31/2027X
3RM-2040100387100010000DM-SAC-261.201TRY1480001/01/202712/31/2027X
4CH-0315100512100020000EGK-SB-201421TRY1020001/01/202706/30/2027
A view built with fictional sample data; not real system data.

Result list columns

#ColumnSource
1RowCalculated Row number in the file
2MaterialEINA-MATNR
3VendorEINA-LIFNR
4PlantEINE-WERKS
5Info recordEINA-INFNR
6Source list entryEORD-ZEORD
7StatusCalculated Created, updated, skipped or error
8MessageCalculated Pre-check or function return message

Sample result list

RowMaterialVendorPlantInfo recordSource list entryStatusMessage
2RM-10011002451000530000184500003UpdatedPrice updated from 01.01.2027
3RM-20401003871000530000221000001CreatedInfo record and source list entry created
4CH-03151005122000ErrorMaterial CH-0315 is not defined in plant 2000
A view built with fictional sample data; not real system data.

How does the program work?

  1. The file is read; material, vendor, purchasing organization and plant are checked as mandatory.
  2. Pre-checks: the vendor exists in LFA1 and is not blocked, the material exists in MARC for the target plant, the currency and price unit are valid.
  3. EINA and EINE are searched for a record with the same material/vendor/organization/plant. If none exists, it is created; if one exists and “update” is selected, price, delivery time and quantities are updated, otherwise the row is skipped.
  4. The info record is written with ME_DIRECT_INPUT_INFORECORD; the price is created as a price condition with the validity start from the file.
  5. If the source list option is set, EORD is checked for an overlapping entry in the same period, then ME_DIRECT_INPUT_SOURCE_LIST creates the entry with validity dates and the fixed vendor flag.
  6. In test mode nothing is written; the result of each row is shown in the ALV log and failed rows can be exported to a file for correction.

Performance notes

For the pre-checks, read LFA1, MARC and the existing EINA/EINE records once with the keys from the file. With thousands of rows, run the program in the background with a file on the server; release locks with COMMIT WORK after each row.

Features

  • Test mode (check without posting)
  • Line-by-line result and error log
  • Download failed lines as a separate file Failed rows can be downloaded in the same template and uploaded again after correction.
  • Export to Excel An empty upload template can be downloaded as Excel.
  • Runs as a background job

Authorization objects

  • M_EINF_EKOInfo record create/change authorization by purchasing organization
  • M_EINF_WRKInfo record authorization by plant
  • M_ORDR_WRKSource list maintenance authorization by plant

Frequently asked questions

Is the old price lost when the price changes?

No. The new price is written as a new price condition with the validity start from the file; the price of the earlier period remains in the history and older orders are not affected.

What happens if two vendors are marked as fixed for the same material?

The program rejects a second fixed vendor for the same period and plant in EORD and returns the row as an error. This avoids ambiguity in source determination.

Does it work on S/4HANA?

Yes. EINA, EINE and EORD keep the same structure in S/4HANA. If clean core is preferred, the same file template can be routed to the released info record API (the object read via I_PurchasingInfoRecordAPI01).

Related reports

MM Program Custom Mass upload

Mass Purchase Order Creation from Excel Program

A custom program that creates purchase orders in bulk from Excel or CSV rows, grouping them by vendor, purchasing organization and group number. It …

EKKO · EKPO · EKET · EKKN

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: Purchasing Info Record and Source List Mass Upload from Excel Program