Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Re:Databaseview entries deletion

Former Member

‎2010 Jan 12 5:49 AM

0 Likes
861

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

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

Reply
6 REPLIES 6
Read only

Former Member

‎2010 Jan 12 5:54 AM

0 Likes
831

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.

Read only

Former Member
In response to Former Member

‎2010 Jan 12 6:47 AM

0 Likes
831

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.

Read only

Former Member
In response to Former Member

‎2010 Jan 12 6:48 AM

0 Likes
831

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.

Read only

vinod_vemuru2
Active Contributor
In response to Former Member

‎2010 Jan 12 6:52 AM

0 Likes
831

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.

Read only

Former Member
In response to Former Member

‎2010 Jan 12 8:10 AM

0 Likes
831

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.

Read only

Former Member
In response to Former Member

‎2010 Jan 12 8:47 AM

0 Likes
831

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.