biuan SAP® BUSINESS ONE SDK
API MHKY
MHKY - MetaData Tables HKeys Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TableName KEY UNIQUETable NamenVarChar
5
PRIMARYYes
HKeyIndexHKey IndexInt
6
NameKey NamenVarChar
10
ViewOrderView OrderInt
6
UniqueKeyUnique KeyVarChar
Y) Yes
N) No
1
Y
AscendAscendingVarChar
Y) Yes
N) No
1
Y
UpdateDateUpdate DateDate
8
UpdateTimeUpdate TimeInt
11
0
UsrSgnAttrUser Sign For Attribs ChangeInt
11
-1
ResCodeResource Code from RSBDInt
11
-1
RevCodeRevision CodeInt
11
-1

SELECT statement

SELECT MHKY.TableName AS 'Table Name', MHKY.HKeyIndex AS 'HKey Index', MHKY.Name AS 'Key Name', MHKY.ViewOrder AS 'View Order', MHKY.UniqueKey AS 'Unique Key', MHKY.Ascend AS 'Ascending', MHKY.UpdateDate AS 'Update Date', MHKY.UpdateTime AS 'Update Time', MHKY.UsrSgnAttr AS 'User Sign For Attribs Change', MHKY.ResCode AS 'Resource Code from RSBD', MHKY.RevCode AS 'Revision Code' FROM MHKY AS MHKY

Related information




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