Query in SD

[Former Member]

Hi,

I need to link MLAN table for output table in Query. MLAN belongs to Tax classification. How can i include this to generate query for output table.

Can anyone please help on this.

Thanks & Regards,

Vamsi

[Lakshmipathi · Accepted solution]

To which table you need to link ?? Nevertheless, you can try in SQVI

thanks

G. Lakshmipathi

[Former Member]

Hi,

Thanks . Answered

[Former Member]

Hi ,

Thanks to all. But i need to link in SQ01. I need MlAN Table in sq01 to generate out puts.I didn't found MLAN ( TAX CLASSIFCATION ) . I hope i will receive feed back verysoon.

Thanks & Best Regards,

Vamsi

[Former Member]

Hi Vamsi,

SQ01 is to maintain the existing queries, believe query involving table MLAN is not there. why dont u create one using SQVI,for table MLAN and select the required output in List field selection. Hope this helps.................

Rgds,

Anitha J

[former_member217082]

Hi Vamsi

Use SQVI to add the tables and feilds .But to which table the MILAN feild is related to . Just check and add the tables and feilds to which you want to add and then execute and then you it will work

Regards

Srinath

[former_member192897]

For what table you want to link MLAN.

Create a Query in Quickviewer in SWVI and Select Table Join Function and Insert Tables MLAN and other and Make the Selection for Input and Output as per your requirement.