Create Field Catalogs (One Source Table) (SAP Library

Create Field Catalogs (One Source Table)

In the Archive Retrieval Configurator (ARC) initial screen choose Environment ® Field Catalogs and then New Entries.

Enter the name of the field catalog (it must not begin with SAP), a description, and the archiving object for which the field catalog is intended.

In the fields File in Index and Offset in Index, you can specify how the name of the archiving file and the offset of the data object are included in the information structure.

You can use the following values for the file names:

'D' - Includes the file name as a data field. This is the minimum value. It causes the archive file name to be entered in the data area of the structure table.
'K' - Includes the file name as a key field. Choose this value if the entries in the structure table would otherwise not be unique.

You can use the following values for the offset:

'D' - Includes the name of the Offset as a data field. This value is sufficient for a direct access to archived data.
'K' - Includes the name of the Offset as a key field. Choose this value if the entries in the table would otherwise not be unique.
' ' - (No value) The Offset will not be included in the structure table. Choose this setting if you do not want direct access. This allows you to reduce the size of the structure table.

If you include the Offset as a key field, you must also include the archive file as a key field, otherwise a clear distinction between archived objects by the Offset cannot be guaranteed.

If an archived object, such as a sales document, has already been clearly identified by the document number in the field catalog key, then you do not need to include the Offset in the key.

To carry out the field assignment, first select the catalog and then the Field Selection function in the navigation area. Choose New Entries and enter the required data.

The use of additional fields from other source tables requires a logical link between these fields by means of a Join. Read the relevant Notes.

You can choose the field number and target field. The name of the target field appears in the generated table and this name should have a meaning related to the reporting. The field number describes its position in the information structure and serves as a sort criteria.
The source field must correspond with the actual field name from the source table.
The source field entered directly in the field selection is also the reference field. The data type of the corresponding field in the information structure is derived from this reference field.
The source table must be a table for which the archiving object in the information structure writes data to the archive. These tables are maintained in the transaction AOBJ for the archiving objects.
If you mark a field Key, that field is included in the key to the structure table. A table's key fields must come at the beginning, that is, the field numbers of the key fields must be smaller than the field numbers of the data fields. Furthermore, the key fields must be connected, that is, no non-key fields are allowed to come between key fields.
The checkbox mandatory key field is only valid for key fields. If you mark this checkbox, the data record will only be included if the relevant field in the source table is not empty.

Tables that are processed by archiving classes can also be used as source tables. However, here, you must create a normalized read function module for each archiving class used.

Save your entries.