9 March

Table OBTF (SAP Business One)

In SAP Business One, the OBTF table contains information on bank account entries. Each row in the table represents a single transaction posted to a bank account.

The OBTF table contains information such as the ID of the booking, the date of the booking, the booking amount and the corresponding bank account. Further information, such as the currency of the booking, the corresponding booking cycle and comments, can also be included.

The OBTF table is closely related to other modules of SAP Business One, such as the Sales Order and Supplier invoice. In this way, bookings can be assigned to an individual business partner or a transaction to simplify accounting and receivables management. Examples of fields in the OBTF table in SAP Business One are as follows:

  • TransId: This field contains the unique ID number of the booking.
  • DocNum: The number of the document assigned to the entry is saved here (e.g. invoice number, credit note number).
  • TransType: This field defines the type of booking (e.g. bank transfer, cash payment).
  • TransDate: The date of the booking is stored in this field.
  • Debit: The amount of the debit is posted here.
  • Credit: The amount of the credit note is posted in this field.
  • BankCode: The code of the associated bank account is stored here.
  • Ref1: An internal reference number for the booking can be stored in this field.
  • Ref2: Further information about the booking can be saved here.
  • ShortName: This field stores the name of the business partner associated with the booking.



This image has an empty alt attribute. The file name is BAnner-VFS2.gif