biuan SAP® BUSINESS ONE SDK
API AACS
AACS - Asset Classes - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
20
PRIMARYYes
NameNamenVarChar
100
AssetTypeAsset TypeVarChar
G) General
L) Low Value Asset
1
G
LimitFromValue Limit FromNum
20
LimitToValue Limit ToNum
20
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
LogInstancLog InstanceInt
11
0
CreateDateCreate DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8
BPLIdBranchInt
11OBPL
Business Place
AttrGrpAttribute GroupInt
11OFAA
Asset Attributes
-1
SnapshotIdSnapshot IDInt
11
0

Table relationship map

SELECT statement

SELECT AACS.Code AS 'Code', AACS.Name AS 'Name', AACS.AssetType AS 'Asset Type', AACS.LimitFrom AS 'Value Limit From', AACS.LimitTo AS 'Value Limit To', AACS.DataSource AS 'Data Source', AACS.UserSign AS 'User Signature', AACS.LogInstanc AS 'Log Instance', AACS.CreateDate AS 'Create Date', AACS.UserSign2 AS 'Updating User', AACS.UpdateDate AS 'Date of Update', AACS.BPLId AS 'Branch', AACS.AttrGrp AS 'Attribute Group', AACS.SnapshotId AS 'Snapshot ID' FROM AACS AS AACS

Related information


Asset Attributes OFAA SQL Table

Business Place OBPL SQL Table

Users OUSR 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