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

How to delete a record in Database View?

Former Member

‎2009 Sep 22 6:52 AM

0 Likes
1,455

HI All,

I have created a Database View using tables LIKP,LIPS,VBUK,VBUP.

In that view I am getting a extra record which is not exit in any tables

but its getting in database view.

I tried buffer memory refresh and even tried SE16n , SE11(thro CODE(DELE))..But record has not been

deleted.

Plz suggest wat shud i have to do to delete the record.

Thanks in advance and help realy appriciate.

Regards

Steve

HI All,

I have created a Database View using tables LIKP,LIPS,VBUK,VBUP.

In that view I am getting a extra record which is not exit in any tables

but its getting in database view.

I tried buffer memory refresh and even tried SE16n , SE11(thro CODE(DELE))..But record has not been

deleted.

Plz suggest wat shud i have to do to delete the record.

Thanks in advance and help realy appriciate.

Regards

Steve

Reply
7 REPLIES 7
Read only

Former Member

‎2009 Sep 22 6:56 AM

0 Likes
1,037

> 

> In that view I am getting a extra record which is not exit in any tables 
> but its getting in database view.

Your intention should be in search of the root of that extra record. Not the deleting it without knowing anything.

Sure, You have put join conditions correctly?

Cheers

Read only

Former Member
In response to Former Member

‎2009 Sep 22 7:04 AM

0 Likes
1,037

Dear Amit,

Thanks for your reply..

I searched that document number which is I am going to delete is not present in all the view tables.

But why View displaying me that document number.

And even i m not able to delete that number by getting an error "View can not be chaged '.

what other alternative u might have to handle this kind if issue..

Regards

Steve

Read only

Former Member
In response to Former Member

‎2009 Sep 22 7:33 AM

0 Likes
1,037

Hi,

I alreadt added MANDT field in join condition .

Now I am thinking that there might be a problem in Status maintance in view.

There is only Read option select not read and change..

Now I m writing a program to delete the extra record ..when i m activating I m getting an error 'the database view is write protected so it can not be changed'.

Now can v change the Access status in that view?

Regards

Steve

Read only

Former Member

‎2009 Sep 22 7:04 AM

0 Likes
1,037

Hello

Add MANDT field into join conditions for all tables.

Extra record will be deleted.

Read only

Former Member
In response to Former Member

‎2009 Sep 22 7:32 AM

0 Likes
1,037

Hi,

I alreadt added MANDT field in join condition .

Now I am thinking that there might be a problem in Status maintance in view.

There is only Read option select not read and change..

Now I m writing a program to delete the extra record ..when i m activating I m getting an error 'the database view is write protected so it can not be changed'.

Now can v change the Access status in that view?

Regards

Steve

Read only

Former Member

‎2009 Sep 23 1:49 PM

0 Likes
1,037

solved

Read only

Former Member
In response to Former Member

‎2010 Jan 19 9:02 PM

0 Likes
1,037

Hi Steve,

First of all, I'm sorry... I know this is old...

I would have been good if you have explained how you solved this. Im facing a similar issue, can you please post your solution?

Thanks,

Pablo.