Show TOC

Transformation Library and Formula BuilderLocate this document in the navigation structure

Use

The transaction for editing transformation rules and update rules offers a transformation library. You can use this when working with the formula builder.

Caution

When working with VirtualProviders, do not use formulas, as no inversion is possible for this. Use routines in this case.

Features

Using the transformation library together with the formula builder enables you to create formulas without the need for ABAP coding.

The transformation library has over 70 pre-defined functions, in the following categories:

  • Functions for Character Strings

  • Date Functions

  • Basic Functions

  • Mathematical Functions

  • Suitable Functions

  • Other Functions

n the dialog box for selecting an update method, you can call the transformation library to get a list of possible functions with a description of their syntax.

Note A type check is not performed for formula. This means the system does not check if the formula result matches the type of the target field.

You can also implement self-defined functions in the transformation library in the formula builder. You can integrate existing function modules in these self-defined functions. You can thus make functions that are not currently contained in the transformation library available for frequent use. More information: BAdI: Customer-Defined Functions in the Formula Builder.

The formula builder has two modes: Standard and expert mode. In standard mode, you can only enter formulas using the pushbuttons and by double-clicking on functions and fields. In expert mode, you can enter formulas directly. You can also toggle between the two modes when entering a formula.

For more detailed information about the formula builder, press Information in the formula builder.

You can find a step-by-step guide using an example under Example for Using the Formula Builder.