Ztransaction+Table maitaince generater

[Former Member]

Hi all,

I have an requirement where I have to create a z transaction for table maintaince generator.But i should create this transaction by skipping the first screen of sm30

and also I should defaultly maintain a table i.e i should pass a ztable to this transaction.i.e we should go to sm30 2nd screen and maintain this table by passing this table in somemeans.

Can anyone guide me

Helpful answers will be rewarded.

Thanks,

Uga

[Former Member]

Hi,

In SE93 while creating a transaction,

Just select <b>Transaction with parameters (Parameter transaction)</b>

Give the tcode - sm30, Select Skip first screen

Just Give the values in the parameters - Name of the screen field (VIew name), and value.

Regards

Rusidar

[Former Member]

Hi Rusider,

I tried this but it is not working.

It is again going to sm30 and just defaulting the table/view value.

can u plz help me out.

Thanks,

Uga

[Former Member]

Hi Uga,

go for BDC and record your session..

and create a tcode for the bdc report..

i think this will help...

try it and let me know...

thank u

[Former Member]

Hi Albert,

I had tried this method.But it is not working .

It is not skipping the first screen.

Is there any other methods.

Thanks,

Uga

[Former Member]

Looks like you are not using the correct transaction type. Please delete the current Transaction and start from the scratch.

1. CREATE

2. Transaction with Parameters

3. Enter T-Code SM30 & CHECK Skip initial Screen

4. Give all details and DEFAULT values; name of screen field - VIEWNAME

Value - <Table name>.

It shud work, good luck.

Regards,

Vishal

[Former Member]

Hi,

u must create a fn group(SE37) & activate it.

In se11, give the table name,choose utitilities-->Table maintainence generator.

Give the authorisation group name (eg:&nc&), fn group name,maintenance type:one type,maintain screen no:overview screen :1 & create the table maintenance generator.

In SE93, create transaction of type -parameter transaction,in transaction give SM30

1)in name of screen field ,give -VIEWNAME,

in value, give ur table name.

2)Then in the next line

<b>Name of the Screen Field as 'SHOW' and

Value as 'X'.</b>

Now if u execute this ztcode, ur req wil be met,

**Reward pts if useful****

Regards,

Viji

[Former Member]

Hi Vijaya,

I created a ztransaction as u said but while running the transaction.It is going to first screen of sm30 and giving an error message "enter a valid value"

Thanks,

Uga.

[Former Member]

Hi muni,

while creating the transaction in SE93 with <b>transaction with parameters</b> option you have to check the check box <b>Skip initial screen</b> in order to directly go to table maintainance.

Regards,

Kasinath.

[Former Member]

Hi

Thanks for spending ur valuable time for giving ur valuable inputs to me.

My problem has been solved.

Vijaya,

Your solution is working but Instead of 'SHOW' we should use 'UPDATE' .

But in the 1st screen the copy/paste functionality is not working and also i have to maintain authorizations i.e the transaction should be used by only super users.

Can any of u give some inputs on this and help me.

I had awarded points for all helpful answers.

Thanks,

Ugandhar.

[Former Member]

Hi uga,

Create a zreport and go for BDC .

and try creating a tcode for the zreport..

[Former Member]

You create a TCODE from SE93 of type 'Transaction with Parameter'

After yo select the above option do the following steps:

1. Give Default Values - Transaction - SM30

2. In the Table control at the bottom of screen give the following info

Name of screen field - VIEWNAME (this is the field name of SM30 screen)

Value - <Table name>.

[Former Member]

Hi,

I think here we want to maintain the ztable.

here in default values we can give table name but how do we maintain(adding entries - change mode) it. I feel we can go for BDC

Please correct me if i am wrong.

[Former Member]

Hi all,

Thanks for ur input.

But this is not working is there any otherway to do it.

Thanks,

Uga