biuan SAP® BUSINESS ONE SDK
DTW Inventory / Item Master Data / Asset Item Period Control
API Items / Items Period Controls
ITM11 - Asset Item Period Control 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
DprStDepreciation StatusVarChar
Y) Yes
N) No
1
Y
factorFactorNum
20
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT ITM11.ItemCode AS 'Item No.', ITM11.PeriodCat AS 'Period Category', ITM11.DprArea AS 'Depreciation Area', ITM11.VisOrder AS 'Visual Order', ITM11.DprSt AS 'Depreciation Status', ITM11.factor AS 'Factor', ITM11.LogInstanc AS 'Log Instance' FROM ITM11 AS ITM11

Related information


Items Period Controls ItemsPeriodControls Object· Table: ITM11
ItemsPeriodControls is a child object of the Items object. You can define the depreciation calculation factors for different periods when you depreciate an asset using the straight line period control method with individual period...
   Parent: Items Items Object· Table: OITM
Fixed Asset Depreciation Areas ODPA SQL Table

Items OITM 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