biuan SAP® BUSINESS ONE SDK
SQL MRP / MRP Scenarios
API OMSN
OMSN - MRP Scenarios Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
MsnCode KEY UNIQUEMRP Scenario CodenVarChar
30
MSN_CODEYes
DescrDescriptionnVarChar
100
GrpPeriodsGroup Data into Periods ofVarChar
D) Days
W) Weeks
M) Months
1
D
PeriodsLenGroup Data into Periods ofInt
11
1
StartDateReport Start DateDate
8
EndDateReport End DateDate
8
MaxLdTimeMaximum Cumulative Lead TimeInt
11
HldaysProdHolidays for ProductionVarChar
Y) Yes
N) No
1
Y
HldaysPurcHolidays for PurchaseVarChar
Y) Yes
N) No
1
Y
ItmFromItems Codes FromnVarChar
20OITM
Items
ItmToItems Codes TonVarChar
20OITM
Items
ItmGrpItems GroupsInt
11OITB
Item Groups
ItmQryGrpItem Summary Report GroupnVarChar
127
ExistStockConsider Existing InventoryVarChar
Y) Yes
N) No
1
Y
PurchOrderConsider Purchase OrdersVarChar
Y) Yes
N) No
1
Y
SalesOrderConsider Sales OrdersVarChar
Y) Yes
N) No
1
Y
WorkOrderConsider Work OrdersVarChar
Y) Yes
N) No
1
Y
MinStckLvlMinimum Inventory LevelVarChar
Y) Yes
N) No
1
N
FCTAbsForecast Absolute EntryInt
11OFCT
Sales Forecast
SortBySort ByVarChar
L) Assembly Sequence
C) Item Number
N) Item Description
G) Item Group
1
L
ItmReqItems Without RequirementVarChar
Y) Yes
N) No
1
N
SimulationIs Scenario a SimulationVarChar
Y) Yes
N) No
1
N
UpdateDateUpdate DateDate
8
UpdateByUpdate BynVarChar
20
LastExecDaLast Execute DateDate
8
AllItemsAll ItemsVarChar
1
Y
ByCompanyBy CompanyVarChar
1
Y
IncHisDataInclude Historical DataVarChar
Y) Yes
N) No
1
N
ResInvReserve InvoiceVarChar
Y) Yes
N) No
1
N
WtrqInventory Transfer RequestVarChar
Y) Yes
N) No
1
N
InvtLevelInventory LevelVarChar
D)
R) Required
I) Minimum
A) Maximum
M) Minimum - Maximum
1
D
RcmPORecommend Purchase OrderVarChar
Y) Yes
N) No
1
N
RcmWORecommend Production OrderVarChar
Y) Yes
N) No
1
Y
RcmWTRQRecommend ITRQVarChar
Y) Yes
N) No
1
N
RCMDefWhsRecommend to Default WarehouseVarChar
Y) Yes
N) No
1
Y
OnlyNettblOnly NettableVarChar
Y) Yes
N) No
1
Y
ExpandedPOExpanded Purchase OrderVarChar
1
N
ExpandedSOExpanded Sales OrderVarChar
Y) Yes
N) No
1
N
RcmCalDateRecommendation Calculated DateDate
8
RcmCalTimeRecommendation Calculated TimeInt
11
PurchOATBlanket Purchase AgreementVarChar
Y) Yes
N) No
1
Y
SalesOATBlanket Sales AgreementVarChar
1
Y
RotsRecurring Order TransactionsVarChar
Y) Yes
N) No
1
N
ExpdResINVExpanded Reserve InvoiceVarChar
1
N
ExpdWORExpanded Production OrderVarChar
Y) Yes
N) No
1
N
IgnoreCLTIgnore Cumulative Lead TimeVarChar
Y) Yes
N) No
1
N
PurchReqConsider Purchase RequestVarChar
Y) Yes
N) No
1
N
PurchQuotaConsider Purchase QuotationsVarChar
Y) Yes
N) No
1
N
SalesQuotaConsider Sales QuotationsVarChar
Y) Yes
N) No
1
N
ExpdPurReqExpanded Purchase RequestVarChar
Y) Yes
N) No
1
N
ExpdPQuotaExpanded Purchase QuotationsVarChar
Y) Yes
N) No
1
N
ExpdSQuotaExpanded Sales QuotationsVarChar
Y) Yes
N) No
1
N
ExpdPAgreeExpanded Purchase AgreementsVarChar
Y) Yes
N) No
1
N
ExpdSAgreeExpanded Sales AgreementsVarChar
Y) Yes
N) No
1
N
ExpdTraReqExpanded Transfer RequestVarChar
Y) Yes
N) No
1
N
DisSelItemDisplay Selected Item OnlyVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT OMSN.AbsEntry AS 'Internal Number', OMSN.MsnCode AS 'MRP Scenario Code', OMSN.Descr AS 'Description', OMSN.GrpPeriods AS 'Group Data into Periods of', OMSN.PeriodsLen AS 'Group Data into Periods of', OMSN.StartDate AS 'Report Start Date', OMSN.EndDate AS 'Report End Date', OMSN.MaxLdTime AS 'Maximum Cumulative Lead Time', OMSN.HldaysProd AS 'Holidays for Production', OMSN.HldaysPurc AS 'Holidays for Purchase', OMSN.ItmFrom AS 'Items Codes From', OMSN.ItmTo AS 'Items Codes To', OMSN.ItmGrp AS 'Items Groups', OMSN.ItmQryGrp AS 'Item Summary Report Group', OMSN.ExistStock AS 'Consider Existing Inventory', OMSN.PurchOrder AS 'Consider Purchase Orders', OMSN.SalesOrder AS 'Consider Sales Orders', OMSN.WorkOrder AS 'Consider Work Orders', OMSN.MinStckLvl AS 'Minimum Inventory Level', OMSN.FCTAbs AS 'Forecast Absolute Entry', OMSN.SortBy AS 'Sort By', OMSN.ItmReq AS 'Items Without Requirement', OMSN.Simulation AS 'Is Scenario a Simulation', OMSN.UpdateDate AS 'Update Date', OMSN.UpdateBy AS 'Update By', OMSN.LastExecDa AS 'Last Execute Date', OMSN.AllItems AS 'All Items', OMSN.ByCompany AS 'By Company', OMSN.IncHisData AS 'Include Historical Data', OMSN.ResInv AS 'Reserve Invoice', OMSN.Wtrq AS 'Inventory Transfer Request', OMSN.InvtLevel AS 'Inventory Level', OMSN.RcmPO AS 'Recommend Purchase Order', OMSN.RcmWO AS 'Recommend Production Order', OMSN.RcmWTRQ AS 'Recommend ITRQ', OMSN.RCMDefWhs AS 'Recommend to Default Warehouse', OMSN.OnlyNettbl AS 'Only Nettable', OMSN.ExpandedPO AS 'Expanded Purchase Order', OMSN.ExpandedSO AS 'Expanded Sales Order', OMSN.RcmCalDate AS 'Recommendation Calculated Date', OMSN.RcmCalTime AS 'Recommendation Calculated Time', OMSN.PurchOAT AS 'Blanket Purchase Agreement', OMSN.SalesOAT AS 'Blanket Sales Agreement', OMSN.Rots AS 'Recurring Order Transactions', OMSN.ExpdResINV AS 'Expanded Reserve Invoice', OMSN.ExpdWOR AS 'Expanded Production Order', OMSN.IgnoreCLT AS 'Ignore Cumulative Lead Time', OMSN.PurchReq AS 'Consider Purchase Request', OMSN.PurchQuota AS 'Consider Purchase Quotations', OMSN.SalesQuota AS 'Consider Sales Quotations', OMSN.ExpdPurReq AS 'Expanded Purchase Request', OMSN.ExpdPQuota AS 'Expanded Purchase Quotations', OMSN.ExpdSQuota AS 'Expanded Sales Quotations', OMSN.ExpdPAgree AS 'Expanded Purchase Agreements', OMSN.ExpdSAgree AS 'Expanded Sales Agreements', OMSN.ExpdTraReq AS 'Expanded Transfer Request', OMSN.DisSelItem AS 'Display Selected Item Only' FROM OMSN AS OMSN

Related information


OMSN SQL Table

Sales Forecast OFCT SQL Table

Items OITM SQL Table

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