Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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..

Tags:
Former Member
Former Member replied

Hi

Refer these links:

<u>http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ec84446011d189700000e8322d00/content.htm</u>

<u>http://www.sap-img.com/abap/what-is-the-different-types-and-usage-of-views.htm</u>

<u>http://www.karakas-online.de/forum/viewtopic.php?t=730</u>

Thanks

Vasudha

Message was edited by:

Vasudha L

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question