topic sqvi in Application Development and Automation Discussions

sqvi

Former Member — Thu, 03 May 2007 06:22:45 GMT

hi experts,

In SQVI, how to do left outer join?

Wht its use?

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

Gowri

Re: sqvi

former_member632991 — Thu, 03 May 2007 06:28:53 GMT

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

Re: sqvi

Former Member — Thu, 03 May 2007 06:31:43 GMT

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^

Re: sqvi

Former Member — Thu, 03 May 2007 06:34:56 GMT

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