Skip to Content
avatar image
Former Member

How can we create Query by using SQVI

Hi Frendz,

I need to generate a report by using SQVI hw can i do that, i want each step wise( I dont know how to do that even begining also), Pl send reply ASAP.

Thanks

Babu Rao

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 15, 2008 at 12:39 PM

    hi babu rao,

    pl check this link where you can see working with SQVI along with screen shots.

    [SQVI|http://www.sapsecurityonline.com/tutorials/r3_sqvi_tutorial.htm]

    regards

    sadhu kishore

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 15, 2008 at 11:16 AM

    Hi

    Please use the following link to access an excellent document on ABAP Query. It explains the process step by step with the help screen shots.

    http://www.auditware.co.uk/downloads/SAPQuery_step_thru.pdf

    Thanks,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 15, 2008 at 11:20 AM

    Hi,

    In SQVI, give a name to a Query & create --> Select Tables & fields --> .....

    Regards,

    Rajesh Banka

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 15, 2008 at 11:23 AM

    Dear Babu rao

    Normally, SQVI will be used to join multiple tables. Go to SQVI and do the following:

    1) Give some description in "Quickview"

    2) Click "Create" button

    3) Give some description in "Title"

    4) From the tab "Data Source", select "Table Join" and click blue tick

    5) Press "Shift + F1"

    6) Give the table you wanted and press enter

    7) Again Press "Shift + F1"

    8) Again give the table you wanted and press enter

    9) Press F3

    10) On your left screen you can see those two tables with header "List fields" and "Selection Field"

    11) Whatever data you want to give as input, (say for example based on sales organisation, you want some report), select the white box under selection field

    12) Whatever data you want as report format, select those fields under List fields

    13) Execute the report

    thanks

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded