topic Re: QUERY REGARDING A STATEMENT in Application Development and Automation Discussions

QUERY REGARDING A STATEMENT

Former Member — Fri, 15 Jun 2007 14:25:07 GMT

SELECT vbeln

fkimg

INTO TABLE i_fkimg

FROM vbrp

FOR ALL ENTRIES IN invtab1

WHERE vbrp~vbeln = invtab1-vbeln

AND vbrp~pstyv = 'TAQ'.

I AM RUNNING THIS QUERY BUT WHAT IT IS DOING IS THAT IN CASE FOR AN ORDER IF FOR TWO CONSECUTIVE LINE ITEMS IF THE VALUE OF FKIMG IS SAME

ITS IS PICKING ONLY ONE VALUE OUT OF THE TWO

I JUST WANTED TO KNOW WHETHER ITS IS DUE TO THE PARTNER FUNCTION(~) THAT WE ARE USING OR SOME OTHER ISSUE.

BECAUSE I NEED ALL THE VALUES.

Re: QUERY REGARDING A STATEMENT

Former Member — Fri, 15 Jun 2007 14:28:30 GMT

Yes - FOR ALL ENTRIES eliminates duplicates.

You can avoid this by adding posnr to your internal table.

Rob

Message was edited by:

Rob Burbank

Re: QUERY REGARDING A STATEMENT

Former Member — Fri, 15 Jun 2007 14:30:00 GMT

Hello,

This is due to the error in the select query.

Whenever u use the for all entries u need to select all the key fields table.

This is the prerequiste of the FOR ALL ENTRIES

Check this.


SELECT vbeln posnr " Check here
fkimg
INTO TABLE i_fkimg
FROM vbrp
FOR ALL ENTRIES IN invtab1
WHERE vbrp~vbeln = invtab1-vbeln
AND vbrp~pstyv = 'TAQ'.

Vasanth

Re: QUERY REGARDING A STATEMENT

Former Member — Fri, 15 Jun 2007 14:30:35 GMT

means its due to FOR ALL ENTRIES it is not taking duplicate values not due to the partner function.

am i getting you correctly.??

if thats the case then my problem is solved..:)

Re: QUERY REGARDING A STATEMENT

Former Member — Fri, 15 Jun 2007 14:31:45 GMT

Hi,

3 major drawbacks of the "for all entries" clause:

1. duplicate rows are automatically removed

2. if the itab used in the clause is empty , all the rows in the source table will be selected .

3. performance degradation when using the clause on big tables.

So you need to use the Joins instead of the For all entries

Regards

Sudheer

Re: QUERY REGARDING A STATEMENT

Former Member — Fri, 15 Jun 2007 14:59:45 GMT

Change ur code like this

SELECT vbeln

fkimg

INTO TABLE i_fkimg

FROM vbrp

FOR ALL ENTRIES IN invtab1

WHERE vbeln = invtab1-vbeln

AND pstyv = 'TAQ'.

Reward me if its helpful

Regards

Ravi

Re: QUERY REGARDING A STATEMENT

Former Member — Fri, 15 Jun 2007 15:08:18 GMT

I don't see how partner function is relevant here at all.

Rob