biuan SAP® BUSINESS ONE SDK
DTW Bill of Materials - Components
API Product Trees / Product Trees Lines
ITT1 - Bill of Materials - Components Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Father KEYParent ItemnVarChar
20OITT
Product Tree
FATHERNo
ChildNumComponent Element NumberInt
11
Code KEYComponent CodenVarChar
20
CHILDNo
QuantityQuantityNum
20
WarehouseWarehousenVarChar
8OWHS
Warehouses
PricePriceNum
20
CurrencyCurrencynVarChar
3OCRN
Currency Codes
PriceList KEYPrice ListInt
6OPLN
Price Lists
0PRICE_LISTNo
OrigPriceOriginal PriceNum
20
OrigCurrOriginal CurrencynVarChar
3
IssueMthdIssue MethodVarChar
B) Backflush
M) Manual
1
UomInventory UoMnVarChar
100
CommentCommentnVarChar
127
LogInstancLog InstanceInt
11
ObjectObjectnVarChar
20
66
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
OcrCode2Distribution Rule2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule5nVarChar
8OOCR
Distribution Rule
PrncpInputPrincipal InputVarChar
Y) Yes
N) No
1
N
ProjectProject CodenVarChar
20OPRJ
Project Codes
TypeComponent TypeInt
4) Item
290) Resource
-18) Text
11
4
WipActCodeWIP Account CodenVarChar
15OACT
G/L Accounts
AddQuantitAdditional QuantityNum
20
LineTextRow TextText
16

Table relationship map

SELECT statement

SELECT ITT1.Father AS 'Parent Item', ITT1.ChildNum AS 'Component Element Number', ITT1.Code AS 'Component Code', ITT1.Quantity AS 'Quantity', ITT1.Warehouse AS 'Warehouse', ITT1.Price AS 'Price', ITT1.Currency AS 'Currency', ITT1.PriceList AS 'Price List', ITT1.OrigPrice AS 'Original Price', ITT1.OrigCurr AS 'Original Currency', ITT1.IssueMthd AS 'Issue Method', ITT1.Uom AS 'Inventory UoM', ITT1.Comment AS 'Comment', ITT1.LogInstanc AS 'Log Instance', ITT1.Object AS 'Object', ITT1.OcrCode AS 'Distribution Rule', ITT1.OcrCode2 AS 'Distribution Rule2', ITT1.OcrCode3 AS 'Distribution Rule3', ITT1.OcrCode4 AS 'Distribution Rule4', ITT1.OcrCode5 AS 'Distribution Rule5', ITT1.PrncpInput AS 'Principal Input', ITT1.Project AS 'Project Code', ITT1.Type AS 'Component Type', ITT1.WipActCode AS 'WIP Account Code', ITT1.AddQuantit AS 'Additional Quantity', ITT1.LineText AS 'Row Text' FROM ITT1 AS ITT1

Related information


Product Trees Lines ProductTrees_Lines Object· Table: ITT1
ProductTrees_Lines is a child object of the ProductTrees object and it represents the line entries of each product tree. This object is part of the Inventory and Production module. Source table: ITT1.
   Parent: Product Trees ProductTrees Object· Table: OITT
Currency Codes OCRN SQL Table

Product Tree OITT SQL Table

Distribution Rule OOCR SQL Table

Price Lists OPLN SQL Table

Project Codes OPRJ SQL Table

Warehouses OWHS SQL Table

G/L Accounts OACT 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