biuan SAP® BUSINESS ONE SDK
DTW Production Instructions - Rows
API Work Orders / Work Order Lines
WKO1 - Production Instructions - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
OrderNum KEY UNIQUEInstruction KeyInt
11OWKO
Production Instructions
PRIMARYYes
LineIDRow NumberInt
11
0
ItemCodeItem No.nVarChar
20OITT
Product Tree
DescriptItem DescriptionnVarChar
100
QuantityItem QuantityNum
20
PriceItem PriceNum
20
Currency KEYPrice CurrencynVarChar
3OCRN
Currency Codes
CURRENCYNo
WhsCodeItem WarehousenVarChar
8OWHS
Warehouses
FinncPriodPosting PeriodInt
11OFPR
Posting Period
ActWorkCodActive Account CodenVarChar
15OACT
G/L Accounts
ActWorkSumTotal WorkNum
20
ProdUpgNumProduction Upgrade No.Int
11OWOR
Production Order

Table relationship map

SELECT statement

SELECT WKO1.OrderNum AS 'Instruction Key', WKO1.LineID AS 'Row Number', WKO1.ItemCode AS 'Item No.', WKO1.Descript AS 'Item Description', WKO1.Quantity AS 'Item Quantity', WKO1.Price AS 'Item Price', WKO1.Currency AS 'Price Currency', WKO1.WhsCode AS 'Item Warehouse', WKO1.FinncPriod AS 'Posting Period', WKO1.ActWorkCod AS 'Active Account Code', WKO1.ActWorkSum AS 'Total Work', WKO1.ProdUpgNum AS 'Production Upgrade No.' FROM WKO1 AS WKO1

Related information


Work Order Lines WorkOrder_Lines Object· Table: WKO1
WorkOrder_Lines is child object of the WorkOrders object that represents a collection of parent items in a work order. The parent item is connected to its bill of material. Source table: WKO1.
   Parent: Work Orders WorkOrders Object· Table: OWKO
G/L Accounts OACT SQL Table

Currency Codes OCRN SQL Table

Posting Period OFPR SQL Table

Product Tree OITT SQL Table

Production Instructions OWKO SQL Table

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