can we write a join on a view and a table

[Former Member]

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

[Former Member]

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

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

[former_member386202]

Hi,

Yes u can write.

Regards,

Prashant

[Former Member]

Hi Prashant

can u help me giving the condition that i have to wirte to join a view and a table.

i mean any example regarding this. so that i can have some idea about how to write it.