Skip to Content
avatar image
Former Member

How to use where clause

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jul 06, 2009 at 11:45 AM

    inner join

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 29, 2009 at 09:08 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 29, 2009 at 09:52 AM

    Hi Amit,

    Hope the following link will help you.

    How to use where clause for dynamic table using dynamic sel scr fields

    Thank You.

    Regards,

    Dhanalakshmi

    Add comment
    10|10000 characters needed characters exceeded