Skip to Content
Technical Articles
Author's profile photo Jakub Djablik

Calculations in DMEEX

 

With the SAP S/4HANA 1809 release, DMEEX came with a new Calculation Functionality. It is now available across all SAP S/4HANA OnPremise releases for DMEEX and it provides you the possibility to perform simple mathematical operations.

This would become handy for example if you need items numbered in the output file.

Calculations are done by variables, calculations node, and the possibility of variable mapping in the nodes.

Variables

Variables are defined in the header of the format mapping. There is a new tab called Variables.

You can define required variables which will be used later in the calculation nodes or nodes where they can be mapped.

You have to specify

  • Name of the variable
  • Data type
  • Initial value

Name of the variable

Name of the variable can contain all letters except space. Variables are case insensitive.

Data type

Currently, the only supported data type is Number which represents whole numbers. The result of the calculations is a whole number.

Variable initial value

For data type Number, you must set value from a set of whole numbers.

Calculation nodes

Calculation nodes groups mathematical operations which are perfo rmed on variables. The current solution supports mathematical operation with one or two parameters. There are several predefined operations which might be used.

Parameters

An important part of the operation is parameters. There is a possibility of selection of four source types of parameters.

Source type Description
Constant The user can insert numeric constant as a parameter
Structure field

User can choose the field from available structures in DMEEX such as:

–        Structures assigned for tree type

–        Tree-dependent structures

–        System structure

Reference node User can access to node value through node reference
Variable User can choose other variable defined in the header as a part of the formula

 

The left side of a formula is always variable which is updated and can be reused later within the tree.

Operation

Operation is a tool which can modify the variable value in a certain way.

Operation Description
ABS Returns absolute value of a variable
/ Returns result of division of two parameters
Returns result of subtraction of two parameters
MOD Finds the remainder after division of two parameters
* Returns result of multiplying of two parameters
+ Returns result of addition of two parameters

Variable mapping

There is a new option for variable mapping.

You can access variable value during the whole execution of the tree. You can select only from variables defined in the header of the tree. List of variables is available through match code on source screen.

Variables in conditions

You can also use variables in the conditions of the nodes. Similarly, as variable mapping, you can select variable on one side of a condition and compare it to the variable or other value (constant, structure or reference node).

To get more information about the 1809 release of DMEEX, click here.

 

Learn more about DMEEX.

Read more about Payment Formats and tools associated with them here.

 

Will the calculation functionality be useful in your workflow? Please, let us know in the comment section below.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.