Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Craeting data fiel for data from KNA1 and ADRC table...

Former Member

‎09-10-2007 2:53 PM

0 Kudos

Hi,

I want to create a data file (tab delimited) which will have data from two tables, KNA1 and ADRC. The customer number, Name1 and Name2 fields data will come from KNA1 but the Street field data will

come from ADRC table. The ADRNR number will be a linkage between two tables KNA1 and ADRC.

I don't want to write a reprot for this. Can someone tell me if I can use SQVI for this and then go to options download in excel sheet directly from the menu.

Is there any other smarter way to do it ?

Regards,

Tushar.

1 REPLY 1

former_member583013
Active Contributor

‎09-10-2007 5:47 PM

0 Kudos

Use an inner join between KNA1 and ADRC...The use <b>GUI_DOWNLOAD</b> FM to download the file...

Greetings,

Blag.