biuan SAP® BUSINESS ONE SDK
API ABFC
ABFC - Bin Field Configuration - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
FldTypeField TypeVarChar
S) Warehouse Sublevel
A) Bin Location Attribute
1
FldNumField NumberInt
6
DispNameDisplay NamenVarChar
20
ActivatedActive [Y/N]VarChar
Y) Yes
N) No
1
N
UserSignUser SignatureInt
6OUSR
Users
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
TransferedYear Transfer [Y/N]VarChar
1
N
InstanceInstanceInt
6
0
LogInstancLog InstanceInt
11
0
CreateDateCreation DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8
DftNameDefault Field NamenVarChar
20

SELECT statement

SELECT ABFC.AbsEntry AS 'Internal Number', ABFC.FldType AS 'Field Type', ABFC.FldNum AS 'Field Number', ABFC.DispName AS 'Display Name', ABFC.Activated AS 'Active [Y/N]', ABFC.UserSign AS 'User Signature', ABFC.DataSource AS 'Data Source', ABFC.Transfered AS 'Year Transfer [Y/N]', ABFC.Instance AS 'Instance', ABFC.LogInstanc AS 'Log Instance', ABFC.CreateDate AS 'Creation Date', ABFC.UserSign2 AS 'Updating User', ABFC.UpdateDate AS 'Date of Update', ABFC.DftName AS 'Default Field Name' FROM ABFC AS ABFC

Related information


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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates