Adding Fields

You define the DataStore object by adding fields or InfoObjects.

Context

The advantage of using fields is that you do not need to model any InfoObjects. This is recommended especially if you want to load data types that are not supported by InfoObjects.

The following functions are not supported by fields:
  • Master Data
  • Alpha Conversion

Procedure

  1. Choose the Details tab.
  2. To add a field, choose Add Field. The field is added to your DataStore object. You can now define the field in the right area of the screen.
  3. Enter a description for the field.
  4. You can specify an InfoObject under Identify with:. This changes the field into an InfoObject. The properties of the InfoObject are applied. You can undo this by switching to Field under Identify with:.
  5. Enter the data type and data length. Certain types and lengths are not supported in the query. If you enter one of these, an error message appears. If they have a different format, they need to be assigned using an Open ODS view, in order to be displayed in the query.
  6. You can select an aggregation type under Aggregation.
  7. You can use fields to organize your InfoObjects. There are no semantic restrictions here. To do this, choose Add Group. You can change the technical name of the group and enter a description. You can move fields from one group to another using drag and drop.
  8. You can define keys. To do this, choose Key.... In the popup that now opens, select the relevant fields and choose Add to Keys. Once you have finished defining your keys, press OK. The keys are then displayed on the General tab page.
  9. To delete fields, choose Delete.