creating a view

[Former Member]

Hi,

I'm trying to create a view, but i've got a few questions :

1) can we use outer join in a view ?

I'm using table QMEL with the table AUFK for example.

and i want to have all the notifications, even those with no order attached to them.

2) can we use a table twice ? for example :

i'm using the table JEST with the table TJ30T to get the user status of a notification,

can i use another table JEST but this time with the table TJ02T to get the system status of a notification ?

Thank's

Mayaa

[Former Member]

Hi,

1. You can use Views in Join Conditions

2. You can write a Join condiiton for JEST with the table TJ30T

3. You can write a Join condiiton for JEST with the table TJ02T separately

Not mixing with 2 nd select.

reward if useful

regards,

Anji

[Former Member]

Hi,

Thank's for your answer.

But how can i do that.

in se11 -> create view, you can only add tables and joints (inner join)

[Former Member]

Hi,

Follow the link

http://help.sap.com/saphelp_nw04s/helpdata/en/ee/1c5be2eba711d4aa2800a0c9430730/frameset.htm

reward with points.