biuan SAP® BUSINESS ONE SDK
SQL Administration / 312 / Choose from List Format
DTW Administration / Setup / Banking / Choose from List Format
API Choose From List / Choose From List Lines
CHFL - Choose from List Format Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ObjName KEY UNIQUEObject NamenVarChar
20
PRIMARYYes
FldIndexField IndexInt
6
FldNumField No.nVarChar
20
DispNameDisplayed NamenVarChar
30
GroupByGroup ByVarChar
Y) Yes
N) No
1
N
VisibleVisibleVarChar
Y) Yes
N) No
1
N
DispDescShow TypeVarChar
Y) Yes
N) No
1
Y
SortOrderSort OrderVarChar
A) Ascending
D) Descending
1
A
VisIndexVisual IndexInt
6
0

SELECT statement

SELECT CHFL.ObjName AS 'Object Name', CHFL.FldIndex AS 'Field Index', CHFL.FldNum AS 'Field No.', CHFL.DispName AS 'Displayed Name', CHFL.GroupBy AS 'Group By', CHFL.Visible AS 'Visible', CHFL.DispDesc AS 'Show Type', CHFL.SortOrder AS 'Sort Order', CHFL.VisIndex AS 'Visual Index' FROM CHFL AS CHFL

Related information


Choose From List Lines ChooseFromList_Lines Object· Table: CHFL
ChooseFromList_Lines is a child object of ChooseFromList. Source table: CHFL.
   Parent: Choose From List ChooseFromList Object· Table: OCHF


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