|
|
DTW Administration / Setup / Inventory / Manufacturers
API OMRC / / Manufacturers
OMRC - Manufacturers Table
Manufacturers Manufacturers Object· Table: OMRC
OMRC SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | FirmCode KEY UNIQUE | Code | Int | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| FirmName KEY UNIQUE | Manufacturer Name | nVarChar | 30 | GROUP_NAME | Yes | |||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users |
Table relationship map
SELECT statement
SELECT
OMRC.FirmCode AS 'Code',
OMRC.FirmName AS 'Manufacturer Name',
OMRC.DataSource AS 'Data Source',
OMRC.UserSign AS 'User Signature'
FROM OMRC AS OMRC
Related information
Manufacturers Manufacturers Object· Table: OMRC
The Manufacturers object enables to define manufacturers used in the Item master data.
Source table: OMRC.
OMRC SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates