Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

T.Code for SAP Query(urgent)

Former Member
0 Likes
1,065

Hi, Experts,

I am creating tcode for a sap query by passing following details

First chosen radio button :Transaction with parameters(parameter transactions)

Transaction code :zmm050

transaction text: tcode for a query

Screen : 1000

From Module pool :AQFKSYSTQV000018ZTEST2========

When I execute tcode zmm050 it display selection screen.

but when I execute it, It show dump with GATEWA_NOT_ASSIGNED.

What I am missing? Please help.

Regards

Rajiv singh.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
970

Hi,

After executing the query Goto tcode SE38,ther you will find the program name of the query.

Go to tcode se93 enter tcode and ---create

-->descripton radio button second->Enter program name which you got in se38

Hi, Experts,

I am creating tcode for a sap query by passing following details

First chosen radio button :Transaction with parameters(parameter transactions)

Transaction code :zmm050

transaction text: tcode for a query

Screen : 1000

From Module pool :AQFKSYSTQV000018ZTEST2========

When I execute tcode zmm050 it display selection screen.

but when I execute it, It show dump with GATEWA_NOT_ASSIGNED.

What I am missing? Please help.

Regards

Rajiv singh.

6 REPLIES 6
Read only

Former Member
0 Likes
970

Hi,

SQ03->user group.

SQ02->info set.

SQ01->sap query.

rgds,

bharat.

Read only

Former Member
0 Likes
970

SQ03

SQ02 SQ01use the above mentioned T-codes

Read only

Former Member
0 Likes
971

Hi,

After executing the query Goto tcode SE38,ther you will find the program name of the query.

Go to tcode se93 enter tcode and ---create

-->descripton radio button second->Enter program name which you got in se38

Read only

Former Member
0 Likes
970

Hi,

SQ01 - Queries

SQ02 - Infosets

SQ03 - User Groups.

Thanks,

Sriram Ponna.

Read only

Former Member
0 Likes
970

I have done it.

using se93

second option.

passing sapquery program name and screen 1000.

Read only

Former Member
0 Likes
970

Hi Rajiv singh,

Parameter transaction:

In transaction SE11, in the attribute tab of your z table check table maintenance check box. Go to SM30 transaction, enter the ztable name and click on maintain button. Here you can enter new entries into the ztable .

Or

You can create a PARAMETER TRANSACTION for the transaction for SM30 .

Follow these steps :

1. go to transaction SE93 , give your own transaction code say ztran_tab, for maintaining your ztable.

2. Click on create button and check the radio button Transaction with parameters (PARAMETER TRANSACTION) and click on the tick button.

3. In the next screen enter default values:

transaction : SM30

check the check box skip initial screen

4. Scroll down you will find a table control for default values

-


Name of the screen field | value

-


VIEWNAME | your ztable name

SHOW | X

Save your work.

Now as you have created a custom transaction for maintaining your ztable this transaction can be called from any program with CALL transaction 'XXX'

Create Parameter transaction for SM30

Assuming that you want the user to maintain a table or view using SM30 but you do not want them to see the initial screen of SM30. For e.g. V023 - Material Group.

Procedure:

Go to transaction SE93. Give a transaction name and press create button.

In the popup screen, enter proper description and select the transaction with parameters (parameter transaction) radio button and press enter.

In the next screen enter the values as shown in the screen shot below and press save button

In the next step enter the name of the screen field and the value.

i.e VIEWNAME and UPDATE.

Now execute this transaction by pressing F8. It will display the change view of the table maintenance screen.

Then click on new entries to enter the values in table.

Don't forget to rewards rajiv,

Thanks & Regards,

Ganesh.