biuan SAP® BUSINESS ONE SDK
SQL Administration / User Tables
API OUTB / / User Tables MD
OUTB - User Tables Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TableName KEY UNIQUETable NamenVarChar
19
PRIMARYYes
DescrDescriptionnVarChar
30
TblNumTable numberInt
11
ObjectTypeObject TypenVarChar
0
1) Master Data
2) Master Data Rows
3) Document
4) Document Rows
20
0
UsedInObjUsed in ObjectnVarChar
20
LogTableLog TablenVarChar
19
ArchivableArchivableVarChar
Y) Yes
N) No
1
N
ArchivDateArchive DatenVarChar
18

SELECT statement

SELECT OUTB.TableName AS 'Table Name', OUTB.Descr AS 'Description', OUTB.TblNum AS 'Table number', OUTB.ObjectType AS 'Object Type', OUTB.UsedInObj AS 'Used in Object', OUTB.LogTable AS 'Log Table', OUTB.Archivable AS 'Archivable', OUTB.ArchivDate AS 'Archive Date' FROM OUTB AS OUTB

Related information


User Tables MD UserTablesMD Object· Table: OUTB
The UserTablesMD object enables to manage user defined tables as follows: Add a user table. Retrieve a user table from the database by its TableName. Remove a user table. Save the object in XML format. Source table:...

OUTB 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