topic Select Statement Doubt in Application Development and Automation Discussions

Select Statement Doubt

Former Member — Fri, 28 Sep 2007 20:40:31 GMT

Hello Experts,

Please let me know after below select statement will be executed, will t_kdst table will have duplicate records. After this select statement do i need to sort the table and add delete adjacent statement?

SELECT VBELN VBPOS MATNR WERKS STLAN STLNR STLAL FROM kdst INTO CORRESPONDING FIELDS OF TABLE t_kdst

WHERE vbeln in order

and matnr in matnr

and vbpos in item

AND werks IN plant.

Regards,

Preeti

Re: Select Statement Doubt

Former Member — Fri, 28 Sep 2007 21:16:45 GMT

Hello Preeti,

Since you are selection all key fields (primary table key) you won't have duplicate entries in the internal table because the primary table key is always unique.

Only if you leave out one or more key fields on the selected fields list, you could get duplicate entries.

Regards,

Michael

Re: Select Statement Doubt

Former Member — Sat, 29 Sep 2007 06:47:15 GMT

Hi Preeti,

there won't be any duplicate records since your where claue is based on KEY fields...

so no need of sorting and adding adjacent duplicates...

hope this may be usefl...

please reward...

Regards,

Prashant

Re: Select Statement Doubt

Former Member — Sat, 29 Sep 2007 08:55:26 GMT

Preeti,

For the KDST table, a combination of 7 fields forms the primary key. In the Select query's where clause, u have taken only 4 fields of the primary key. Due to the rest of 3 fields, there is a possibility for existing of duplicate entries. Hence you have to use SORT as well as DELETE ADJACENT statement (if you are concerned about records with univque values of the where clause's 4 fields alone).

Re: Select Statement Doubt

Former Member — Sat, 29 Sep 2007 10:14:08 GMT

Hi Preeti,

As you are selecting all 7 primary keys, there is no chance of having duplicate entries in your internal table.

Each entry in the internal table would have a unique primary key combination.

Regards,

Pankaj Sharma

Re: Select Statement Doubt

Former Member — Sat, 29 Sep 2007 15:50:04 GMT

The problem is not <u>duplicate</u> entries; it is <u>missing</u> entries. But the answer is the same; if you are selecting all fields in the primary key, you will have no problem.

Rob