Show TOC

Creating Field Catalogs (More than One Source Table)Locate this document in the navigation structure

Prerequisites

  • You have created a field catalog with at least one field.

  • You are at the field selection for the field catalog.

Context

You can add additional source fields to field catalogs. This means:

  • For key fields, the system establishes field similarities between the join conditions of the different source tables.

  • The system can fill data fields with data from different source tables in an archive information structure.

Note the following special features:

  • For each source table, there must be a unique combination of fields in the key of the information structure. This means that there can never be two data records with the same value combination within one data object.

  • For each key field, the system establishes the field similarity between the reference field and the additional source fields.

  • The system fills the information structure with archive data using an outer join based on the field combination. The system writes a record for the data object if at least one of the source tables contains data.

  • When the system is filling an information structure, an incorrectly defined field catalog can cause a program termination. Read the long text in the error message Q6234. Here you can also find a detailed example of how to create field catalogs.

  • The source field entered directly in the field selection is also the reference field. The data type of the relevant field in the information structure is derived from this reference field. The fields entered in Additional Source Fields must be compatible reference field type.

Procedure


  1. Choose the field to which you want to add source fields.

  2. In the navigation frame, choose the Additional Source Fields node.

  3. Choose New Entries and enter the source table and the source field that are to be joined with the target field.

  4. Save your entries.

Results

There is now a logical link (join) for key fields between the target field and the additional source field. When the system fills the information structure, it moves the contents of the source fields assigned to the target field to the data fields.