Interview Questions of IBM? Please help me with these,its urgent?

[Former Member]

1. Which method in BDC will you go for if the record is about 5000 records and why? State your answer with respect to performance, time, no. of hits and so on?

2. I am suppose to upload 5000 records in database using session method and the first 2000 records are updated successfully and in the next 1000 records are error records, how will session method handle these error records and process the rest remaining 3000 records?

3. What is At PF Status and where all it is used?

4.How can you make a column in an ALV report output editable?

5. What are the dump errors you have come across while dealing with ALV reports?

6. How can you display more than one smart form at a time?

7.Is it possible to change a script to a smart form and how?

8. In Intercative report what is the system variable used todisplay the selected contents of a particular column?

[Former Member]

9. What is synchronouse and asynchronous updates and what happens in each of these updates in real time?

10. Is it possible to update logos in normal reports?

11. What is the function modules used in AlV for events?

12.How can you add a field to a report in runtime?

13. What are the dump errors we come across in case of scripts and smart forms?

14. What are the type-pools in ALV other than slis?

15. What is reuse_alv_fieldcatalogue_merge?

Please help me with answers to these questions.

Regards,

MD.

[Former Member]

hi..

answer to question no:15

A field catalog is required for every ALV list output.

The field catalog for the output table is built-up in the caller's coding. The build-up can be completely or partially automated by calling the REUSE_ALV_FIELDCATALOG_MERGE module.

See also the documentation of the function module

REUSE_ALV_FIELDCATALOG_MERGE.

The minimal field catalog is documented under 'default'. The caller can use the other optional parameters to assign output attributes to a field which differ from the default.

A field catalog need not be built-up and passed explicitly only under the following conditions:

o The internal table to be output has the same structure as a Data Dictionary structure which is referred to in the internal table declaration using LIKE or INCLUDE STRUCTURE.

o all fields in this structure are to be output

o the structure name is passed to ALV in the parameter I_STRUCTURE_NAME.

[Former Member]

10

using oops concept we can insert logs

11

reuse_alv_getevents(check)

14

in se11--type group--f4help u get no of type group

12

i think it is not possible to add field in the report

[Former Member]

7.Is it possible to change a script to a smart form and how?

yaa its possible to convert a script in to smartform ...

• go to the transaction SMARTFORMS

• go to utilities

• go to migrate sap scripform

*give the script name which ur going to convert to smart form

*then do the modifications inthe smartform...

[Former Member]

10. Is it possible to update logos in normal reports?

OAER -transaction to update logos in reports

[Former Member]

9. synchronus \update means it will update record by record process will not be stooped untill the updation is completed

asynchronus means the entire records will update ant once

and process will not wait for complte updation.

10. in normal reports we have to use oops concept..their no function module as in alv reports

11.for events first we have declre event table from slis

then

user_command fro user definned keys

top_page for top of page

15.alv_field catlog_merge is for field headings to maitain field catalogs ,no need of paarametr it_fieldcatalog in resuse_alv_list_display to be passed for field catalog .insted we can directly use alv_fldcatlog_nerge

[Former Member]

Hi Friends,

I am really thankful to all of you for your valuable inputs for my queries. However I am still looking for some more views. Please help me with more elaborate answers for these questions. Thanks in advance.

1. Which method in BDC will you go for if the record is about 5000 records and why? State your answer with respect to performance, time, no. of hits and so on?

2. I am suppose to upload 5000 records in database using session method and the first 2000 records are updated successfully and in the next 1000 records are error records, how will session method handle these error records and process the rest remaining 3000 records?

5. What are the dump errors you have come across while dealing with ALV reports?

6. How can you display more than one smart form at a time?

8. In Intercative report what is the system variable used todisplay the selected contents of a particular column?

9. What is synchronouse and asynchronous updates and what happens in each of these updates in real time?

11. What is the function modules used in ALV for events?

12.How can you add a field to a report in runtime?

13. What are the dump errors we come across in case of scripts and smart forms?

14. What are the type-pools in ALV other than slis?

Looking for your valuable comments.

Regards,

MD.

[Former Member]

Hi,

1Ans: If there is large amount of data (ie. in lakhs) then u can go for session method, since 5000 reords u can use call transaction, it takes less time to process because it can be done by asyncronous mode, this can be done in foreground process only.

[Former Member]

Hi MD,

Answers for some of your Questions:

3. The R/3 system automatically, generates a graphical user interface (GUI) for your lists that offers the basic functions for list processing, such as saving or printing the list. If you want to include additional functionality, such as pushbuttons, you must define your own interface status. To create a new status, the Development Workbench offers the Menu Painter. With the Menu Painter, you can create menus and application toolbars. And you can assign Function Keys to certain functions. At the beginning of the statement block of AT END-OF-SELECTION, active the status of the basic list using the statement: SET PF-STATUS ‘STATUS’.

