SQL syntax from SQVI

Former Member — Wed, 02 Sep 2009 01:31:49 GMT

Hi all,

can we get a SQL statement from our SQVI created?

Re: SQL syntax from SQVI

Former Member — Wed, 02 Sep 2009 02:58:34 GMT

This message was moderated.

Re: SQL syntax from SQVI

Former Member — Wed, 02 Sep 2009 05:11:53 GMT

Hi,

try in ths way,

First goto t.code

SQ03--->Create any name of User Group. its save and activated.

Second goto t.code.

SQ02-->Create any name of Infoset. its add table name or join two table name. its alignment of table name. click as save and red color circle which its infoset generated. goto main screen then click role/user group assignment find ur user group which t.code SQ03.

its save and activated and click as generated.

Third goto t.code,

SQ01-->Create any name of query from user group. click as next screen then u add table name which t.code SQ02. click as check box with ur table field. next then click as u want about SV or 1Z. which no intervals or no extensions. next click as basis list then click as check box with table field. u want which calculated with total formats. click as execute then see graphs which vertical or pie chat etc its good graphics.

Fourth goto t.code,

SQVI---->Create any name of Quick Viewer. its same as SQ01.which basis type. its used layout model. click as execute then see graph which vertical bar or horizontal bar or pie chat etc..

regards,

Archana

topic SQL syntax from SQVI in Application Development and Automation Discussions

SQL syntax from SQVI

Re: SQL syntax from SQVI

Re: SQL syntax from SQVI