Skip to Content
avatar image
Former Member

Different queries

1.Why is it always advisable not to select within loops?

2 Can you declare an error message under select statement?

3.You have two parameters on selection screen a. Plant b. Material

How can you get a value help for the material corresponding to the plant value I enter ?

4. Whether interactive reports can be scheduled in background ? If yes what is the ABAP command you can use ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Aug 21, 2007 at 09:22 AM

    1.b'cz it'll access database for every iteration n then cause poor performance.

    2.for displaying error msg u should use SY-SUBRC after select query.

    3.use F4IF_INT_TABLE_VALUE_REQUEST.

    4.yes interactive report can be scheduled in background.

    don't forget to reward.

    S@meer

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 09:22 AM

    Hi

    Please close u r previous thread.

    if u have 10k records in a internal table and if u write select stmt in side a loop of that int table. it will select 10k times from data base table so for reducing this network traffic we have to select all the required data from database table at once and process with it.

    yes u can decalre

    select single matnr from mara where matnr in s_matnr.

    if sy-subrc ne 0.

    message e000(z00) 'no matnr exits'.

    endif.

    3. use dynp_values_read and dynp_values_update functionmodule.

    reward points to all helpful answers

    kiran.M

    Add comment
    10|10000 characters needed characters exceeded