|
|
API MDP2
MDP2 - Manual Depreciation - Area Journal Transactions Table
Manual Depreciation OMDP SQL Table
Fixed Asset Depreciation Areas ODPA SQL Table
Journal Entry OJDT 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 | OMDP Manual Depreciation | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| DprArea | Depreciation Area | nVarChar | 15 | ODPA Fixed Asset Depreciation Areas | ||||
| JrnlMemo | Journal Remarks | nVarChar | 50 | |||||
| ObjType | Object Type | nVarChar | 20 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| TransNum | Transaction Number | Int | 11 | OJDT Journal Entry | ||||
| JrnlMemo1 | Cancellation Journal Remarks | nVarChar | 50 | |||||
| TransNum1 | Cancellation Transaction No. | Int | 11 | OJDT Journal Entry |
Table relationship map
SELECT statement
SELECT
MDP2.DocEntry AS 'Document Internal ID',
MDP2.LineNum AS 'Row Number',
MDP2.DprArea AS 'Depreciation Area',
MDP2.JrnlMemo AS 'Journal Remarks',
MDP2.ObjType AS 'Object Type',
MDP2.LogInstanc AS 'Log Instance',
MDP2.TransNum AS 'Transaction Number',
MDP2.JrnlMemo1 AS 'Cancellation Journal Remarks',
MDP2.TransNum1 AS 'Cancellation Transaction No.'
FROM MDP2 AS MDP2
Related information
Manual Depreciation OMDP SQL Table
Fixed Asset Depreciation Areas ODPA SQL Table
Journal Entry OJDT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
