07-19-2007 3:29 AM
Hi Peers,
i have got a requirement like, i need to create a custom t-code for table t030. I have to create a selection screen same as the one that appears in SE 16 (with same buttons) for table t030 with selection restricted to 'chart of accounts = xxxx'. When one uses the transaction it should display the ALV display same as when we view contents of table t030 with addition of :
Table: t030
Displayed fields: x of y Fixed columns: x List width:
on top of the page within display tab ( below tool bar).
Could you help me with the code. its most urgent.
07-19-2007 4:11 AM
In transaction SE11, in the attribute tab of your 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 table .
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 table.
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 | t030
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'.
07-19-2007 3:32 AM
Follow these steps.
1. Go to transaction SE93 ,
2. Give the name of ur tcode say zxxxx, for maintaining your ztable.
3. Click on create button,now a page opens.
4. Choose the radio button Transaction with parameters (PARAMETER TRANSACTION).
5. In the next screen enter transaction as : SM30
7. Also check all the three check boxes for the GUI support.
8. Scroll down you will find a table control for default values
Name of the screen field | value
___________________________________
VIEWNAME | your ztable name
UPDATE | X
Regards
Gopi
07-19-2007 4:11 AM
In transaction SE11, in the attribute tab of your 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 table .
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 table.
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 | t030
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'.
07-19-2007 4:23 AM
hi Dear
I couldn't get your question properly ... anyway
try with tcode <b>SQVI</b>
you can mare some table views from that with conditions
Rewards if useful.
07-19-2007 4:36 AM
<b>Creating a transaction code for table maintenance (SM30)</b>
Allowing access to table maintenance via a custom transaction code is fairly straight forward.Once the table maintenance has been generated for a specific database table you need to Create a parameter transaction. See below for example
<b>Step 1</b>
Create parameter transaction (i.e. via SE93)
<b>Step 2</b>
Enter transaction details. Within the Proposed values section there are a number of value which
can be setup, simply use drop down menu to view the list. The 2 values assigned in the following
example are as follows:
VIEWNAME: Set table name to maintained
UPDATE: Open table for update
" see the link for screen shot of creating trascation code .
<a href="http://">http://www.sapdevelopment.co.uk/tips/tips_tabmaint_tcode.htm</a>
reward points if it is usefull....
Girish
07-19-2007 2:10 PM
Hi Girish,
i tried your solution, but its not working for me. the requirement is when i enter my custom t-code it should directly take me the display screen with the 7 fields in table T030. The data browser screen should be skipped, and the validation part is T030-KTOPL = 'GM01' for example. this field should be restricted to this particular value only.