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
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| EINAPurchasing Info Record: General Data | Info record general data: material, vendor, vendor material number | Write | ECC + S/4 |
| EINEPurchasing Info Record: Purchasing Organization Data | Info record organizational data: price, price unit, delivery time, standard quantity | Write | ECC + S/4 |
| EORDPurchasing Source List | Source list: validity, fixed vendor, blocked flag | Write | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor existence and block check | Read | ECC + S/4 |
| MARCPlant Data for Material | Whether the material exists in the target plant | Read | ECC + 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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_FILE | Upload file (XLSX or CSV) | Single value | — | Yes | C:\temp\bilgi_kayitlari_2027.xlsx |
| P_UPDATE | Update existing info records | Checkbox | — | No | X |
| P_SRCL | Also create the source list entry | Checkbox | — | No | X |
| P_TEST | Test mode (check without saving) | 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 | Material | EINA-MATNR | Yes |
| 2 | Vendor | EINA-LIFNR | Yes |
| 3 | Purchasing organization | EINE-EKORG | Yes |
| 4 | Plant | EINE-WERKS | Yes |
| 5 | Info record category | EINE-ESOKZ | No |
| 6 | Vendor material number | EINA-IDNLF | No |
| 7 | Net price | EINE-NETPR | Yes |
| 8 | Price unit | EINE-PEINH | No |
| 9 | Currency | EINE-WAERS | Yes |
| 10 | Planned delivery time (days) | EINE-APLFZ | No |
| 11 | Standard order quantity | EINE-NORBM | No |
| 12 | Valid from | EORD-VDATU | Yes |
| 13 | Valid to | EORD-BDATU | No |
| 14 | Fixed vendor | EORD-FLIFN | No |
Sample upload file
| 1 | Material * | Vendor * | Purchasing organization * | Plant * | Info record category | Vendor material number | Net price * | Price unit | Currency * | Planned delivery time (days) | Standard order quantity | Valid from * | Valid to | Fixed vendor |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | RM-1001 | 100245 | 1000 | 1000 | 0 | ATL-K4030 | 1.70 | 1 | TRY | 7 | 5,000 | 01/01/2027 | 12/31/2027 | X |
| 3 | RM-2040 | 100387 | 1000 | 1000 | 0 | DM-SAC-2 | 61.20 | 1 | TRY | 14 | 800 | 01/01/2027 | 12/31/2027 | X |
| 4 | CH-0315 | 100512 | 1000 | 2000 | 0 | EGK-SB-20 | 142 | 1 | TRY | 10 | 200 | 01/01/2027 | 06/30/2027 |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Row | Calculated Row number in the file |
| 2 | Material | EINA-MATNR |
| 3 | Vendor | EINA-LIFNR |
| 4 | Plant | EINE-WERKS |
| 5 | Info record | EINA-INFNR |
| 6 | Source list entry | EORD-ZEORD |
| 7 | Status | Calculated Created, updated, skipped or error |
| 8 | Message | Calculated Pre-check or function return message |
Sample result list
| Row | Material | Vendor | Plant | Info record | Source list entry | Status | Message |
|---|---|---|---|---|---|---|---|
| 2 | RM-1001 | 100245 | 1000 | 5300001845 | 00003 | Updated | Price updated from 01.01.2027 |
| 3 | RM-2040 | 100387 | 1000 | 5300002210 | 00001 | Created | Info record and source list entry created |
| 4 | CH-0315 | 100512 | 2000 | Error | Material CH-0315 is not defined in plant 2000 |
How does the program work?
- The file is read; material, vendor, purchasing organization and plant are checked as mandatory.
- 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.
- 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.
- 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.
- 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.
- 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
Purchasing Contract Utilization and Remaining Balance Report
A custom ALV report that lists, for quantity and value contracts, how much of the target quantity and value has been used by release orders, the …
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 …
Purchase Price Variance (PPV) Report by Vendor and Material Group
A custom ALV report that compares the unit price on purchase orders with the material's standard or moving average price, the price in the purchasing …
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.