4. to make the field editable in the output you have to specify that in the fieldcatalog as,

ls_fcat-edit = 'X'.

11. We can use ABAP ALV LIST and GRID function modules to display Normal LIST and Hiearchical LISTS .

All the definitions TYPES and STRUCTURES and CONSTANTS are defined

in the TYPE-POOL 'SLIS' ,so it should be declared first.

TYPE-POOLS : 'SLIS' .

To display ALV LISTS the function module used are :

REUSE_ALV_LIST_DISPLAY "For Normal LIST

REUSE_ALV_HIERARCHICAL_LIST_DISPLAY "For Hierarchical LIST

To display ALV GRID the function module used are :

REUSE_ALV_GRID_DISPLAY . "For GRID display

The most important component of the ALV is the FIELDCATALOG which is of

TYPE SLIS_T_FIEDLCAT_ALV

or of

TYPE STANDARD TABLE OF SLIS_FIELDCAT_ALV .

The line items of the field catalog are of

TYPE SLIS_FIELDCAT_ALV .

FIELDCATALOG

To prepare field catalog certain fields are essential .There are various other fields allowing for vaarious possibilities and display options.

TABNAME

FIELDNAME

REF_TABNAME

SELTECT_M

e.g.

DATA: WS_FCAT TYPE SLIS_FIELDCAT_ALV . "LINE ITEM OF FCAT

DATA: IN_FCAT TYPE SLIS_T_FIELDCAT_ALV.

WS_FCAT-TABNAME = 'MARA'.

WS_FCAT-FIELDNAME = 'MATNR'.

WS_FCAT-SELTEXT_M = 'Material Number'.

APPEND WS_FCAT TO IN_FCAT .

CLEAR WS_FCAT.

WS_FCAT-TABNAME = 'MAKT'.

WS_FCAT-FIELDNAME = 'MAKTX'.

WS_FCAT-SELTEXT_M = 'Material Description'.

APPEND WS_FCAT TO IN_FCAT .

This will create fieldcatalog with two columns for displaying material and material description .

RESUSE_ALV_LIST_DISPLAY.

The following FM is used to display the data in the internal table in the form of ALV

LIST. The Event table is only required if event handling is being done.

CALL FUNCTION 'RESUSE_ALV_LIST_DISPLAY'

EXPORTING

I_CALLBACK_PROGRAM = W_REPID "of TYPE SY-REPID and

" value SY-REPID

IS_LAYOUT = W_LAYOUT "of TYPE SLIS_LAYOUT_ALV

IT_FIELDCAT = IN_FCAT "of TYPE SLIS_T_FIELDCAT_ALV

I_SAVE = W_SAVE "of TYPE C ,values A ,U ,' '

IT_EVENTS = IN_EVENTS " of TYPE SLIS_T_EVENT

TABLES

T_OUTTAB = IN_DATA "internal table conatining data

"corresponding to IN_FCAT

EXCEPTIONS

PROGRAM_ERROR = 1

OTHERS = 2

IF SY-SUBRC NE 0.

MESSAGE ENNN .

ENDIF.

REUSE_ALV_EVENTS_GET.

This FM is used to get the default event table of the ALV LIST DISPLAY.

The IN_EVENTS internal table is of TYPE SLIS_T_EVENT. This table contains

all the events wrapped up in the ALV LIST or ALV GRID and consistsof two fields

NAME and FORM .The NAME corresponds to names of the events like TOP_OF_PAGE and END_OF_PAGE ,USER_COMMAND and FORM will contain the name of the FORM ROUTINE that will be called dynamically through callback mechanism when the particular event will fire and is initial for all events bt default and has to be filled for

events for which handling is required.

CALL FUNCTION 'REUSE_ALV_EVENTS_GET'

EXPORTING

I_LIST_TYPE = 0

IMPORTING

ET_EVENTS = IN_EVENTS[].

e.g.

DATA: W_EVENT TYPE SLSI_ALV_EVENT "LINE ITEM OF EVENT TABLE

DATA: IN_EVENTS TYPE SLSI_T_EVENT . "Internal table containing events

CALL FUNCTION 'REUSE_ALV_EVENTS_GET'

EXPORTING

I_LIST_TYPE = 0

IMPORTING

ET_EVENTS = IN_EVENTS[].

RTEAD TABLE IN_EVENTS WITH KEY NAME = 'TOP_OG_PAGE'

INTO W_EVENT.

IF SY-SUBRC EQ 0.

MOVE 'F3000_TOP_OF_PAGE' TO W_EVENT -FORM.

MODIFY IN_EVENTS FROM W_EVENT INDEX SY-TABIX.

ENDIF.

Here the FORM ROUTINE 'F3000_TOP_OF_PAGE' is being set up for the

event TOP_OF_PAGE which will fire when the ALV LIST will be displayed ,This form

