topic Re: Re:Databaseview entries deletion in Application Development and Automation Discussions

Re:Databaseview entries deletion

Former Member — Tue, 12 Jan 2010 05:49:55 GMT

hi experts,

I need to delete the entries from database view in which it is linked with two tables .i have deleted the entries from that two tables

but still entries are exists in the database view.

is there any possiblity to do that ?

if so,could you please help me out to solve this issue?

Thanks & Regards,

R.Dhineshraj.

Edited by: dhinesh raj on Jan 12, 2010 1:51 PM

Re: Re:Databaseview entries deletion

Former Member — Tue, 12 Jan 2010 05:54:25 GMT

Hi dhinesh,

If the view is a database view, then deleting records from table should automatically reflect in the view.

After all it is a view, it does not have any entries of its own, it just SHOWS / VIEWS the entries in the corresponding tables.

Just make sure that the view has only two tables, and no other tables, and also make sure the view had MANDT field as one of the join condition.

Regards,

Amit Mittal.

Re: Re:Databaseview entries deletion

Former Member — Tue, 12 Jan 2010 06:47:39 GMT

Hi Amit,

I agree with you but it s not reflecting in my database view after deleting the entries from the tables which are involved in my database view.so that was the problem i am facing now .

Could you please help me to solve this issue?

Thanks &b Regards,

R.dhineshraj.

Re: Re:Databaseview entries deletion

Former Member — Tue, 12 Jan 2010 06:48:55 GMT

Hi again,

Is the view and the related tables Z or standard one. And what are the field (key joining fields). Type of view. If you can give some information, that would be helpful.

regards,

amit m.

Re: Re:Databaseview entries deletion

vinod_vemuru2 — Tue, 12 Jan 2010 06:52:24 GMT

Hi,

This might be because of table buffering issue. Can you try to logoff from SAP, relogin and see?

Other way could be, just write a small select query on this view to fetch the deleted entries.

Please note that view is just an INNER JOIN of the tables specified in the view.

Thanks,

Vinod.

Re: Re:Databaseview entries deletion

Former Member — Tue, 12 Jan 2010 08:10:52 GMT

Hi Amit,

Sorry for the late reply.I have created the view for custom tables only (ztable) and what are all the fields i have used in that

view is three primary fileds

first one is mandt

second one is project definition

and the last one is material number

and for these fields only, i am comparing in both the custom tables.

Re: Re:Databaseview entries deletion

Former Member — Tue, 12 Jan 2010 08:47:40 GMT

Hi again,

Suppose in view you are getting records related to Project XXXX and Material YYYY, then all records for project XXXX (in Ztable1) should be deleted, and all records for material YYYY (in Ztable2) should be deleted.

(Atleast if one (either XXXX or YYYY) is not there, then based upon inner join (and not outer join), the records will not come in view). If it is still coming, then it is really strange. I think there should be some minor mistake somewhere other wise this should not happen. I can only say to check again and make sure all objects are activated.

Regards,

Amit Mittal.