biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Asset Item Balances - History
API AIT8
AIT8 - Asset Item Balances - History 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
APCAPCNum
20
APCHistHistorical APCNum
20
QuantityAsset QuantityNum
20
OrDpAccAccumulated Ordinary Depr.Num
20
UnDpAccAccumulated Unplanned Depr.Num
20
SpDpKey1Special Depreciation 01nVarChar
2ODPP
Depreciation Type Pools
SpDpAcc1Accumulated Special Depr. 01Num
20
SpDpKey2Special Depreciation 02nVarChar
2ODPP
Depreciation Type Pools
SpDpAcc2Accumulated Special Depr. 02Num
20
SpDpKey3Special Depreciation 03nVarChar
2ODPP
Depreciation Type Pools
SpDpAcc3Accumulated Special Depr. 03Num
20
LogInstancLog InstanceInt
11
0
ObjTypeObjectnVarChar
20ADP1
Object Settings - History		4
SalvageValSalvage ValueNum
20
OrDpAcc1Ordinary Depr. Accumulation 01Num
20
WriteUpAccAccumulated Write-UpNum
20
IsMaSalValManually Changed Salvage ValueVarChar
Y) Yes
N) No
1
N
AppreAccAccumulated AppreciationNum
20

Table relationship map

SELECT statement

SELECT AIT8.ItemCode AS 'Item No.', AIT8.PeriodCat AS 'Period Category', AIT8.DprArea AS 'Depreciation Area', AIT8.APC AS 'APC', AIT8.APCHist AS 'Historical APC', AIT8.Quantity AS 'Asset Quantity', AIT8.OrDpAcc AS 'Accumulated Ordinary Depr.', AIT8.UnDpAcc AS 'Accumulated Unplanned Depr.', AIT8.SpDpKey1 AS 'Special Depreciation 01', AIT8.SpDpAcc1 AS 'Accumulated Special Depr. 01', AIT8.SpDpKey2 AS 'Special Depreciation 02', AIT8.SpDpAcc2 AS 'Accumulated Special Depr. 02', AIT8.SpDpKey3 AS 'Special Depreciation 03', AIT8.SpDpAcc3 AS 'Accumulated Special Depr. 03', AIT8.LogInstanc AS 'Log Instance', AIT8.ObjType AS 'Object', AIT8.SalvageVal AS 'Salvage Value', AIT8.OrDpAcc1 AS 'Ordinary Depr. Accumulation 01', AIT8.WriteUpAcc AS 'Accumulated Write-Up', AIT8.IsMaSalVal AS 'Manually Changed Salvage Value', AIT8.AppreAcc AS 'Accumulated Appreciation' FROM AIT8 AS AIT8

Related information


Fixed Asset Depreciation Areas ODPA SQL Table

Items OITM SQL Table

Object Settings - History ADP1 SQL Table

Depreciation Type Pools ODPP 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