topic delete vendor master data in Application Development and Automation Discussions

delete vendor master data

Madjid_Khanevadegi — Wed, 07 Nov 2018 05:35:02 GMT

i whant to delete vendor master date with "OBR2" tcode . the vendor has not any transaction data . when i used this action . then vendor is deleted. but with "MK03" tcode this vendor is exists and in LFA1 table .

how can i delete the vendor compeletly

thanks

Re: delete vendor master data

DavidLY — Wed, 07 Nov 2018 05:50:19 GMT

Hello,

Hard delete of the Vendor Master Data is not recommended.

Once you have marked the vendors for deletion in XK06 transaction, you can then archive the vendors with SARA object FI_ACCPAYB in 3 steps.

Run for purchasing org data.
Run for company code data.
Run for general data.

System will check if the vendor is used in any document. if that is the case, then you have to archive these data first.

For more details, please refer to link: https://help.sap.com/saphelp_erp2005/helpdata/EN/01/a9b65c455711d182b40000e829fbfe/frameset.htm

Regards,

David

Re: delete vendor master data

Madjid_Khanevadegi — Wed, 07 Nov 2018 06:01:41 GMT

thank you David .

but i want delete vendor completely

Re: delete vendor master data

RaymondGiuseppi — Tue, 04 Dec 2018 10:34:29 GMT

Are you updating some test or quality system or are you purging some obsolete/errouneous data in a production system. OBR2 is intended to clean-up some initial (before golive) or replicated (development or quality system) FI and CO data, and not suitable in a productive system.

So in second case use David Liu solution

set deletion flag (XK06, FK06)
archive data (SARA)
delete data (SARA)

Hint: In SARA transaction, click on database table, and display every object related to the table you want to clean.