|
|
API AACS
AACS - Asset Classes - History Table
Asset Attributes OFAA SQL Table
Business Place OBPL SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Code | nVarChar | 20 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name | Name | nVarChar | 100 | |||||
| AssetType | Asset Type | VarChar | G) General L) Low Value Asset | 1 | G | |||
| LimitFrom | Value Limit From | Num | 20 | |||||
| LimitTo | Value Limit To | Num | 20 | |||||
| DataSource | Data Source | VarChar | 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 | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| CreateDate | Create Date | Date | 8 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| BPLId | Branch | Int | 11 | OBPL Business Place | ||||
| AttrGrp | Attribute Group | Int | 11 | OFAA Asset Attributes | -1 | |||
| SnapshotId | Snapshot ID | Int | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
