Additional Information for InfoSets

The logical databases provide you with a large number of fields. An InfoSet not only lets you reduce or groups fields into useful units, but it also lets you enlarge the pool of available fields to obtain additional information.

Additional tables

Using additional tables you can link DDIC tables to the logical database. However, this is only possible if you can link using foreign keys.

If you require characteristics from the central master data table BUT000 in addition to the business partner attributes provided in the FTI_TR_POSITIONS logical database, you can use the common key "partner number" (PARTNR) and a table join to link the logical database to the table. All the fields in table BUT000 are then available for evaluation purposes.

Additional structures

Additional fields

If you require individual fields in a table, you should consider system performance by defining additional fields individually and then make field entries using a separate selection logic. You will require additional fields if you want to output information that is calculated on the basis of original logical database fields.

The InfoSet CFM_POSITION was created on the basis of the FTI_LDB_TR_POSITIONS logical database. The InfoSet has been enlarged by the following six additional fields that can be calculated on the basis of existing key figures (fields).

Hidden reserve

Write-down requirement

Pending gains

Pending losses

Security valuation, affecting profit/loss

FX valuation, affecting profit/loss

Market value in local currency

This information can be useful for various query evaluations.