‎2006 Sep 27 9:26 AM
Hi,
i have a requrement that to maintain a table (new table) by a t-code. with that t-code we can enter the data into the table what is the process to do it .
‎2006 Sep 27 9:29 AM
Hi ,
is it a database table ? U can use table maintainance generator. Also u will be able to create a Tcode for this
‎2006 Sep 27 9:29 AM
Hi ,
is it a database table ? U can use table maintainance generator. Also u will be able to create a Tcode for this
‎2006 Sep 27 9:33 AM
i maintain table maintains generator but how we can create a Tcode for the table
‎2006 Sep 27 9:42 AM
hi,
simple.
1. goto <b>SE93</b>
2. give a Tcode Z... and short text and choose <b>PARAMETER TRANSACTION</b> radiobutton.
3. give transaction as <b>SM30</b>
4. at the end write like this,
Name of screen field Value
VIEWNAME <ZTEST_TABLE>
UPDATE X
hope it helps.
reward if useful...
‎2006 Sep 27 9:31 AM
First you need to create table maintenance generator for that table. Then create a view for that table and then you can assign a tcode for that view.
Best Regards,
Vibha
*Reward points if it helps
‎2006 Sep 27 9:32 AM
you can use SM30 for this purpose.
No need to create a Tcode for this purpose.
Regards
srikanth
‎2006 Sep 27 9:35 AM
‎2006 Sep 27 9:37 AM
You need to create a view for that table and then you can assign tcode to taht view.
Best Regards,
Vibha
*Reward points if it helps
‎2006 Sep 27 9:40 AM
Hi Sunil,
TCode SM30 can be used for maintaining your Database table.
However if you want to create a new TCode(may be for authorization purposes) you can create one using transaction SE93. Use the last option 'Transaction with Parameters). Specify Transaction as SM30 and in the default values give field name as VIEWNAME and value as your DB table name.
Save and activate.
Now you can use this new TCode.
Hope this helps!
Regards,
Saurabh
‎2006 Sep 27 9:42 AM
Hi ,
U can follow the below steps
1.SE11.
2.CHOOSE TABLE.
3.UTILITIES--->TABLE MAINT GENERATOR.
4.AUTH GRP : W/O AUTH.
5.FUNCTION GRP: PROJ DEPENDENT (SEE CREATE FUNC GROUP).
6.MAINT TYPE : 2 STEP.
7.MAINT. SCR NO. : CLICK APPL BUTTON | FIND SCR. NUMBER(S) |
8.CHOOSE PROPOSE SCREEN NO FROM POPUP.
9.REMEMBER OVERVIEW SCR NO.
10.CLICK CREATE BUTTON ON APPL TOOL BAR.
11.CLICK SAVE ON FUNC TOOL BAR.
12.GO TO SE93. TO CREATE TRANSACTION CODE.
13.WRITE SUTIABLE TRAN NAME..CLICK CREATE
14.CHOOSE TRANSACTION WITH PARAMETERS(LAST).
15.FILL SHORT TEXT.
16.OK
17.TRANSACTION : SM30.
18.CHECK SKIP INITAL SCREEN CHKBOX
19.SCREEN NO : FROM STEP 9.
20.IN TABLE BELOW
NAME OF SCREEN FIELD VALUE.
VIEWNAME [TABLENAME]
UPDATE X
21.SAVE
22.RUN TRAN CODE IN COMMAND BOX.
Note:- Once a Table Maintainence is made for a custom table
u cannot delete enteries from the table then.
Only through the table maintenance u can delete enteries.
note2:- To show decimal values also on the first screen --
first create single screen then change it to two step.
‎2006 Sep 27 9:57 AM
Hi Sunil,
For your Requirement, You need to create a dialog program(SE51) which consists of all the fields of your table as I/O fields and some push buttons for update . After the dialog program is ready create a tcode with the program name and screen number.
Warm Regards:-
<b>Santosh.D</b>