biuan SAP® BUSINESS ONE SDK
API AHF1
AHF1 - Hide Functions Configuration - Rows History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
FuncIDFunction IDInt
11OHFC
Hide Functions Configuration
formNumForm NumbernVarChar
127
ItemUIDItem UIDnVarChar
127
ColUIDColumn UIDnVarChar
127
HideValHide Valid ValuenVarChar
20
AltValAlternative Valid ValuenVarChar
20
PanelIDHide Item by PanelInt
6
ActionTypeHide Item Action TypeInt
0
1) Hide Column
2) Hide Item's Valid Value
3) Hide Panel
4) Hide Column's Valid Value
6
0
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
Y) Yes
N) No
1
N
InstanceInstanceInt
6
0
LogInstancLog InstanceInt
11
0
CreateDateCreation DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8

Table relationship map

SELECT statement

SELECT AHF1.AbsEntry AS 'Internal Number', AHF1.FuncID AS 'Function ID', AHF1.formNum AS 'Form Number', AHF1.ItemUID AS 'Item UID', AHF1.ColUID AS 'Column UID', AHF1.HideVal AS 'Hide Valid Value', AHF1.AltVal AS 'Alternative Valid Value', AHF1.PanelID AS 'Hide Item by Panel', AHF1.ActionType AS 'Hide Item Action Type', AHF1.UserSign AS 'User Signature', AHF1.DataSource AS 'Data Source', AHF1.Transfered AS 'Year Transfer [Y/N]', AHF1.Instance AS 'Instance', AHF1.LogInstanc AS 'Log Instance', AHF1.CreateDate AS 'Creation Date', AHF1.UserSign2 AS 'Updating User', AHF1.UpdateDate AS 'Date of Update' FROM AHF1 AS AHF1

Related information


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