topic Re: Table maintenance in Application Development and Automation Discussions

Table maintenance

Former Member — Wed, 13 Apr 2011 06:10:34 GMT

Dear All,

I have created a ztable, and maintained a table maintenance for that.Also for the table maintanance I have a ztransaction code.

And I have a report which should output all the records created or changed for that ztable based on selection creteria.

When i create an entry for the ztbale thru SM30, report is working fine, but when i create an enetry thru that ztransaction, that record is notoutputed from the report.

I have specified VIEWNAME= <VIEWNAME> and UPDATE = X for the ztransaction in SE93.

And I alsoe tried with VIEWNAME =ztable (table name), then report working fine.

Can anyone tell me why it so? is that the correct method to specify the VIEWNAME =ztable name?

Awaiting for your reply.

Regards,

Ashwini

Re: Table maintenance

SuhaSaha — Wed, 13 Apr 2011 06:36:51 GMT

Hello Aswini,

Can anyone tell me why it so? is that the correct method to specify the VIEWNAME =ztable name?

Creating a parameter transaction for some tcode means you want to run the transaction by assign default values to the initial screen.

So in your case when you're creating param transaction for SM30 for the particular Z-table, it's like SAP will call the transaction by internally putting the values in the screen fields.

Since you've created a TMG for the particular table, you need to pass

<VIEWNAME> = ZTABLE

just like you do while using SM30.

is that the correct method to specify the VIEWNAME =ztable name?

For tables which have TMG defined this is the standard way of doing it.

Cheers,

Suhas

Re: Table maintenance

Former Member — Wed, 13 Apr 2011 07:03:03 GMT

Hi Suhas,

Thanks for your valuable inputs.

I need to clarify one more thing, Since the report is outputing the required result when i specify the field value on the selection screen (which is created thru the ztransaction for teh ztable) but when try executing the report based on date range sayrecords created between date1 to date2, then it is not resulting the record created thru ztransaction but record created via SM30 will come.

Any idea?Please.

Thanks a lot.

Regards,

Ashwini

Re: Table maintenance

Former Member — Wed, 13 Apr 2011 07:34:55 GMT

Please check the date format input that you have given. Is it a select-option or a range created?

Re: Table maintenance

Former Member — Wed, 13 Apr 2011 08:06:14 GMT

it is a select-option.Please justify your answer.

Regards,

Ashwini

Edited by: ashwini mahendrakar on Apr 13, 2011 10:07 AM

Re: Table maintenance

Former Member — Wed, 13 Apr 2011 12:54:48 GMT

Please check that when you update the table via the ztransaction , if the table is getting updated for those values.

If it is not then check if you have followed the below mentioned steps while creating the transaction.

[http://fuller.mit.edu/misc/creating_sm30_transaction.htm]

Regards,

Anup