biuan SAP® BUSINESS ONE SDK
API MDKY
MDKY - MetaData Tables DKeys Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TableName KEY UNIQUETable NamenVarChar
5
PRIMARYYes
HKeyIndexHKey IndexInt
6
DKeyIndexDKey IndexInt
6
FieldNameField in KeynVarChar
20
UpperUpperVarChar
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 MDKY.TableName AS 'Table Name', MDKY.HKeyIndex AS 'HKey Index', MDKY.DKeyIndex AS 'DKey Index', MDKY.FieldName AS 'Field in Key', MDKY.Upper AS 'Upper', MDKY.UpdateDate AS 'Update Date', MDKY.UpdateTime AS 'Update Time', MDKY.UsrSgnAttr AS 'User Sign For Attribs Change', MDKY.ResCode AS 'Resource Code from RSBD', MDKY.RevCode AS 'Revision Code' FROM MDKY AS MDKY

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