biuan SAP® BUSINESS ONE SDK
SQL Others / SEWDB
API SEWDB
SEWDB - SEWDB Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEAbsolute EntrynVarChar
8
PRIMARYYes
SmpTableIdSmp Table IDnVarChar
3
CollectDatDB Size Collect DatenVarChar
10
CompDbNameCompany DB NamenVarChar
100
DbPathDb PathnVarChar
127
PrevDbSizePrev Db SizenVarChar
32
DbSizeDb SizenVarChar
32
TranLogSizTransaction Log SizenVarChar
32
TranLogPatTransaction Log PathnVarChar
127
TotalDbSizTotal Db SizenVarChar
16
FreDskSpacFree Disk SpacenVarChar
16
MaxDbSizeMax Db SizenVarChar
16
MaxLogSizeMax Log SizenVarChar
16

SELECT statement

SELECT SEWDB.AbsEntry AS 'Absolute Entry', SEWDB.SmpTableId AS 'Smp Table ID', SEWDB.CollectDat AS 'DB Size Collect Date', SEWDB.CompDbName AS 'Company DB Name', SEWDB.DbPath AS 'Db Path', SEWDB.PrevDbSize AS 'Prev Db Size', SEWDB.DbSize AS 'Db Size', SEWDB.TranLogSiz AS 'Transaction Log Size', SEWDB.TranLogPat AS 'Transaction Log Path', SEWDB.TotalDbSiz AS 'Total Db Size', SEWDB.FreDskSpac AS 'Free Disk Space', SEWDB.MaxDbSize AS 'Max Db Size', SEWDB.MaxLogSize AS 'Max Log Size' FROM SEWDB AS SEWDB

Related information
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