biuan SAP® BUSINESS ONE SDK
API AIT11
AIT11 - 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 AIT11.ItemCode AS 'Item No.', AIT11.PeriodCat AS 'Period Category', AIT11.DprArea AS 'Depreciation Area', AIT11.VisOrder AS 'Visual Order', AIT11.DprSt AS 'Depreciation Status', AIT11.factor AS 'Factor', AIT11.LogInstanc AS 'Log Instance' FROM AIT11 AS AIT11

Related information


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