biuan SAP® BUSINESS ONE SDK
DTW Production Order - Base
API Production Orders / Production Orders Sales Order Lines
WOR2 - Production Order - Base Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal NumberInt
11OWOR
Production Order
PRIMARYYes
BaseEntryProduction Order Base EntryInt
11ORDR
Sales Order
BaseNumProduction Order Base NumberInt
11
BaseLineProduction Order Base LineInt
11
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT WOR2.DocEntry AS 'Document Internal Number', WOR2.BaseEntry AS 'Production Order Base Entry', WOR2.BaseNum AS 'Production Order Base Number', WOR2.BaseLine AS 'Production Order Base Line', WOR2.LogInstanc AS 'Log Instance' FROM WOR2 AS WOR2

Related information


Production Orders Sales Order Lines ProductionOrders_SalesOrderLines Object· Table: WOR2
The ProductionOrders_SalesOrderLines is a child object of the ProductionOrders object. You can set the sales order to which to link the production order. Source table: WOR2.
   Parent: Production Orders ProductionOrders Object· Table: OWOR
Sales Order ORDR SQL Table

Production Order OWOR 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