topic Re: read statement - behaving diffrently in development and prodution in Application Development and Automation Discussions

read statement - behaving diffrently in development and prodution

Former Member — Mon, 08 Aug 2011 09:11:03 GMT

Dear friend,

 LOOP AT IT_DATA INTO WA_DATA.
       READ TABLE IT_BKPF INTO WA_BKPF---------------------------------------------------------------
                          WITH KEY BUKRS = WA_DATA-BUKRS
                                   GJAHR = WA_DATA-GJAHR
                                   BELNR = WA_DATA-BELNR BINARY SEARCH.
       IF SY-SUBRC = 0.
         WA_DATA-STGRD = WA_BKPF-STGRD.
         MODIFY IT_DATA FROM WA_DATA TRANSPORTING STGRD.
       ENDIF.

       CLEAR : WA_DATA, WA_BKPF.
     ENDLOOP.

piece code of my program, the most strange thing it working proper in devlopment ,but not in prodution

where i made big line(-------) in that work area data not coming when the cursor on sy-subrc.

kindly help me out

victor ezaaz

Edited by: Matt on Aug 8, 2011 1:20 PM added tags

Re: read statement - behaving diffrently in development and prodution

Former Member — Mon, 08 Aug 2011 09:16:12 GMT

Hi,

Hi, i have faced the issue several times.

This issue is because of the use of binary search.You can remove it and test,Should work fine.

Re: read statement - behaving diffrently in development and prodution

deepak_dhamat — Mon, 08 Aug 2011 09:23:40 GMT

Hi ,

LOOP AT IT_DATA INTO WA_DATA.
READ TABLE IT_BKPF INTO WA_BKPF---------------------------------------------------------------
WITH KEY BUKRS = WA_DATA-BUKRS
GJAHR = WA_DATA-GJAHR
BELNR = WA_DATA-BELNR BINARY SEARCH.
IF SY-SUBRC = 0.
WA_DATA-STGRD = WA_BKPF-STGRD.
MODIFY IT_DATA FROM WA_DATA TRANSPORTING STGRD.
ENDIF.

CLEAR : WA_DATA, WA_BKPF.
ENDLOOP.

in above code you have used work area WA_DATA . Please check which table you have assigned while creating wa_data whether thay have same no of fields and order in Production and Development .

regards

Deepak.

Re: read statement - behaving diffrently in development and prodution

former_member404244 — Mon, 08 Aug 2011 09:24:25 GMT

Hi,

Before using binary search .. hope you have sorted your internal table.

You need to sort the internal table before using read statment..Binary search.

Regards,

Nagaraj

Re: read statement - behaving diffrently in development and prodution

deepak_dhamat — Mon, 08 Aug 2011 09:28:07 GMT

Hi ,

Yes Nagarajan is right .

regards

Deepak.

Re: read statement - behaving diffrently in development and prodution

Former Member — Mon, 08 Aug 2011 10:57:03 GMT

Firstly sort your internal table to read any table using binary search. above answer is correct

Re: read statement - behaving diffrently in development and prodution

Former Member — Mon, 08 Aug 2011 11:13:40 GMT

You should Sort the internal table BY BURKS....it will be fine then...

Re: read statement - behaving diffrently in development and prodution

Former Member — Mon, 08 Aug 2011 11:14:16 GMT

Hi Victor,

I too faced same issue and this is because of BINARY SEARCH keyword.

And sy-subrc values are set to 6 or 8.

so just remove Keyword BINARY SEARCH where ever you have used them and then move to productiona and run again.

Dep

Re: read statement - behaving diffrently in development and prodution

matt — Mon, 08 Aug 2011 11:21:56 GMT

Anyone else wishing to suggest sorting before using Binary Search?

Re: read statement - behaving diffrently in development and prodution

Former Member — Mon, 08 Aug 2011 14:18:26 GMT

Anybody else want to suggest removing the binary saearch?

Rob

Re: read statement - behaving diffrently in development and prodution

Former Member — Mon, 08 Aug 2011 15:20:01 GMT


Anyone else wishing to suggest sorting before using Binary Search?

if I may add : use F1 help on READ statement...

Re: read statement - behaving diffrently in development and prodution

Former Member — Mon, 08 Aug 2011 15:54:06 GMT

Every one will suggest

SORT IT_BKPF BY BUKRS GJAHR BELNR.

That is the basic rule of BINARY SEARCH.

The fields which are used for binary search must be sorted.

Don't ever remove it will affect your performance as it will flow linear search

Thanks

Hariharan.

Re: read statement - behaving diffrently in development and prodution

matt — Mon, 08 Aug 2011 16:08:08 GMT

Of course you remove it. Design your program correctly, and you'll never* need to use it. SORTED/HASHED tables anyone? I haven't used binary search in years.

*well, hardly ever.

Re: read statement - behaving diffrently in development and prodution

Former Member — Mon, 08 Aug 2011 17:11:13 GMT

IF YOU USE SORTED/HASHED TABLE NO NEED TO USE BINARY SEARCH . AS WE KNOW BOTH FOLLOW BINARY SEARCH .

THANKS MATT .

THANKS

HARIHARAN.

Re: read statement - behaving diffrently in development and prodution

Former Member — Mon, 26 Sep 2011 12:09:40 GMT

Thanks nagrajan

Regards

Victor