biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Items / Asset Attributes
DTW Inventory / Item Master Data / Asset Attributes
API Items / Items Attribute Groups
ITM13 - Asset Attributes Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem No.nVarChar
20OITM
Items		PRIMARYYes
AttriTxt1Attribute 1nVarChar
100
AttriTxt2Attribute 2nVarChar
100
AttriTxt3Attribute 3nVarChar
100
AttriTxt4Attribute 4nVarChar
100
AttriTxt5Attribute 5nVarChar
100
AttriTxt6Attribute 6nVarChar
100
AttriTxt7Attribute 7nVarChar
100
AttriTxt8Attribute 8nVarChar
100
AttriTxt9Attribute 9nVarChar
100
AttriTxt10Attribute 10nVarChar
100
AttriTxt11Attribute 11nVarChar
100
AttriTxt12Attribute 12nVarChar
100
AttriTxt13Attribute 13nVarChar
100
AttriTxt14Attribute 14nVarChar
100
AttriTxt15Attribute 15nVarChar
100
AttriTxt16Attribute 16nVarChar
100
AttriTxt17Attribute 17nVarChar
100
AttriTxt18Attribute 18nVarChar
100
AttriTxt19Attribute 19nVarChar
100
AttriTxt20Attribute 20nVarChar
100
AttriTxt21Attribute 21nVarChar
100
AttriTxt22Attribute 22nVarChar
100
AttriTxt23Attribute 23nVarChar
100
AttriTxt24Attribute 24nVarChar
100
AttriTxt25Attribute 25nVarChar
100
AttriTxt26Attribute 26nVarChar
100
AttriTxt27Attribute 27nVarChar
100
AttriTxt28Attribute 28nVarChar
100
AttriTxt29Attribute 29nVarChar
100
AttriTxt30Attribute 30nVarChar
100
AttriTxt31Attribute 31nVarChar
100
AttriTxt32Attribute 32nVarChar
100
AttriInt33Attribute 33Int
11
AttriInt34Attribute 34Int
11
AttriInt35Attribute 35Int
11
AttriInt36Attribute 36Int
11
AttriInt37Attribute 37Int
11
AttriInt38Attribute 38Int
11
AttriInt39Attribute 39Int
11
AttriInt40Attribute 40Int
11
AttriInt41Attribute 41Int
11
AttriInt42Attribute 42Int
11
AttriDt43Attribute 43Date
8
AttriDt44Attribute 44Date
8
AttriDt45Attribute 45Date
8
AttriDt46Attribute 46Date
8
AttriDt47Attribute 47Date
8
AttriAm48Attribute 48Num
20
AttriAm49Attribute 49Num
20
AttriAm50Attribute 50Num
20
AttriAm51Attribute 51Num
20
AttriAm52Attribute 52Num
20
AttriAm53Attribute 53Num
20
AttriAm54Attribute 54Num
20
AttriPr55Attribute 55Num
20
AttriPr56Attribute 56Num
20
AttriPr57Attribute 57Num
20
AttriPr58Attribute 58Num
20
AttriPr59Attribute 59Num
20
AttriQTY60Attribute 60Num
20
AttriQTY61Attribute 61Num
20
AttriQTY62Attribute 62Num
20
AttriQTY63Attribute 63Num
20
AttriQTY64Attribute 64Num
20
LogInstancLog InstanceInt
6
0
ObjTypeObjectnVarChar
20ADP1
Object Settings - History		4

Table relationship map

SELECT statement

