biuan SAP® BUSINESS ONE SDK
API Fixed Asset Items Service / Fixed Asset End Balance
 v9.0  OFEV - Fixed Asset End Balances Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem CodenVarChar
20OITM
Items		PRIMARYYes
PeriodCatPeriod CategorynVarChar
10
DprAreaDepreciation AreanVarChar
15ODPA
Fixed Asset Depreciation Areas
APCHistHistorical APCNum
20
APCAPCNum
20
NetNBVNet Book ValueNum
20
HistNBVHistorical Net Book ValueNum
20
OrDpAccAccumulated Ordinary Depr.Num
20
UnDpAccAccumulated Unplanned Depr.Num
20
spDpAccAccumulated Special Depr.Num
20
WriteUpAccAccumulated Write-UpNum
20
SalvageValSalvage ValueNum
20
QuantityAsset QuantityNum
20

SELECT statement

SELECT OFEV.ItemCode AS 'Item Code', OFEV.PeriodCat AS 'Period Category', OFEV.DprArea AS 'Depreciation Area', OFEV.APCHist AS 'Historical APC', OFEV.APC AS 'APC', OFEV.NetNBV AS 'Net Book Value', OFEV.HistNBV AS 'Historical Net Book Value', OFEV.OrDpAcc AS 'Accumulated Ordinary Depr.', OFEV.UnDpAcc AS 'Accumulated Unplanned Depr.', OFEV.spDpAcc AS 'Accumulated Special Depr.', OFEV.WriteUpAcc AS 'Accumulated Write-Up', OFEV.SalvageVal AS 'Salvage Value', OFEV.Quantity AS 'Asset Quantity' FROM OFEV AS OFEV

Related information


Fixed Asset End Balance FixedAssetEndBalance Object· Table: OFEV
Source table: OFEV.
   Parent: Fixed Asset Items Service FixedAssetItemsService Service· Table: OFDV


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