table maintainance generator

[Former Member]

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

[Former Member]

Hi,

you can work with the database-utilitie.

Same menu then the generator.

Regards

Nicole

[Former Member]

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

3)

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.

[Former Member]

Hi,

Refer

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

Regards

Kiran Sure

[Former Member]

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.

[Former Member]

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

[Former Member]

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.