|
|
DTW Inventory / Item Master Data / Asset Item Period Control
API Items / Items Period Controls
ITM11 - Asset Item Period Control Table
Items Period Controls ItemsPeriodControls Object· Table: ITM11
Parent: Items Items Object· Table: OITM
Fixed Asset Depreciation Areas ODPA SQL Table
Items OITM 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 | |||||
| DprSt | Depreciation Status | VarChar | Y) Yes N) No | 1 | Y | |||
| factor | Factor | Num | 20 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 |
Table relationship map
SELECT statement
SELECT
ITM11.ItemCode AS 'Item No.',
ITM11.PeriodCat AS 'Period Category',
ITM11.DprArea AS 'Depreciation Area',
ITM11.VisOrder AS 'Visual Order',
ITM11.DprSt AS 'Depreciation Status',
ITM11.factor AS 'Factor',
ITM11.LogInstanc AS 'Log Instance'
FROM ITM11 AS ITM11
Related information
Items Period Controls ItemsPeriodControls Object· Table: ITM11
ItemsPeriodControls is a child object of the Items object.
You can define the depreciation calculation factors for different periods when you depreciate an asset using the straight line period control method with individual period...
Parent: Items Items Object· Table: OITM Fixed Asset Depreciation Areas ODPA SQL Table
Items OITM SQL Table
Items
Object
ItemsPeriodControls
Method
Property
Factor
DB
FiscalYear
DB
SubPeriod
DB
Collection
Enumeration
Method
Object
Section OSEC
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates