|
|
API DRN2
DRN2 - Depreciation Run - Posting - Asset Table
Fixed Assets Account Determination OADT SQL Table
Asset Classes OACS SQL Table
Depreciation Run ODRN 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 | ODRN Depreciation Run | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| AcctDtn | Account Determination | nVarChar | 15 | OADT Fixed Assets Account Determination | ||||
| ItemCode | Item Code | nVarChar | 20 | OITM Items | ||||
| OrdDprAmt | Ordinary Depreciation Amount | Num | 20 | |||||
| SpDprAmt | Special Depreciation Amount | Num | 20 | |||||
| RevReserve | Revaluation Reserve Amount | Num | 20 | |||||
| AssetClass | Asset Class | nVarChar | 20 | OACS Asset Classes |
Table relationship map
SELECT statement
SELECT
DRN2.DocEntry AS 'Document Internal ID',
DRN2.AcctDtn AS 'Account Determination',
DRN2.ItemCode AS 'Item Code',
DRN2.OrdDprAmt AS 'Ordinary Depreciation Amount',
DRN2.SpDprAmt AS 'Special Depreciation Amount',
DRN2.RevReserve AS 'Revaluation Reserve Amount',
DRN2.AssetClass AS 'Asset Class'
FROM DRN2 AS DRN2
Related information
Fixed Assets Account Determination OADT SQL Table
Asset Classes OACS SQL Table
Depreciation Run ODRN 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
