biuan SAP® BUSINESS ONE SDK
DTW User Fields - Values Definitions
API User Fields MD / Valid Values MD
UFD1 - User Fields - Values Definitions Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TableID KEY UNIQUETablenVarChar
20
PRIMARYYes
FieldIDFieldInt
6
IndexIDIndexInt
6
FldValueValuenVarChar
127
DescrDescriptionnVarChar
127
FldDateDate ValueDate
8

SELECT statement

SELECT UFD1.TableID AS 'Table', UFD1.FieldID AS 'Field', UFD1.IndexID AS 'Index', UFD1.FldValue AS 'Value', UFD1.Descr AS 'Description', UFD1.FldDate AS 'Date Value' FROM UFD1 AS UFD1

Related information


Valid Values MD ValidValuesMD Object· Table: UFD1
ValidValuesMD enables you to add valid values to a specified user defined field (UserFieldsMD). Source table: UFD1.
   Parent: User Fields MD UserFieldsMD Object· Table: CUFD


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