For Repair Service Report - FOR ALL ENTRIES IN is giving Time Out Error

Thanks Sachin & Raymond,

@ Sachin

But in this case ITAB is without header line. so I need to go with ITAB and not ITAB[]

DATA: gi_caufv TYPE TABLE OF gt_caufv,

@ Raymond

Sorry, I am unable to open the Notes (dnt have authority)

Yes, It's not in index.

Before this, I worked on VGBEL & VGPOS fields of LIPS for fetching Records.

But for Repair Service, the exact Item NO. is found in POSNV and not in VGPOS !!!

How can I continue with it?

Thank You All.

@ Anmol

Yes, Index is not there.

Even changing fields are not useful. I think problem is with vbelv & posnv.

@ Sujay

I thought to do this way but in some cases it's not possible -->

like entries are

kdauf = 1290 & kdpos - 10030
IN LIPS
vbeln    vgbel  vgpos  vbelv  posnv  
8400094   1290   10000  1290  10030              " With Del. type 'LR'
34000171  1290    10000  1290  10030            " With Del. type 'LF' for item 10030
34000172  1290    10000  1290  10080            "With Del. type 'LF' for item 10080

@ Immanuel

I tried to change the sequence, Also Delete the so_vbeln, Still the problem is there.

I think it's because of Indexing of vbelv & posnv.

@ Raymond & Vinod

As I write for Sujay, there are Multiple Delivery for different Items.

(After Repair Multiple items has OBD on diff. Date)

DATA IN VBFA
preceding doc.  item     follow doc.   item
1290             10000       34000171     10
1290             10000       34000172      10

My Required o/p is -->

1290 10030 --> 34000171 10

Edited by: Priya.ABAP on Oct 13, 2010 7:40 AM

Hi Priya,

I dont know the correct answer,

but please check line in your code:

IF gi_caufv IS NOT INITIAL.

please make it as

IF gi_caufv[] IS NOT INITIAL.

if I am not getting it wrong, you missed [] if gi_caufv is an internal table.

Thanks and regards

Sachin Bhatt IN

As LIPS don't have index for vbelv, posnv, the access is certainly not optimised (check via [ST05|http://www.sdn.sap.com/irj/scn/advancedsearch?query=st05#sdn_content_category_value_wiki])

First, read this OSS [Note 185530 - Performance: Customer developments in SD|https://service.sap.com/sap/support/notes/185530] (You could try loading first VBFA and then LIPS)

Regards,

Raymond

SELECT vbeln posnr vbelv posnv 
      FROM lips client specified
      INTO TABLE gi_lips
       FOR ALL ENTRIES IN gi_caufv
       WHERE mandt = sy-mandt
        and     vbeln IN so_vbeln.

This can't be correct:

+ don't use 'Client specified' with sy-mandt, it is done automatically

+ don't reduce the WHERE conditions and expect a performance improvement

+ don't use nested loops with standard tables

Siegfried

Thank You All for Your Help.

I think with SELECT statemnt it's not possible to get the Exact OBD no.

@Vinod & Madhukar

In SEKECT statement I am taking vgbel = kdauf as WHERE condition.

And in ITAB comparing all OBDs for posnv = kdpos.

@ Siegfried

Agree with You.

Following all three suggestions.

SELECT vbeln posnr vgbel vbelv posnv 
      FROM lips
      INTO TABLE gi_lips
       FOR ALL ENTRIES IN gi_caufv
       WHERE vbeln IN so_vbeln
         AND vgbel = gi_caufv-kdauf.
        

Now Report is taking Few Second to Execute.

Thanks Again.

I got the Solution via Processing Logic in ITAB

But, Is it possible to get the Exact OBD No with SELECT statement .

Using - Database tables like LIPS or VBFA .

Hi Priya,

I tried your query to my end and found out that, if you do not use for all entries and gi_caufv-kdauf

and gi_caufv-kdpos field in your where clause the performance is considerably higher,

As I mensioned before there is no index to your where clause,

So try to get the data according to VBELN first and then delete the internal table accordingly.

Please refer to this code

if gi_caufv[] is not INITIAL.
SELECT vbeln posnr vbelv posnv " At this point it stuck and gives time out
     FROM lips INTO CORRESPONDING FIELDS OF TABLE gi_lips
       FOR ALL ENTRIES IN gi_caufv  WHERE vbelv = gi_caufv-kdauf
         AND posnv = gi_caufv-kdpos and vbeln IN so_vbeln.
endif.

This code gives timeout error for me as well, Now please refer the other code

SELECT vbeln posnr vbelv posnv    FROM lips
      INTO CORRESPONDING FIELDS OF TABLE gi_lips
       FOR ALL ENTRIES IN gi_caufv
       WHERE vbeln IN so_vbeln.

Thanks,

Anmol.

Hi Priya,

SELECT vbeln posnr vbelv posnv " At this point it stuck and gives time out
     FROM lips
      INTO TABLE gi_lips
       FOR ALL ENTRIES IN gi_caufv
       WHERE vbelv = gi_caufv-kdauf
         AND posnv = gi_caufv-kdpos
         AND vbeln IN so_vbeln.

I don't know your exact requirement where you are putting such type of condition.

if so_vbeln range or select option variable is empty . That case it will gives timeout error and it is feasiable most probably.

In this condition it read whole table for all entries where condition is consider and there where is not secondary index for it alos.

1) read data from table lips using the vbeln

2) after reading data into internal table filter data with internal table gi_caufv i.e. Delete rest of entries from internal table lips.

but must be mind that so_vbeln should not be initial.

I think this will gives better performance.