query exe

[Former Member]

Please check this logic, if it works or not let me know.

If it not works how it will work let me know.

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

LOOP AT it_behdr.

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. "$05

ENDLOOP.

SELECT SINGLE vbeln INTO it_vbeln "$05

FROM LTAP

WHERE tanum = tonumber

AND lgnum = w_lgnum. "$05

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

Thanks

[Former Member]

LOOP AT it_behdr.
SELECT SINGLE kunnr "[code]LOOP AT it_behdr.
SELECT SINGLE kunnr "$05
INTO it_behdr-kunnr
FROM VBPA
WHERE vbeln = it_behdr-wdno " <---------changed here
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. "$05



ENDLOOP.

SELECT SINGLE vbeln INTO v_vbeln "$05 "<---change it_vbeln to v_vbeln
FROM LTAP
WHERE tanum = tonumber
AND lgnum = w_lgnum. "$05[/code]5
INTO it_behdr-kunnr
FROM VBPA
WHERE vbeln = it_behdr-wdno " <---------changed here
AND PARVW = 'AG'. "[code]LOOP AT it_behdr.
SELECT SINGLE kunnr "$05
INTO it_behdr-kunnr
FROM VBPA
WHERE vbeln = it_behdr-wdno " <---------changed here
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. "$05



ENDLOOP.

SELECT SINGLE vbeln INTO v_vbeln "$05 "<---change it_vbeln to v_vbeln
FROM LTAP
WHERE tanum = tonumber
AND lgnum = w_lgnum. "$05[/code]5

SELECT SINGLE adrnr "[code]LOOP AT it_behdr.
SELECT SINGLE kunnr "$05
INTO it_behdr-kunnr
FROM VBPA
WHERE vbeln = it_behdr-wdno " <---------changed here
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. "$05



ENDLOOP.

SELECT SINGLE vbeln INTO v_vbeln "$05 "<---change it_vbeln to v_vbeln
FROM LTAP
WHERE tanum = tonumber
AND lgnum = w_lgnum. "$05[/code]5
INTO addr FROM Kna1
WHERE kunnr = it_behdr-kunnr. "[code]LOOP AT it_behdr.
SELECT SINGLE kunnr "$05
INTO it_behdr-kunnr
FROM VBPA
WHERE vbeln = it_behdr-wdno " <---------changed here
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. "$05



ENDLOOP.

SELECT SINGLE vbeln INTO v_vbeln "$05 "<---change it_vbeln to v_vbeln
FROM LTAP
WHERE tanum = tonumber
AND lgnum = w_lgnum. "$05[/code]5

SELECT SINGLE name1 name2 name3 street house_num1 str_suppl1 "[code]LOOP AT it_behdr.
SELECT SINGLE kunnr "$05
INTO it_behdr-kunnr
FROM VBPA
WHERE vbeln = it_behdr-wdno " <---------changed here
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. "$05



ENDLOOP.

SELECT SINGLE vbeln INTO v_vbeln "$05 "<---change it_vbeln to v_vbeln
FROM LTAP
WHERE tanum = tonumber
AND lgnum = w_lgnum. "$05[/code]5
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. "[code]LOOP AT it_behdr.
SELECT SINGLE kunnr "$05
INTO it_behdr-kunnr
FROM VBPA
WHERE vbeln = it_behdr-wdno " <---------changed here
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. "$05



ENDLOOP.

SELECT SINGLE vbeln INTO v_vbeln "$05 "<---change it_vbeln to v_vbeln
FROM LTAP
WHERE tanum = tonumber
AND lgnum = w_lgnum. "$05[/code]5



ENDLOOP.

SELECT SINGLE vbeln INTO v_vbeln "[code]LOOP AT it_behdr.
SELECT SINGLE kunnr "$05
INTO it_behdr-kunnr
FROM VBPA
WHERE vbeln = it_behdr-wdno " <---------changed here
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. "$05



ENDLOOP.

SELECT SINGLE vbeln INTO v_vbeln "$05 "<---change it_vbeln to v_vbeln
FROM LTAP
WHERE tanum = tonumber
AND lgnum = w_lgnum. "$05[/code]5 "<---change it_vbeln to v_vbeln
FROM LTAP
WHERE tanum = tonumber
AND lgnum = w_lgnum. "[code]LOOP AT it_behdr.
SELECT SINGLE kunnr "$05
INTO it_behdr-kunnr
FROM VBPA
WHERE vbeln = it_behdr-wdno " <---------changed here
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. "$05



ENDLOOP.

SELECT SINGLE vbeln INTO v_vbeln "$05 "<---change it_vbeln to v_vbeln
FROM LTAP
WHERE tanum = tonumber
AND lgnum = w_lgnum. "$05[/code]5