Wrong data is coming while displaying the maintenance view

[Former Member]

Hi Experts,

When I am executing the maitenance view, the displayed data is incorrect.

How to correct the data.

Thanks

Nagiredddy.

[Former Member]

Hi Experts,

When I am executing the maitenance view, the displayed data is incorrect.

How to correct the data.

Thanks

Nagiredddy.

[SimoneMilesi]

THe table structure is changed but the view is not updated, could be?

[Former Member]

Yes Simone.

I have checked the view and it was changed in feb 2014 and the generation of table maintenance view happend in 2009.

This is the reason. If yes please tell me how to correct.

Thanks

Nagireddy Alavala

[Former Member]

Hi,

That might be due to addition of some new fields after generation of table maintenance view. Regenerate the complete maintenance view.

Regards,

Ashish

[Former Member]

Yes Ashish.

But how to regenerate the complete maintenance view.

Please help in this.

Thanks

Nagireddy Alavala

[SimoneMilesi]

Via SE11->put your table name and edit

then

Choose

mak all flags in every popup SAP presents and confirm.

Your table maintainence is updated

[Former Member]

Hi Simone,

Will it effect on my system.

if I move it to production, any effect on data.

Thanks

Nagireddy Alavala

[SimoneMilesi]

No, it just re-draw the SM30 you see, data is unchanged.

[Former Member]

Hi Simone,

After clicking on the change button, I received one popup screen Asking reason for change,

in that popup some options are there. What I need to select all the options or particular one only.

Please confirm.

Thanks

Nagireddy Alavala

[SimoneMilesi]

Select all without worry

[Clemenss]

... here, switch to expert mode, push the select-all button and generate.

This works best if the view maintained is the only one defined with this function group, may cause havoc if anything except maintenance views is defined in this function group.

Regards

Clemens

[Former Member]

Hi Clemens,

after updating the view as above, if it did not give solution for my requirement, Can I revert back these changes.

if Yes. How can I revert back my changes.

Thanks

Nagireddy Alavala

[Former Member]

Hi Simone,

after updating the view as above, if it did not give solution for my requirement, Can I revert back these changes.

if Yes. How can I revert back my changes.

Thanks

Nagireddy Alavala

[Clemenss]

Reverting to the status before is a bit tricky: You have to restore the previous version for all objects involved. But as you said, the original view was not what you wanted, you might first think about what you want. Don't worry, as long as you do not SAVE any changed data, the data are not affected.

But if you don't let anybody know the exact view and involved table structure, as long as you can't say exactly what you want or what your requirement ist as opposed to what you got, how can we help you?

Best regards

Clemens

[Former Member]

Hi clemens,

It is not about wrong data.

the view is designed in such way that, it is picking like taht data only.

Now I donot want that data, as it is not matching my requirement.

I need to change the view not the data.

If I change the view as per new requirement, it will give the correct data.

Ex : one cost centre / cost element/ maintenance view is there.

it is displaying values for cost center and cost center name etc.

for cost center they have mainted two names ane is valid to 08.11.2012

and other name is valid upto 30.12.9999.

But the view is displaying 08.11.2012 cost center name only.

Now it should show the name which is valid upto 30.12.9999.

I have checked the view selection conditions tab.

they are no selection conditions for this view.

If I mantain the selection conditions like CSKT( TABLE)...DATBI(FIELD).....COMPARISION VALUE 30.12.9999.

will it resolve my solution......?

Will I need to regenerate the TMG for this new changed view.....?

If yes, I have custom includes in the function pool of this TMG.

Is there any effect on these custom includes.....if I generate new TMG for this view.

[Former Member]

Hi Nagireddy,

before regenerating,  check wethey any modification events are added to the routine .

they may get overwritten when you regnerate the table maintaince .

[Former Member]

Hi Ashokmani,

Yes. Two events are implented to the routine.

If I regenerate, any effect on these routines.

if effect is there, how can I regenerate the TMG for the view without effecting on these routines.

Thanks

Nagireddy Alavala

[Former Member]

Hi Nagireddy

These routines are stored in the includes of TMG function group. Its better to take a back up of these includes , as well as the entries that are added in the events.

Regards

Arulmani

[Former Member]

Hi Arulmani,

other than addition of selection conditions to the view

and regeneration of TMG, is there any option means is there any event

that will help in this scenario.

I am thinking it will be diffuclt to do regeneration. we need to take more precautions.

if event is there I will implenet that event by creating the routine.

And in yout lasr post, I have a doubt,

as well as the entries that are added in the events.

I did not get the above point. Can you explain clearly.

Thanks

Nagireddy Alavala

[former_member201275]

Go to SE14, enter your view name, click "view" radiobutton (or "table" if you are having problems with a table. In the next screen click on "activate and adjust database".

[naveen_inuganti2]

In addition to above inputs, if you still see some issue, you can check if your view is showing data from all clients of your system.

A view can show data independent of clients - when your system is having more than one client.