Create a table

Use the dbdict utility to create a new table. In this example you will create a table named EXWorkOrder. Before you can create this table, you need to know what fields are needed and the attributes of the fields.In this example, the table stores the data for work orders associated with incidents.

To create a table, follow these steps:

1. From the System Navigator, click Tailoring > Database Dictionary to open the Database Dictionary.
2. Type EXWorkOrder in the File Name field.
3. Click New.

4. On the Fields tab, enter the following information after clicking NewField/Key.

   Field	Description
   ID	Will be filled from the number file. Type: character
   RelatedID	Will be filled by the unique ID of the related record. For example: incident number. Type: character
   status	Used to store the status of the work order. Type: character
   initiator	The operator who opened the work order. Type: character
   assignee.name	The operator assigned to the work order. Type: character
   description	Used to hold the description of the work to do for the work order. Type:array of character
   category	Filled from the category of the related record. Type: character
   RelatedCIs	Used for the list of Configuration Items (CIs) associated with the work order. Type: array of character
   impact	Type: character
   urgency	Type: character
   priority	Type: character
   closure.code	Type: character
   deadline	Date by which the work order must be completed and filled on open. Type: date/time
   est.finish	The assignee's estimate for completion. Type: date/time
   update.action	Type: array of character
   closure.comments	Type: array of character

5. After you have added the fields to the table you need to add keys to the table. You should not exit Database Dictionary utility until you have done this for the EXWorkOrder table. See Add key fields to table for the detailed information.