Table maintenance

[Former Member]

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

[SuhaSaha]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

Regards,

Ashwini

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

[Former Member]

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