|
|
SQL MRP / MRP Pegging Information
API MSN3
MSN3 - MRP Pegging Information Table
Items OITM 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 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ItemCode | Item No. | nVarChar | 20 | OITM Items | ||||
| PeriodID | Period ID | Int | 11 | |||||
| Quantity | Quantity | Num | 20 | |||||
| BaseEntry | Base Document Internal ID | Int | 11 | |||||
| BaseLine | Base Row | Int | 11 | |||||
| BaseObj | Base Object Type | nVarChar | 20 | |||||
| BaseDocNum | Base Document Number | nVarChar | 16 | |||||
| BaseDue | Base Due Date | Date | 8 | |||||
| StockType | Stock Operation Type | VarChar | I) Stock Issue R) Stock Receipt | 1 | I | |||
| LineID | Row Number | Int | 11 | |||||
| ParentCode | Parent Item No. | nVarChar | 20 | OITM Items | ||||
| StartDate | Period Start Date | Date | 8 | |||||
| EndDate | Period End Date | Date | 8 | |||||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses |
Table relationship map
SELECT statement
SELECT
MSN3.AbsEntry AS 'Internal Number',
MSN3.ItemCode AS 'Item No.',
MSN3.PeriodID AS 'Period ID',
MSN3.Quantity AS 'Quantity',
MSN3.BaseEntry AS 'Base Document Internal ID',
MSN3.BaseLine AS 'Base Row',
MSN3.BaseObj AS 'Base Object Type',
MSN3.BaseDocNum AS 'Base Document Number',
MSN3.BaseDue AS 'Base Due Date',
MSN3.StockType AS 'Stock Operation Type',
MSN3.LineID AS 'Row Number',
MSN3.ParentCode AS 'Parent Item No.',
MSN3.StartDate AS 'Period Start Date',
MSN3.EndDate AS 'Period End Date',
MSN3.WhsCode AS 'Warehouse Code'
FROM MSN3 AS MSN3
Related information
Items OITM 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
