|
|
API MDP3
MDP3 - Manual Depreciation - Item Areas Table
Capitalization OACQ SQL 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 | DocEntry KEY UNIQUE | Document Internal ID | Int | 11 | OACQ Capitalization | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ItemLine | Item Row Number | Int | 11 | |||||
| ItemCode | Item Code | nVarChar | 20 | OITM Items | ||||
| DprArea | Depreciation Area | nVarChar | 15 | ODPA Fixed Asset Depreciation Areas | ||||
| Total | Total | Num | 20 | |||||
| TotalFrgn | Total (FC) | Num | 20 | |||||
| TotalSys | Total (SC) | Num | 20 | |||||
| ObjType | Object Type | nVarChar | 20 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 |
Table relationship map
SELECT statement
SELECT
MDP3.DocEntry AS 'Document Internal ID',
MDP3.ItemLine AS 'Item Row Number',
MDP3.ItemCode AS 'Item Code',
MDP3.DprArea AS 'Depreciation Area',
MDP3.Total AS 'Total',
MDP3.TotalFrgn AS 'Total (FC)',
MDP3.TotalSys AS 'Total (SC)',
MDP3.ObjType AS 'Object Type',
MDP3.LogInstanc AS 'Log Instance'
FROM MDP3 AS MDP3
Related information
Capitalization OACQ SQL Table
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
