Skip to Content
0
Former Member
Dec 05, 2008 at 02:29 PM

Problem Data Selection

19 Views

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?