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

SQL Administration / User Key Description / User Sub-Keys Description

DTW User Sub-Keys Description

API User Keys MD / User Keys MD Elements

SBO SQL database table details

Field	Description	Type	Size	Primary_Key	Unique
TableName ^KEY	Table Name	nVarChar	20	ALIAS	No
KeyId	Key Index	Int	6
SubKeyId	Sub-Key Index	Int	6
ColAlias	Column Alias	nVarChar	18

SELECT statement

SELECT
   UKD1.TableName AS 'Table Name', 
   UKD1.KeyId AS 'Key Index', 
   UKD1.SubKeyId AS 'Sub-Key Index', 
   UKD1.ColAlias AS 'Column Alias'
FROM UKD1 AS UKD1

Related information

UserKeysMD_Elements Object· Table: UKD1

UserKeysMD_Elements is a child object of the UserKeysMD object. UserKeysMD_Elements defines the fields that combine the key index. Source table: UKD1.

Parent: User Keys MD UserKeysMD Object· Table: OUKD

biuan SAP® BUSINESS ONE

Object
UserKeysMD

Object
UserKeysMD_Elements

Method

Add

SetCurrentLine

Property

ColumnAlias

Count

SubKeyIndex

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