biuan SAP® BUSINESS ONE SDK
DTW Inventory / Item Master Data / Asset Item Depreciation Params
API Items / Items Depreciation Parameters
ITM7 - Asset Item Depreciation Params Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem No.nVarChar
20OITM
Items
PRIMARYYes
PeriodCatPeriod CategorynVarChar
10
DprAreaDepreciation AreanVarChar
15ODPA
Fixed Asset Depreciation Areas
VisOrderVisual OrderInt
11
DprStartDepreciation Start DateDate
8
DprEndDepreciation End DateDate
8
UsefulLifeUseful LifeInt
11
RemainLifeRemaining LifeNum
20
DprTypeDepreciation TypenVarChar
15ODTP
Fixed Assets Depreciation Types
DprTypeCDepr. Type CalculationnVarChar
15ODTP
Fixed Assets Depreciation Types
UsefulLfeCUseful Life CalculationInt
11
LogInstancLog InstanceInt
11
0
ObjTypeObjectnVarChar
20ADP1
Object Settings - History
4
RemainDaysRemaining Life in DaysNum
20

Table relationship map

SELECT statement

SELECT ITM7.ItemCode AS 'Item No.', ITM7.PeriodCat AS 'Period Category', ITM7.DprArea AS 'Depreciation Area', ITM7.VisOrder AS 'Visual Order', ITM7.DprStart AS 'Depreciation Start Date', ITM7.DprEnd AS 'Depreciation End Date', ITM7.UsefulLife AS 'Useful Life', ITM7.RemainLife AS 'Remaining Life', ITM7.DprType AS 'Depreciation Type', ITM7.DprTypeC AS 'Depr. Type Calculation', ITM7.UsefulLfeC AS 'Useful Life Calculation', ITM7.LogInstanc AS 'Log Instance', ITM7.ObjType AS 'Object', ITM7.RemainDays AS 'Remaining Life in Days' FROM ITM7 AS ITM7

Related information


Items Depreciation Parameters ItemsDepreciationParameters Object· Table: ITM7
ItemsDepreciationParameters is a child object of the Items object. You can specify depreciation parameters for a fixed asset. Source table: ITM7.
   Parent: Items Items Object· Table: OITM
Fixed Asset Depreciation Areas ODPA SQL Table

Fixed Assets Depreciation Types ODTP SQL Table

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