Delete SD master data and transaction data

[Former Member]

Hi,

My requirement is to delete all the SD master data and SD transactional data for specific company codes.

Are there any transaction codes or standard reports for this?

[Lakshmipathi]

Dear Shubhada

If your intention is to hide all master and transactinal datas from a particular company code, I dont think this is possible. For example, if you delete any billing document, in the document flow, not only you can see the billing reference but also the cancellation document.

Deletion of Master datas is not possible in standard but if you write a code as suggested here, you can achieve that but strictly speaking, it is not recommended.

thanks

G. Lakshmipathi

[Former Member]

Yes there is a Code for Deletion of Customer Master Data .

Ask your abaper to Configure a Transaction Code for the Program Code.

REPORT ZCUSTOMER_CHANGE.

TABLES : KNA1.

PARAMETER : KUNNR LIKE KNA1-KUNNR,

KTOKD LIKE KNA1-KTOKD.

*SELECT * FROM KNA1 WHERE KUNNR = KUNNR.

*KNA1-KTOKD = KTOKD.

*MODIFY KNA1.

*ENDSELECT.

select * from kna1 where KUNNR = KUNNR.

DELETE KNA1.

ENDSELECT.

You can delete the transactional Data from Billing cancelation to Delievry deletion collectively.

And then Delete Sales Orders.

regards,

Amlan Sarkar

[Former Member]

Hello Shubhada,

Could U plz share, What exactly has triggered this reqmnt?

Plz consider archiving them using standard Archiving Objects like SD_VBAK, SD_VBAP or FI_ACCRECV etc..Though, it is time taking, it is a safe and long term solution..

Let me know, you require more information on this..

Rgds,

Raghu.

Edited by: Raghuram Saripalli on Jul 16, 2008 5:42 PM

[Former Member]

Hi Raghu,

My server contains 4 company codes data out of which requirement is to keep data for only 2 company codes.

Thats why need to delete all the data for all the SAP modules

for unwanted comapany codes.

Is there any other way besides Archiving? As data is huge, archiving will take a lot of time.

Please comment.

Regards,

Shubhada

[Former Member]

Hello Shubhada,

Well, am sure its not just about deleting 2 Company Codes..it is about deleting all the dependent masters and all the transaction data/assignments--so, archiving is the best option.

However, there is a transaction OABL-- This transaction will reset all the application data from Asset Accounting in one company code !!!

There are lot of other implications, which am not very sure of..

check with one of FI guys for complete information on this..

Assign points, if helpful.

Rgds,

Raghu.

[Former Member]

Hi,

U can Use CATT For it.

http://www.sap-img.com/sap-catt.htm

Thanks,

Raja

[Former Member]

HI,

Please try with MASS or CATT if not then please try to do with BDC by taking help from ABAPer...

Regards

sankar