SQL syntax from SQVI

[Former Member]

Hi all,

can we get a SQL statement from our SQVI created?

[Former Member]

This message was moderated.

[Former Member]

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