topic Re: Problem Data Selection in Application Development and Automation Discussions

Problem Data Selection

Former Member — Fri, 05 Dec 2008 14:29:10 GMT

Hi Experts,

I have one query. I have unique sales order in my table ITAB. Now my requirement is to find out the partner function SP & SH for all sales order available in ITAB.

For partner function I have appended both partner function in one range table having 2 values as above mentioned.

I wrote the below logic

LOOP AT ITAB INTO WA.

SELECT * FROM VBPA INTO CORRESPONDING FIELDS OF TABLE JTAB WHERE VBELN = WA-VBELN AND PARVW IN R_PARVW.

ENDLOOP.

I have checked the database table VBPA having entries for both partner function. But still after the loop I am getting only one value in internal table JTAB.

Any suggestion pls?

Re: Problem Data Selection

Former Member — Fri, 05 Dec 2008 14:33:57 GMT

Hii

Use this code:

Select * from VBPA into table JTAB for all entries in ITAB

where vbeln = it_vbeln and parvw in r_parvw.

This'll give you all the delivery num & partners

Cheers

RAvish

PS: Never use a select query inside a loop unless unavoidable.

Re: Problem Data Selection

Former Member — Fri, 05 Dec 2008 14:39:29 GMT

When you do Select ... into table .. statement, your internal table is refreshed for every statement, so it will have the results from just the last execution. thats the reason you are getting one entry as you are in a loop here.

Look at the answer above, and fix it./

Re: Problem Data Selection

Former Member — Fri, 05 Dec 2008 14:45:08 GMT

HI,

Instead of writing select in the loop try this way

SELECT * FROM VBPA INTO CORRESPONDING FIELDS OF TABLE JTAB

FOR ALL ENTRIES IN ITAB

WHERE VBELN = ITAB-VBELN AND PARVW IN R_PARVW

Re: Problem Data Selection

Former Member — Fri, 05 Dec 2008 14:50:18 GMT

Hi Neha,

I think you need to consider POSNR while selecting from VBPA table, then you can see more than one entry in the internal table for partner functions.

LOOP AT ITAB INTO WA.

SELECT * FROM VBPA INTO CORRESPONDING FIELDS OF TABLE JTAB WHERE VBELN = WA-VBELN and posnr = wa-posnr AND PARVW IN R_PARVW.

ENDLOOP.

Hope this helps

-Sujatha