Pick Values from SINGLE FIELD

[Former Member]

Dear All,

I want to Pick the data in MAKTX field from MAKT table. So Plzz tell me if I can use "READ" statement or "SELECT SINGLE". And I am using this in a loop & endloop. Suggest me what would be the correct statement.

Thanks.

Regards.

Farooq

[Former Member]

Hello,

Better use for all entries instead of LOOPL-ENDLOOP.

SELECT * FROM MARA INTO TABLE ITAB WHERE MATNR IN SO_MATNR.

IF NOT ITAB[] IS INTIAL.

SELECT * from MAKT INTO ITAB1 FOR ALL ENTRIES IN ITAB

WHERE MATNR = ITAB-MATNR

AND SORAS = SY-LANGU.

If useful reward.

Vasanth

[Former Member]

Hi Farooq,

i do it like this:

SELECT SINGLE * FROM MAKT WHERE MATNR = MARA-MATNR

AND SPRAS = SY-LANGU.

*

and it works OK.

Regards, Dieter

[Former Member]

hi,

loop at itab.

select single maktx into v_maktx from makt

<b>where matnr = itab-matnr

and spras = 'E'.</b>

modify itab ..transporting v_maktx index sy-tabix.

endloop.

u can do this way ..

regards,

vijay

[Former Member]

Hi Farooq,

here a short information of the Docu of READ:

READ - Read a database table

Basic form

READ TABLE dbtab.

Extras:

1. ... SEARCH FKEQ

2. ... SEARCH FKGE

3. ... SEARCH GKEQ

4. ... SEARCH GKGE

5. ... WITH KEY key

6. ... VERSION vers

Note

<b>This variant is no longer maintained and should therefore not be used

(see also obsolete statements). Please use a SELECT (SINGLE) statement instead.</b>

Regards, Dieter

[Former Member]

ok