biuan SAP® BUSINESS ONE SDK
API AITT
AITT - Product Tree - History 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
PriceListPrice ListInt
6OPLN
Price Lists
0
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 AITT.Code AS 'Parent Item', AITT.TreeType AS 'BOM Type', AITT.PriceList AS 'Price List', AITT.Qauntity AS 'No. of Units', AITT.UseFthrWhs AS 'Issue from Parent Warehouse', AITT.CreateDate AS 'Creation Date', AITT.UpdateDate AS 'Date of Update', AITT.Transfered AS 'Postponed to Next Year', AITT.DataSource AS 'Data source', AITT.UserSign AS 'User Signature', AITT.SCNCounter AS 'SCN Counter', AITT.DispCurr AS 'Display Currency', AITT.ToWH AS 'Whse for Finished Product', AITT.Object AS 'Object Type', AITT.LogInstac AS 'Log Instance - History', AITT.UserSign2 AS 'Updating User', AITT.OcrCode AS 'Distribution Rule', AITT.HideComp AS 'Hide Components in Printing', AITT.OcrCode2 AS 'Distribution Rule2', AITT.OcrCode3 AS 'Distribution Rule3', AITT.OcrCode4 AS 'Distribution Rule4', AITT.OcrCode5 AS 'Distribution Rule5', AITT.UpdateTime AS 'Time of Update', AITT.Project AS 'Project Code' FROM AITT AS AITT

Related information


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