biuan SAP® BUSINESS ONE SDK
SQL Finance / Fixed Asset Transaction - Rows
API FIX1
FIX1 - Fixed Asset Transaction - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11OFIX
Fixed Asset Transactions		PRIMARYYes
LineNumRow NumberInt
11
ItemCodeItem CodenVarChar
20OITM
Items
DprArea KEYDepreciation Area IDnVarChar
15ODPA
Fixed Asset Depreciation Areas		SECONDARYNo
PeriodCatPeriod Category IDnVarChar
10
PostPeriodPosting SubperiodInt
11
RefDatePosting DateDate
8
APCAPCNum
20
OrdDprOrdinary DepreciationNum
20
UnpDprUnplanned DepreciationNum
20
SpDprKey1Special Depreciation Key 01nVarChar
2ODPP
Depreciation Type Pools
SpDpr1Special Depreciation 01Num
20
QtyQuantityNum
20
DprTypeNew Depreciation TypenVarChar
15ODTP
Fixed Assets Depreciation Types
DprDateNew Depreciation Start DateDate
8
RemLifeNew Remaining LifeInt
11
SalvageValNew Salvage ValueNum
20
RecvAsstReceiving Item CodenVarChar
20OITM
Items
RetirDateRetirement DateDate
8
SpDprKey2Special Depreciation Key 02nVarChar
2ODPP
Depreciation Type Pools
SpDpr2Special Depreciation 02Num
20
SpDprKey3Special Depreciation Key 03nVarChar
2ODPP
Depreciation Type Pools
TransTypeTransaction TypenVarChar
0
110) Acquisition
115) Subacquisition
120) Credit Memo
210) Full Retirement
220) Full Scrapping
230) Partial Retirement
240) Partial Scrapping
260) Low Value Asset Full Retirement
270) Low Value Asset Full Scrapping
310) Full Transfer
320) Partial Transfer
330) Asset Class Transfer
410) Manual Ordinary Depreciation
420) Manual Unplanned Depreciation
430) Manual Special Depreciation
440) Appreciation
550) Revaluation
510) Change of Depreciation Type
520) Change of Useful Life
530) Change of Depreciation Start Date
540) Change of Salvage Value
560) Change of Period Control
4
UsefulLifeNew Useful LifeInt
11
ApprAppreciationNum
20
WriteUpWrite-UpNum
20
DeltaDaysDelta Remaining Life in DaysInt
11
NewAstClsNew Asset ClassnVarChar
20OACS
Asset Classes
HistOrdDprHistorical Ordinary Depr.Num
20
SpDpr3Special Depreciation 03Num
20
TransAmntTransaction AmountNum
20
RemarkRemarksnVarChar
127
ReTranTypeReceiving Transaction TypenVarChar
0
110) Acquisition
115) Subacquisition
4
0

Table relationship map

SELECT statement

SELECT FIX1.AbsEntry AS 'Internal Number', FIX1.LineNum AS 'Row Number', FIX1.ItemCode AS 'Item Code', FIX1.DprArea AS 'Depreciation Area ID', FIX1.PeriodCat AS 'Period Category ID', FIX1.PostPeriod AS 'Posting Subperiod', FIX1.RefDate AS 'Posting Date', FIX1.APC AS 'APC', FIX1.OrdDpr AS 'Ordinary Depreciation', FIX1.UnpDpr AS 'Unplanned Depreciation', FIX1.SpDprKey1 AS 'Special Depreciation Key 01', FIX1.SpDpr1 AS 'Special Depreciation 01', FIX1.Qty AS 'Quantity', FIX1.DprType AS 'New Depreciation Type', FIX1.DprDate AS 'New Depreciation Start Date', FIX1.RemLife AS 'New Remaining Life', FIX1.SalvageVal AS 'New Salvage Value', FIX1.RecvAsst AS 'Receiving Item Code', FIX1.RetirDate AS 'Retirement Date', FIX1.SpDprKey2 AS 'Special Depreciation Key 02', FIX1.SpDpr2 AS 'Special Depreciation 02', FIX1.SpDprKey3 AS 'Special Depreciation Key 03', FIX1.TransType AS 'Transaction Type', FIX1.UsefulLife AS 'New Useful Life', FIX1.Appr AS 'Appreciation', FIX1.WriteUp AS 'Write-Up', FIX1.DeltaDays AS 'Delta Remaining Life in Days', FIX1.NewAstCls AS 'New Asset Class', FIX1.HistOrdDpr AS 'Historical Ordinary Depr.', FIX1.SpDpr3 AS 'Special Depreciation 03', FIX1.TransAmnt AS 'Transaction Amount', FIX1.Remark AS 'Remarks', FIX1.ReTranType AS 'Receiving Transaction Type' FROM FIX1 AS FIX1

Related information


Fixed Asset Transactions OFIX SQL Table

Fixed Asset Depreciation Areas ODPA SQL Table

Fixed Assets Depreciation Types ODTP SQL Table

Items OITM SQL Table

Asset Classes OACS 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