Help reqd for PO - Smartform....getting address to display the Street

[Former Member]

Hi abappers,

i want to print the Delivery address with all name street& pincode...in my PO form...the name of the Delivery(as in PO:me23n) is available in the <b>MT001W</b> table (DB view)...but the corresponding fields for addresses are available in <b>ADRC</b> table....so far...im displaying the name field from MT001W...

how can i match the table fields thru primary key to join the two tables of MT001W and ADRC....

FYI (coding)

*********

select name2 from MT001w into g_name2 where WERKS = g_xekpo-werks.

endselect.

if sy-subrc = 0.

*move g_name2 to g_add.

*endif.

select house_num1 street post_code1 from adrc into (g_house , g_street , g_pcode)

where name2 = g_name2 and langu = 'E'.

endselect.

endif.

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

it displaying the field text of g_name2 but not diplaying the field records from ADRC.....

Pls do the needful to solve my issue...

thanks & regards

sankar

[Former Member]

THANKS A LOT TO ALL,

HAVE DONE IT THRU TABLE T001W.

REGARDS

SANKAR