SELECT with and without for all entries giving different results

[former_member215563]

Hi All,

For some reason unknown to me ,

There is a difference in result between the below mentioned query however the logic is same.

1 .  lw_ebeln-EBELN = '0000366416'.

     APPEND lw_ebeln to lt_ebeln. 

      SELECT    ebeln

     FROM     ekbe

     INTO TABLE lt_ekbe

     FOR ALL ENTRIES IN lt_ebeln

     WHERE ebeln = lt_ebeln-ebeln

2. SELECT ebeln from ekbe into table lt_ekbe where

ebeln = '0000366416'..

I have tried a lot to find the reason but unable to.

Thanks,

Faiz

[PeterJonker]

So what is the result in both cases ? What is the difference

I guess this is pseudo code because otherwise it would not make much sense.

The result will always be a table with only  '0000366416' so I am wondering which result you are getting.

Is your Lw_ebeln-ebeln of type EBELN ? And how did you define table LT_EKBE ?

[raymond_giuseppi]

Read more carefully documentation for FOR ALL ENTRIES (look for word "duplicate")

(As a rule, for ALL ENTRIES, try to extract the whole primary key)

Regards,

Raymond

[FredericGirod]

Hi,

it's an know issue explain in the doc :

"Rows that appear in duplicate are removed from the result set automatically"

try in your example to add the EBELP value

regards

Fred

[VenkatRamesh_V]

Hi faizur,

Hope it help ful.

If you add the EBELP in Internal table,  you will be getting same number of entries in both query.

For all entries Removes the Duplicate key.

Regards,

Venkat.