biuan SAP® BUSINESS ONE SDK
SQL Administration / User Key Description
API OUKD / User Keys MD
OUKD - User Key Description Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TableName KEY UNIQUETable NamenVarChar
20
PRIMARYYes
KeyIdKey IndexInt
6
KeyNameKey NamenVarChar
10
UniqueKeyUnique KeyVarChar
Y) Yes
N) No
1
N
ActionActionVarChar
A) Add
U) Update
D) Delete
N) None
1
N

SELECT statement

SELECT OUKD.TableName AS 'Table Name', OUKD.KeyId AS 'Key Index', OUKD.KeyName AS 'Key Name', OUKD.UniqueKey AS 'Unique Key', OUKD.Action AS 'Action' FROM OUKD AS OUKD

Related information


User Keys MD UserKeysMD Object· Table: OUKD
The UserKeysMD object enables to mange user defined keys of user tables. A user table contains a default primary key that consists of the Code and Name columns. Use the UserKeysMD object to add secondary keys to user tables. This object enables...
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