|
|
DTW Inventory / Item Master Data / Asset Item Depreciation Params
API Items / Items Depreciation Parameters
ITM7 - Asset Item Depreciation Params Table
Items Depreciation Parameters ItemsDepreciationParameters Object· Table: ITM7
Parent: Items Items Object· Table: OITM
Fixed Asset Depreciation Areas ODPA SQL Table
Fixed Assets Depreciation Types ODTP SQL Table
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ItemCode KEY UNIQUE | Item No. | nVarChar | 20 | OITM Items | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| PeriodCat | Period Category | nVarChar | 10 | |||||
| DprArea | Depreciation Area | nVarChar | 15 | ODPA Fixed Asset Depreciation Areas | ||||
| VisOrder | Visual Order | Int | 11 | |||||
| DprStart | Depreciation Start Date | Date | 8 | |||||
| DprEnd | Depreciation End Date | Date | 8 | |||||
| UsefulLife | Useful Life | Int | 11 | |||||
| RemainLife | Remaining Life | Num | 20 | |||||
| DprType | Depreciation Type | nVarChar | 15 | ODTP Fixed Assets Depreciation Types | ||||
| DprTypeC | Depr. Type Calculation | nVarChar | 15 | ODTP Fixed Assets Depreciation Types | ||||
| UsefulLfeC | Useful Life Calculation | Int | 11 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object | nVarChar | 20 | ADP1 Object Settings - History | 4 | |||
| RemainDays | Remaining Life in Days | Num | 20 |
Table relationship map
SELECT statement
SELECT
ITM7.ItemCode AS 'Item No.',
ITM7.PeriodCat AS 'Period Category',
ITM7.DprArea AS 'Depreciation Area',
ITM7.VisOrder AS 'Visual Order',
ITM7.DprStart AS 'Depreciation Start Date',
ITM7.DprEnd AS 'Depreciation End Date',
ITM7.UsefulLife AS 'Useful Life',
ITM7.RemainLife AS 'Remaining Life',
ITM7.DprType AS 'Depreciation Type',
ITM7.DprTypeC AS 'Depr. Type Calculation',
ITM7.UsefulLfeC AS 'Useful Life Calculation',
ITM7.LogInstanc AS 'Log Instance',
ITM7.ObjType AS 'Object',
ITM7.RemainDays AS 'Remaining Life in Days'
FROM ITM7 AS ITM7
Related information
Items Depreciation Parameters ItemsDepreciationParameters Object· Table: ITM7
ItemsDepreciationParameters is a child object of the Items object.
You can specify depreciation parameters for a fixed asset.
Source table: ITM7.
Parent: Items Items Object· Table: OITM Fixed Asset Depreciation Areas ODPA SQL Table
Fixed Assets Depreciation Types ODTP SQL Table
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
Items
Object
ItemsDepreciationParameters
Method
Property
FiscalYear
DB
UsefulLife
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
