biuan SAP® BUSINESS ONE SDK
API MSN3
MSN3 - MRP Pegging Information Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
ItemCodeItem No.nVarChar
20OITM
Items
PeriodIDPeriod IDInt
11
QuantityQuantityNum
20
BaseEntryBase Document Internal IDInt
11
BaseLineBase RowInt
11
BaseObjBase Object TypenVarChar
20
BaseDocNumBase Document NumbernVarChar
16
BaseDueBase Due DateDate
8
StockTypeStock Operation TypeVarChar
I) Stock Issue
R) Stock Receipt
1
I
LineIDRow NumberInt
11
ParentCodeParent Item No.nVarChar
20OITM
Items
StartDatePeriod Start DateDate
8
EndDatePeriod End DateDate
8
WhsCodeWarehouse CodenVarChar
8OWHS
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates