SAP Online Help 07.09.2004
SAP NetWeaver Visual Composer: User Guide 154
Func-
tion
Descrip-
tion
Syntax Examples
DVAL/
TVAL
Converts a
date or
time string
representat
ion to a
standard
date/time
object
format.
DVAL(str,seq)
TVAL(str,seq)
where seq is:
• EUR
(DD/MM/YYY
Y HH:NN:SS)
• USA
(MM/DD/YYY
Y HH:NN:SS)
• XML
(YYYY-
MM-
DDTHH:NN:S
S)
• FREE (free
format)
DVAL(@TIME_FIELD,USA)
Converts the date string returned
to a standard format. for example,
May 30, 2002 would be converted to
the USA standard date format:
05/30/2002.
.
Conditional Functions
Func-
tion
Descrip-
tion
Syntax Examples
IF
Checks
whether a
specified
condition is
met. If it is,
returns the
first
specified
value;
otherwise,
returns the
second
specified
value.
IF(text,expr
1,
expr2)
IF(@NET_PRICE>1000,’Expensive’,’Che
ap’)
If the expression in the field is
TRUE (the value is greater than
1000), the text Expensive is
displayed. If the expression is
FALSE (the value is less than
1000), the text Cheap is displayed.
IF(@@==’DE’,’Germany’,’Other’)
If the string DE is returned, the
text displayed in the iView will be
Germany. Otherwise, the text will
be Other.
IF(@BANK_CTRY==’US’,United States’,
IF(BANK_CTRY==’GB’,’England’,IF(@BA
NK_
CTRY==’IL’,’Israel’,IF(@BANK_CTRY==
’DE’,
’Germany’,’Other’))))
A nested IF expression defining
display text for country names. If
the vale returned is not US, GB, IL
or DE, the text displayed will be
Other.
ISNUL
L
Returns
TRUE if a
reference
is to an
empty,
undefined
or null cell,
ISNULL(value
)
IF(ISNULL(@@),’NO FAX NUMBER’, @@)
If the value of the current cell is
empty, the value displayed in the
iView will be NO FAX NUMBER;
otherwise, the returned value will
be displayed.
