Ztable to be insert,modify operation through a transction

[Former Member]

hi all,

I have a ztable. Now I need to make this as transaction based, say I create a tcode ZCODE and when I execute ZCODE, I NEED TO DISPLAY ALL ENTRIES IN ztable, then I need INSERT, MODIFY,DELETE ,CREATE NEW ENTRIES button in the screen and SAVE IN THE DATABASE

I know i can use through ALV ..AND SCREEN PAINTER..

BUT still need some hepl in finding out the right procedure...kindly help...

thanks

[Former Member]

hi all,

I have a ztable. Now I need to make this as transaction based, say I create a tcode ZCODE and when I execute ZCODE, I NEED TO DISPLAY ALL ENTRIES IN ztable, then I need INSERT, MODIFY,DELETE ,CREATE NEW ENTRIES button in the screen and SAVE IN THE DATABASE

I know i can use through ALV ..AND SCREEN PAINTER..

BUT still need some hepl in finding out the right procedure...kindly help...

thanks

[Former Member]

Hi,

You should create a table manaintenanace generator for your custom table.

Go to SE11 and open the table in change mode. Follow the menu path and create the maintenece generator

UTILITIES -

---

> TABLE MAINTENCE GENERATOR.

Save the mainatenence generator.

Now when you will execute the tranaction, we will be able to insert/delete entries in your custom table.

Thanks

Hemant

[Former Member]

even though I can do in SM30, THE user wants in a transaction where he can do all the features same as in SM30.

THANKS

Edited by: JaiKarthik on Mar 4, 2010 2:24 AM

[anup_deshmukh4]

create a report

use function VIEW_MAINTENANCE_CALL pass ACTION as U and pass table name in view name field ....!

it will simulate Tcode sm30 for you programatically and then assign tcode for your created program

Hope it helps

[Former Member]

Hello,

Why don't you create a transaction which will call SM30 with the z table that you want. In this way you will have a Z transaction as the client as requested and have all the functionality required as it exists in SM30.

Do the following-

1. Go to SE93 and create a Z transaction.

2. in start object select the last radio button Transaction with parameters.

3. In the next screen enter SM30 in the text box saying transaction.

4. At the bottom of the screen write 'VIEWNAME' and in the value write the name of the table. Under that enter 'UPDATE' and for the value column enter 'X'.

Now when you call the transaction, it automatically calls SM30 and open the table in which you want the entries to be worked upon.

Hope this helps.

Regards,

Sachin

[Former Member]

In transaction SE11, in the attribute tab of your z table check table maintenance check box. Go to SM30 transaction, enter the ztable name and click on maintain button. Here you can enter new entries into the ztable .

Or

You can create a PARAMETER TRANSACTION for the transaction for SM30 .

Follow these steps :

1. go to transaction SE93 , give your own transaction code say ztran_tab, for maintaining your ztable.

2. Click on create button and check the radio button Transaction with parameters (PARAMETER TRANSACTION) and click on the tick button.

3. In the next screen enter default values:

transaction : SM30

check the check box skip initial screen

4. Scroll down you will find a table control for default values

-

---

Name of the screen field | value

-

---

VIEWNAME | your ztable name

SHOW | X

Save your work.

Now as you have created a custom transaction for maintaining your ztable this transaction can be called from any program with CALL transaction 'XXX'.

Thanks,

Archana

[Former Member]

hi Jai,

if you want to program it then you have to do lot of coding.

you have to goto trans se80(object navigator) then you have to create the screen in screen painter and then you have to define varous buttons required in menu painter then you have to code in PAI event of the screen with sy-ucomm value.but it is long process, its better to make parameter transaction for sm30, if you want exactly the same scenerios as in sm30.

Thanks,

Tanmaya

[Former Member]

Hi,

For ur requirement u need to create a table maintainenec generator for the Ztable and then create T.code for that.

Regards,

GK

[Former Member]

Hi Jai,

For your requirement a table maintenance generator will be an appropriate choice.

For the details about how to create it please go through the following link:

Hope it helps you,

Regards,

Abhijit G. Borkar