biuan SAP® BUSINESS ONE SDK
API MSN1
MSN1 - MRP Scenarios - Warehouses Array Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11OMSN
MRP Scenarios
PRIMARYYes
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
ReqSelRequirement SelectionVarChar
Y) Yes
N) No
1
Y
InvtSelInventory SelectionVarChar
Y) Yes
N) No
1
Y
ExtIvntSelExisting Inventory SelectionVarChar
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



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