biuan SAP® BUSINESS ONE SDK
API OITT / / Product Trees
OITT - Product Tree Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUEParent ItemnVarChar
20OITM
Items
PRIMARYYes
TreeTypeBOM TypeVarChar
A) Assembly
S) Sales
P) Production
T) Template
1
P
PriceList KEYPrice ListInt
6OPLN
Price Lists
0PRICE_LISTNo
QauntityNo. of UnitsNum
20
UseFthrWhsIssue from Parent WarehouseVarChar
Y) Yes
N) No
1
N
CreateDateCreation DateDate
8
UpdateDateDate of UpdateDate
8
TransferedPostponed to Next YearVarChar
Y) Yes
N) No
1
N
DataSourceData sourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
SCNCounterSCN CounterInt
6
DispCurrDisplay CurrencynVarChar
3
ToWHWhse for Finished ProductnVarChar
8
ObjectObject TypenVarChar
20
66
LogInstacLog Instance - HistoryInt
11
UserSign2Updating UserInt
11OUSR
Users
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
HideCompHide Components in PrintingVarChar
Y) Yes
N) No
1
N
OcrCode2Distribution Rule2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule5nVarChar
8OOCR
Distribution Rule
UpdateTimeTime of UpdateInt
11
ProjectProject CodenVarChar
20OPRJ
Project Codes

Table relationship map

SELECT statement

SELECT OITT.Code AS 'Parent Item', OITT.TreeType AS 'BOM Type', OITT.PriceList AS 'Price List', OITT.Qauntity AS 'No. of Units', OITT.UseFthrWhs AS 'Issue from Parent Warehouse', OITT.CreateDate AS 'Creation Date', OITT.UpdateDate AS 'Date of Update', OITT.Transfered AS 'Postponed to Next Year', OITT.DataSource AS 'Data source', OITT.UserSign AS 'User Signature', OITT.SCNCounter AS 'SCN Counter', OITT.DispCurr AS 'Display Currency', OITT.ToWH AS 'Whse for Finished Product', OITT.Object AS 'Object Type', OITT.LogInstac AS 'Log Instance - History', OITT.UserSign2 AS 'Updating User', OITT.OcrCode AS 'Distribution Rule', OITT.HideComp AS 'Hide Components in Printing', OITT.OcrCode2 AS 'Distribution Rule2', OITT.OcrCode3 AS 'Distribution Rule3', OITT.OcrCode4 AS 'Distribution Rule4', OITT.OcrCode5 AS 'Distribution Rule5', OITT.UpdateTime AS 'Time of Update', OITT.Project AS 'Project Code' FROM OITT AS OITT

Related information


Product Trees ProductTrees Object· Table: OITT
ProductTrees is a business object that represents a completed product comprising parts and raw materials, which is described by means of a bill of materials. This object is part of the Inventory module. This object enables you to: Add an item...

OITT SQL Table

Items OITM SQL Table

Distribution Rule OOCR SQL Table

Price Lists OPLN SQL Table

Project Codes OPRJ SQL Table

Users OUSR 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