biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Items / Asset Item Distribution Rules
DTW Inventory / Item Master Data / Asset Item Distribution Rules
API Items / Items Distribution Rules
ITM6 - Asset Item Distribution Rules Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem No.nVarChar
20OITM
Items		PRIMARYYes
LineNumLine NumbernVarChar
11
ValidFromValid FromDate
8
ValidToValid ToDate
8
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
OcrCode2Costing Code 2nVarChar
8OOCR
Distribution Rule
OcrCode3Costing Code 3nVarChar
8OOCR
Distribution Rule
OcrCode4Costing Code 4nVarChar
8OOCR
Distribution Rule
OcrCode5Costing Code 5nVarChar
8OOCR
Distribution Rule
LogInstancLog InstanceInt
11
0
ObjTypeObjectnVarChar
20ADP1
Object Settings - History		4

Table relationship map

SELECT statement

SELECT ITM6.ItemCode AS 'Item No.', ITM6.LineNum AS 'Line Number', ITM6.ValidFrom AS 'Valid From', ITM6.ValidTo AS 'Valid To', ITM6.OcrCode AS 'Distribution Rule', ITM6.OcrCode2 AS 'Costing Code 2', ITM6.OcrCode3 AS 'Costing Code 3', ITM6.OcrCode4 AS 'Costing Code 4', ITM6.OcrCode5 AS 'Costing Code 5', ITM6.LogInstanc AS 'Log Instance', ITM6.ObjType AS 'Object' FROM ITM6 AS ITM6

Related information


Items Distribution Rules ItemsDistributionRules Object· Table: ITM6
ItemsDistributionRules is a child object of the Items object. You can assign distribution rules to an asset to facilitate cost accounting. Source table: ITM6.
   Parent: Items Items Object· Table: OITM
Items OITM SQL Table

Object Settings - History ADP1 SQL Table

Distribution Rule OOCR 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