How to use where clause

[Former Member]

Hello,

I am using sapnwrfc for perl to get few information about SAP system. To get the Applications pruning on SAP system i need to use two tables DF14AVD and DF14T to get Application Name and Description. table DF14T contains description of the application.

I want to know using QUERY_TABLE how i can combined it and get desired result.

For ex. FCTR_ID is present in both the table. FCTR_ID which are present in DF14AVD table, i want to retrieve short description from DF14T .

Any idea how i can do this?

Amit

[Former Member]

Hi Amit,

Hope the following link will help you.

Thank You.

Regards,

Dhanalakshmi

[Former Member]

Hi,

You can refer to the following link.

http://help.sap.com/erp2005_ehp_04/helpdata/EN/4b/38b618068911d295300000e8353423/frameset.htm

Thank You.

Regards,

Dhanalakshmi L

[Former Member]

inner join