topic Re: Read stmt problem in ECC 6.0 in Application Development and Automation Discussions

Read stmt problem in ECC 6.0

Former Member — Tue, 26 Aug 2008 20:45:21 GMT

My read stmt is not working in ECC 6.0

READ TABLE gt_zadi_matnr_conv WITH KEY

mandt = sy-mandt zadi_key_type = 'WERKS'

zadi_key_value = gs_zadi_m_2017_gm02-plant BINARY SEARCH.

Re: Read stmt problem in ECC 6.0

RichHeilman — Tue, 26 Aug 2008 20:48:48 GMT

Pretty sure you don't need the MANDT in there, but not sure that is causing your problem. Do you mean you are getting a syntax error? What is the error? Or is it simply not returning anything?

READ TABLE gt_zadi_matnr_conv WITH KEY
                         zadi_key_type  = 'WERKS'      "<--- is this value correct?
                         zadi_key_value = gs_zadi_m_2017_gm02-plant
                                                        BINARY SEARCH.
if sy-subrc = 0.
...
endif.

Regards,

Rich Heilman

Re: Read stmt problem in ECC 6.0

Former Member — Tue, 26 Aug 2008 20:51:34 GMT

I am getting sy-subrc = 4.

Re: Read stmt problem in ECC 6.0

Former Member — Tue, 26 Aug 2008 20:53:35 GMT

Is gs_zadi_m_2017_gm02 a table with Header line?

Can you post the code for the entire loop where you are performing this read?

Re: Read stmt problem in ECC 6.0

Former Member — Tue, 26 Aug 2008 20:59:17 GMT

SORT gt_zadi_matnr_conv BY zadi_key_value.

LOOP AT gt_zadi_m_2017_gm02 INTO gs_zadi_m_2017_gm02.

READ TABLE gt_zadi_matnr_conv WITH KEY zadi_key_type = 'WERKS'

zadi_key_value = gs_zadi_m_2017_gm02-plant BINARY SEARCH.

IF sy-subrc = 0 .

gv_reebok_monitor = 'X'.

PERFORM convert_number_rbk_vs_adi USING gs_zadi_m_2017_gm02-plant

gs_zadi_m_2017_gm02-material

CHANGING gs_zadi_m_2017_gm02-material.

ENDIF.

Ihave commented sort stmt like

SORT gt_zadi_matnr_conv BY zadi_key_value.

Now my code is working ..

Now my doubt is Can I comment my sort ?????????

Or is there any issu ue?

If so please suggest me what to do ?

Re: Read stmt problem in ECC 6.0

Former Member — Tue, 26 Aug 2008 21:04:01 GMT

For using binnary search option you have to sort the table first with the same key. Did you try:


SORT gt_zadi_matnr_conv BY zadi_key_type zadi_key_value.

Re: Read stmt problem in ECC 6.0

Former Member — Tue, 26 Aug 2008 21:16:04 GMT

Hi,

If you are using BINARY SEARCH, then please use SORT on the fields which are getting used in the READ STATEMENT WITH KEY, else it will be huge performance issue.

SORT will sought out your problem.

Thanks,

Kartavya.

Re: Read stmt problem in ECC 6.0

Former Member — Tue, 26 Aug 2008 21:50:01 GMT

Aparna Sekahar and Karthavaya THANK S FOR YOUR TIMELY REPLY.....!