biuan SAP® BUSINESS ONE SDK
API MSN2
MSN2 - MRP Run Results Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
ItemCodeItem No.nVarChar
20OITM
Items
PeriodIDPeriod IDInt
11
InitialInitial QuantityNum
20
InitialOrgOriginal Initial QuantityNum
20
InStockIncoming StockNum
20
OutStockOutgoing StockNum
20
FinalFinal QuantityNum
20
FinalOrgOriginal Final QuantityNum
20
RequestsRequestsNum
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



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