topic Re: inner join in Application Development and Automation Discussions

inner join

Former Member — Sun, 15 Oct 2006 19:55:13 GMT

Hi all

CAn anybody please help me how to create inner join in se11..i know how to do it from se38..i want from se11..

Thanks and Regards.

vijaya

Re: inner join

Former Member — Sun, 15 Oct 2006 19:57:29 GMT

Hi,

Do you want to create a view in SE11 for two tables..Is that your requirement??

Thanks,

Naren

Re: inner join

Former Member — Sun, 15 Oct 2006 20:09:48 GMT

hi naren

yes please

Thanks

Re: inner join

Former Member — Sun, 15 Oct 2006 20:16:34 GMT

Hi,

Check this example..

GO TO SE11

Select the view button and give the name Z_TEST_VIEW..

Select the database view..

Then press enter..

Give the short text...

In the Tables...Give VBAK , VBAP..

In the Join conditions..

TABLE FIELDNAME = TABLE FIELDNAME

VBAK MANDT = VBAP MANDT

VBAK VBELN = VBAP VBELN

Then go to the view fields...

View field Tablename Fieldname

VBELN VBAP VBELN

POSNR VBAP POSNR

Then activate the view...

Check this documentation for details..

http://help.sap.com/saphelp_46c/helpdata/EN/cf/21ec5d446011d189700000e8322d00/frameset.htm

Thanks,

Naren

Re: inner join

Former Member — Sun, 15 Oct 2006 20:29:13 GMT

That doesnt work..its giving me some errors...

Thanks

vijaya

Re: inner join

Former Member — Sun, 15 Oct 2006 20:30:03 GMT

Hi,

What is the error you are getting..

Thanks,

Naren

Re: inner join

Former Member — Sun, 15 Oct 2006 20:35:26 GMT

The view ignores client dependancy of the base tables

all fields r evaluated as key fields

selection condition not permitted for the client

field vbak-mandt(type conflict in selection condition)

operator is nto allowed in selection condition.

type vbal-vbeln (type conflict in selection condition)

link the selection condition with AND or OR

Re: inner join

Former Member — Sun, 15 Oct 2006 20:38:31 GMT

Hi,

I tried this example..It is working fine for me..Are you giving any additional selection conditions in the Selection conditions tab..

Thanks,

Naren

Re: inner join

Former Member — Sun, 15 Oct 2006 20:40:10 GMT

HI naren

I did exactly what u gave...even i tried this with other example and some problem with it...its bugging me from morning..

Thanks and regards

vijaya

Re: inner join

Former Member — Sun, 15 Oct 2006 20:44:35 GMT

Hi,

Send me your email id ..I will send you a document with screen shots..

Thanks,

Naren

Re: inner join

Former Member — Sun, 15 Oct 2006 20:46:14 GMT

p_vijji@yahoo.com

Re: inner join

Former Member — Sun, 15 Oct 2006 21:00:49 GMT

Hi,

I have sent you the document..But there is slight change..

In the Table/join conditions tab screen short..

In the second line of the join conditions section..

Give VBAK instead of VBAP in the Table column to make the join condition work correctly..

Please let me know if it is not clear..I will re-send the document for you..

Thanks,

Naren

Message was edited by: Narendran Muthukumaran

Re: inner join

Former Member — Sun, 15 Oct 2006 21:07:46 GMT

Hi naren

Thats working fine...when i got some errors i didnt ignore them..there went wrong..thanks once again

Regards

vijaya