OMRC table in SAP Business One (Manufacturers)
OMRC is the SAP Business One manufacturers table: one row per manufacturer, with a numeric code (FirmCode) and a name (FirmName). Items point to their manufacturer through OITM.FirmCode, so OMRC is mostly used to show the manufacturer name in item, stock and sales reports.
OMRC key fields
| Field | What it holds |
|---|---|
FirmCode | Manufacturer code, the key. OITM.FirmCode points to it. |
FirmName | Manufacturer name (up to 30 characters). |
DataSource | How the row was created, for example O = DI API, S = Service Layer, M = import. |
UserSign | User signature. Joins to OUSR. |
OITM.FirmCode | Manufacturer of the item; the default is -1. |
How OMRC relates to other tables
OMRC is a small master data table with no line table. Each item in OITM has one manufacturer code in FirmCode, which joins to OMRC.FirmCode. The default value of OITM.FirmCode is -1.
Common joins
OITM T0 LEFT JOIN OMRC T1 ON T1.FirmCode = T0.FirmCode (manufacturer name)
When you use the OMRC table
Use OMRC to group item lists, stock and sales by manufacturer and to find items that still have the default manufacturer code.
Example query: number of items per manufacturer, including items without one
SQL Server
SELECT ISNULL(T1.FirmName, '(none)') AS Manufacturer, COUNT(T0.ItemCode) AS Items FROM OITM T0 LEFT JOIN OMRC T1 ON T1.FirmCode = T0.FirmCode GROUP BY T1.FirmName ORDER BY Items DESC
SAP HANA (column names in double quotes)
SELECT IFNULL(T1."FirmName", '(none)') AS "Manufacturer", COUNT(T0."ItemCode") AS "Items" FROM OITM T0 LEFT JOIN OMRC T1 ON T1."FirmCode" = T0."FirmCode" GROUP BY T1."FirmName" ORDER BY "Items" DESC
Paste either version in Tools → Queries → Query Generator. Need the other dialect for your own query? Use the SQL to HANA converter.
Common pitfall: An inner join drops items
OITM.FirmCode defaults to -1, which has no row in OMRC, so an INNER JOIN silently drops every item without a manufacturer. Use a LEFT JOIN from OITM. See OITM table (item master).
Questions about the OMRC table
Where is the manufacturer of an item stored in SAP B1?
OITM.FirmCode holds the code; the name is OMRC.FirmName, joined on FirmCode.
What does FirmCode -1 mean on an item?
-1 is the default value of OITM.FirmCode, so no manufacturer was picked; it has no OMRC row.
How long can a manufacturer name be?
OMRC.FirmName is 30 characters.
Related tables
OITM (Items (item master data)) · OITB (Item Groups) · search all SAP Business One tables
Sources: SAP Business One documentation and SDK (DI API database tables reference), SAP Help Portal.
Ready to get started?
Tell us what you need. You get a clear technical answer, a fixed scope and a price, usually within 24 hours.