Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

inner join

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

12 REPLIES 12

Former Member
0 Kudos

Hi,

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

Thanks,

Naren

0 Kudos

hi naren

yes please

Thanks

0 Kudos

Hi

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

Thanks

vijaya

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi,

What is the error you are getting..

Thanks,

Naren

0 Kudos

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

Former Member
0 Kudos

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

0 Kudos

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

Former Member
0 Kudos

Hi,

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

Thanks,

Naren

0 Kudos

p_vijji@yahoo.com

Former Member
0 Kudos

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

0 Kudos

Hi naren

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

Regards

vijaya