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

user-exits

Former Member
0 Likes
996

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 .

1 ACCEPTED SOLUTION
Read only

former_member188770
Active Participant
0 Likes
963

Hi ,

is it a database table ? U can use table maintainance generator. Also u will be able to create a Tcode for this

10 REPLIES 10
Read only

former_member188770
Active Participant
0 Likes
964

Hi ,

is it a database table ? U can use table maintainance generator. Also u will be able to create a Tcode for this

Read only

0 Likes
963

i maintain table maintains generator but how we can create a Tcode for the table

Read only

0 Likes
963

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...

Read only

Former Member
0 Likes
963

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

Read only

Former Member
0 Likes
963

you can use SM30 for this purpose.

No need to create a Tcode for this purpose.

Regards

srikanth

Read only

Former Member
0 Likes
963

check this

regards

Prabhu

Read only

Former Member
0 Likes
963

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

Read only

Former Member
0 Likes
963

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

Read only

former_member188770
Active Participant
0 Likes
963

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.

Read only

Former Member
0 Likes
963

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>