Table links in SQ02

[Former Member]

Hello,

I´m trying to create a query through Tcodes SQ01, SQ02, SQ03, and when I get to SQ02 - Infoset, and it comes to the join tables section, I try to link the KNA1 and ADR6 tables (basically I want a list of customers with their proper email address). Although the fields that the system suggests me to link are ADR6-DATE_FROM and KNA1-ERDAT, when I really want to link ADR6-ADDRNUMBER and KNA1-ADRNR. In SQVI the link between the tables occur this way.

My doubt is: is that anyway that I can change the fields that I want to be linked to each other?

Regards.

[Lakshmipathi · Accepted solution]

Dear grindcardoso

Yes you can. In SQVI after giving the tables KNA1 & ADR6, by default, system will join some fields with an arrow. Place your mouse on the arrow (one thin line) and right click your mouse so that you will have the option to delete the link. Click your mouse and delete the link. Now place your mouse on the required field in KNA1 and drag your mouse to another field in ADR6. Now you can see the field will be linked.

thanks

G. Lakshmipathi

ps:- thanks to a friend in this forum from whom I have learned recently