Problem with data dictionary and SM30

[Former Member]

Hello all,

I've created a Z table ZMAT containing 3 fields MANDT, MATNR and MAKTX. Also i've created table maintainance for this table.

My requirement is like this. I want to log on to SM30 to maintain ZMAT table. when I enter any material number and press 'Enter' key, material description should automatically come.

How can this be achieved?

Regards,

Anup

[Former Member]

Hi

You should use the event for SM30.

After generating the program for SM30 go to: Enviroment->Modification->Events.

Here you can insert a routine to load the description, for example the event 05 (Creating a new entry).

Max

[Former Member]

Hello Max,

Thanks for the update.

I've inserted a new form include (event 05). Then I am writting a simple code to fetch the data (Select statement). But I am getting an error 'Statement Not accessible'. Why this error could be?

Regards,

Anup

[Former Member]

Hi

After insertin the event 05, you have to define the routine name and the create a form with this name.

Hit-> 05 - GET_DESCRIPTION.

FORM GET_DESCRIPTION.

SELECT SINGLE MAKTX FROM MAKT INTO ZMAT-MAKTX

WHERE SPRAS = SY-LANGU

AND MATNR = ZMAT-MATNR.

ENDFORM.

Max

Message was edited by: max bianchi

[Former Member]

Hi,

Go to table maintenacnce-> Environment-> Modification-> Events.

(only if u have further acess...)

u can create a form for several events like:

- before saving an entry

- after saving an entry

- before deleting an entry

- before creating an entry

This will help you to do customization in SM30.

Hope this helps you.

Check out this weblog on table maintenance:

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

Best Regards,

Anjali

[Former Member]

Not sure for this why do you need a custom table.

You can simply look at MAKT table in SE16 right which will also have a selection screen.

If you still want to do in this, after entering the table name in SM30, choose the Enter Conditions radio button and then you can enter the selection criteria and that will fetch the data for the given conditions from the table.

While entering data, if you want the functionality, then you will have to use the events and do the coding to get the description and populate the data.

Regards,

Ravi

Note : Please mark all the helpful answers

Message was edited by: Ravikumar Allampallam