|
|
API Depreciation Level Collection / Depreciation Level
DTP1 - Depreciation Types - Rows Table
Depreciation Level DepreciationLevel Object· Table: DTP1
Parent: Depreciation Level Collection DepreciationLevelCollection Collection
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 | 15 | ODTP Fixed Assets Depreciation Types | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Level | Level | Int | 11 | |||||
| Base | Base | nVarChar | APC) Acquisition Value NBV) Net Book Value | 3 | APC | |||
| Years | Number of Years | Int | 11 | |||||
| Percentage | Percentage | Num | 20 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| Amount | Amount | Num | 20 | |||||
| SnapshotId | Snapshot ID | Int | 11 | 0 |
SELECT statement
SELECT
DTP1.Code AS 'Code',
DTP1.Level AS 'Level',
DTP1.Base AS 'Base',
DTP1.Years AS 'Number of Years',
DTP1.Percentage AS 'Percentage',
DTP1.LogInstanc AS 'Log Instance',
DTP1.Amount AS 'Amount',
DTP1.SnapshotId AS 'Snapshot ID'
FROM DTP1 AS DTP1
Related information
Depreciation Level DepreciationLevel Object· Table: DTP1
DepreciationLevel is a child object of DepreciationType object.
You can view an asset's useful life as several phases and depreciate the asset by a defined rate for each phase. This way, the asset can have a course of depreciation that changes...
Parent: Depreciation Level Collection DepreciationLevelCollection CollectionFixed Assets Depreciation Types ODTP SQL Table
DepreciationLevelCollection
Object
DepreciationLevel
Enumeration
Method
Property
amount
DB
Level
DB
Percentage
DB
Method
Property
Code
8.8.2 DB
Name
8.8.2 DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
