biuan SAP® BUSINESS ONE SDK
API OWOR / Production Orders
OWOR - Production Order Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocNum KEY UNIQUEDocument NumberInt
11
NUMYes
SeriesSeriesInt
6NNM1
Documents Numbering - Series
0
ItemCodeProduct No.nVarChar
20OITT
Product Tree
StatusProduction Order StatusVarChar
P) Planned
R) Released
L) Closed
C) Canceled
1
P
TypeProduction Order TypeVarChar
S) Standard
P) Special
D) Disassembly
1
S
PlannedQtyPlanned Quantity - HeaderNum
20
CmpltQtyCompleted QuantityNum
20
RjctQtyRejected QuantityNum
20
PostDatePosting DateDate
8
DueDateDue DateDate
8
OriginAbsProduction Order Origin EntryInt
11
OriginNumProduction Order Origin NumberInt
11
OriginTypeProduction Order OriginVarChar
M) Manual
R) MRP
S) Sales Order
U) Upgrade
1
M
UserSignUser SignatureInt
6OUSR
Users
CommentsRemarksnVarChar
127
CloseDateClosing DateDate
8
RlsDateRelease DateDate
8
CardCodeCustomer CodenVarChar
15OCRD
Business Partner
WarehouseWarehousenVarChar
8OWHS
Warehouses
UomInv. UoM in Production OrdernVarChar
100
LineDirtyLine ModifiedInt
11
WOR1CountWOR1 Counter for Next No.Int
11
0
JrnlMemoJournal RemarksnVarChar
50
TransIdTransaction NumberInt
11OJDT
Journal Entry
CreateDateCreation DateDate
8
PrintedPrintedVarChar
Y) Copy
N) Original
1
N
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
PIndicatorPeriod IndicatornVarChar
10OPID
Period Indicator
' '
OcrCode2Distribution Rule2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule5nVarChar
8OOCR
Distribution Rule
SeqCodeSequence CodeInt
6
SerialSerial NumberInt
11
SeriesStrSeries StringnVarChar
3
SubStrSubseries StringnVarChar
3
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8
ProjectProject CodenVarChar
20OPRJ
Project Codes
SupplCodeSupplementary CodenVarChar
127
UomEntryUoM EntryInt
11OUOM
UoM Master Data
0
PickRmrkPick RemarksnVarChar
127
SysCloseDtSystem Closing DateDate
8
SysCloseTmSystem Closing TimeInt
6
CloseVerNmClosing Version NumbernVarChar
11

Table relationship map

SELECT statement

SELECT OWOR.DocEntry AS 'Internal Number', OWOR.DocNum AS 'Document Number', OWOR.Series AS 'Series', OWOR.ItemCode AS 'Product No.', OWOR.Status AS 'Production Order Status', OWOR.Type AS 'Production Order Type', OWOR.PlannedQty AS 'Planned Quantity - Header', OWOR.CmpltQty AS 'Completed Quantity', OWOR.RjctQty AS 'Rejected Quantity', OWOR.PostDate AS 'Posting Date', OWOR.DueDate AS 'Due Date', OWOR.OriginAbs AS 'Production Order Origin Entry', OWOR.OriginNum AS 'Production Order Origin Number', OWOR.OriginType AS 'Production Order Origin', OWOR.UserSign AS 'User Signature', OWOR.Comments AS 'Remarks', OWOR.CloseDate AS 'Closing Date', OWOR.RlsDate AS 'Release Date', OWOR.CardCode AS 'Customer Code', OWOR.Warehouse AS 'Warehouse', OWOR.Uom AS 'Inv. UoM in Production Order', OWOR.LineDirty AS 'Line Modified', OWOR.WOR1Count AS 'WOR1 Counter for Next No.', OWOR.JrnlMemo AS 'Journal Remarks', OWOR.TransId AS 'Transaction Number', OWOR.CreateDate AS 'Creation Date', OWOR.Printed AS 'Printed', OWOR.OcrCode AS 'Distribution Rule', OWOR.PIndicator AS 'Period Indicator', OWOR.OcrCode2 AS 'Distribution Rule2', OWOR.OcrCode3 AS 'Distribution Rule3', OWOR.OcrCode4 AS 'Distribution Rule4', OWOR.OcrCode5 AS 'Distribution Rule5', OWOR.SeqCode AS 'Sequence Code', OWOR.Serial AS 'Serial Number', OWOR.SeriesStr AS 'Series String', OWOR.SubStr AS 'Subseries String', OWOR.LogInstanc AS 'Log Instance', OWOR.UserSign2 AS 'Updating User', OWOR.UpdateDate AS 'Update Date', OWOR.Project AS 'Project Code', OWOR.SupplCode AS 'Supplementary Code', OWOR.UomEntry AS 'UoM Entry', OWOR.PickRmrk AS 'Pick Remarks', OWOR.SysCloseDt AS 'System Closing Date', OWOR.SysCloseTm AS 'System Closing Time', OWOR.CloseVerNm AS 'Closing Version Number' FROM OWOR AS OWOR

Related information


Production Orders ProductionOrders Object· Table: OWOR
The ProductionOrders object supports the creation and maintenance of production orders. This object replaces the WorkOrders object of release 2004. During upgrade to 2005, SAP Business One creates production orders based on the data of the...

OWOR SQL Table

Business Partner OCRD SQL Table

Product Tree OITT SQL Table

Distribution Rule OOCR SQL Table

Period Indicator OPID SQL Table

Project Codes OPRJ SQL Table

Documents Numbering - Series NNM1 SQL Table

Journal Entry OJDT SQL Table

UoM Master Data OUOM SQL Table

Users OUSR 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates