Show TOC Start of Content Area

 Function documentationUpdate Methods  Locate the document in its SAP Library structure

Use

You use the calculation method to control whether and how a characteristic/key figure or a data field/key field should be updated in the data target.

Functions

There are several options:

·        Source InfoObject:  The field is filled directly from the selected source InfoObject of the communications structure.

If the system does not make any suggestions for a source InfoObject, you can assign a source InfoObject of the same type (amount, number, integer, quantity, float, time) or create a routine.

If you assign a source InfoObject of the same type, that has a different currency to the target InfoObject, then you must translate the source currency using a Currency Translation to the Target Currency.

For source-time characteristics: The system offers Automatic Time Conversion.

·        Constant: The field is not filled with the communication structure. It is filled directly with the specified value. 

·        Formula: The key figure/data field/attribute is updated with a value determined with a Formula.

·        Master Data Attribute of: The data field/attribute is updated by reading the master data table of an InfoObject that is included with a key and a value in the communication structure and contains the corresponding data field/attribute as an attribute. The attributes and their values are read from the key, these are then returned.

Example

In an InfoCube there is a characteristic (for example, FM area) that does not appear as a characteristic in the communication structure. In the communication structure, however, there is a characteristic (for example, cost center) that has the characteristic FM area as an attribute.

You can read the attribute FM area from the master data on demand, and thereby fill the characteristic FM area in the InfoCube.

Caution

It is not possible to read recursively, that is, to read additional attributes for the attribute To do this, you have to use routines.

Caution

If you have changed master data, you have to execute the change run. By reading the master data, the active version is read. If this is not available, an error occurs.

If the attribute is time-dependent, you also have to define when it should be read: at the current date (sy-datum), at the beginning or end of a period (defined with a time characteristic of the InfoSource), or at a constant date that you enter directly. sy-datum is used as a default.

·        Routine: The field is filled by an Update Routine that you have written.

The system provides you with a selection option which lets you decide whether the routine should be valid for all of the key figures /data field / attributes belonging to this characteristic or only for the key figure / data field / attribute displayed.

Update routines generally only have one return value. If you select return table, the corresponding key figure routine then no longer has a return value, but a return table. You can then generate as many key figures/data field values as you like from one data record.

Note

With ODS objects/InfoObjects: You cannot use the return code in the routine for data fields that are updated by being overwritten. If you do not want to update specific records, you can delete these from the start routine.

If you create different rules for different key figures/data fields for the same characteristic, a separate data record can be created from a data record of the InfoSource for each key figure.

For InfoCubes: If you choose a routine, you can then also choose the indicator routine with unit calculation. In the routine you then also get the return parameter ‘UNIT’. In this respect you can, for example, store the required unit of the key figure, such as ‘DEM’ or ‘ST’. You can use this option, for example, to calculate the unit KG present in the communication structure in tons in the InfoCube

If you fill the target key figure from an update routine for update rules, the currency translation has to be carried out using the update routine. This means that an automatic calculation is not available.

·        Initial value: The field is not filled. It remains empty.

 

 

End of Content Area