>>PREVIOUS>>

QUESTION DATABASE

The following events occur during the processing of the output list of a report program:

Event keyword Event

TOP-OF-PAGE Point during list Processing when a new page is started
END-OF-PAGE Point during list Processing when a Page Is ended

The following events occur during the display of the output list of a report program:
Event key work Event

AT LINE-SELECTION Point at which the user Selects a Line

AT USER-COMMAND Point at which the user Presses a Function key or enters a command in the
command Field.

AT PF ..nn.. Point at which the User presses the Function key with the function code PF With the selection screen, ABAP/4 offers an interactive element also for report programs. You can define a selection screen without having to bother about all the details required in dialog programming.

The selection screen is always processed directly after a report program is started. The user can enter field values and selection criteria on this screen.

The main purpose of the selection screen is to enable the user to control the database selections of the report program. If a report program is started from another ABAP/4 program with the SUBMIT statement (see Calling Reports), the selection screen objects also serve as a data interface, With a selection screen defined in the report program, you can enable the user to

Assign values to variables with the PARAMETERS statement

Determine selection criteria with the SELECT-OPTIONS statement

Q)How do you read selected lines of database table into an internal table in packages of predefined size.

SELECT * FROM SPGLI INTO TABLE ITAB PACKAGE SIZE ..N..

Where ‘n’ is variable.

Q)Name the WILDCARD characters which are used for comparisons with character strings & numeric

strings.‘%’ and ‘-‘

Q)How to specify a client for database table processing.

TABLES SPFLI .

SELECT * FROM SPFLI CLIENT SPECIFIED
WHERE MANDT BETWEEN ‘001’ AND ‘003’ .
. . .
ENDSELECT.

Q) Activation – During activation, the runtime object of aggregate object or tables is created. The runtime object is buffered so that the application program can access it quickly. Runtime object has information about the following objects of table

- domain – data elements – field definition – table definition


Q) Lock Mechanism – prevents a new database operation being started an existing one has been correctly completed. When conversion is done, lock is created automatically and released only when conversion is successful.

Clearing of locks

- restart adjustment – attempt is made to continue conversion at the point of termination cancel adjustment - lock entry is simply deleted from table.

>>>NEXT>>>