CRM – Text Editor

If you create a letter or a selection expression, you can use the Text Editor to specify the actual layout of the letter or to specify an expression.

Note

You can specify letters in the Letters (tdsmi1150m000) session.
You can specify selection expression in the Selections (tdsmi0170m000) session

Using the text editor

The layout of a letter or a selection expression can be very simple or quite complex. It can contain the following data:

Normal text
For example, "We are excited...". You can use special characters like ö or é but it is not possible to use print effects such as bold, underscore, and different fonts.
Table fields
You can use all table fields recorded in the Tables to be Displayed in Relation Management (tdsmi0182m000) session, such as tccom100.nama (the business partner's name).
Attributes
You can use all attributes recorded in the Attributes (tdsmi0550m000) session. For more information, refer to CRM – attributes in the Text Editor.
Predefined variables
For example, @today (gives current date). For more information, refer to CRM – predefined variables in the Text Editor.

It is recommended that you zoom and select table fields and attributes rather than entering them, because you are less likely to make mistakes by selecting them. On the Options menu of the Text Editor, click Start Zoomsession to retrieve the required table fields or attributes.

Note

Any text that you type after the pipe ( | ) symbol is not used as programming code, but is merely used as additional information for the user.

Operators in the Text Editor

You can use arithmetic, logical, or relational operators in the Text Editor.

Arithmetic operators
*	multiplication
/	division
+	addition
-	subtraction
¥	remainder after division
&	linking strings (alphanumerical arrays)

Logical operators
or
and
not (negation)

Relational operators
=	equal to
<>	unequal to
>	greater than
<	less than
>=	greater than or equal to
<=	less than or equal to

Functions in the Text Editor

You can use the following functions in the Text Editor:

Arithmetic
Trigonometric
Logarithmic
String
Date

Arithmetic functions		Example
round (X,Y,Z)	produces rounded value of X Y is number of decimals Z is rounding method (0 = down, 1 = normal, 2 = up)	-
val (A)	produces numeric value of string A	val ("8.7") = 8.7
abs (X)	calculates absolute value of X	abs (-10.3) = 10.3
int (X)	produces integer value of X	int (11.6) = 11
pow (X, Y)	raises X to the power of Y	pow (10.2) = 100
sqrt (X)	produces square root of X	sqrt (16) = 4
min (X, Y)	produces smallest value of X and Y	min (6, 10) = 6
max (X, Y)	produces largest value of X and Y	max (6, 10) = 10
pi	constant with value pi (3.1415926)	-

Trigonometric functions
sin (X), cos (X), tan (X)	produces sine, cosine, or tangent of X
asin (X), acos (X), atan (X)	produces arc sine, cosine, or tangent of X
hsin (X), hcos (X), htan (X)	produces hyperbolic sine, cosine, or tangent of X

Logarithmic functions
exp (X)	raises e to the power of X
log (X)	produces natural logarithm of X on the basis of e
log10 (X)	produces logarithmic value of X on the basis of powers of 10

String functions		Example
edit (X,Y)	formats numeric value X according to format Y	edit (10.3, "ZZZ9V,99") = " 10,30"
str (X)	puts numeric value in string	str (10.3) = "10.3"
len (X)	produces length of string X	len ("abc") = 3
strip (X)	deletes spaces after last character	strip ("A ") = "A"
pos (X,Y)	produces position of string Y in string X from left	-
rpos (X,Y)	produces position of string Y in string X from right	-

Date functions		Example
date ()	produces current date	-
date (YYYY, MM, DD)	produces date according to specified year (YYYY), month (MM), and day (DD)	date (2008, 5, 1) = 1 May 2008