How to Create a Table?

Homepage » How To » How to Create a Table?

By neel May 23rd, 2008

Most of the objects in Siebel can be created in two ways.

Wizard
Manually

Wizard gives you step by step procedure to create an object and creates the required records according to the options you choose. This is a pretty convenient way of creating objects and there are less chances of missing something which can result in errors. This is probably the best option for beginners in Siebel. Some of things that require use of wizard are Integration Object, Web Service, and Business Component etc.

Manually creating things manually help you understand the basics of the object which helps you in case if you need to make just minor modifications. So, it is a good idea to actually create everything manually at least once.

But unlike other objects tables can only be created with the help of wizard. You cannot create a table by doing a new record and it is quite rare that you might need to create a new table altogether. I recently had a chance to do it so thought of sharing the procedure with all. Here is a step by step procedure of creating a Table in Siebel Tools

Open Siebel tools
Click File > New Object and Select Table in the new window that is opened (Shown in the screenshot below)
Enter the name of the table you want to create such as CX_TEST_TABLE
Choose the project for the newly created table.
Click on OK
Click on finish in the next window and you are done

A new table will be created with the system columns like CONFLICT _ID, CREATED, CREATED_BY etc.

You can add new columns of you choice. Then you need to Apply and activate the table.

Your table is almost ready to use. I said almost because you can create a Business Components based on this table and use them in way you want. But before you can use this table for a join in some other BC you need to compile it.

If you try to use this table in a join specification without compiling it you will get an error that Definition of your table cannot be found. So it is a good idea to Apply, Activate and Compile at same time.