topic Re: Pick Values from SINGLE FIELD in Application Development and Automation Discussions

Pick Values from SINGLE FIELD

Former Member — Wed, 08 Nov 2006 09:17:53 GMT

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

Re: Pick Values from SINGLE FIELD

Former Member — Wed, 08 Nov 2006 09:20:55 GMT

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

Re: Pick Values from SINGLE FIELD

Former Member — Wed, 08 Nov 2006 09:21:49 GMT

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

Re: Pick Values from SINGLE FIELD

Former Member — Wed, 08 Nov 2006 09:21:56 GMT

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

Re: Pick Values from SINGLE FIELD

Former Member — Wed, 08 Nov 2006 09:27:42 GMT

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

Re: Pick Values from SINGLE FIELD

Former Member — Mon, 27 Nov 2006 09:57:38 GMT