|
|
SQL MRP / MRP Run Results
API MSN2
MSN2 - MRP Run Results Table
Items OITM SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ItemCode | Item No. | nVarChar | 20 | OITM Items | ||||
| PeriodID | Period ID | Int | 11 | |||||
| Initial | Initial Quantity | Num | 20 | |||||
| InitialOrg | Original Initial Quantity | Num | 20 | |||||
| InStock | Incoming Stock | Num | 20 | |||||
| OutStock | Outgoing Stock | Num | 20 | |||||
| Final | Final Quantity | Num | 20 | |||||
| FinalOrg | Original Final Quantity | Num | 20 | |||||
| Requests | Requests | Num | 20 |
SELECT statement
SELECT
MSN2.AbsEntry AS 'Internal Number',
MSN2.ItemCode AS 'Item No.',
MSN2.PeriodID AS 'Period ID',
MSN2.Initial AS 'Initial Quantity',
MSN2.InitialOrg AS 'Original Initial Quantity',
MSN2.InStock AS 'Incoming Stock',
MSN2.OutStock AS 'Outgoing Stock',
MSN2.Final AS 'Final Quantity',
MSN2.FinalOrg AS 'Original Final Quantity',
MSN2.Requests AS 'Requests'
FROM MSN2 AS MSN2
Related information
Items OITM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
