Delete Entries in View

[Former Member]

Hi Experts,

One small doubt. I have a view in which i dont want some data to be populated. I dont want to delete that manually but to be taken care of automatically. To be clear i want only one row in the table for a given month. Any suggestions?

Regards,

Ramesh.

[Former Member]

???

A Database View is a "logical" object. It is the joining of multiple tables to create the "view" of the data.

If you do not want to see an entry in a view, you must remove the entries from the appropriate tables which were joined to make the view.

[Former Member]

How is this view maintained? do you have individual maintenance for the view tables as well?

[Former Member]

Hi Srinivas,

There is no individual Maintenance for this view.

Regards,

Ramesh.

[former_member188685]

Hi,

you have the selection screen for the view, with that you can control the data, using selection criteria you can exclude them, but if you want them to exclude from the table then you need to remove it from the join tables also. this will be big task. <b>i feel using selection restriction is easy.</b>

Regards

Vijay

[Former Member]

How is the view maintained?