biuan SAP® BUSINESS ONE SDK
DTW Inventory / Item Master Data / Asset Item Projects
API Items / Items Projects
ITM5 - Asset Item Projects Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem No.nVarChar
20OITM
Items
PRIMARYYes
LineNumLine NumberInt
11
ValidFromValid FromDate
8
ValidToValid ToDate
8
ProjectProjectnVarChar
20OPRJ
Project Codes
LogInstancLog InstanceInt
11
0
ObjTypeObjectnVarChar
20ADP1
Object Settings - History
4

Table relationship map

SELECT statement

SELECT ITM5.ItemCode AS 'Item No.', ITM5.LineNum AS 'Line Number', ITM5.ValidFrom AS 'Valid From', ITM5.ValidTo AS 'Valid To', ITM5.Project AS 'Project', ITM5.LogInstanc AS 'Log Instance', ITM5.ObjType AS 'Object' FROM ITM5 AS ITM5

Related information


Items Projects ItemsProjects Object· Table: ITM5
ItemsProjects is a child object of the Items object. You can assign projects to an asset to facilitate cost accounting. Source table: ITM5.
   Parent: Items Items Object· Table: OITM
Items OITM SQL Table

Object Settings - History ADP1 SQL Table

Project Codes OPRJ 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