Q: What are SAP reports?
A: SAP Reports are event-driven programs using ABAP/4 programming language. These reports are used to fetch business-specific data from SAP standard databases under specified selection criteria, fetched data is processed to display result on output screen. User develop SAP report object on ABAP editor using the standard SAP transaction SE38.
Q: What are ABAP report types?
A: ABAP report types are of 7 types. ABAP report types are available in report’s attributes screen.
Executable program
Function group (containing function modules)
Include
Interface pool
Class pool
Module pool
Subroutine pool
Q: How many lists can be displayed through an interactive report?
A: Maximum 21 lists can be displayed (1 basic list+ 20 secondary lists).
Q: what is the event that will be triggered first in an ABAP report?
A: Initialization event is triggered first if user executes an ABAP report. But if the program is of type 1, M, F, or S; then LOAD-OF-PROGRAM is triggered first and then INITIALIZATION event.
Q: What are the differences between simple and interactive ABAP reports?
A: A simple ABAP report allows the user to interact with the whole business-result data. In case of interactive reports user can interact with specific result data at a time.
Q: How do you read selected lines of database table into an internal table in packages of predefined size?
A: SELECT * FROM <SPFLI>INTO TABLE <ITAB>PACKAGE SIZE<N>.
Where n is variable.
Q: How do you write a DATA object from ABAP/4 program to ABAP/4 memory and restore the same from memory to program.
A: EXPORT <f1>[FROM <g1>]<f2>[FROM <g2>]…. TO MEMORY ID <key>.
The ID <key>, which can be up to 32 characters long, identifies the data in memory.
Q: Name the function modules to write data from an Internal Table to the Presentation Server.
A: DOWNLOAD and WS_DOWNLOAD.
Q: How to determine the attributes of an internal table?
A: DESCRIBE TABLE <itab>[LINES <lin>] [OCCURS <occ>].
Q: What is interactive reporting?
A: It helps you to create easy-to-read lists. You can display an overview list first that contains general information and provide the user with the possibility of choosing detailed information that you display on further lists.
Q: What are the uses of interactive reporting?
A: The user can actively control data retrieval and display during the session. Instead of an extensive and detailed list, you create a basic list with condensed information from which the user can switch to detailed displays by positioning the cursor and entering commands. The detailed information appears in secondary lists.
Q; what are the event key words in interactive reporting?
A: Event Keyword Event
AT LINE-SELECTION Moment at which the user selects a line by double clicking on it or by positioning the cursor on it and pressing F2.
AT USER-COMMAND Moment at which the user presses a function key.
TOP-OF-PAGE DURING Moment during list processing of a
LINE-SELECTION Secondary list at which a new page starts.
A: SAP Reports are event-driven programs using ABAP/4 programming language. These reports are used to fetch business-specific data from SAP standard databases under specified selection criteria, fetched data is processed to display result on output screen. User develop SAP report object on ABAP editor using the standard SAP transaction SE38.
Q: What are ABAP report types?
A: ABAP report types are of 7 types. ABAP report types are available in report’s attributes screen.
Executable program
Function group (containing function modules)
Include
Interface pool
Class pool
Module pool
Subroutine pool
Q: How many lists can be displayed through an interactive report?
A: Maximum 21 lists can be displayed (1 basic list+ 20 secondary lists).
Q: what is the event that will be triggered first in an ABAP report?
A: Initialization event is triggered first if user executes an ABAP report. But if the program is of type 1, M, F, or S; then LOAD-OF-PROGRAM is triggered first and then INITIALIZATION event.
Q: What are the differences between simple and interactive ABAP reports?
A: A simple ABAP report allows the user to interact with the whole business-result data. In case of interactive reports user can interact with specific result data at a time.
Q: How do you read selected lines of database table into an internal table in packages of predefined size?
A: SELECT * FROM <SPFLI>INTO TABLE <ITAB>PACKAGE SIZE<N>.
Where n is variable.
Q: How do you write a DATA object from ABAP/4 program to ABAP/4 memory and restore the same from memory to program.
A: EXPORT <f1>[FROM <g1>]<f2>[FROM <g2>]…. TO MEMORY ID <key>.
The ID <key>, which can be up to 32 characters long, identifies the data in memory.
Q: Name the function modules to write data from an Internal Table to the Presentation Server.
A: DOWNLOAD and WS_DOWNLOAD.
Q: How to determine the attributes of an internal table?
A: DESCRIBE TABLE <itab>[LINES <lin>] [OCCURS <occ>].
Q: What is interactive reporting?
A: It helps you to create easy-to-read lists. You can display an overview list first that contains general information and provide the user with the possibility of choosing detailed information that you display on further lists.
Q: What are the uses of interactive reporting?
A: The user can actively control data retrieval and display during the session. Instead of an extensive and detailed list, you create a basic list with condensed information from which the user can switch to detailed displays by positioning the cursor and entering commands. The detailed information appears in secondary lists.
Q; what are the event key words in interactive reporting?
A: Event Keyword Event
AT LINE-SELECTION Moment at which the user selects a line by double clicking on it or by positioning the cursor on it and pressing F2.
AT USER-COMMAND Moment at which the user presses a function key.
TOP-OF-PAGE DURING Moment during list processing of a
LINE-SELECTION Secondary list at which a new page starts.
Q: What is secondary list?
A: It allows you to enhance the information presented in the basic list. The user can, for example, select a line of the basic list for which he wants to see more detailed information. You display these details on a secondary list. Secondary lists may either overlay the basic list completely or you can display them in an extra window on the screen. The secondary lists can themselves be interactive again.
Q; How to select valid lines for secondary list?
A: To prevent the user from selecting invalid lines, ABAP/4 offers several possibilities. At the end of the processing block END-OF-SELECTION, delete the contents of one or more fields you previously stored for valid lines using the HIDE statement. At the event AT LINE-SELECTION, check whether the work area is initial or whether the HIDE statement stored field contents there. After processing the secondary list, clear the work area again. This prevents the user from trying to create further secondary lists from the secondary list displayed.
Q: Can we call reports and transactions from interactive reporting lists?
A: Yes. It also allows you to call transactions or other reports from lists. These programs then use values displayed in the list as input values. The user can, for example, call a transaction from within a list of change the database table whose data is displayed in the list.
Q: What are system fields for secondary lists?
A: SY-LSIND Index of the list created during the current event (basic list = 0)
SY-LISTI Index of the list level from which the event was triggered.
SY-LILLI Absolute number of the line from which the event was triggered.
SY-LISEL Contents of the line from which the event was triggered.
SY-CUROW Position of the line in the window from which the event was triggered
SY-CUCOL Position of the column in the window from which the event was triggered
SY-CPAGE Page number of the first displayed page of the list from which the event was triggered.
SY-STARO Number of the first line of the first page displayed of the list from which the event was triggered (counting starts with 1). Possibly, a page header occupies this line.
SY-STACO Number of the first column displayed in the list from which the event was triggered
SY-UCOMM Function code that triggered the event.
SY-PFKEY Status of the displayed list.
Q: What are the page headers for secondary lists?
A: On secondary lists, the system does not display a standard page header and it does not trigger the event. TOP-OF-PAGE. To create page headers for secondary list, you must enhance TOP-OF-PAGE: Syntax TOP-OF-PAGE DURING LINE-SELECTION. The system triggers this event for each secondary list. If you want to create different page headers for different list levels, you must program the processing block of this event accordingly, for example by using system fields such as SY-LSIND or SY-PFKEY in control statements (IF, CASE).
A: It allows you to enhance the information presented in the basic list. The user can, for example, select a line of the basic list for which he wants to see more detailed information. You display these details on a secondary list. Secondary lists may either overlay the basic list completely or you can display them in an extra window on the screen. The secondary lists can themselves be interactive again.
Q; How to select valid lines for secondary list?
A: To prevent the user from selecting invalid lines, ABAP/4 offers several possibilities. At the end of the processing block END-OF-SELECTION, delete the contents of one or more fields you previously stored for valid lines using the HIDE statement. At the event AT LINE-SELECTION, check whether the work area is initial or whether the HIDE statement stored field contents there. After processing the secondary list, clear the work area again. This prevents the user from trying to create further secondary lists from the secondary list displayed.
Q: Can we call reports and transactions from interactive reporting lists?
A: Yes. It also allows you to call transactions or other reports from lists. These programs then use values displayed in the list as input values. The user can, for example, call a transaction from within a list of change the database table whose data is displayed in the list.
Q: What are system fields for secondary lists?
A: SY-LSIND Index of the list created during the current event (basic list = 0)
SY-LISTI Index of the list level from which the event was triggered.
SY-LILLI Absolute number of the line from which the event was triggered.
SY-LISEL Contents of the line from which the event was triggered.
SY-CUROW Position of the line in the window from which the event was triggered
SY-CUCOL Position of the column in the window from which the event was triggered
SY-CPAGE Page number of the first displayed page of the list from which the event was triggered.
SY-STARO Number of the first line of the first page displayed of the list from which the event was triggered (counting starts with 1). Possibly, a page header occupies this line.
SY-STACO Number of the first column displayed in the list from which the event was triggered
SY-UCOMM Function code that triggered the event.
SY-PFKEY Status of the displayed list.
Q: What are the page headers for secondary lists?
A: On secondary lists, the system does not display a standard page header and it does not trigger the event. TOP-OF-PAGE. To create page headers for secondary list, you must enhance TOP-OF-PAGE: Syntax TOP-OF-PAGE DURING LINE-SELECTION. The system triggers this event for each secondary list. If you want to create different page headers for different list levels, you must program the processing block of this event accordingly, for example by using system fields such as SY-LSIND or SY-PFKEY in control statements (IF, CASE).
No comments:
Post a Comment