|
|
API DRN1
DRN1 - Depreciation Run - Posting Table
Fixed Assets Account Determination OADT SQL Table
Asset Classes OACS SQL Table
Depreciation Run ODRN SQL Table
G/L Accounts OACT 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 | ODRN Depreciation Run | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| AcctDtn | Account Determination | nVarChar | 15 | OADT Fixed Assets Account Determination | ||||
| TransId | Transaction Number | Int | 11 | OJDT Journal Entry | ||||
| OrdDprAct | Ordinary Depreciation Account | nVarChar | 15 | OACT G/L Accounts | ||||
| SpDprAct | Special Depreciation Account | nVarChar | 15 | OACT G/L Accounts | ||||
| SpBalAct | Special Balance Account | nVarChar | 15 | OACT G/L Accounts | ||||
| OrdBalAct | Ordinary Balance Account | nVarChar | 15 | OACT G/L Accounts | ||||
| OrdDprAmt | Ordinary Depreciation Amount | Num | 20 | |||||
| SpDprAmt | Special Depreciation Amount | Num | 20 | |||||
| RevResAct | Revaluation Reserve Account | nVarChar | 15 | OACT G/L Accounts | ||||
| RevResClr | Revaluation Reserve Clearing | nVarChar | 15 | OACT G/L Accounts | ||||
| RevReserve | Revaluation Reserve Amount | Num | 20 | |||||
| AssetClass | Asset Class | nVarChar | 20 | OACS Asset Classes | ||||
| CancelId | Cancelation Transaction No. | Int | 11 |
Table relationship map
SELECT statement
SELECT
DRN1.DocEntry AS 'Document Internal ID',
DRN1.AcctDtn AS 'Account Determination',
DRN1.TransId AS 'Transaction Number',
DRN1.OrdDprAct AS 'Ordinary Depreciation Account',
DRN1.SpDprAct AS 'Special Depreciation Account',
DRN1.SpBalAct AS 'Special Balance Account',
DRN1.OrdBalAct AS 'Ordinary Balance Account',
DRN1.OrdDprAmt AS 'Ordinary Depreciation Amount',
DRN1.SpDprAmt AS 'Special Depreciation Amount',
DRN1.RevResAct AS 'Revaluation Reserve Account',
DRN1.RevResClr AS 'Revaluation Reserve Clearing',
DRN1.RevReserve AS 'Revaluation Reserve Amount',
DRN1.AssetClass AS 'Asset Class',
DRN1.CancelId AS 'Cancelation Transaction No.'
FROM DRN1 AS DRN1
Related information
Fixed Assets Account Determination OADT SQL Table
Asset Classes OACS SQL Table
Depreciation Run ODRN SQL Table
G/L Accounts OACT 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
