inner join

[Former Member]

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

[Former Member]

Hi,

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

Thanks,

Naren

[Former Member]

hi naren

yes please

Thanks

[Former Member]

Hi

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

Thanks

vijaya

[Former Member]

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]

Hi,

What is the error you are getting..

Thanks,

Naren

[Former Member]

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]

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

[Former Member]

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]

Hi,

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

Thanks,

Naren

[Former Member]

p_vijji@yahoo.com

[Former Member]

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

[Former Member]

Hi naren

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

Regards

vijaya