Skip to Content
0
Former Member
Apr 13, 2007 at 05:01 AM

solve this logic

13 Views

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