Table

[Former Member]

Hi

How to create table maintenance screen for a Z table and how to add it to a transaction code????

points will be awarded?

Thanks in advance

[Former Member]

Go to SE11.

Open your table.

Go to menu Utilities->Table Maintainance Gr.

It will generate a maintainance program in the name of

SAPL + "Function group name specified"

Now go to SE93 and attach a tcode to this program.

[Former Member]

Create the table maintainace

by clicking the menu option utilities-->table maintaince generator

create the tcode in SE93 and select parameter transaction as tcode type.

Goto SE93-->

1) Mention the already created transaction code or new.

2) If it is existing one then select change mode, at the

end of the screen you can see 'Default values'

3)under that give the

name of the screen field value

VIEWNAME ZHR_T7BRCB (here you can change the view)

UPDATE x

Thanks

eswar

[Former Member]

Hi,

Please find these threads

http://help.sap.com/saphelp_46c/helpdata/EN/cf/21eb6e446011d189700000e8322d00/frameset.htm

http://help.sap.com/saphelp_bw30b/helpdata/en/69/c2516e4ba111d189750000e8322d00/content.htm

This will answer ur question.

Cheers

Sunny

[Former Member]

Hi jayashree,

sorry i misunderstood your query..

Go to <b>SE55 tcode</b> ,

give the name of the table..

give the name of a Function Group ..

A Pgm with name SAPLfollowed by the name of the Fg is created..

to create a associated tcode go to <b>se93</b>

regards

satesh

Message was edited by: Satesh R

[Former Member]

Hi,

Create your Z table using SE11.

Then go to Utilities -> Generate Table Maintainance and generate the table maintainance.

Then go to SE93 to create Z transaction code.

Choose "Transaction With Parameters".

In Default Values For Transaction, enter SM30.

Check the box "Skip First Screen"

In Default values:

Enter your Z table name for VIEWNAME

and VIMDYNFLDS-LTD_DTA_NO = 'X'

and UPDATE = 'X'.

Hope this helps...

Regards,

Shashank

[Former Member]

from se11 > utilities > table maintenance generator

give authorization group ( if any) other wise &NC&( no auth grp)function group maintenace type etc ang create .....

for tcode

go to se 93

select parameter transaction

in transaction give sm30

skip initial screen

in default values give

UPDATE X

VIEWNAME table name

[Former Member]

Hi Jayasree.

1. SE11 for Z-table then via menu Utilities->Table Maintenance generator,

2. Transaction: SE93 Create (type is parameter transaction). On the next screen enter the following parameters:

Transaction: Sm31

VIEWNAME <Z-table>

UPDATE X

Regards,

John.

[Former Member]

<b>Create a table maintance program for a z table</b>

In transaction SE11, in the attribute tab of your z 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 ztable .

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

Now as you have created a custom transaction for maintaining your ztable this transaction can be called from any program with CALL transaction 'XXX'.

<b>reward if useful</b>

[Former Member]

Thanks for help. But I am getting an error .

THESE ARE THE FOLLOWING STEPS I CARRIED OUT.

1.go to SE11, Ulitilies -->Table Maintnance Generator.I entered Authorisation Group: &NC&

Function Group : zconcode (table name)

Package : zform

maintenance type : 1 step

maintenance screen no: overview screen : 1

single screen : 0

2.Created a parameter trancastion for the transaction for Sm30.

But after this I am getting error.

<u><b>No maintenance authorization for cross-client tables</b></u> (see Help)

Message no. TB109

<b>Diagnosis</b>

You wish to maintain a table or table view using the standard table maintenance function (SM30, SM31). This is a cross-client activity, that is, all changes also affect all other clients in the system.

Since the standard table maintenance function is mainly used for changing client-specific customizing data, the maintenance of cross-client tables is protected by a special authorization S_TABU_CLI. You do not have this maintenance authorization.

<b>System response</b>

You cannot maintain the table or view. Only display is possible.

<b>Procedure</b>

Contact your system administration department to find out whether you can be assigned the authorization S_TABU_CLI. This authorization to change cross-client system data should be assigned only to appropriately qualified users.

Kindly clarify.

Points will be awarded

[Former Member]

Are you creating maintainance generator for a Z* table or not...

Or does the table already have entries in it?

[Former Member]

The table has already have 1 entry in it .Then the client asked to create a Table Maintenace generator and add transaction code to it. So I created Table Maintenance Generator and create tcode.

Kindly reply ASAP

[Former Member]

I think that <b>No Overwriting option</b> has been set in the client settings.

You can exclude the table from this if you have set the option. See http://help.sap.com/saphelp_nw04/helpdata/en/44/714d3ca270fd6be10000000a114084/content.htm

[Former Member]

Hi,

Please check if MANDT field is missing in your Z table.

If it is missing,then add it as key.

it will give error when activating.

go to SE14. Select your table. press adjust and activate.

now generate the maintainance and tcode.

Hope this helps..

regards,

Shashank

[Former Member]

hi,

regards

vijay