biuan SAP® BUSINESS ONE SDK
API ABAT
ABAT - Attribute - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
FldAbsBin Field Conf. Internal NumberInt
11OBFC
Bin Field Configuration
AttrValueCodenVarChar
20
DataSourceData SourceVarChar
1
N
UserSignUser SignatureInt
6OUSR
Users
TransferedYear Transfer [Y/N]VarChar
1
N
InstanceInstanceInt
6
0
LogInstancLog InstanceInt
11
0
CreateDateCreate DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8
DeletedDeletedVarChar
1
N

Table relationship map

SELECT statement

SELECT ABAT.AbsEntry AS 'Internal Number', ABAT.FldAbs AS 'Bin Field Conf. Internal Number', ABAT.AttrValue AS 'Code', ABAT.DataSource AS 'Data Source', ABAT.UserSign AS 'User Signature', ABAT.Transfered AS 'Year Transfer [Y/N]', ABAT.Instance AS 'Instance', ABAT.LogInstanc AS 'Log Instance', ABAT.CreateDate AS 'Create Date', ABAT.UserSign2 AS 'Updating User', ABAT.UpdateDate AS 'Date of Update', ABAT.Deleted AS 'Deleted' FROM ABAT AS ABAT

Related information


Bin Field Configuration OBFC SQL Table

Users OUSR 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