When calling "check database" a database update starts for automatic updating of new or changed columns or tables.
The file DB.INI gets processed. The commands from the DB.INI are interpreted by the program.
ATTENTION: Manual Database modification is not allowed!
These are possible commands for the DB.INI:
version=<versioninfo> |
current Version: 67xxxyy (xxx = versionnumber, yy=build) |
versiondatum=<versiondate> |
Date of the current version |
table=<tablename> |
checks a table |
udt=<tablename>=<Description>=<type> |
Create a SAP Table type: Noobject, Masterdata,masterdatalines,Document, documentlines,Noobjectautoincrement
Example udt=BEAS_TEST=Desc Table
To Add udf's to an udt you simply has to write table name (without @ symbol)
Don't use Prefix "beas" beas_color -> wrong mycompany_color -> correct |
udf=<tablename>=<columnname>=<description>=<type>=<type2>=<length> |
creates a SAP-Field type: Alpha,Float,Numeric,dec type2 at Float: Rate,sum,Price,quantity,percent,measure udf=OITM=beas_myField=This is my field=dec=quantity
Don't use Prefix "beas" beas_color -> wrong mycompany_color -> correct |
Column=<tablename>=<columnname>=<datetype>=<description> |
checks a column |
sapcolumn=<tablename>=<columnname>=<datetpye>=<description> |
checks a SAP |
sapcolumninfo=<description> |
Info to a SAP-column |
primary=<tablename>=<columname> |
sets a primary key for a column primary=beas_mrp_planung=id |
default=<tablename>=<columnname>=<value> |
sets a default value for a column |
droptable=<tablename>=true/false=<columname> |
drops a table : |
delcolumn=<tablename>=<columname>=<datetpye>=<description> |
deletes a column |
abgleich=<sql-command> |
Processes the specified SQL-command if there is a name for "abgleich" (matching) |
abgleichname=<description> |
enables a matching abgleichname=pk_typen |
meldung=<description> |
outputs a message |
prozent=<value> |
displays progress in percent |
script=<Scriptname> |
Calls and interprets a file with a BEAS-Script |