|
|
API MSN1
MSN1 - MRP Scenarios - Warehouses Array Table
MRP Scenarios OMSN SQL Table
Warehouses OWHS SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | OMSN MRP Scenarios | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| ReqSel | Requirement Selection | VarChar | Y) Yes N) No | 1 | Y | |||
| InvtSel | Inventory Selection | VarChar | Y) Yes N) No | 1 | Y | |||
| ExtIvntSel | Existing Inventory Selection | VarChar | Y) Yes N) No | 1 | Y |
Table relationship map
SELECT statement
SELECT
MSN1.AbsEntry AS 'Internal Number',
MSN1.WhsCode AS 'Warehouse Code',
MSN1.ReqSel AS 'Requirement Selection',
MSN1.InvtSel AS 'Inventory Selection',
MSN1.ExtIvntSel AS 'Existing Inventory Selection'
FROM MSN1 AS MSN1
Related information
MRP Scenarios OMSN SQL Table
Warehouses OWHS SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
