topic Re: Data Dictionary in Application Development and Automation Discussions

Data Dictionary

Former Member — Fri, 07 Dec 2007 03:44:45 GMT

hi friends,

could u plz tell me how to create a T-Code for Z tables?

regards,

Priya.S

Re: Data Dictionary

Former Member — Fri, 07 Dec 2007 03:51:43 GMT

To create a TCODE for a custom table, follow the steps below:

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 | ztable name

UPDATE | X

Save your work. Thus ur Tcode is created.

check the below thread.

Regards,

Maha

Re: Data Dictionary

Former Member — Fri, 07 Dec 2007 03:53:11 GMT

go to se55 Tcode..

give the name of the table..

in that give the authorization group &NC& ..

create a Z function Group ..

press on find screen numbers..

click on the pop-up 'Propose screen numbers'.

click on save..

this creates the maintenance screens in SM30

then

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.

Award points for helpful answers

Re: Data Dictionary

Former Member — Fri, 07 Dec 2007 05:56:39 GMT

Hi,

Follow below steps.

1. Create the table maintanance generator for your table.

2. You need to create a "Parameter Transaction".

What this means is that you will have a transaction (let's call it "ZMAINT") which calls "SM30" and passes in your table name.

Go to transaction SE93 and enter your new transaction code. Enter in the Tcode description and choose "Transaction with Parameters" (it shouldbe the last radio button).

Enter in the default transaction "SM30" and tick the "Skip Initial Screen" check box. Hit Enter.

Now scroll to the bottom of the screen and you will see a Table Control where you will need to enter in the values to the SM30 selection screen.

Because you hit ENTER, the program will have loaded in the Selection Screen parameters into it's memory. Hit the drop down for "Name of Screen Field" and select "VIEWNAME" and then enter in your Z Table in the "Value" column.

Now go to the next line and hit the drop down and select "UPDATE" in the "Name of Screen Field". Enter in a "X" in the value column.

Re: Data Dictionary

Former Member — Fri, 07 Dec 2007 05:59:27 GMT

Hi,

Procedure to create a TCODE for ZTABLE:

Create a table maintainance/View for the Z* Table.

Once you create the view goto SE93~~>Select Parameter transaction and give the short desc.~~>

Give the transaction as SM30(Skip the first screen-optional)~~>Check all check boxes under GUI support~~>In the default values(grid)section first row give the VIEWNAME as you created initially and the second row UPDATE as X.

Se93 --> then which radio button to be selected

Select the parameter transaction as a radio button.

what is the program nam e to be given

no need to give any program name. Instead you have to give the transaction code name as SM30.

Regards,

Omkar.

Re: Data Dictionary

sreeramkumar_madisetty — Fri, 07 Dec 2007 06:12:18 GMT

Hi Priya

Procedure to create a TCODE for ZTABLE:

Create a table maintainance/View for the Z* Table.

Once you create the view goto SE93~~>Select Parameter transaction and give the short desc.~~>

Se93 --> then which radio button to be selected

Select the parameter transaction as a radio button.

what is the program nam e to be given

no need to give any program name. Instead you have to give the transaction code name as SM30.

Regards,

Sree

Re: Data Dictionary

Former Member — Fri, 07 Dec 2007 06:25:04 GMT

Hi Priya,

do reward if useful.

As someone else already suggested, you can create a whole new role with access either to transaction SE16 only or with other transactions too.

Any way, if you choose to create this new role, add SE16 in the menu and update authorization object S_TABU_DIS to include display access only to the specified authorization group (which you have created in SE54).

On the other hand, if you choose to remove the maintain function from S_TABU_DIS from an existing role, it will only have impact on this role unless you remove this access from a template (which is used as a basis to create other roles).

I=B4d say that it would be best to create a whole new role to give this access.