biuan SAP® BUSINESS ONE SDK
API MSN4
MSN4 - MRP Scenarios - Items Array Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11OMSN
MRP Scenarios
PRIMARYYes
ItemCode KEYItem CodenVarChar
20
ItemCodeNo
SelectedSelectedVarChar
Y) Yes
N) No
1
Y
TmpForMrpIs Temporary for MRPVarChar
1
N
WorDueDateProduction Order Due DateDate
8
DsmDueDateDisassembly Order Due DateDate
8
NorDueDateNon Prd Order Doc. Due DateDate
8
IntervalOrder IntervalsInt
6
MultipleOrder MultipleNum
20
MinORdrQtyMinimum Order QuantityNum
20
LeadTimeLead TimeInt
11
prcrmntMtdProcurement MethodVarChar
B) Buy
M) Make
1
B
ToleranDayTolerance DayInt
11
CompoWHComponent WarehouseVarChar
B) From Bill of Materials Line
P) From Parent Item Document Line
1
B

SELECT statement

SELECT MSN4.AbsEntry AS 'Internal Number', MSN4.ItemCode AS 'Item Code', MSN4.Selected AS 'Selected', MSN4.TmpForMrp AS 'Is Temporary for MRP', MSN4.WorDueDate AS 'Production Order Due Date', MSN4.DsmDueDate AS 'Disassembly Order Due Date', MSN4.NorDueDate AS 'Non Prd Order Doc. Due Date', MSN4.Interval AS 'Order Intervals', MSN4.Multiple AS 'Order Multiple', MSN4.MinORdrQty AS 'Minimum Order Quantity', MSN4.LeadTime AS 'Lead Time', MSN4.prcrmntMtd AS 'Procurement Method', MSN4.ToleranDay AS 'Tolerance Day', MSN4.CompoWH AS 'Component Warehouse' FROM MSN4 AS MSN4

Related information


MRP Scenarios OMSN 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