SELECT ITM13.ItemCode AS 'Item No.', ITM13.AttriTxt1 AS 'Attribute 1', ITM13.AttriTxt2 AS 'Attribute 2', ITM13.AttriTxt3 AS 'Attribute 3', ITM13.AttriTxt4 AS 'Attribute 4', ITM13.AttriTxt5 AS 'Attribute 5', ITM13.AttriTxt6 AS 'Attribute 6', ITM13.AttriTxt7 AS 'Attribute 7', ITM13.AttriTxt8 AS 'Attribute 8', ITM13.AttriTxt9 AS 'Attribute 9', ITM13.AttriTxt10 AS 'Attribute 10', ITM13.AttriTxt11 AS 'Attribute 11', ITM13.AttriTxt12 AS 'Attribute 12', ITM13.AttriTxt13 AS 'Attribute 13', ITM13.AttriTxt14 AS 'Attribute 14', ITM13.AttriTxt15 AS 'Attribute 15', ITM13.AttriTxt16 AS 'Attribute 16', ITM13.AttriTxt17 AS 'Attribute 17', ITM13.AttriTxt18 AS 'Attribute 18', ITM13.AttriTxt19 AS 'Attribute 19', ITM13.AttriTxt20 AS 'Attribute 20', ITM13.AttriTxt21 AS 'Attribute 21', ITM13.AttriTxt22 AS 'Attribute 22', ITM13.AttriTxt23 AS 'Attribute 23', ITM13.AttriTxt24 AS 'Attribute 24', ITM13.AttriTxt25 AS 'Attribute 25', ITM13.AttriTxt26 AS 'Attribute 26', ITM13.AttriTxt27 AS 'Attribute 27', ITM13.AttriTxt28 AS 'Attribute 28', ITM13.AttriTxt29 AS 'Attribute 29', ITM13.AttriTxt30 AS 'Attribute 30', ITM13.AttriTxt31 AS 'Attribute 31', ITM13.AttriTxt32 AS 'Attribute 32', ITM13.AttriInt33 AS 'Attribute 33', ITM13.AttriInt34 AS 'Attribute 34', ITM13.AttriInt35 AS 'Attribute 35', ITM13.AttriInt36 AS 'Attribute 36', ITM13.AttriInt37 AS 'Attribute 37', ITM13.AttriInt38 AS 'Attribute 38', ITM13.AttriInt39 AS 'Attribute 39', ITM13.AttriInt40 AS 'Attribute 40', ITM13.AttriInt41 AS 'Attribute 41', ITM13.AttriInt42 AS 'Attribute 42', ITM13.AttriDt43 AS 'Attribute 43', ITM13.AttriDt44 AS 'Attribute 44', ITM13.AttriDt45 AS 'Attribute 45', ITM13.AttriDt46 AS 'Attribute 46', ITM13.AttriDt47 AS 'Attribute 47', ITM13.AttriAm48 AS 'Attribute 48', ITM13.AttriAm49 AS 'Attribute 49', ITM13.AttriAm50 AS 'Attribute 50', ITM13.AttriAm51 AS 'Attribute 51', ITM13.AttriAm52 AS 'Attribute 52', ITM13.AttriAm53 AS 'Attribute 53', ITM13.AttriAm54 AS 'Attribute 54', ITM13.AttriPr55 AS 'Attribute 55', ITM13.AttriPr56 AS 'Attribute 56', ITM13.AttriPr57 AS 'Attribute 57', ITM13.AttriPr58 AS 'Attribute 58', ITM13.AttriPr59 AS 'Attribute 59', ITM13.AttriQTY60 AS 'Attribute 60', ITM13.AttriQTY61 AS 'Attribute 61', ITM13.AttriQTY62 AS 'Attribute 62', ITM13.AttriQTY63 AS 'Attribute 63', ITM13.AttriQTY64 AS 'Attribute 64', ITM13.LogInstanc AS 'Log Instance', ITM13.ObjType AS 'Object' FROM ITM13 AS ITM13

Related information


Items Attribute Groups ItemsAttributeGroups Object· Table: ITM13
ItemsAttributeGroups is a child object of the Items object. You can manage the attributes of an asset. Source table: ITM13.
   Parent: Items Items Object· Table: OITM
Items OITM SQL Table

Object Settings - History ADP1 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