Delete only the Purchasing view from vendor master data

[tamim_elmahmah]

Hello,

We need to delete only the purchasing view of vendors master data ( and leaving general data and company data as exists)

is this is possible ? and how can we make it ?

[Former Member]

Jurgen  Sir  ,  Normally  he  is  saying that  he  want  to  delete  at  Tables .

Is  their   any   effect If  he  do  the deletion  at   tables  ?

[JL23]

I said it: it creates inconsistencies is case of dependent data and may lead to dumps.

Such ideas are usually coming from people who have no experience with the complexity

What is the table for partners? WYT3 and this table is dependent to LFM1, like LFM2 is dependent, and if you have texts maintained at purchasing org level, then they are stored in STXH and STXL with a dynamic key which has the purchasing organization within the string.

An experiences user would not really consider record deletions from such complex structures.

[JL23]

Moderator message: I am sorry but I had to remove the "correct answer" as it was not correct.

It is well possible to remove the purchasing view via archiving, since archiving of vendor masters is divided into 3 activities: archiving purchasing view, archiving company code views, archiving general data.

Of course there are preconditions: you cannot archive purchasing data view if you had already created orders. In that case you have to archive the orders first.

See the network graphic,  in SARA enter object FI_ACCPAYB, then click the icon for network.

In that particular case you would even create inconsistencies if you delete a table entry.

And before you delete table entries you should in general know about the relationship of tables.

Just thinking that a vendor master is LFA1, LFB1 and LFM1 is much to short. Goto DB15, enter FI_ACCPAYB (this is the archiving object) in the lower part and see how much tables are returned. These are all tables that can have data if you maintain a vendor master.

Now check all those tables if they have a relation to LFM1 and if they contain data

what will happen if you delete the vendor despite of existing orders? you probably get a dump when you access the purchase order.

[Former Member]

Jurgen  Sir  ,  Normally  he  is  saying that  he  want  to  delete  at  Tables .

Is  their   any   effect If  he  do  the deletion  at   tables  ?

[Former Member]

Please  dont  delete  form  tables  .

[tamim_elmahmah]

ok,

An Abaper just told me to delete data form Table LFM1 directly,

what are the risks ??

Any one already did that ?

[Former Member]

Because  if  you  MK05 ,  when one user will try to use vendor code which is currently used by another user so he will get the message that locked/blocked  is locked by user xyz.

Mk06 -Deletion of vendor  will avoid the user to do any transaction on such vendor which is flag for deletion as if this Vendor is not in use.

[Former Member]

We  have    MK06  for   flag  for  deletion  but  i  Suggest  to  block  by using MK05

[tamim_elmahmah]

Thank you, but we need to delete, not only block purchasing vendor data.

is it possible ?

[former_member183424]

No its not possible to erase the view from vendor master record (any master data)..

You have to use either deletion flag or block...

Regards

Dev

[Prasoon]

Hi,

   The blocking method can block all purchasing activities of the vendor for the purchase organization.

   You may also check the archiving option. Refer the help doc: http://help.sap.com/saphelp_45b/helpdata/en/ba/4b68b8327911d2a25c0000e8a5f24f/content.htm

Regards,

AKPT

[tamim_elmahmah]

ok,

An Abaper just told me to delete data form Table LFM1 directly,

what are the risks ??

Any one already did that ?

[former_member183424]

No.. Never do that.

Never delete any data from a standard table...

It will create inconsistent.. It will be big issue later...

Regards

Dev

[Prasoon]

Hi,

   NEVER delete any entries from tables directly since It will create lot of inconsistencies. There can be lot of tables in which the data is loaded, other than the common tables known.

   If you still want to delete, you may check the archive option as explained in the help doc: Archiving Vendor Master Data

Regards,

AKPT

[tamim_elmahmah]

OK Thank you Dev

[Former Member]

Hi,

Use t-code XK05 and block only purchasing view of vendor master. if you want to block only specific purchasing org then first enter that purchasing org and active the check box button "selected purchasing org".

Mahesh

[Prasoon]

Hi,

   Use the transaction MK05 to block the vendor at purchase organization level.

Regards,

AKPT