topic Re: solve this logic in Application Development and Automation Discussions

solve this logic

Former Member — Fri, 13 Apr 2007 05:01:33 GMT

Here for single field iam taking internal table , for this i need just

one variable to store this internal table field instead of internal table.

Please send me that variable logic for following shown logic.

Tables LTAP.

DATA: BEGIN OF it_vbeln occurs 0,

wdno like ltap-vbeln,

END OF it_vbeln.

SELECT SINGLE vbeln INTO it_vbeln

FROM LTAP

WHERE tanum = tonumber

AND lgnum = w_lgnum.

After that iam passing that internal table (now i need that defined variable pased here)to retrieve data in this loop.

by See 'WHERE vbeln = it_vbeln-wdno'.

Here i need that defined variable. Please do this , remaining part is ok.

LOOP AT it_vbeln.

SELECT SINGLE kunnr "$05

INTO it_behdr-kunnr

FROM VBPA

WHERE vbeln = it_vbeln-wdno

AND PARVW = 'AG'. "$05

SELECT SINGLE adrnr "$05

INTO addr FROM Kna1

WHERE kunnr = it_behdr-kunnr. "$05

SELECT SINGLE name1 name2 name3 street house_num1 str_suppl1 "$05

str_suppl2 city1 post_code1

INTO (w_cname4, w_cname5, w_cname6, w_cstreet1,w_chouse_num2,

w_cstr_suppl3, w_cstr_suppl4, w_ccity2, w_cpost_code2)

FROM adrc

WHERE addrnumber = addr.

ENDLOOP.

*********************

Please change my logic as i mentioned.

Thanks

Re: solve this logic

Former Member — Fri, 13 Apr 2007 05:04:35 GMT

Hi....

i think here there is no need of internal table because you are retrieving a single value in select statement..

and remove loop statement..

write like this.....

Tables LTAP.

DATA: BEGIN OF it_vbeln, "occurs 0,

wdno like ltap-vbeln,

END OF it_vbeln.

SELECT SINGLE vbeln INTO it_vbeln-wdno

FROM LTAP

WHERE tanum = tonumber

AND lgnum = w_lgnum.

********************************************

After that iam passing that internal table (now i need that defined variable pased here)to retrieve data in this loop.

by See 'WHERE vbeln = it_vbeln-wdno'.

Here i need that defined variable. Please do this , remaining part is ok.

****************************

*LOOP AT it_vbeln.

SELECT SINGLE kunnr "$05

INTO it_behdr-kunnr

FROM VBPA

WHERE vbeln = it_vbeln-wdno

AND PARVW = 'AG'. "$05

SELECT SINGLE adrnr "$05

INTO addr FROM Kna1

WHERE kunnr = it_behdr-kunnr. "$05

SELECT SINGLE name1 name2 name3 street house_num1 str_suppl1 "$05

str_suppl2 city1 post_code1

INTO (w_cname4, w_cname5, w_cname6, w_cstreet1,w_chouse_num2,

w_cstr_suppl3, w_cstr_suppl4, w_ccity2, w_cpost_code2)

FROM adrc

WHERE addrnumber = addr.

*ENDLOOP.

Hope it helps you...

Let me know if u have any more doubt...

Reward points if useful......

Suresh.......

Re: solve this logic

Former Member — Fri, 13 Apr 2007 05:06:04 GMT

Hi,

Check the changes marked in bold..

Tables LTAP.

DATA: BEGIN OF it_vbeln, " Removed the occurs 0.

wdno like ltap-vbeln,

END OF it_vbeln.

SELECT SINGLE vbeln INTO it_vbeln

FROM LTAP

WHERE tanum = tonumber

AND lgnum = w_lgnum.

After that iam passing that internal table (now i need that defined variable pased here)to retrieve data in this loop.

by See 'WHERE vbeln = it_vbeln-wdno'.

Here i need that defined variable. Please do this , remaining part is ok.

* Removed the LOOP AT

SELECT SINGLE kunnr "$05

INTO it_behdr-kunnr

FROM VBPA

WHERE vbeln = it_vbeln-wdno

AND PARVW = 'AG'. "$05

SELECT SINGLE adrnr "$05

INTO addr FROM Kna1

WHERE kunnr = it_behdr-kunnr. "$05

SELECT SINGLE name1 name2 name3 street house_num1 str_suppl1 "$05

str_suppl2 city1 post_code1

INTO (w_cname4, w_cname5, w_cname6, w_cstreet1,w_chouse_num2,

w_cstr_suppl3, w_cstr_suppl4, w_ccity2, w_cpost_code2)

FROM adrc

WHERE addrnumber = addr.

REmoved the ENDLOOP.

Thanks,

Naren

Re: solve this logic

Former Member — Fri, 13 Apr 2007 05:06:20 GMT

Hi,

data: v_vbeln like vbap-vbeln, v_kunnr(10).

SELECT SINGLE vbeln INTO v_vbeln

FROM LTAP

WHERE tanum = tonumber

AND lgnum = w_lgnum.

remove the LOOP..endloop

SELECT SINGLE kunnr "$05

INTO v_kunnrFROM VBPA

WHERE vbeln = v_vbeln

AND PARVW = 'AG'. "$05

SELECT SINGLE adrnr "$05

INTO addr FROM Kna1

WHERE kunnr = v_kunnr. "$05

SELECT SINGLE name1 name2 name3 street house_num1 str_suppl1 "$05

str_suppl2 city1 post_code1

INTO (w_cname4, w_cname5, w_cname6, w_cstreet1,w_chouse_num2,

w_cstr_suppl3, w_cstr_suppl4, w_ccity2, w_cpost_code2)

FROM adrc

WHERE addrnumber = addr.

Dear Ali, You have asked this question so many times. but have you awarded points for the answers.

reward points for useful

answers

regards,

Anji

Re: solve this logic

Former Member — Fri, 13 Apr 2007 05:07:28 GMT

Hi ali..

SELECT SINGLE vbeln INTO it_vbeln

FROM LTAP

WHERE tanum = tonumber

AND lgnum = w_lgnum.

it will fetch u only one record...so save it in a single field ..

why r u going for loop LOOP AT it_vbeln.??

it will run only once as it has only one record...

is it clear???

ram