# Purchasing Info Record and Source List Mass Upload from Excel Program

> 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.

- Type: Program, Custom development, Mass upload
- Module: MM
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/programs/purchasing-info-record-source-list-mass-upload/


## 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.

### Closest standard alternatives

- ME11: Creates info records one at a time; no mass upload from file and no test mode.
- ME01: Maintains the source list manually per material; cannot be loaded together with the info record.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| EINA | Info record general data: material, vendor, vendor material number | Write | - | ECC + S/4 |
| EINE | Info record organizational data: price, price unit, delivery time, standard quantity | Write | EINE-INFNR = EINA-INFNR | ECC + S/4 |
| EORD | Source list: validity, fixed vendor, blocked flag | Write | EORD-MATNR = EINA-MATNR AND EORD-LIFNR = EINA-LIFNR | ECC + S/4 |
| LFA1 | Vendor existence and block check | Read | LFA1-LIFNR = EINA-LIFNR | ECC + S/4 |
| MARC | Whether the material exists in the target plant | Read | MARC-MATNR = EINA-MATNR AND MARC-WERKS = EINE-WERKS | ECC + S/4 |

## BAPIs and functions used

- ME_DIRECT_INPUT_INFORECORD: Creates or updates the info record and its price condition for each row
- ME_DIRECT_INPUT_SOURCE_LIST: Creates the source list entry with validity dates

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| P_FILE | Upload file (XLSX or CSV) | Single value | - | Yes |
| P_UPDATE | Update existing info records | Checkbox | - | No |
| P_SRCL | Also create the source list entry | Checkbox | - | No |
| P_TEST | Test mode (check without saving) | Checkbox | - | No |

## Input file columns

| Column | Target field | Required |
|---|---|---|
| Material | EINA-MATNR | Yes |
| Vendor | EINA-LIFNR | Yes |
| Purchasing organization | EINE-EKORG | Yes |
| Plant | EINE-WERKS | Yes |
| Info record category | EINE-ESOKZ | No |
| Vendor material number | EINA-IDNLF | No |
| Net price | EINE-NETPR | Yes |
| Price unit | EINE-PEINH | No |
| Currency | EINE-WAERS | Yes |
| Planned delivery time (days) | EINE-APLFZ | No |
| Standard order quantity | EINE-NORBM | No |
| Valid from | EORD-VDATU | Yes |
| Valid to | EORD-BDATU | No |
| Fixed vendor | EORD-FLIFN | No |

## Result list columns

| Column | Source |
|---|---|
| Row | Calculated: Row number in the file |
| Material | EINA-MATNR |
| Vendor | EINA-LIFNR |
| Plant | EINE-WERKS |
| Info record | EINA-INFNR |
| Source list entry | EORD-ZEORD |
| Status | Calculated: Created, updated, skipped or error |
| Message | Calculated: Pre-check or function return message |

## 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.

## Authorization objects

- M_EINF_EKO: Info record create/change authorization by purchasing organization
- M_EINF_WRK: Info record authorization by plant
- M_ORDR_WRK: Source 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).

---
Let us build this program for your system: https://nekuhub.com/en/request-a-quote/?report=mm-info-record-source-list-upload
