|
|
API AIT11
AIT11 - Asset Item Period Control Table
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
AIT11.ItemCode AS 'Item No.',
AIT11.PeriodCat AS 'Period Category',
AIT11.DprArea AS 'Depreciation Area',
AIT11.VisOrder AS 'Visual Order',
AIT11.DprSt AS 'Depreciation Status',
AIT11.factor AS 'Factor',
AIT11.LogInstanc AS 'Log Instance'
FROM AIT11 AS AIT11
Related information
Fixed Asset Depreciation Areas ODPA SQL Table
Items OITM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
