Skip to Content
author's profile photo Former Member
Former Member

can we write a join on a view and a table

Hi all,

can we write a join on a view and a table. i got the requirement from my functional people about the following one

Select CAUFV-AFUNR, CAUFV-AUART, AFVC-VORNR, CAUFV-FTRMI, CRHD-ARBPL

into <ProOrd>, <OrdTyp>, <Opt>, <RelDat>, <WorCen>

from CAUFV, AFVC, CRHD

where CAUFV-WERKS = plant in selection screen

and CAUFV-AFUNR = production order in selection screen

and CAUFV-AUART = production order type in selection screen

and CAUFV-FTRMI = range of release date in selection screen

and CAUFV-AUFPL = AFVC-AUFPL

and AFVC-ARBID = CRHD-OBJID

and CRHD-OBJTY = ‘A’

here CAUFV is a view and CRHD and AFVC are transperent tables.

please tell me any feasible solution for this..

Thanks in Advance..

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 04:24 AM
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      can any body please give me an example of how to write this.

      my requirement is like this:

      Select CAUFV-AFUNR, CAUFV-AUART, AFVC-VORNR, CAUFV-FTRMI, CRHD-ARBPL

      into <ProOrd>, <OrdTyp>, <Opt>, <RelDat>, <WorCen>

      from CAUFV, AFVC, CRHD

      where CAUFV-WERKS = plant in selection screen

      and CAUFV-AFUNR = production order in selection screen

      and CAUFV-AUART = production order type in selection screen

      and CAUFV-FTRMI = range of release date in selection screen

      and CAUFV-AUFPL = AFVC-AUFPL

      and AFVC-ARBID = CRHD-OBJID

      and CRHD-OBJTY = ‘A’

      i want the join condition so the these can be joined..

  • Posted on Dec 04, 2007 at 04:25 AM

    Hi,

    Yes u can write.

    Regards,

    Prashant

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.