biuan SAP® BUSINESS ONE SDK
SQL Finance / Fixed Assets Depreciation Value
API ODPV
ODPV - Fixed Assets Depreciation Value Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
ItemCode KEY UNIQUEItem CodenVarChar
20OITM
Items		SECONDARYYes
DprAreaDepreciation Area IDnVarChar
15ODPA
Fixed Asset Depreciation Areas
PeriodCatPeriod CategorynVarChar
10
FromDatePeriod Start DateDate
8
ToDatePeriod To DateDate
8
OrdDprPlanOrdinary Depreciation PlanNum
20
OrdDprPostOrdinary Depreciation PostedNum
20
OrdDprActOrdinary Depreciation ActualNum
20
SpDprKeySpecial Depreciation KeynVarChar
2ODPP
Depreciation Type Pools
SpDprPlanSpecial Depreciation PlanNum
20
SpDprPostSpecial Depreciation PostedNum
20
SpDprActSpecial Depreciation ActualNum
20
SubPeriodSub-periodInt
11
OrdDprPln1Ordinary Depreciation Plan 1Num
20
OrdDprPst1Ordinary Depreciation Posted 1Num
20
OrdDprAct1Ordinary Depreciation Actual 1Num
20

Table relationship map

SELECT statement

SELECT ODPV.AbsEntry AS 'Internal Number', ODPV.ItemCode AS 'Item Code', ODPV.DprArea AS 'Depreciation Area ID', ODPV.PeriodCat AS 'Period Category', ODPV.FromDate AS 'Period Start Date', ODPV.ToDate AS 'Period To Date', ODPV.OrdDprPlan AS 'Ordinary Depreciation Plan', ODPV.OrdDprPost AS 'Ordinary Depreciation Posted', ODPV.OrdDprAct AS 'Ordinary Depreciation Actual', ODPV.SpDprKey AS 'Special Depreciation Key', ODPV.SpDprPlan AS 'Special Depreciation Plan', ODPV.SpDprPost AS 'Special Depreciation Posted', ODPV.SpDprAct AS 'Special Depreciation Actual', ODPV.SubPeriod AS 'Sub-period', ODPV.OrdDprPln1 AS 'Ordinary Depreciation Plan 1', ODPV.OrdDprPst1 AS 'Ordinary Depreciation Posted 1', ODPV.OrdDprAct1 AS 'Ordinary Depreciation Actual 1' FROM ODPV AS ODPV

Related information


Fixed Asset Depreciation Areas ODPA SQL Table

Items OITM SQL Table

Depreciation Type Pools ODPP SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates