Interview Questions

[Former Member]

hi friends,

pls answer these questions.

1. What is central control instance?

2. what is the module name , that is automatically exits in SAP R/3?

3. WHat is the maximum Number of sessions we can create?

4. where exactly the secondary index is useful in programming code ? example?

5. What is token in VPN network?

6. What is the precondition we need to check, if you use FOR ALL ENTRIES? explain with example?

7. What is the another method to avoid nested select statements , other than for all entries?

8. Suppose i created sesion in BDC? errors occur during session processing? then how do get log records into internal table?

thankq

ch

[Former Member]

Hi Chandra,

3. Maximum munber of session we can create is 6.

6. The internal table used in for all entries statement

should not be initial. Check like this

IF not itab[] is initial.

• Select query

Endif.

Please reward some points if it helps you.

Regards,

Amit M. Mishra

[Former Member]

. What is central control instance?

2. what is the module name , that is automatically exits in SAP R/3?

- MM,SD,FI,PP

3. WHat is the maximum Number of sessions we can create?

- 6

4. where exactly the secondary index is useful in programming code ? example?

- Where the key fields are not available and where the database table is really huge

5. What is token in VPN network?

- its a sort of dynamic session id or password to connect to a session through VPN

6. What is the precondition we need to check, if you use FOR ALL ENTRIES? explain with example?

- Check if the primary table is not empty on which yu are using a For all entries.

7. What is the another method to avoid nested select statements , other than for all entries?

- Array fetch and Read data or Subquery.

8. Suppose i created sesion in BDC? errors occur during session processing? then how do get log records into internal table?

- There is a MESSAGE option in the CALL TRANSACTION use that to fetch the transaction errors.

Cheers

VJ

[Former Member]

Hi,

Secondary Index:

create secondary indexes, for database tables from which you mainly read, since indexes have to be updated each time the database table is changed. secondary indexes should contain columns that you use frequently in a selection, and that are as highly selective as possible to improve performance..

Tokens:

Tokens are Issues sent by the Client to us

FOR ALL ENTRIES:

Always check the driver internal tables is not empty, while using FOR ALL ENTRIES

You can only use FOR ALL ENTRIES IN ...WHERE ...in a SELECT statement.

SELECT ... FOR ALL ENTRIES IN itab WHERE cond returns the union of the solution sets of all SELECT

statements that would result if you wrote a separate statement for each line of the internal table replacing the symbol

itab-f with the corresponding value of component f in the WHERE condition.Duplicates are discarded from the result

set. If the internal table itab does not contain any entries, the system treats the statement as though there were no WHERE cond condition, and selects all records (in the current client).

for example:

SELECT * FROM sflight INTO wa_sflight

FOR ALL ENTRIES IN ftab

WHERE CARRID = ftab-carrid AND

CONNID = ftab-connid AND

fldate = '20010228'.

this condition, return all entries of the sflight

Error in Session:

We look into the list of incorrect session and process it again. To correct incorrect session we analyize the session to determine which screen and value produced the error.For small errors in data we correct them interactively otherwise

modify batch input program that has generated the session or many times even the datafile.

Regards,

Gayathri