2008 Mar 24 10:43 AM
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.
2008 Mar 24 10:59 AM
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
2008 Mar 24 10:44 AM
Hi,
SQ03->user group.
SQ02->info set.
SQ01->sap query.
rgds,
bharat.
2008 Mar 24 10:50 AM
2008 Mar 24 10:59 AM
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
2008 Mar 24 11:03 AM
Hi,
SQ01 - Queries
SQ02 - Infosets
SQ03 - User Groups.
Thanks,
Sriram Ponna.
2008 Mar 24 11:04 AM
I have done it.
using se93
second option.
passing sapquery program name and screen 1000.
2008 Mar 24 11:21 AM
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.