Each Table Member Names must be unique.
beas-Tables must begin with "beas_"
The Name of the Data Table must be written with lowercase. --> "beas_mytablename"
If this is not a beas extension than you must ensure that you have a valid unique abbreviation.
For that special occasion you can reserve a namespace in SAP or you are using "beas_" with an abbreviation after that. ( e.g. the Customer Name )
e.g. Name Customer = "Mustermann"
Name Table like -> beasmst_xxxxx
You have to have a Folder under the Beas installation if it is a Customer extension...
e.g.. c:\program files\beas software\beas\project\mustermann
inside beas under "extra / system / option / customer-specific Extensions / Directory Customized Windows" you need to insert this new Folder... "mustermann" will be enough.
This folder will maintain all the files related to this customer.
If you have to change anything inside the database than you need to create, change the db.ini file.
!!!! This db.ini file will also be under the customer's folder !!!!!
When the database inspection will be run inside BEAS than this db.ini will be called.
It can also be called separately from the menu "Extra / options / common" [ Orange Arrow before the Folder Name ]
Generate this file:
extra / system / option / customer-specific Extensions / Databaseextenstion Edit
Table definition
table=<tablename>
primary=<tablename>=Primary Key
column=<tablename>=<columnname>=definition
Remark:
Changes will be directly executed when the db.ini is loaded.
Create the db.ini in the new folder for the Customer "Mustermann".
Table Script:
table=beasmst_color
primary=beasmst_color=color_id
column=beasmst_color=color_id=nchar(20) not null
column=beasmst_color=description=nvarchar(100)
column=beasmst_color=tstamp
Valid Data types:
nchar() |
nvarchar() |
ntext() |
decimal(19,6) |
int |
datetime |
tstamp |
Remarks:
With decimal ONLY accuracy is permitted of (19,6)
Each Column should be separated by "_" to improve identification.
e.g. color_id, user_id, user_phone, user_name ...
Column names have to be lowercase.
If you are done with the db.in start BEAS.
Go to Menu "extra / options / common" and click the orange Arrow... This will start the scan of the db.ini and it will run our commands.
The Column tstamp is an assemblage of 4 Column. That means if you use a column with the data type tstamp than the generator will generate the following columns.
erftstamp -> datetime
erfuser -> originator
andtstamp -> change datetime
anduser -> user who changed the value
These Columns need to be in every Form but the will be invisible.
be.as will take care about the administration of these columns.