|
|
API AAC1
AAC1 - Asset Classes - Depreciation Areas - History Table
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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Code | nVarChar | 20 | OACS Asset Classes | UNIQUE | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Line Number | Int | 11 | |||||
| DprAreaID | Depreciation Area ID | nVarChar | 15 | ODPA Fixed Asset Depreciation Areas | ||||
| Active | Active | VarChar | Y) Yes N) No | 1 | Y | |||
| AcctDtn | Account Determination | nVarChar | 15 | OADT Fixed Assets Account Determination | ||||
| DprTypID | Depreciation Type ID | nVarChar | 15 | ODTP Fixed Assets Depreciation Types | ||||
| UseLife | Useful Life | Int | 11 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| SnapshotId | Snapshot ID | Int | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
