Database Design

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

 

 

Structure of db.ini

 

Table definition

table=<tablename>

primary=<tablename>=Primary Key

column=<tablename>=<columnname>=definition

 

Remark:

Changes will be directly executed when the db.ini is loaded.

 

Sample: Color Table [ Color and Color Description ]

 

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

 

help-achtung

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.

 

Column tstamp:

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.