Deleting fields from a standard view

[Former Member]

Hello,

I want to delete fields form standard view which are appended by me accidentally . I have written a delete statement to delete the fields from the standard view . but i got an error at declaration part . I have declared it as shown below

Tables : V_MMIM_REP_CUST

V_MMIM_REP_CUST----

---

> is the view name

So, guide me how to declare this view .

Regards,

mnarar.

Edited by: mnarar on Nov 30, 2011 1:12 PM

[Former Member]

Hello,

I want to delete fields form standard view which are appended by me accidentally . I have written a delete statement to delete the fields from the standard view . but i got an error at declaration part . I have declared it as shown below

Tables : V_MMIM_REP_CUST

V_MMIM_REP_CUST----

---

> is the view name

So, guide me how to declare this view .

Regards,

mnarar.

Edited by: mnarar on Nov 30, 2011 1:12 PM

[Former Member]

Hi

But what do you want to delete?

I mean why you're writing a delete statament?

DELETE is to delete a record, not a field.

V_MMIM_REP_CUST is maintenance view, so it can't use with TABLES statament, you should use the transparent table MMIM_REP_CUST instead of the view.

But it's not clear what you need to delete

If you mean to delete some wrong records, you don't need a program, but you can do it by SM30

Max

[Former Member]

Hello,

I tried to delete a field from the view [ V_MMIM_REP_CUST ] from SM30 but there was a warning that it is a ross-client even though i tried to delete it then i got an information that

" Entry MKPF BUDAT must not be deleted " . so, ois there any possible way to delete the field from a view.

Thanks & Regards ,

MNARAR.

[Former Member]

hi mnarar,

u cannot delete the record directly ,

if u want to delete the record then go to the table mmim_rep_cust ,

se11-->table = mmim_rep_cust. select display.

now give ctrlshiftf10 and execute ,

here u can delete the records directly( check the record , menu-option table entry -select delete.).

[samantak_chatterjee]

Hi,

This is just an idea to delete the records from the Table. But ideally you should not use this approach in any development.

The table for this view is MMIM_REP_CUST. You can write a Custom Report Program where you need to create a work area with the values which you would like to delete. And then write a Delete statement and delete the table entry from that work area.

I guess you are doing this in the development environment and have all the necessary authorizations. And you should not transport any report like the above to other environments. Also double check if that entry will not effect other business scenarios.

Hope this helps.

Best Regards,

Samantak.

[Former Member]

null

Edited by: mnarar on Dec 2, 2011 9:54 AM

Edited by: mnarar on Dec 2, 2011 9:55 AM