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?

SAP R/3 ABAP 4.6 Delta Training Questions

ABAP Basic Functions

PricewaterhouseCoopers LLP 1 August 2000

Global Training Centre

---