topic Re: Unable to retrieve data in Application Development and Automation Discussions

Unable to retrieve data

Former Member — Wed, 12 Jun 2013 12:24:10 GMT

hi,

LOOP AT itab.
    IF itab-fkart = 'ZIV'.
      SELECT SINGLE name1 INTO name12 FROM kna1 WHERE kunnr = itab-kunag.
      MODIFY itab TRANSPORTING name12.
    ENDIF.
ENDLOOP.

But I am unable to get name1.

Regards

kalpana

Re: Unable to retrieve data

Former Member — Wed, 12 Jun 2013 13:12:12 GMT

Please put a break inside the if and verify that there is a successful call of the select.

Neal

Re: Unable to retrieve data

Former Member — Wed, 12 Jun 2013 13:16:24 GMT

Hi,

Debug and see whether select is successful or not.

Also i assume itab is an internal table with header line, if not use this

modify <internal table> from <work area> transporting <field>

BR,

Ankit.

Re: Unable to retrieve data

Former Member — Wed, 12 Jun 2013 13:18:35 GMT

Hi Kalpana,

Use CONVERSION_EXIT_ALPHA_INPUT for Kunnr ... if you have populated it some times it looses its conversion.

Re: Unable to retrieve data

Former Member — Wed, 12 Jun 2013 14:02:36 GMT

SELECT SINGLE name1 INTO itab-name12 FROM kna1 WHERE kunnr = itab-kunag.

Re: Unable to retrieve data

former_member188827 — Wed, 12 Jun 2013 14:54:00 GMT

in the into clause use itan-name12 instead of name12.

LOOP AT itab.
    IF itab-fkart = 'ZIV'.
      SELECT SINGLE name1 INTO itab-name12 FROM kna1 WHERE kunnr = itab-kunag.
      MODIFY itab TRANSPORTING name12.
    ENDIF.
ENDLOOP.

Re: Unable to retrieve data

Former Member — Wed, 12 Jun 2013 15:14:58 GMT

Your code should be like below;

LOOP AT itab WHERE fkart = 'ZIV'.
*Call CONV_EXIT_ALPHA_INPUT if kunag does not have leading zeros
 CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
      EXPORTING
        input  = itab-kunag
      IMPORTING
        output = itab-kunag

      SELECT SINGLE name1 INTO itab-name12 FROM kna1 WHERE kunnr = itab-kunag.
      MODIFY itab TRANSPORTING name12.
ENDLOOP.

Hope this helps. To check whether it works, you can always debug and see if the values are getting passed properly.

Regards,

Karthik

Re: Unable to retrieve data

Former Member — Sat, 29 Jun 2013 09:12:17 GMT

LOOP AT itab .
    IF itab-fkart = 'ZIV'.
      SELECT SINGLE name1 INTO wa_itab-name12 FROM kna1 WHERE kunnr = itab-kunag.
          MODIFY itab FROM wa_itab TRANSPORTING name12.

ENDIF.
ENDLOOP.

Re: Unable to retrieve data

former_member209120 — Sat, 29 Jun 2013 09:56:56 GMT

Hi Kalpana,

Try this code.

LOOP AT itab.
     IF itab-fkart = 'ZIV'.
       SELECT SINGLE name1 INTO name12 FROM kna1 WHERE kunnr = itab-kunag.
       itab-name1 = name12.
       MODIFY itab TRANSPORTING name1.
     ENDIF.
   ENDLOOP.

Re: Unable to retrieve data

Former Member — Sat, 29 Jun 2013 11:22:36 GMT

This message was moderated.

Re: Unable to retrieve data

former_member209120 — Mon, 01 Jul 2013 09:20:02 GMT

Hi Kalpana,

Your problem solved or not?

Regards,

Ramesh.T

Re: Unable to retrieve data

former_member216769 — Mon, 01 Jul 2013 11:09:13 GMT

Hi Kalpana,

In Debugger mode check the KUNAG value and also check the KNA1 table entry for KUNNR. You might need to remove leading ZERO's or might need to append leading ZERO's w.r.t data in KNA1 table before select statement. Also check the data type of variable 'name12'.

FM: CONVERSION_EXIT_ALPHA_INPUT (to add leading zeros)

FM: CONVERSION_EXIT_ALPHA_OUTPUT(to remove leading zeros)

Try the below code:

DATA: name12 type KNA1-NAME1.