will be called dynamically by th ALV LIST display during top_of_page event and for this the modified Events internal table has to be passed to the FM 'REUSE_ALV_LIST_DISPLAY' in the exporting parameter IT_EVENTS. Failing this the form '3000_TOP_OF_PAGE' will not be called . This event is used for placing heading information like Current date and time and the name of the report.

Check these links

14. Syntax

TYPE-POOLS tpool.

Effect

In order to use the definitions of a type group, you have to integrate the type group into the program.

The TYPE-POOLS statement integrates the type group tpool into the current context. You can specify it in the global data declarations of an ABAP program or in the declaration section of a class or interface. The data types and constants of the type group are visible as of this statement in the current context.

Note

If the integrated type group tpool integrates a further type group with the TYPE-POOLS statement, this new type group is also integrated into the program.

Example

Integrating the predefined type group abap. By referring to the table type abap_func_parmbind_tab from the type group abap, the system declares an internal table parameter_tab for the dynamic parameter transfer to function modules.

TYPE-POOLS abap.

DATA parameter_tab TYPE abap_func_parmbind_tab.

Type pools do not have anything to do with alv. They are type and constant declarations and are very similar to includes, but as I said they can only hold type and constant declarations. goto SE11 and have alook at type group ABAP or ICON. The special type pools SLIS makes life much more easier in ALV cause it helds alle the types you need handling the ALV layout.

15. This is the functionality of that FM,

Supports the creation of the field catalog for the ALV function modules

based either on a structure or table defined in the ABAP Data

Dictionary, or a program-internal table.

The program-internal table must either be in a TOP Include or its

Include must be specified explicitly in the interface.

The variant based on a program-internal table should only be used for

rapid prototyping since the following restrictions apply:

o Performance is affected since the code of the table definition must

always be read and interpreted at runtime.

o Dictionary references are only considered if the keywords LIKE or

INCLUDE STRUCTURE (not TYPE) are used.

If the field catalog contains more than 90 fields, the first 90 fields

are output in the list by default whereas the remaining fields are only

available in the field selection.

If the field catalog is passed with values, they are merged with the

'automatically' found information.

Check the link below:

http://www.sapdev.co.uk/reporting/alv/alvgrid_basic.htm

Reward If useful.

Regards,

Chitra Parameswaran

[Former Member]

hi,

yes we can convert scripts to smartforms

procedure is go to smartform transcation--

---

utilites -

---

migration--

---

give the script name to convert and name of the smartform

[Former Member]

hi

answer for question no.7

yes, u can convert script 2 smartform.

goto smartforms ......in the menu bar there is a option ...utilities....in that...migrate...select import from sapscript....

u can give the script name here and convert 2 smartform.

[Former Member]

Hi,

1Ans: If there is large amount of data (ie. in lakhs) then u can go for session method, since 5000 reords u can use call transaction, it takes less time to process because it can be done by asyncronous mode, this can be done in foreground process only.

2Ans:In session method errors can be handled by logs, all the correct records will be processed if any error record raised then error log will handle this record but the process will continue for the correct records finally we can handle the error records seperatly. We can view these errors in Tcode : se35

3Ans:At PF status is used to to activate the icons in the menu bar when we create our own screen, initially these icons will be in diable mode.

4Ans: *CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' bye useing this u can display the fields u selected for more details

verify Type-pools:slis in se11

5Ans: -

---

6Ans:----

---

7Ans: Yes we can change the script and smart forms.

8 Ans: Sycolno.

9Ans:Synchronous Update means if any data is uploaded, first syburc will return zero for all the tables related to the data after uploading.

Asyncronous Update means data will uplode first later on sysubrc will return.

10Ans: In normal report by using oops concept we can uploade logo, normally we cant..

11Ans:CALL FUNCTION 'REUSE_ALV_EVENTS_GET'

12Ans:----

13Ans:----

14Ans:slisl, tpool etc for more goto se11typegroup f1help

15Ans:reuse_alv_fieldcatalogue_merge: create field catlog from dictionary structure or internal table dynmically.

[Former Member]

hi

answer for question no:3

AT PF-STATUS : TO PROVIDE FUNCTIONS FOR OUR OWN PROVIDED GUI BUTTONS AT OUTPUT

[Former Member]

hi

6. How can you display more than one smart form at a time?

answer

functional consultant can do those settings...

they need to configure it...so that u can display more than one smartform .

they have some transaction code assigned .

[Former Member]

2. the error recods which u got will be stored in log table in session method .go to sm 35 their u find log table .so u can correct it their aganin u process but in call transcation method e have store these records using bdcmsgcoll structure .

3.AT PF status is used is used in reports (normal or alv) to put staus bar the menu bar userdefined such as back .exit...

ex: at pf status <pf name>

define ur pf name and add the user defined buttons which u want and code it .it will works.

4.in field catalog

it-field-edit = 'x'

check this ucan edit the column

reward if usefull