sqvi

[Former Member]

hi experts,

In SQVI, how to do left outer join?

Wht its use?

if anyone hve the knowledge plz ......

Gowri

[former_member632991]

Hi,

With an left outer join (table 1 left outer join table2), exactly one record is included in the results. In this record, the fields from table 1 contain the values of the record from table 1 and the fields from table 2 are all filled with the initial value.

Also check these links.

http://help.sap.com/saphelp_46c/helpdata/EN/50/a71ec8f65911d296390000e82de14a/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/f1/713c3b35703079e10000000a114084/content.htm

Regards,

Sonika

[Former Member]

hi

good

go through this link,this ll give you complete idea about the SQVI.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCSRVQUE/BCSRVQU

E.pdf

THANKS

MRUTYUN^

[Former Member]

Goto Transaction sqvi... create you query there ...

- you will get a create pop-up there

• in data source drop down list ... select the table join .

• select the type of mode you want.

- select the tables on which you have to make join also the join... i.e. innner join or left outer join.... and then also check the fields you want in the output...

This transaction is basically for checking the output....

Hope that it helps.... Actually in my system for now it is giving a dump when selecting the Table join condition... you cannot help you much ...

In my suggestion do not go for join....

Regards,

Jayant

Please award if helpful