Formula (Enhanced)

Planning function type Formel provides you with a simple programming language for manipulating transaction data in BW Integrated Planning.

The following enhancements have been made:

Data Declaration

In addition to the existing variable types I (Integer) for index operations, F (Floating Decimal) for calculations and variable characteristic type variables, the new variable D (Date) has now been introduced for data calculations and STRING.

You can use any InfoObject of your choice for data definition, even if this InfoObject does not belong to the aggregation level.

Sample Code

DATA COSTCTR TYPE 0COSTCENTER

This is possible even though 0COSTCENTER in this example does not have any relation to the aggregation level.
Internal Tables

You can define and use internal tables.

Sample Code

TABLE INTTAB { YEAR TYPE 0CALYEAR KEY, ZAHL TYPE F, COSTCENTER TYPE 0COSTCENTER }.
Accessing InfoProviders

In BW Integrated Planning, additional data can be read from any aggregation levels. This is declared using the InfoProvider statement.

Sample Code

INFOPROVIDER DSO_REF