• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

SAP Report Interview Questions Answers

Question - 41 : - What is Refresh in Internal Table?

Answer - 41 : - 'Refresh' is the keyworld which clears the contents of an internal table body.

Question - 42 : - What is difference between ON Change of and At New Field ?

Answer - 42 : - Select Single * from and select Upto 1 rows At new - on change of difference: In case if you want calculate sub totals for same values in a field you can use the atnew statement.ie: For example in a table sflight, there are 2 fields carrid ( airline id) and seatsmax( seat available). In case if you want calculate the total number of seats available for each carrrid you can sort the table first and using the at new and sum you can claculate the total seats for each carrid. Atnew will be triggered whenever there is a change in the carrid and the total seats will be returned for each carrid. In the same scenario if you use onchange of it will not return the total seats for each carrid, instead it will return the total seat count for the entire table( ie: for all the carrids in the table. Another diffrence is atnew can be used only between loop and end loop whereas on change of can also be used in select- endselect , do -enddo. Another diffrence is while using atnew in case if you code any write statements between atnew and end at the value for the numeric fields will be returned as 0 and that of no numeric fields will be returned as *(asteriks). But in on change of the orginal values will be returned. Select single * and select upto 1 row diffrence. The select single * from stmt selects only one row form the database table and puts it in to the work area(internal table). The select upto n(where n stands for a integer number) rows stmt selects all the rows from the database table but writes only the specified number of rows specified by the n into the internal table. If its given as upto 1 rows only 1 row is written in to the internal table.

Question - 43 : - What is the difference between start_form and open_form in scripts? Why is it necessary to close a form always once it is opened?

Answer - 43 : - strat_form using this we can open many layoutses open_form using this we can open the layout performance will be high Open_form -- is used to initialize the spool request. Start_form-- is used to initialize the layout.

Question - 44 : - What are the difference between table controls and step loops in dialog programming?

Answer - 44 : - 1. Function modules use a special screen to define the parameters where as subroutines use the same ABAP/4 editor to define its parameters. 2. Tables work area can be commonly shared by calling program and subroutine where as function modules do not share commonly. 3. Calling a function module syntax (Call function.) is different from calling a subroutine syntax (perform….). 4. With raise statement user can exit from a function module where as exit is used in subroutines.

Question - 45 : - How to assign multiple transaction codes in a session method to BDC_Insert function module?

Answer - 45 : - Call function ' BDC_Insert' exporting tr. code = ' enter tr.code1 here' table = 'give an internal table related totr.code1 here' call function 'BDC_INSERT' exporting tr.code = ' enter 2nd tr code' tables = ' 2nd internal table' “Check” and “Continue”. What is the difference? Check statement, checks the condition with in a loop and if it satisfies the condition, the control moves to next statement in the loop. Otherwise, it terminates the loop. Continue statement, acts like goto statement. If the condition is true, it processes the remaining statements and if the condition is false, then the control moves to the top of loop. At-Line selection, At user-command etc.., In at line-selection system defined fcode will be generated In at user-command we need to define the fcode and fkey manually then only it will triggers. “Exit” and “Stop”. What is the difference? exit statments is exit the current loop. and moving to next loop but stop statement move to end of selection. it's not check all other loops.  

Question - 46 : - Have you used SM30 and SM31 transactions?

Answer - 46 : - sm30 is used to view the ' Call Up View Maintenance ' and SM31 is to view the ' Table maintenance ' with

Question - 47 : - What are the Cluster Tables?

Answer - 47 : - Cluster tables contain continuous text, for example, documentation. Several cluster tables can be combined to form a table cluster. Several logical lines of different tables are combined to form a physical record in this table type. This permits object-by-object storage or object-by-object access. In order to combine tables in clusters, at least parts of the keys must agree. Several cluster tables are stored in one corresponding table on the database.

Question - 48 : - How many types of Standard Internal Tables?

Answer - 48 : - - STANDARD TABLE: The key is, by default, set to NON-UNIQUE. You may not use the UNIQUE addition. - SORTED TABLE: Unlike stadard tables, sorted table have no default setting for the uniqueness attribute. If you do not specify either UNIQUE or NON-UNIQUE, the system defines a generic table type, where uniqueness is irrelevant. You can use generic types to specify the type of generic subroutine parameters. - HASHED TABLE: Hashed tables have no default setting. You must use the UNIQUE addition with hashed tables. You may not use NON-UNIQUE.

Question - 49 : - What is the Difference Between Collect and Sum?

Answer - 49 : - COLLECT allows you to create unique or summarized datasets. The system first tries to find a table entry corresponding to the table key. The key values are taken either from the header line of the internal table itab, or from the explicitly-specified work area. If the system finds an entry, the numeric fields that are not part of the table key (see ABAP number types) are added to the sum total of the existing entries. If it does not find an entry, the system creates a new entry instead. The way in which the system finds the entries depends on the type of the internal table: - STANDARD TABLE: The system creates a temporary hash administration for the table to find the entries. This means that the runtime required to find them does not depend on the number of table entries. The administration is temporary, since it is invalidated by operations like DELETE, INSERT, MODIFY, SORT, ...). A subsequent COLLECT is then no longer independent of the table size, because the system has to use a linear search to find entries. For this reason, you should only use COLLECT to fill standard tables. - SORTED TABLE: The system uses a binary search to find the entries. There is a logarithmic relationship between the number of table entries and the search time.

Question - 50 : - Which is the First character of creating LockObject?

Answer - 50 : - LockObjects always starts with character 'E'.

Computer Contributors

Rajeev Katiyar
Yes Baroda

Share your email for latest updates


Our partners