ITM11 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Inventory and Production /

Items / Asset Item Period Control

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

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
ItemCode ^KEY ^UNIQUE	Item No.	nVarChar		20	OITM Items		PRIMARY	Yes
PeriodCat	Period Category	nVarChar		10
DprArea	Depreciation Area	nVarChar		15	ODPA Fixed Asset Depreciation Areas
VisOrder	Visual Order	Int		11
DprSt	Depreciation Status	VarChar	Y) Yes N) No	1		Y
factor	Factor	Num		20
LogInstanc	Log Instance	Int		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

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
ODPA SQL Table

OITM SQL Table

biuan SAP® BUSINESS ONE

Object
Items

Object
ItemsPeriodControls

Method

Add

SetCurrentLine

Property

Count

Factor

Collection

SectionsParams

Enumeration

SectionsServiceDataInterfaces

Method

AddSection

DeleteSection

GetDataInterface

GetDataInterfaceFromXMLFile

GetDataInterfaceFromXMLString

GetSection

GetSectionList

UpdateSection

Object

Section OSEC

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