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.