topic Re: Problem in Select Query in Application Development and Automation Discussions

Problem in Select Query

Former Member — Mon, 30 Dec 2013 05:33:41 GMT

Hi All ,

Can anybody tell me what is wrong in below query ?

Im getting performance issue in the below Query ....

When im trying to execute the code program is going to dump

>>>>> Select PARTNER

356 RLTYP

357 FROM BUT100 INTO TABLE IT_BUT100

358 for all entries in t_but020

359 WHERE partner eq t_but020-partner

360 and RLTYP = ''

361 OR RLTYP = 'BUP001' .

Error in Dump : You attempted to extend an internal table, but the required space was not available.

Thanks in advance

Smitha

Re: Problem in Select Query

arivazhagan_sivasamy — Mon, 30 Dec 2013 05:39:48 GMT

Hi Sumitha,

Please use like below.

Select PARTNER

356 RLTYP

357 FROM BUT100 INTO TABLE IT_BUT100

358 for all entries in t_but020

359 WHERE partner eq t_but020-partner

360 and RLTYP IN ('', 'BUP001' ).

Arivazhagan S

Re: Problem in Select Query

Arun_Prabhu_K — Mon, 30 Dec 2013 05:43:52 GMT

Hello Smitha KB.

You have to put the OR condition within brackets.

Like,

and ( RLTYP = ' ' OR RLTYP = 'BUP001' ).

Your current code will fetch all data which satisfies

EITHER

partner = t_but020-partner and RLTYP = ' '

RLTYP = 'BUP001'.

This is the reason for error.

Regards

Re: Problem in Select Query

Former Member — Mon, 30 Dec 2013 05:55:25 GMT

Use the addition into corresponding fields of

Select PARTNER

356 RLTYP

357 FROM BUT100 INTO CORRESPONDING FIELDS OF TABLE IT_BUT100

358 for all entries in t_but020

359 WHERE partner eq t_but020-partner

360 and RLTYP = ''

361 OR RLTYP = 'BUP001' .

Re: Problem in Select Query

Former Member — Mon, 30 Dec 2013 06:09:59 GMT

Check your internal table declaration..

create a structure with required fields (PARTNER, RLTYP) & after that create an internal table of that structure type.

Re: Problem in Select Query

former_member226419 — Mon, 30 Dec 2013 06:12:59 GMT

Can you tell me how many records you are getting for this condition? Seems that no of records are too much..

Re: Problem in Select Query

former_member188282 — Mon, 30 Dec 2013 06:35:37 GMT

Hi Smitha,

Can you please check how you declared your internal table IT_BUT100.

Regards,

Rajesh.B

Re: Problem in Select Query

Former Member — Mon, 30 Dec 2013 07:46:01 GMT

Hi Sumeet ,

Thanks for the reply .....

Yes number of records are more in the internal table im trying to extract records around 2 Lacks ....

Can you please let me know how to improve the performance for this issue ?

Re: Problem in Select Query

Former Member — Mon, 30 Dec 2013 07:46:39 GMT

My internal table declaration

data: begin of it_but100 occurs 0,

PARTNER like BUT100-PARTNER,

RLTYP like BUT100-RLTYP,

end of it_but100.

Re: Problem in Select Query

Former Member — Mon, 30 Dec 2013 07:54:08 GMT

Do not use occurs 0...

Create a structure & internal table.

TYPES: BEGIN OF ty_struct,

partner TYPE bu_partner,

rltyp TYPE bu_partnerrole,

END OF ty_struct.

DATA : it_but100 TYPE STANDARD TABLE OF ty_struct.

Re: Problem in Select Query

RaymondGiuseppi — Mon, 30 Dec 2013 07:57:55 GMT

Your program reached the maximal memory allowed in your system. Try to remove unnecessary fields in the internal table, or contact system administrators. (20527 - Runtime error TSV_TNEW_PAGE_ALLOC_FAILED and similar notes for more information)

Also, never forget to check that t_but020[] is not initial, as if the internal table used in FOR ALL ENTRIES condition is empty, the whole WHERE clause is ignored, so you try to load the whole database table in memory.

Regards,

Raymond

Re: Problem in Select Query

atul_mohanty — Mon, 30 Dec 2013 08:00:26 GMT

Hi-

check the NOT t_but020[] IS INITIAL

Please check the below code, it should not give you dump.

   DATA: BEGIN OF t_but020 OCCURS 0,

partner LIKE but100-partner,

END OF t_but020.

DATA: BEGIN OF it_but100 OCCURS 0,

partner LIKE but100-partner,

rltyp LIKE but100-rltyp,

END OF it_but100.

IF NOT t_but020[] IS INITIAL.

SELECT partner
          rltyp

        FROM but100 INTO TABLE it_but100

         FOR ALL ENTRIES IN t_but020

        WHERE partner EQ t_but020-partner

        AND ( rltyp = ' ' OR rltyp = 'BUP001' ).

IF sy-subrc = 0.

ENDIF.

ENDIF.

Let us know, in case it helps.

Regards,

Atul Mohanty

Re: Problem in Select Query

Former Member — Mon, 30 Dec 2013 08:14:25 GMT

Hi smitha,

Are you checking the table entries before using for all entries.

i.e, if t_but020[] is not initial .

Select PARTNER

356 RLTYP

357 FROM BUT100 INTO TABLE IT_BUT100

358 for all entries in t_but020

359 WHERE partner eq t_but020-partner

360 and RLTYP = ''

361 OR RLTYP = 'BUP001' .

endif.

Regards,

Mahesh Somanath.