Execute SQVI Query to a T-Code

[Former Member]

Dear experts

Currently I creating a query on Delivery note in QAS.

Read from other threads that I must convert it to T-Code in DEV instead of QAS.

and after I executed the report under SQVI (QAS) , go to SYSTEM -> Status-> copy the Programme name "AQFKSYSTQV000006DELIVERY======" and checked

Next, I accessed to T-code SE93 in DEV

I keyed in the my desired Transaction Code as ZDN01 and select CREATE

I keyed in the short text as " Delivery Note Detail" and Select the 2ND RADIO Button as " Program & Selection Screen"

What shld I keyed in under the program & what kind of package must I select?

Pls advise.

Thanks

Newbie

[Former Member · Accepted solution]

Hey Newbie ,

You have done almost right.

Program name will be the "AQFKSYSTQV000006DELIVERY======"

Now you need to select the package in which the object ie query will be stored.

3 ways .

1) choose already existing package ie press f4 and select the package z* ie starting with zname.

2) If you want it in another package then create it .

there are 2 ways to create a package.

One is Through SE80.

Other one is SE21(package Builder).

->How to create a package?

Goto SE80 Transaction or SE21

Select Package and below give the package name and click on enter.

then u get a pop up asking to create package. Click yes. then u get a pop up Package Builder: Create package

Give the description and the Application component and click on create.

3) If you dont want this object to be moved to QAS then give the package name as $TMP which is a local package this wont allow the objects which is stored in it to move to other servers.

If you still face any problems in that , pls revert, happy to help you.

Regards,

Vvieks

"Grow and help others to Grow"

[Former Member]

solved. Thanks for all the help given.

[Former Member]

Dear Vivek Baddula,

1) What happen if I select the existing package? would it auto transport from DEV to QAS then to PRD?

2) I would like this object to appear in QAS, which mean the $TMP cannot fit into my bills when I create the package in DEV?

Dear Jelena Perfiljeva

if I used SAP Query (transaction SQ01...03), would the user able to use to execute the report? I do not wish them to create the report by themselves.

Pls advise.

Newbie

[Former Member]

Hi Newbie,

Are you planning to use this report by urself, or do you want others to use it as well? If it is a multi user report, the best solution is to convert your quick view into a query. Then create a program in SE38 with the following code,

REPORT ZDN01.

CALL FUNCTION 'RSAQ_QUERY_CALL'

EXPORTING

WORKSPACE = ' '

QUERY = 'ZDN01' " (Give your query name)

• USERGROUP = '' " (Give the user group who use this report)

VARIANT = ' '

SKIP_SELSCREEN = SPACE

EXCEPTIONS

NO_USERGROUP = 1

NO_QUERY = 2

QUERY_LOCKED = 3

GENERATION_CANCELLED = 4

NO_SELECTION = 5

NO_VARIANT = 6

JUST_VIA_VARIANT = 7

NO_SUBMIT_AUTH = 8

NO_DATA_SELECTED = 9

DATA_TO_MEMORY_NOT_POSSIBLE = 10

OTHERS = 11.

Then call this program in your transaction.

[Jelena]

Do not use Quick View (SQVI), use SAP Query (transaction SQ01...03). QuickView queries are user-specific and not transportable. Your transaction will not work in any other environment. A QuickView query may be converted to a SAP Query in SQ01.

There are lots of posts on how to create a transaction for a SAP Query. As the name suggests, Quick Views are meant for quick ad-hoc reports, not for developing queries for everyone to use.

[Former Member]

Hi

Program name should be "AQFKSYSTQV000006DELIVERY======"

and package should be the same in which other objects of your projects resides, ask your ABAPers.

If not any package define for your project then make it local object.(Take help of ABAPer)

try and revert