biuan SAP® BUSINESS ONE SDK
SQL Administration / Short Cut
API USR1
USR1 - Short Cut Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
STATUSStatusVarChar
1
USERLINK KEY UNIQUEUser LinkInt
6OUSR
Users		PRIMARYYes
MODIF01ModifiersnVarChar
2
MODIF02ModifiersnVarChar
2
MODIF03ModifiersnVarChar
2
MODIF04ModifiersnVarChar
2
MODIF05ModifiersnVarChar
2
MODIF06ModifiersnVarChar
2
MODIF07ModifiersnVarChar
2
MODIF08ModifiersnVarChar
2
MODIF09ModifiersnVarChar
2
MODIF10ModifiersnVarChar
2
MODIF11ModifiersnVarChar
2
MODIF12ModifiersnVarChar
2
MODIF13ModifiersnVarChar
2
ATOMID01Autom. IDInt
11
ATOMID02Autom. IDInt
11
ATOMID03Autom. IDInt
11
ATOMID04Autom. IDInt
11
ATOMID05Autom. IDInt
11
ATOMID06Autom. IDInt
11
ATOMID07Autom. IDInt
11
ATOMID08Autom. IDInt
11
ATOMID09Autom. IDInt
11
ATOMID10Autom. IDInt
11
ATOMID11Autom. IDInt
11
ATOMID12Autom. IDInt
11
ATOMID13Autom. IDInt
11
STRID01String IDInt
11
STRID02String IDInt
11
STRID03String IDInt
11
STRID04String IDInt
11
STRID05String IDInt
11
STRID06String IDInt
11
STRID07String IDInt
11
STRID08String IDInt
11
STRID09String IDInt
11
STRID10String IDInt
11
STRID11String IDInt
11
STRID12String IDInt
11
STRID13String IDInt
11
RESERVEDRESERVEDnVarChar
16
FILLERFillernVarChar
16

SELECT statement

SELECT USR1.STATUS AS 'Status', USR1.USERLINK AS 'User Link', USR1.MODIF01 AS 'Modifiers', USR1.MODIF02 AS 'Modifiers', USR1.MODIF03 AS 'Modifiers', USR1.MODIF04 AS 'Modifiers', USR1.MODIF05 AS 'Modifiers', USR1.MODIF06 AS 'Modifiers', USR1.MODIF07 AS 'Modifiers', USR1.MODIF08 AS 'Modifiers', USR1.MODIF09 AS 'Modifiers', USR1.MODIF10 AS 'Modifiers', USR1.MODIF11 AS 'Modifiers', USR1.MODIF12 AS 'Modifiers', USR1.MODIF13 AS 'Modifiers', USR1.ATOMID01 AS 'Autom. ID', USR1.ATOMID02 AS 'Autom. ID', USR1.ATOMID03 AS 'Autom. ID', USR1.ATOMID04 AS 'Autom. ID', USR1.ATOMID05 AS 'Autom. ID', USR1.ATOMID06 AS 'Autom. ID', USR1.ATOMID07 AS 'Autom. ID', USR1.ATOMID08 AS 'Autom. ID', USR1.ATOMID09 AS 'Autom. ID', USR1.ATOMID10 AS 'Autom. ID', USR1.ATOMID11 AS 'Autom. ID', USR1.ATOMID12 AS 'Autom. ID', USR1.ATOMID13 AS 'Autom. ID', USR1.STRID01 AS 'String ID', USR1.STRID02 AS 'String ID', USR1.STRID03 AS 'String ID', USR1.STRID04 AS 'String ID', USR1.STRID05 AS 'String ID', USR1.STRID06 AS 'String ID', USR1.STRID07 AS 'String ID', USR1.STRID08 AS 'String ID', USR1.STRID09 AS 'String ID', USR1.STRID10 AS 'String ID', USR1.STRID11 AS 'String ID', USR1.STRID12 AS 'String ID', USR1.STRID13 AS 'String ID', USR1.RESERVED AS 'RESERVED', USR1.FILLER AS 'Filler' FROM USR1 AS USR1

Related information


Users OUSR SQL Table
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