Exercise 2 - Abap Basic Functions Questions

SAP R/3 ABAP 4.6 Delta TrainingQuestions ABAP Basic Functions 1. What three system fields are always displayed in the 4.6 debugger? ___________________________________________________________________________________ ___________________________________________________________________________________

2. What are the three types of internal tables that can be defined in 4.6? ___________________________________________________________________________________ ___________________________________________________________________________________

3. What kind of expression must the HAVING clause be used with? ___________________________________________________________________________________ ___________________________________________________________________________________

Using a Sorted Internal Table and an Inner Join Select Statement No. Steps 1

Copy program ZDELTA_ABAP_SELECT_SHELL to another name.

1.1

Goto Object Navigator (SE80)

1.2

Select Program and fill in the program name to copy and click the display button next to the field.

1.3

In the browser section on the left, right click on the program name and select the copy function

1.4

Save the new program as a local object

2

Code the data definition for the SORTED internal table

2.1

On line 18 fill in the correct syntax to define a SORTED table ITAB1 with a line structure line_type and a unique key field NAME1

3

Code the Inner Join on KNA1 and KNVV

3.1

Select all the fields defined in the structure into the internal table via an inner join on KNA1-KUNNR –> KNVV-KUNNR, where KNA1-SORTL = ‘46DELTA’ and KNVV-VKORG = ‘0001’.

3.2

Execute the program.

4

Follow-up

4.1

What field was the table sorted on?

4.2

What happens if you switch the UNIQUE KEY field to KUNNR?

PricewaterhouseCoopers LLP Global Training Centre Th is is Pri cewaterhou seCoop ers P RO PRIE TARY MAT ERIAL (hereafter, the Material ) in ten ded for i nternal use on ly. You may n ot ren t, lease or d istri bute th e M aterial to cli ents o r o th er thi rd parties, bu t you may tran sfer the Material to oth er em pl oyees o f P ricewaterho useCoo pers.

1

August 2000