TAW_11 Chapter 2, statements, functions and expressions

Question 1

Type I truncates values?

Answer 1

False, Integers are ROUNDED, not truncated

Question 2

The type I value range is from what to what?

Answer 2

-2,147,483,648 to 2,147,483,647

Question 3

There are 7 basic calculations. What are they

Answer 3

+,-,*,/,DIV (rounded down),MOD,**

Question 4

Type F is extremely accurate

Answer 4

No, only use for approximations as the decimals are often unpredictable

Question 5

when would a type F be needed?

Answer 5

There are special aggregations of the SELECT statement that require it

Question 6

What is the maximum number of decimals in a type P

Answer 6

14

Question 7

What is the requirement for number of digits to the left

of the decimal in type P?

Answer 7

At least one digit to the left of the decimal must be present

Question 8

Which can hold larger numbers, type F or DECFLOAT

Answer 8

The DECFLOAT are larger and more accurate than type F

Question 9

If a arithmetic expression contains a type P, is the internal calc based on type P?

Answer 9

Yes, all is converted to type P unless a type F is also present

Question 10

The system will use DECFLOAT as the interim if what is true

Answer 10

If at least one field is of type DECFLOAT and no type P or F fields exist

Question 11

There are 9 statements for processing character type data. What are they

Answer 11

CONCATENATE
SHIFT
OVERLAY
SPLIT
FIND
TRANSLATE
REPLACE
CONDENSE
WRITE..TO..

Question 12

What did the FIND command replace?

Answer 12

The SEARCH command

Question 13

Two of the character type statements cannot be used with type X fields. What are they?

Answer 13

CONDENSE and OVERLAY

Question 14

What must be added to the 7 processing statements for character processing to use them with type X fields?

Answer 14

add IN BYTE MODE

Question 15

Name the 8 logical operators

Answer 15

CA - contains any
NA - not any
CO - contains only
CP - contains pattern
NP - not pattern
CN - contains no
CS - contains string
NS - no string

Question 16

How can the 8 logical operators be used with type X

Answer 16

Just add BYTE- to the operator

Question 17

SAP date calculations use Julian date?

Answer 17

No, they use a start date of 01-01-0001

Question 18

What is the concatenation symbol for string templates?

Answer 18

&&

Question 19

In a string expression functions can be used provided…

Answer 19

The result is character type or convertible to a string

Question 20

Name some of the string template formatting options

Answer 20

width
date
time
currency
align
pad
case
sign
exponent
decimals
zero
style
number
timestamp
timezone
country

Question 21

what do predicate functions return?

Answer 21

True or False boolean

Question 22

What do descriptive functions return?

Answer 22

Numeric results

Question 23

What do processing functions return?

Answer 23

Character type results

Question 24

Name the 6 descriptive sting functions

Answer 24

STRLEN
NUMOFCHAR
FIND
FIND_ANY_OF
COUNT
COUNT_ANY_OF

Question 25

why doesn't find_any_of have a "case" parameter?

Answer 25

Because it is always case sensitive

Question 26

``` What does the following do? And what does it return? FIND( VAL = 'abapABAP' SUB = 'A' OCC = 2 CASE = 'X' ) ```

Answer 26

Finds the second occurrence of 'A' from the left. It returns the value of 6. (remember the count starts at position 0.

Question 27

What would OCC = -2 mean?

Answer 27

Find the second occurrence from the right

Question 28

What are the 18 processing functions in character type data

Answer 28

``` SHIFT_LEFT - SHIFT_RIGHT TO_UPPER - TO_LOWER TO_MIXED - FROM_MIXED CMAX - CMIN ESCAPE CONCAT_LINES_OF MATCH REPEAT REVERSE TRANSLATE CONDENSE REPLACE INSERT SUBSTRING ```

Question 29

What are the available PREDICATE functions

Answer 29

CONTAINS, CONTAINS_ANY_OF, MATCHES

Question 30

What does MATCHES require?

Answer 30

A REGEX

Question 31

There are 10 regular expression operators. Good luck naming them!

Answer 31

``` . = any character r* = 0 or more occurrences r+ = 1 or more occurrences r{m,n} = min,max occurrences of r{m} = exactly occurrences of r? = 0 or 1 occurrences of r|s = r or s ( ) = subgroup ^ $ = Start/end of line \< \> = Start/end of word ```

Question 32

There are 6 special character combinations to describe a single character

Answer 32

``` . = placeholder \ = placeholder for group of characters [] = value set for single character [ABC] [^] = Negation of a character set [^ABC] [-] = value range for single character [A-D] [[::]] = description upper/digital ```

Question 33

Which string expressions support the use of regular expressions

Answer 33

``` COUNT COUNT_ CONTAINS FIND FIND_ MATCH MATCHES REPLACE SUBSTRING SUBSTRING_ ```

Question 34

Regex replacements start with what?

Answer 34

$