biuan SAP® BUSINESS ONE SDK
API AAC1
AAC1 - Asset Classes - Depreciation Areas - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
20OACS
Asset Classes
UNIQUEYes
LineNumLine NumberInt
11
DprAreaIDDepreciation Area IDnVarChar
15ODPA
Fixed Asset Depreciation Areas
ActiveActiveVarChar
Y) Yes
N) No
1
Y
AcctDtnAccount DeterminationnVarChar
15OADT
Fixed Assets Account Determination
DprTypIDDepreciation Type IDnVarChar
15ODTP
Fixed Assets Depreciation Types
UseLifeUseful LifeInt
11
LogInstancLog InstanceInt
11
0
SnapshotIdSnapshot IDInt
11
0

Table relationship map

SELECT statement

SELECT AAC1.Code AS 'Code', AAC1.LineNum AS 'Line Number', AAC1.DprAreaID AS 'Depreciation Area ID', AAC1.Active AS 'Active', AAC1.AcctDtn AS 'Account Determination', AAC1.DprTypID AS 'Depreciation Type ID', AAC1.UseLife AS 'Useful Life', AAC1.LogInstanc AS 'Log Instance', AAC1.SnapshotId AS 'Snapshot ID' FROM AAC1 AS AAC1

Related information


Fixed Assets Account Determination OADT SQL Table

Asset Classes OACS SQL Table

Fixed Asset Depreciation Areas ODPA SQL Table

Fixed Assets Depreciation Types ODTP 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