Reg SM30 specific data display

[former_member576008]

Hi,

I have a table with table maintenance generator, for that i need to create a t-code and to display/update the data.

But i need to display a specific data. For example if a user is assigned to a plant i need to show only that plant details when the user executed the t-code.

I will get the user-plant details from a role.

Kindly let me how to display the specific data when the t code is executed.

Thanks.

Regards,

Nandha

[RaymondGiuseppi]

Create a driver program that will perform the authority-check and then call the maintenance dialog with allowed value(s) (In Integrating Enhanced Table Maintenance in Customer Developments, look for DBA_SELLIST).

Regards,

Raymond

[ThomasZloch]

You could maybe also use maintenance event AA for this purpose, replacing the standard data retrieval routine with your own, checking the authorization and selecting the data accordingly.

Thomas

[former_member576008]

Hi Thomas,

Thanks for your reply. I have created table completed table maintenance generator and created few entries.

When checking that entries in sm30, i'm able to see all the entries. Later i created the AA event and named the routine before_display. I was unable to put a break point, because function group is inactive. Then i activated the function group and table. Now, i was able to keep a break point in the routine.

Next, i created a tcode for the table maintenance generator. When i executed that t code, the system stopped in debugger at the routine. I checked the tables TOTAL and EXTRACT in the debugger but there is no data in that. After executing the debugger there is no data in the SM30 also. But the data is available in SE16.

I have deleted my table maintenance generator and followed the above approach. Again the same result.

Please suggest.

Regards,

Nandha

[RaymondGiuseppi]

Later i created the AA event and named the routine before_display.
(...)
I checked the tables TOTAL and EXTRACT in the debugger but there is no data in that.

What coding did you put in AA event, you have to fill internal table TOTAL yourself  in your code. I suggest first calling form TABLE_GET_DATA (Include LSVIMFTX is already included in your function group, you could also copy it in your event form code) and then filter data using authority-checks. - Better rename it read_data than before_display.

Regards,

Raymond

PS: reference at Event AA

[former_member576008]

Hi Raymond,

I have not written any code in the routine. I just tried whether data is flowing or not. Now i understood that i need to push the data. I will write a select query and fill the TOTAL table.

But I don't know why the data deleted from SM30.

Thanks.

Regards,

Nandha

[ThomasZloch]

That event AA is a replacement of the standard, you need to do the selection yourself, thus TOTAL arrives emtpy inside your own routine. If you don't do anything there, SM30 shows no records, as you have found out.

Thomas

[former_member576008]

Thank you Thomas, do i have to delete and re generate the table maintenance generator after creating the AA event. Please suggest.

Regards,

Nandha

[ThomasZloch]

Probably so, but you could well try this yourself. Don't re-generate it, see the result, if something is missing, re-generate it.

The more you find out yourself, the steeper your learning curve.

Thomas

[former_member576008]

I got the solution.The changes are working fine.

Thank you Thomas and Raymond.

PS. Now I'll try Raymond's approach

Regards,

Nandha

[Former Member]

Hi,

    After creating table maintainance generator then

GO to tcode-Se93.

Then create the new T.code.

Under that select parameter Transaction.

Then give the sm30 in the t.code in default values tab.

Check the checkbox skip initial screen in classification tab.

Click checkbox inherit gui attributes..

Now below..

In the default values..

WRITE

viewname = give ur table name.

show = X

save and check it once...

    then u can login with this new tcode and view and update those fields and press enter ans then save.

[former_member214878]

I have a table with table maintenance generator, for that i need to create a t-code and to display/update the data.

Creating T-Code might not be a problem, as you can have lot of help on this. Also Ramya has given correct way to create a T-code for TM.

But i need to display a specific data. For example if a user is assigned to a plant i need to show only that plant details when the user executed the t-code.
I will get the user-plant details from a role.

Events could be useful for this, you can see there will be Z - Screen and Includes be avail, you can implement appropriate event and replace the data by conditions you want.

Also here would like to mention you can go for Extended Table maintenance generator too.

Using event again should not be a problem you can find lot of documents for that as well.

Hope this could be enough.

Regards,

Ravindra Sonar.