topic Re: Table in Application Development and Automation Discussions

Table

Former Member — Fri, 03 Mar 2006 11:55:59 GMT

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

Re: Table

Former Member — Fri, 03 Mar 2006 12:01:10 GMT

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.

Re: Table

Former Member — Fri, 03 Mar 2006 12:01:17 GMT

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

Re: Table

Former Member — Fri, 03 Mar 2006 12:02:43 GMT

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

Re: Table

Former Member — Fri, 03 Mar 2006 12:07:01 GMT

Hi jayashree,

sorry i misunderstood your query..

Go to SE55 tcode ,

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 se93

regards

satesh

Message was edited by: Satesh R

Re: Table

Former Member — Fri, 03 Mar 2006 12:08:06 GMT

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

Re: Table

Former Member — Fri, 03 Mar 2006 12:08:11 GMT

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

Re: Table

Former Member — Fri, 03 Mar 2006 12:10:25 GMT

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.

Re: Table

Former Member — Fri, 03 Mar 2006 12:11:20 GMT

Create a table maintance program for a z table

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 .

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

reward if useful

Re: Table

Former Member — Fri, 03 Mar 2006 12:11:57 GMT

hi,

regards

vijay

Re: Table

Former Member — Tue, 07 Mar 2006 04:26:37 GMT

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.

No maintenance authorization for cross-client tables (see Help)

Message no. TB109

Diagnosis

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.

System response

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

Procedure

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

Re: Table

Former Member — Tue, 07 Mar 2006 04:35:29 GMT

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

Or does the table already have entries in it?

Re: Table

Former Member — Tue, 07 Mar 2006 04:46:55 GMT

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

Re: Table

Former Member — Tue, 07 Mar 2006 04:59:25 GMT

I think that No Overwriting option 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

Re: Table

Former Member — Tue, 07 Mar 2006 05:37:01 GMT

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