Wednesday, August 1, 2007

Reports

1

What is the T-Code for creating a report.

SE38

2

Can reports be executed via any other option other than SE38 and its own T-code if any.

Yes,Via SA38

3

What are the basic types reports.

Classical & Interactive

4

What are the events in an reports

INITLIZATION

AT SELECTION-SCREEN ON FIELD

AT SELECTION-SCREEN OUTPUT

AT SELECTION-SCREEN ON BLOCK

START-OF-SELECTION

TOP-OF-PAGE

END-OF-PAGE

TOP-OF-PAGE DURING LINE SELECTION

AT LINE SELECTION

AT PF-STATUS

AT USER COMMAND

END-OF-SELECTION.

5

What is the difference between parameters and select-options.

Parameters are used for input of single values

Select-Options are used for input of multiple values.

6

Can select options be used as parameters .

Yes, with options of No-Intervals and No-extensions.

7

How do we design a selection screen.

Using Begin of block <block name> with frame title text-001.

This will format the selection screen and create a block at the output.

8

How is a report aligned.

Using pretty printer , make sure that intend option is selected in Utilities->Setting->Abap editor

It is always aligned w.r.t to the reports statement.

9

Which is the default event.

START-OF-SELECTION

10

What is Line-Count and Line-Size options.

Line-Count : No of lines in a page , new page is automatically triggered when line-count lines are

Encountered

Line-Size:No of characters in a line.

11

What is Message-ID in the report statement.

It is the default message class to be used throught the report.

12

How to assign a label to the selection screen object.

Use Selection-Text Goto->Text Element->Selection Text

`

What is a modif-id.

If we want to modify the screen at runtime based on the user id then we use a modif id with the screen element.

14

Why do we use a text element.

If we are logged on to different language and if a text element is maintained in that language then it is automatically picked up.

15

When does an event end.

When a new event start the previous event end.

16

My End-Of-Page event is not triggering.

You need to reserve no of lines needed for your page end in the LINE-COUNT(<specify no of lines here) which is used at the report header.

17

When is End-Of-Page event triggered.

It is triggered only when the line count as mentioned in the LINE-COUNT is reached and not before that , we can also trigger page end explicitly by appropriate logic.

18

Do we also need to reserve line for TOP-OF-PAGE

No.

19

What are different types of select statements.

Select single

Select up to

Nested select

Sub Queries

Select into

20

What is the difference between a select single and select up to 1 rows.

Select single retrieves the 1st records depending upon the where condition , where as as select up to 1 rows gives the exact records depending upon the where condition.

21

What are the steps to rember while writing a select stmt for better performance.

a. Always select only required fields from the data base table.

b. Always use where conditions.

c. Avoid using nested selects and sub-queries.

d. If selecting more that one records use internal tables.

e. Do not use inner joins for more than 3 tables at a given time.

f. Do not use move-corresponding unless required.

22

What if select stmt using for all entries of a certain internal table is initial.

It will retire all the records for that select stmt. This should be avoided using proper check.

23

What are the types of internal tables.

a. Standard

b. Sorted

c. Hashed

24

Give names of control loop statements.

a. At New

b. At Last

c. At First

d. At End of.

e. On Change of – Can be used outside loop also.

25

Do we have nested loops?

Yes we do but these should be avoided unless and until required as the performance is hit due to this.

26

Can we have a where condition with the loop.

Yes we can.

27

What if the difference between TOP-OF-PAGE and TOP-OF-PAGE DURING LINE SELECTION.

TOP-OF-PAGE is used for basic list

TOP-OF-PAGE DURING LINE SELECTION used for secondary list.

30

What is an interactive list.

A report which generated a basic list and using the basic list if we are able to generate a secondary list then it is called a interactive reports.

31

How many basic and secondary list do we have.

One basic and 20 Secondary list.

32

What is the system field for list index.

Sy-Lsind.

33

How do we store the clicked records.

Using the HIDE stmt in the Loop..EndLoop.

And then using AT LINE-SELECTION event.

34

How do I display Top of page for secondary list.

Use TOP-OF-PAGE-DURING LINE SELECTION and depending upon the generated list index display the appropriate heading.

35

Name few system variables.

a. Sy-Datum Date

b. Sy-Uzeit Time

c. Sy-Lsind List Index

d. Sy-Pagno Page No

e. Sy-Uname User Name

f. Sy-Sysid System Id

More of these can found in system table SYST.

36

What is a message class.

Message class contain message that are displayed during the program its created in SE91 and contains max of 1000 messages 000-999.

37

What are different types of messages.

a. A bandon

b. E xit

c. S tatus

d. I nformation

e. W Arning

38

Can we have a custom message at runtime.

Yes we can, we can pass maximum of 4 variable to the message class.

39

What is a FORMAT stmt.

FORMAT is used to format the report output.

Its options are

a. COLOR 0-7

b. INPUT 0-1

c. INTENSIFIED 0-1

d. HOTSPOT ON/OFF

e. RESET

40

How do I assign a T-CODE to a report.

Go to SE93 and create a T-CODE it will ask for a report name give the report name here.

41

How do I analyze my report performance.

Use ST05 or SE30 or use extended program check

Programs->Check->Extended program check/Code Inspector

42

What is a Short Dump.

An exception, that occurs in the programs are stored as short dump. You can see it in ST22.

43

How do we call an report from another report.

Using Submit statement.

44

Can we pass parameter to these report.

Yes we can, see the option with the submit statement.

45

What is a program statement.

It is equivalent to a report statement.

No comments: