biuan SAP® BUSINESS ONE SDK
API AFA2
AFA2 - Asset Document - Area Journal Transactions Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11AFAD
Asset Document - History
PRIMARYYes
LineNumRow NumberInt
11
DprAreaDepreciation AreanVarChar
15ODPA
Fixed Asset Depreciation Areas
JrnlMemoJournal RemarksnVarChar
50
ObjTypeObject TypenVarChar
20
LogInstancLog InstanceInt
11
0
TransNumTransaction NumberInt
11OJDT
Journal Entry
JrnlMemo1Cancellation Journal RemarksnVarChar
50
TransNum1Cancellation Transaction No.Int
11OJDT
Journal Entry

Table relationship map

SELECT statement

SELECT AFA2.DocEntry AS 'Document Internal ID', AFA2.LineNum AS 'Row Number', AFA2.DprArea AS 'Depreciation Area', AFA2.JrnlMemo AS 'Journal Remarks', AFA2.ObjType AS 'Object Type', AFA2.LogInstanc AS 'Log Instance', AFA2.TransNum AS 'Transaction Number', AFA2.JrnlMemo1 AS 'Cancellation Journal Remarks', AFA2.TransNum1 AS 'Cancellation Transaction No.' FROM AFA2 AS AFA2

Related information


Asset Document - History AFAD SQL Table

Fixed Asset Depreciation Areas ODPA SQL Table

Journal Entry OJDT 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