Field-Symbols: <LFS_ITAB> like line of itab.

LOOP AT itab assigning <LFS_ITAB>.
IF <LFS_ITAB>-FKART = 'ZIV'.

SELECT SINGLE name1 INTO name12 FROM kna1 WHERE kunnr = <LFS_ITAB>-kunag.

IF SY-SUBRC = 0.

<LFS_ITAB>-<your-field-name> = name12.
ENDIF.

ENDIF.

ENDLOOP.

Note: Using select query inside loop will affect your program performance. Fetch appropriate data from KNA1 before doing LOOP and then use READ TABLE inside loop.

Regards,

M Nair

Re: Unable to retrieve data

Former Member — Mon, 01 Jul 2013 12:38:57 GMT

Hi,

Looping and modifying the same table is not an good coding practice.

Select query inside the loop is not advisable.

Make sure that KUNAG and KUNNR are of same type.

data:itab1 type standard table of kunnr,

watab1 type stnadard table of kunnr.

*Conversion routine for customer

loop at itab where fkart = 'ZIV'.

        CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
           EXPORTING
                input =itab-kunag
           IMPORTING
                output = itab-kunag.

endloop.

if itab is not initial.

select name1 from kna1 into itab1

for all entries in itab where kunnr = itab-kunag

and fkart = 'ZIV'.

if sy-subrc eq 0.

loop at itab1 into watab1.

itab-name12 = watab1-name1.

MODIFY itab TRANSPORTING name12.

clear watab, itab.

endloop.

endif.

Re: Unable to retrieve data

gurunathkumar_dadamu — Mon, 01 Jul 2013 13:04:15 GMT

Hi Kalapana,

Try with the following code.

LOOP AT itab.

IF itab-fkart = 'ZIV'.

SELECT SINGLE name1 INTO name12 FROM kna1 WHERE kunnr = itab-kunag.

if sy-subrc = 0.

itab-name1 = name12.

MODIFY itab TRANSPORTING name1.

endif.

ENDIF.

ENDLOOP.

before modifying the value check sy-subrc otherwise it willl update the null values.

Regards,

Gurunath

Re: Unable to retrieve data

former_member845053 — Mon, 01 Jul 2013 18:43:38 GMT

HI Kalpana,

Try with this its always a better practise to mention the index keyword while using modify statement.

LOOP AT itab .
    IF itab-fkart = 'ZIV'.
      SELECT SINGLE name1 INTO wa_itab-name12 FROM kna1 WHERE kunnr = itab-kunag.
          MODIFY itab FROM wa_itab TRANSPORTING name12 index sy-tabix..

ENDIF.
ENDLOOP.

Regards,

Kotni Srikant

Re: Unable to retrieve data

matt — Tue, 02 Jul 2013 06:00:39 GMT

Kotni Srikant wrote:
HI Kalpana,
Try with this its always a better practise to mention the index keyword while using modify statement.

Not always good practice. What if ITAB was a hashed table?

Re: Unable to retrieve data

Former Member — Tue, 02 Jul 2013 07:27:05 GMT

Hii use this

LOOP AT itab where fkart eq 'ZIV'

clear : name12.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
           EXPORTING
                input =itab-kunag
           IMPORTING
                output = itab-kunag.

SELECT SINGLE name1 INTO name12 FROM kna1 WHERE kunnr eq itab-kunag

and spras eq SY-LANGU

MODIFY itab TRANSPORTING name12.

ENDLOOP.

Re: Unable to retrieve data

former_member845053 — Fri, 16 Jan 2015 11:15:14 GMT

Hi Mathew,

I was talking about standard internal tables not about hashed tables as we rarely used hashed table when we have huge amount of data.

Thanks,

Kotni Srikant

Re: Unable to retrieve data

Former Member — Fri, 16 Jan 2015 11:50:45 GMT

Hi,

MODIFY TABLE itab FROM wa [TRANSPORTING f1 f2 ...].

Re: Unable to retrieve data

Former Member — Fri, 16 Jan 2015 12:47:47 GMT

hi kalpana,

I think your code should be like this

LOOP AT itab.
    IF itab-fkart = 'ZIV'.
      SELECT SINGLE name1 INTO itab-name12 FROM kna1 WHERE kunnr = itab-kunag.
      MODIFY itab.
    ENDIF.
ENDLOOP.

name12 is assumed as workarea field. (itab is considered as internal table as well as workarea)