topic table maintainance generator in Application Development and Automation Discussions

table maintainance generator

Former Member — Tue, 06 May 2008 07:10:43 GMT

hi, i have created table through se11 and i have also created maintainace view for SM30.

i have following fileds in table

CREATED_DATE - system date

LAST_MODIF_DATE - last modification date

CREATED_USER - user who created entry

CURRENCY - always 'INR'

i want to know how i can automatically populate above fields whenever table is accessed. can we do it through SM30, if yes HOW ???

or i have to write separate abap programme ??

Re: table maintainance generator

Former Member — Tue, 06 May 2008 07:16:25 GMT

Hi,

you can work with the database-utilitie.

Same menu then the generator.

Regards

Nicole

Re: table maintainance generator

Former Member — Tue, 06 May 2008 07:20:02 GMT

Hi,

By creating the table maintenace generator only u can display those fields.

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.

Regards,

Shiva.

Re: table maintainance generator

Former Member — Tue, 06 May 2008 07:22:44 GMT

Hi,

Refer

https://forums.sdn.sap.com/click.jspa?searchID=11465826&messageID=2545202

Regards

Kiran Sure

Re: table maintainance generator

Former Member — Tue, 06 May 2008 07:25:16 GMT

You have to use 'EVENTS' of table maintenance generator.

Go to the following path:

Open the table in SE11 -> Utilities -> table maintenance generator-> Environment (In menubar)->Modification-> events.

There you will find various form routines that will be called in variation point of time while data updation through SM30.

You have to write code in appropriate events.

Re: table maintainance generator

Former Member — Tue, 06 May 2008 07:29:01 GMT

You can do this using table maintenance events.

Have a look at below link:

[Table Maintenance Events|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]

Let me know if any doubts.

I hope it helps.

Best Regards,

Vibha

Please mark all the helpful answers

Re: table maintainance generator

Former Member — Tue, 06 May 2008 07:33:10 GMT

Hi,

If you know the table maintanance then go and cteate the table maintenance for that.

And write the your code in PAI of the screen mentioned in table maintenance.

Regards,

madan.