OUKD - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Administration /

User Key Description

API OUKD / User Keys MD

OUKD - User Key Description Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
TableName ^KEY ^UNIQUE	Table Name	nVarChar		20		PRIMARY	Yes
KeyId	Key Index	Int		6
KeyName	Key Name	nVarChar		10
UniqueKey	Unique Key	VarChar	Y) Yes N) No	1	N
Action	Action	VarChar	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

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...

biuan SAP® BUSINESS ONE

Object
UserKeysMD

Method

Add

GetAsXML

GetByKey

Remove

SaveToFile

SaveXML

Object

UserKeysMD_Elements UKD1

Property

Browser

Elements

KeyIndex

KeyName

TableName

Unique

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