Skip to Content

ABAP in update rule

I have one code in the start routine of the update rule which i have copied below .Just to fetch 96000 record , the system is getting hanged.

select

/bic/zemployee

/bic/zevent

/bic/zmatlsamp

material

/bic/zcustomer

postal_cd

time

into table t_seq_ind

from /bic/azfw_o0200

for all entries in t_cardnum

where /bic/zemployee = t_cardnum-/bic/zemployee.

t_cardnum is an internal table & /bic/azfw_o0200 is an oDS table which have only 96000 records.How to increase the performance for this query

Reagdrs,

Anita

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2007 at 11:05 AM

    Hi Anita!

    What is the key in your ODS ?!?

    If in your ODS there are so few records, you can upload into an internal table ALL the active data table (SELECT * FROM /bic/azfw_o0200 into table tb_zfw_o0200).

    Then you can read the entries of this table as you need...

    Anyway, your ABAP is good...are you sure that t_cardnum-/bic/zemployee has the right format as in ODS ?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2007 at 10:48 AM

    Hi,

    create a Secondary index in ODS /bic/azfw_o0200 with the field zemployee.

    And also define the Internal table as indexed internal table with index on zemployee.

    With rgds,

    Anil Kumar Sharma .P

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.