topic Uploading data through Table Maintance Generator in Application Development and Automation Discussions

Uploading data through Table Maintance Generator

Former Member — Thu, 13 Dec 2007 08:46:52 GMT

hi Folks,

I have created three Custom tables in Solution Manager. i need to create multiple entries for the tables. but i am very new to table maintanance generator. could any one tel me the step by step procedure (Like what to give for authorization grp and Function grp) to accomplish the task. thnx in advance.

santosh....

Re: Uploading data through Table Maintance Generator

Former Member — Thu, 13 Dec 2007 08:49:02 GMT

Hi,

Table maintanance Generator is used to manually

input values using transaction sm30.The Table Maintenance Generator is used to create table maintenance program to add, modify or delete records in the database table. This can be accessed using transaction SE54 or in SE11 using the menu Utilities->Table Maintenance Generator

follow below steps

go to se11 check table maintanance check box under

attributes tab

utilities-table maintanance Generator->

create function group and assign it under

function group input box.

also assign authorization group default &NC& .

select standard recording routine radio in table

table mainitainence generator to move table

contents to quality and production by assigning

it to request.

select maintaience type as single step.

maintainence screen as system generated numbers

this dialog box appears when you click on create

button

save and activate table

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed2d446011d189700000e8322d00/content.htm

One step, two step in Table Maintenance Generator

Single step: Only overview screen is created i.e. the Table Maintenance Program will have only one screen where you can add, delete or edit records.

Two step: Two screens namely the overview screen and Single screen are created. The user can see the key fields in the first screen and can further go on to edit further details.

please check the link for getting information about table maintenance generator !

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=use%20of%20table%20maintenance%20generator&cat=sdn_all

http://www.sapdevelopment.co.uk/tips/tips_tabmaint_tcode.htm

http://www.sap-img.com/abap/create-a-table-maintance-program-for-a-z-table.htm

Regards,

Priyanka.

Re: Uploading data through Table Maintance Generator

Former Member — Thu, 13 Dec 2007 12:37:13 GMT

Hi Santosh.

You must have set the attributes of the Table Maintenance such that the entries should be Transported.

What you can do is, in the table maintenance screen, for the radio button --- recording routine - select no,or user recording .

<b>Kindly reward points if you found the reply helpful.<b>

Cheers,

Chaitanya.

Re: Uploading data through Table Maintance Generator

Former Member — Thu, 13 Dec 2007 12:43:21 GMT

Hi,

Table Maintenance generator is required to do Manual entries in the Table. If the requirement is to update the table only programmatically and not manually then table maint. generator is not required.

Manual entries in table can be maintained ( New record can be inserted / existing can be modified ) using transaction SM 30, if the table maintenance for the table is generated.

How to activate Table maint.

Goto SE11 and open the table.

Click UTILITIES -> Table Maint. Generator, Enter the details and click on Save. Then activate the table.

http://help.sap.com//saphelp_470/helpdata/EN/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

chk a sample 1.

refer.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20implement%20events%20in%20table%20maintenance.doc

Also:

1. SE11 enter table name

2. Go to Attributes tab

3. Change the delivery class to 'L'

4. Follow the path Utilities -> Table maintenance generator

5. Change the recording routine ( bottom of the screen) to NO, or user.

6. Activate the table, do NOT recreate the table maintenance routines

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed2d446011d189700000e8322d00/content.htm

Reward points if found helpful……

Cheers,

Chandra Sekhar.

Re: Uploading data through Table Maintance Generator

Former Member — Thu, 13 Dec 2007 14:00:51 GMT

Hi santosh,

See this link.

https://www.sdn.sap.com/irj/sdn/forums

Plzzzzzzz Reward if useful,

Mahi.

Re: Uploading data through Table Maintance Generator

Former Member — Fri, 14 Dec 2007 08:45:19 GMT

Dear Santosh,

Table maintanance Generator is used to manually

input values using transaction sm30

follow below steps

1) go to se11 check table maintanance check box under

attributes tab

2) utilities-table maintanance Generator->

create function group and assign it under

function group input box.

also assign authorization group default &NC& .

select standard recording routine radio in table

table mainitainence generator to move table

contents to quality and production by assigning

it to request.

4) select maintaience type as single step.

5) maintainence screen as system generated numbers

this dialog box appears when you click on create

button

6) save and activate table

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed2d446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_46c/helpdata/en/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

/message/2831202#2831202 [original link is broken]

One step, two step in Table Maintenance Generator

Single step: Only overview screen is created i.e. the Table Maintenance Program will have only one screen where you can add, delete or edit records.

Two step: Two screens namely the overview screen and Single screen are created. The user can see the key fields in the first screen and can further go on to edit further details.

Best Regards,

Raj

<b>Please reward points if helpful.</b>