topic select statement in Application Development and Automation Discussions

select statement

Former Member — Wed, 17 Dec 2008 15:01:50 GMT

hi,

SELECT partner addrnumber FROM but020 INTO TABLE lt_adno

WHERE partner = lt_bpiddata-bottlerid.

The above select statement is removing all the duplicate values.

but i need duplicate values also.

is there any solution?

thanks in advance,

srinivas.

Re: select statement

Former Member — Wed, 17 Dec 2008 15:05:15 GMT

in this table but020 there is no dulicate entries ..

Re: select statement

Former Member — Wed, 17 Dec 2008 15:09:01 GMT

Hi,


put for all entries in select stmt 
if not lt_bpiddata[] is initial.
SELECT partner addrnumber FROM but020 INTO TABLE lt_adno 
for all entries in lt_bpiddata
WHERE partner = lt_bpiddata-bottlerid.
endif.

Thanks,

Krishna..

Re: select statement

Former Member — Wed, 17 Dec 2008 15:12:27 GMT

yes u r correct.

in my table primary key is bottler id and mat grp id.

both are partners.

and my question is

select statement removes duplicate values.

is there any syntax for the select statement so that it should not remove duplicate values.

Re: select statement

Former Member — Wed, 17 Dec 2008 15:13:28 GMT

i tried this code

i m facing the same problem.

Re: select statement

Former Member — Wed, 17 Dec 2008 15:16:41 GMT

Hi,

Put break Pt & check values coming correnct in first internal table or not.

second query is correct of for all entries..

Thanks,

Krishna..

Re: select statement

Former Member — Wed, 17 Dec 2008 15:21:38 GMT

Hi,

As far as I can see, the table but020 have 2 primary keys , i.e the PARTNER and ADDRNUMBER. Now if you select an entry using a partner only, you should get all the ADDRNUMBERS for that partner as well. So no issues with your select statement. But it is not always necessary that the each partner will have multiple addresses.

However if it does and still you not getting the duplicates, then check that there is no uniquekey defined for the internal table lt_adno.

regards,

Advait

Re: select statement

Former Member — Wed, 17 Dec 2008 15:22:18 GMT

SELECT bottler material_group FROM zsupplier INTO TABLE lt_bpiddata.

IF lt_bpiddata[] IS NOT INITIAL..

SELECT partner addrnumber FROM but020 INTO TABLE lt_adno FOR ALL ENTRIES IN lt_bpiddata WHERE partner = lt_bpiddata-bottlerid.

duplicate values are getting populated into lt_bpiddata

but it not the same with lt_adno.

Re: select statement

Former Member — Wed, 17 Dec 2008 15:22:23 GMT

Hi,

Please select both key fields in your query. Doing this you will get all the duplicate values also.

SELECT PARTNER ADDRNUMBER FROM but020

INTO TABLE lt_adno

FOR ALL ENTRIES IN lt_bpiddata

WHERE partner = lt_bpiddata-bottlerid.

Hope it helps.

Regards,

Nadim