# SAP Purchasing Info Record Mass Upload Worksheet (ME11)

> Source: https://netray.co/tools/sap-info-record-mass-upload-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Editable worksheet for preparing info record data (EINA, EINE fields) with price per unit and annual value checks before upload.

## Category

sap

## Erp

SAP S/4HANA

## Audience

- SAP MM consultant
- Master data specialist
- Buyer

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Vendor (LIFNR)

**Key:** lifnr

**Type:** text

#### Material (MATNR)

**Key:** matnr

**Type:** text

#### Purch. org (EKORG)

**Key:** ekorg

**Type:** text

#### Plant (WERKS)

**Key:** werks

**Type:** text

#### Info record category (ESOKZ)

**Key:** esokz

**Type:** select

**Options:**

- 0 Standard
- 1 Subcontracting
- 2 Pipeline
- 3 Consignment

#### Net price (NETPR)

**Key:** netpr

**Type:** number

**Format:** currency

#### Price unit (PEINH)

**Key:** peinh

**Type:** number

**Help:** Quantity the net price refers to, for example 100 means price per 100 units.

#### Order price unit (BPRME)

**Key:** bprme

**Type:** select

**Options:**

- EA
- KG
- M
- PC
- L

#### Planned delivery time (days)

**Key:** aplfz

**Type:** number

#### Expected annual quantity

**Key:** annual

**Type:** number

#### Price per single unit

**Key:** unit_price

**Type:** number

**Expr:** netpr / peinh

**Format:** currency

#### Expected annual value

**Key:** annual_val

**Type:** number

**Expr:** annual * netpr / peinh

**Format:** currency

#### Price valid to

**Key:** valid_to

**Type:** date

**Rows:**

**Lifnr:** 100045

**Matnr:** FAST-0412

**Ekorg:** 1000

**Werks:** 1000

**Esokz:** 0 Standard

**Netpr:** 42

**Peinh:** 100

**Bprme:** EA

**Aplfz:** 14

**Annual:** 60000

**Valid to:** 2027-10-31

**Lifnr:** 100078

**Matnr:** HSG-8820

**Ekorg:** 1000

**Werks:** 1000

**Esokz:** 0 Standard

**Netpr:** 18.5

**Peinh:** 1

**Bprme:** EA

**Aplfz:** 28

**Annual:** 2400

**Valid to:** 2027-10-31

**Lifnr:** 100112

**Matnr:** CBL-1150

**Ekorg:** 1000

**Werks:** 1000

**Esokz:** 3 Consignment

**Netpr:** 6.8

**Peinh:** 1

**Bprme:** M

**Aplfz:** 10

**Annual:** 5000

**Valid to:** 2027-03-31

**Lifnr:** 100130

**Matnr:** SEAL-0071

**Ekorg:** 1000

**Werks:** 1000

**Esokz:** 1 Subcontracting

**Netpr:** 2.15

**Peinh:** 1

**Bprme:** EA

**Aplfz:** 21

**Annual:** 12000

**Valid to:** 2027-12-31

**Lifnr:** 100145

**Matnr:** BRG-6204

**Ekorg:** 2000

**Werks:** 2000

**Esokz:** 0 Standard

**Netpr:** 790

**Peinh:** 100

**Bprme:** EA

**Aplfz:** 35

**Annual:** 4800

**Valid to:** 2027-06-30

**Totals:**

#### Total expected annual value

**Key:** annual_val

**Agg:** sum

**Format:** currency

#### Average planned delivery time

**Key:** aplfz

**Agg:** avg

**Format:** days

**Summary:**

#### Info records in file

**Key:** records

**Expr:** count

**Format:** integer

#### Average annual value per record

**Key:** avg_value

**Expr:** sum_annual_val / count

**Format:** currency

**Notes:** Info records live in tables EINA (general vendor material data) and EINE (purchasing organization data). Condition prices are stored through condition records. Check which fields your migration cockpit object, LSMW recording or BAPI expects. This sheet prepares and sanity checks the data and does not post anything to SAP.

## Content

**Intro:** A purchasing info record stores the relationship between one vendor and one material: price, delivery time, tolerances and order unit. Migrating or refreshing hundreds of them is a common SAP MM task. This worksheet gives you a clean layout and instant value checks before you load.

**Sections:**

#### How to use the worksheet

**Body:** Replace the sample rows with your records: one row per vendor, material, organization and plant combination. Pick the info record category, then enter net price, price unit and order price unit. The sheet computes price per single unit and expected annual value, which makes outliers visible, for example a price entered per 1 that should be per 100. Export to Excel and use it as the upload source for the migration cockpit, a recording or a custom program.

#### Key fields and how SAP uses them

**Body:** EINA holds data valid across organizations, such as vendor material number and order unit. EINE holds purchasing organization and plant data: net price, price unit (PEINH), planned delivery time (APLFZ), standard order quantity and tolerances. The price itself is held as a condition record, so a load must create the condition together with the record. The info record category decides whether the record is used for standard, subcontracting, pipeline or consignment procurement.

**Bullets:**

- Standard (0): normal purchase from the vendor
- Subcontracting (1): the vendor assembles with components you supply
- Pipeline (2): material is withdrawn from a pipeline and invoiced periodically
- Consignment (3): vendor owned stock at your site

#### Worked example

**Body:** A fastener has a net price of 42 per price unit of 100 pieces. The sheet shows a price per single unit of 0.42 and with 60,000 pieces a year an expected annual value of 25,200. If a colleague typed 42 with a price unit of 1 by mistake, the sheet would show 2.52 million, a clear sign of an error you can catch before the upload. Use the average value summary to spot rows far above the typical.

#### Common mistakes

**Body:** Price unit errors are the most expensive, followed by wrong order price unit conversions. Others include loading a record for a vendor not extended to the purchasing organization, mixing plant specific and organization level records for the same vendor and material, and ignoring validity dates on conditions so that old prices stay active. Always reconcile the loaded records with a SELECT on EINA and EINE or a report such as ME1M after the load.

**Cta:** If you are consolidating prices from several ERPs or spreadsheets into SAP info records, we can help validate the source data and map it to the right fields before the load.

**Faq:**

#### What are the main tables for info records in SAP?

**Answer:** EINA stores general data of the info record: vendor, material and order unit. EINE stores purchasing organization and plant specific data such as net price, planned delivery time and tolerances. Conditions for the price are stored in the condition tables, accessed through the record.

#### How can I mass upload info records in SAP?

**Answer:** Typical routes are the S/4HANA migration cockpit with a purchasing info record object, LSMW with a ME11 recording, or a program that calls standard BAPIs. Prepare the data in Excel, test on a few records, then load. Reconcile with ME1M afterwards.

#### What is the price unit in an info record?

**Answer:** It is the quantity that the net price refers to. A net price of 42 with a price unit of 100 means 42 per 100 pieces, or 0.42 each. The order price unit defines the unit of measure of that quantity and may differ from the base unit of the material.

#### Do I need an info record to create a purchase order?

**Answer:** No. A PO can be created without one, but then price and delivery time must be typed by the buyer. With an info record the system proposes them, and MRP can use it for source determination. Info records also feed price history and vendor evaluations.

## Search terms

sap info record upload, sap me11 info record mass upload, sap purchasing info record excel, sap eina eine fields, sap info record template, sap info record migration, sap me12 change info record, sap info record price per unit

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json