topic Re: user-exits in Application Development and Automation Discussions

user-exits

Former Member — Wed, 27 Sep 2006 08:26:19 GMT

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 .

Re: user-exits

former_member188770 — Wed, 27 Sep 2006 08:29:39 GMT

Hi ,

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

Re: user-exits

Former Member — Wed, 27 Sep 2006 08:31:57 GMT

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

Re: user-exits

Former Member — Wed, 27 Sep 2006 08:32:13 GMT

you can use SM30 for this purpose.

No need to create a Tcode for this purpose.

Regards

srikanth

Re: user-exits

Former Member — Wed, 27 Sep 2006 08:33:49 GMT

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

Re: user-exits

Former Member — Wed, 27 Sep 2006 08:35:31 GMT

check this

regards

Prabhu

Re: user-exits

Former Member — Wed, 27 Sep 2006 08:37:30 GMT

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

Re: user-exits

Former Member — Wed, 27 Sep 2006 08:40:07 GMT

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

Re: user-exits

former_member188770 — Wed, 27 Sep 2006 08:42:04 GMT

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.

Re: user-exits

Former Member — Wed, 27 Sep 2006 08:42:32 GMT

hi,

simple.

1. goto SE93

2. give a Tcode Z... and short text and choose PARAMETER TRANSACTION radiobutton.

3. give transaction as SM30

4. at the end write like this,

Name of screen field Value

VIEWNAME <ZTEST_TABLE>

UPDATE X

hope it helps.

reward if useful...

Re: user-exits

Former Member — Wed, 27 Sep 2006 08:57:12 GMT

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

Santosh.D