topic Re: Problem with data dictionary and SM30 in Application Development and Automation Discussions

Problem with data dictionary and SM30

Former Member — Mon, 23 Oct 2006 11:57:10 GMT

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

Re: Problem with data dictionary and SM30

Former Member — Mon, 23 Oct 2006 12:12:05 GMT

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

Re: Problem with data dictionary and SM30

Former Member — Mon, 23 Oct 2006 12:12:28 GMT

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

Re: Problem with data dictionary and SM30

Former Member — Mon, 23 Oct 2006 12:34:01 GMT

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

Re: Problem with data dictionary and SM30

Former Member — Mon, 23 Oct 2006 12:45:03 GMT

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

Re: Problem with data dictionary and SM30

Former Member — Mon, 23 Oct 2006 18:46:47 GMT

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