biuan SAP® BUSINESS ONE SDK
API ABT1
ABT1 - Internal Bank Operation Codes - Accounts - Log Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
0PRIMARYYes
LineIdRowInt
6
GLActG/L AccountnVarChar
15OACT
G/L Accounts
ProjectProjectnVarChar
20OPRJ
Project Codes
PrftCenterDistribution RulenVarChar
8OOCR
Distribution Rule
VatCodeVAT CodenVarChar
8OVTG
Tax Definition
LogInstancLog InstanceInt
11
0
PrftCent2Distribution Rule2nVarChar
8OOCR
Distribution Rule
PrftCent3Distribution Rule3nVarChar
8OOCR
Distribution Rule
PrftCent4Distribution Rule4nVarChar
8OOCR
Distribution Rule
PrftCent5Distribution Rule5nVarChar
8OOCR
Distribution Rule

Table relationship map

SELECT statement

SELECT ABT1.AbsEntry AS 'Internal Number', ABT1.LineId AS 'Row', ABT1.GLAct AS 'G/L Account', ABT1.Project AS 'Project', ABT1.PrftCenter AS 'Distribution Rule', ABT1.VatCode AS 'VAT Code', ABT1.LogInstanc AS 'Log Instance', ABT1.PrftCent2 AS 'Distribution Rule2', ABT1.PrftCent3 AS 'Distribution Rule3', ABT1.PrftCent4 AS 'Distribution Rule4', ABT1.PrftCent5 AS 'Distribution Rule5' FROM ABT1 AS ABT1

Related information


G/L Accounts OACT SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ SQL Table

Tax Definition OVTG SQL Table



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