topic Re: why should we select all key fields when using for all entries in Application Development and Automation Discussions

why should we select all key fields when using for all entries

Former Member — Fri, 16 Oct 2009 07:31:10 GMT

Hi,

Why should we select all key fields in our select query when using for all entries statement?

I read about for all entries but this point was not clear in any post.

Please explain me

Regards,

Subhashini

Re: why should we select all key fields when using for all entries

Former Member — Fri, 16 Oct 2009 07:34:28 GMT

there is no restriction that we should use all key fields while using for all entries.Like any other select statement ,using all key fields will increase the performance of the select statement.

Re: why should we select all key fields when using for all entries

Former Member — Fri, 16 Oct 2009 07:37:59 GMT

Hi,

We can increase the performance by using key fields in where condition but why should we select all key fields.

I mean how duplicate entries will not get deleted when we use this?

Regards,

Subhashini

Re: why should we select all key fields when using for all entries

SuhaSaha — Fri, 16 Oct 2009 07:41:06 GMT

Dear Subhasini,

It is because FOR ALL ENTRIES deletes the duplicate entries before populating the target internal table.

Please do an F1 on FOR ALL ENTRIES & read the SAP documentation.

I mean how duplicate entries will not get deleted when we use this?

Quite simple, if you select all key fields then each entry will be unique & there will not be any duplicate entries to delete !!

BR,

Suhas

Edited by: Suhas Saha on Oct 16, 2009 9:41 AM

Re: why should we select all key fields when using for all entries

Former Member — Fri, 16 Oct 2009 07:49:59 GMT

Hi Subhasini,

as suhas has already explained... FAE (for all entries) will delete the duplicate entries...

from the help itself:

> The result set of the SELECT statement is the union of the individual selections for each line of the internal table. Duplicate lines

>are automatically eliminated from the result set.

so.. is the need of including all the key elements for no duplication