plz chk the code wats wrong in it

[Former Member]

DATA : lv_gbstk TYPE c VALUE 'A'.

SELECT vbeln "order number

FROM vbuk

INTO TABLE ct_ordnsnt

FOR ALL ENTRIES IN lt_ztsd2marc

WHERE vbeln <> lt_ztsd2marc-ordnr

AND gbstk = lv_gbstk.

its taking all values of vbeln .

[Former Member]

DATA : lv_gbstk TYPE c VALUE 'A'.

SELECT vbeln "order number

FROM vbuk

INTO TABLE ct_ordnsnt

FOR ALL ENTRIES IN lt_ztsd2marc

WHERE vbeln <> lt_ztsd2marc-ordnr

AND gbstk = lv_gbstk.

its taking all values of vbeln .

[Former Member]

That means lt_ztsd2marc is empty and the second issue could be <> condition.

First check if the table is empty, the you should not use FOR ALL ENTRIES.

IF NOT lt_ztsd2marc[] IS INITIAL.

SELECT vbeln "order number
FROM vbuk
INTO TABLE ct_ordnsnt
FOR ALL ENTRIES IN lt_ztsd2marc
WHERE vbeln <> lt_ztsd2marc-ordnr
AND gbstk = lv_gbstk.

ENDIF.

Regards,

Ravi

Note - Please mark all the helpful answers

[Former Member]

hi

i mean gbstk = lv_gbstk. is not workin in the code bcz my lt_ztsd2marc is havin data.but its not pickin those gbstk whic r equal to A

[Former Member]

hi,

check if lt_ztsd2marc is empty, that is the prerequest for using for all entries.

santhosh

[Former Member]

hi,

as you are using

for all entries in itab..

check whether the previous itab is initial.

if it is initial it will select all records .

eg:

if not previous_itab[] is initial.

select query of itab....

for all entries in previous_itab

endif.

hope this helps.

Regards

Abdullah

[Former Member]

hi Neha,

if not lt_ztsd2marc[] is initial.
 SELECT vbeln "order number
FROM vbuk
INTO TABLE ct_ordnsnt
FOR ALL ENTRIES IN lt_ztsd2marc
WHERE vbeln <> lt_ztsd2marc-ordnr
AND gbstk = lv_gbstk.
endif.

Regards,

Santosh

[Former Member]

Hi Neha,

The code seems to be correct but before writing this just check weather lt_ztsd2marc has some value or not.

Thanks

Vikranth Khimavath

[Former Member]

try

SELECT vbeln "order number

FROM vbuk

INTO CORRESPONDING FIELDS OF TABLE ct_ordnsnt

FOR ALL ENTRIES IN lt_ztsd2marc

WHERE vbeln <> lt_ztsd2marc-ordnr

AND gbstk = lv_gbstk.

perhaps handy next time to include the data declarations or the errors you get with this query.

kind regards

arthur

Message was edited by:

A. de Smidt

[Former Member]

3 major drawbacks of the "for all entries" clause :

1. duplicate rows are automatically removed

2. if the itab used in the clause is empty , all the rows in the source table will be selected .

3. performance degradation when using the clause on big tables.

May be the second point is ur problem ,

but u r saying there r entries in the table , so try like this

SELECT vbeln "order number
FROM vbuk
INTO TABLE ct_ordnsnt
WHERE  gbstk = lv_gbstk.

then filter the entries using lt_ztsd2marc- table