biuan SAP® BUSINESS ONE SDK
SQL Others / Company Configuration
API CCFG
CCFG - Company Configuration Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ConfigEntr KEY UNIQUEInternal Configuration IDInt
11
PRIMARYYes
ConfigNameConfiguration File NamenVarChar
127
ConfigDateConfiguration File Create DateDate
8
ConfigTimeConfiguration File Create TimeInt
6
UserCodeConfiguration Created ByInt
11
CreateByCreated from Menu:Int
0
1) Configuration Management
11
ServerNameConfiguration Saved on Server:nVarChar
127
CompanyDBCompany DatabasenVarChar
127
InternalInternalVarChar
N) No
Y) Yes
1
N

SELECT statement

SELECT CCFG.ConfigEntr AS 'Internal Configuration ID', CCFG.ConfigName AS 'Configuration File Name', CCFG.ConfigDate AS 'Configuration File Create Date', CCFG.ConfigTime AS 'Configuration File Create Time', CCFG.UserCode AS 'Configuration Created By', CCFG.CreateBy AS 'Created from Menu:', CCFG.ServerName AS 'Configuration Saved on Server:', CCFG.CompanyDB AS 'Company Database', CCFG.Internal AS 'Internal' FROM CCFG AS CCFG

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