biuan SAP® BUSINESS ONE SDK
API UWKO1
UWKO1 - 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 UWKO1.OrderNum AS 'Instruction Key', UWKO1.LineID AS 'Row Number', UWKO1.ItemCode AS 'Item No.', UWKO1.Descript AS 'Item Description', UWKO1.Quantity AS 'Item Quantity', UWKO1.Price AS 'Item Price', UWKO1.Currency AS 'Price Currency', UWKO1.WhsCode AS 'Item Warehouse', UWKO1.FinncPriod AS 'Posting Period', UWKO1.ActWorkCod AS 'Active Account Code', UWKO1.ActWorkSum AS 'Total Work', UWKO1.ProdUpgNum AS 'Production Upgrade No.' FROM UWKO1 AS UWKO1

Related information


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