topic Re: for all entry in Application Development and Automation Discussions

for all entry

Former Member — Wed, 21 May 2008 12:38:20 GMT

1. how can i get the duplicate data while using on for all entry?

Re: for all entry

Former Member — Wed, 21 May 2008 12:58:31 GMT

Maybe a query like this:

select field from table into corresponding fields of i_table group by field having count( * ) > 1.

Re: for all entry

Former Member — Wed, 21 May 2008 13:00:20 GMT

Hi Chakri,

When you use FOR ALL ENTRIES syntax, the data is fetched based on the data stored in the first internal table, on which you write , IF NOT INITIAL condiiton.

I general, FOR ALL ENTRIES does not fetch duplicate entries, so it is better to opt for writing seperate SELECT stmts. to fetch the data as per your requirement.

Hope this is helpful to you. If you need further information, revert back.

Reward all the helpful answers.

Regards

Nagaraj T

Re: for all entry

Former Member — Wed, 21 May 2008 15:20:06 GMT

hi,

say if the source table has duplicate entries:

if you dont delete the duplicates and use it in for all entries to fetch data, ex. 1 occurs twice, the same data will be fetched twice. same is the case for 3 too. if u delete the duplicates, only once the matching data will be fetched.

regards,

madhu

Re: for all entry

Former Member — Thu, 22 May 2008 00:22:15 GMT

For ALL ENTRIES doesnt give u a duplicate data depending on the selected tables. If it is so you can use

DELETE ADJACENT DUPLICATES FROM it_table.

Re: for all entry

chaiphon — Thu, 22 May 2008 19:13:42 GMT

For all entries in select statement always deletes duplicates data in result internal table comparing all fields.

Therefore, If you want some duplicates data in some fields, I suggest you to get all key fields of the selected table into your internal table then you will get duplicates data you want.

Regards,

Chaiphon Pulnitiporn

Re: for all entry

Former Member — Fri, 23 May 2008 06:44:17 GMT

Please ask your question properly, the database table can not have duplicates, because the primary key MUST be unique. If you select which

FOR ALL ENTRIES with Select * or Select primary key, then you get everything there is nothing missing.

But the FAE is a select´distinct, if you have a field list with less fields, such that you woould get duplicates, then they will disappear from the result table.

=> choose your field list properly

Siegfried

Re: for all entry

Former Member — Tue, 27 May 2008 08:35:44 GMT

let say..

if itab is the source table having 2 same data

then whiling joining by for all entries at that time the data will fetch from the source is default one or first one

that is why u can avoid the duplicacy.

if u want to populate duplicate value then use innre join.

thanks

sachhi

Re: for all entry

Former Member — Tue, 03 Jun 2008 17:10:56 GMT

Hi,

If you want to have duplicate data with For all entries

you must avoid to select key field in the select statement.

because of For all entries will removed duplicates data from the current select statement

Cheers

Wiparat