for all entries

[Former Member]

is it possible to use like this.

data:itab....

select ..... from ... into itab for all entries in itab where....

[Former Member]

Hi ,

Not possible .

It would be endless loop .

[Former Member]

Hi kavitha,

i think its not possible.

it will give error.

use inner join instead

Regards,

Talwinder.

[Former Member]

hi,

this is not possible but cud u plz write down ur requirement.

warm regards,

sumanjeet

[Former Member]

hi,

u can do this

select ...from mara into table itab for all entries in table itab1 where .....

there u have missed into TABLE

[arpit_shah]

Hi ,

Not possible .

It would be endless loop .

[mahaboob_pathan]

Hi,

look at this once,

SELECT MARA~MATNR

MARA~ERSDA

MARC~WERKS

MARD~LGORT

INTO CORRESPONDING FIELDS OF TABLE IT_MAR

FROM ( ( MARA INNER JOIN MARC ON MARA_{MATNR = MARC}MATNR )

INNER JOIN MARD ON MARA_{MATNR = MARD}MATNR )

WHERE MARA~MATNR IN S_MATNR AND

MARA~ERSDA IN S_ERSDA AND

MARC~WERKS IN S_WERKS.

IF NOT IT_MAR[] IS INITIAL.

SORT IT_MAR.

SELECT MATNR

MAKTX

INTO CORRESPONDING FIELDS OF TABLE IT_MAK

FROM MAKT

FOR ALL ENTRIES IN IT_MAR

WHERE MATNR = IT_MAR-MATNR AND

SPRAS = SY-LANGU.

ENDIF.

DELETE ADJACENT DUPLICATES FROM IT_MAR.