How to delete master data of specific country ?

[former_member217770]

We have master data from different  countries loaded to  same info object.

Now we need to delete all master data of specific country.  HOw is it possible?

Thanks all

[former_member186053]

Hi Naiduz,

I think selective deletion is not possible if master data being used in transaction data. But it is possible if it is not being used in anywhere. please go through the below link.

http://help.sap.com/saphelp_nw70/helpdata/EN/3b/f817385bf3be74e10000009b38f842/content.htm

In my opinion, you need to consider why you want to delete master data, as it is being used in other infoproviders already, you can check this using where used list.

If you do not want to see the data of that specific country, you can exclude that in a query. However, exclusion will decrease query performance.

Regards,

Vengal.

[former_member217770]

Hi Vengal,

now i have data from different source systems for info object.

I  need to delete data of only single source system.

can i do selective deletion of master data of a single source system   through request id or any other way?

[RamanKorrapati]

Hi,

Deleting master data is tricky one.,

First we need to delete the transaction data which belongs to country(specific country).

Later you can delete master data specific to country.

but in your case it will too hard to delete them. Better keep them as it easy.

Just reload your master data as per the needs.

Thanks

[Former Member]

Hi,

You can delete the entries through RSD1 by clicking on maintenance of master data

and then select the relevant entries for deletion but you have to take care of the related transaction data.

Please award some points if you find it useful.

Thanks

[former_member217770]

let me explain u

we have multiple source systems master data loaded to  one info object

no i need to delete master data  attr,text and hierarchies from one of the source systems .

we have already deleted transactional data of the particular source system

[RamanKorrapati]

Hi,

from one source system how many entries(records) you have?

at master data level, have you used source system object as compounded? if yes then you can delete the data thru below program.

if you have more data from your source system(which want delete) then selective deletion(manually) will be time consuming one.

So check report/SE38 - RSDMDD_DELETE_BATCH.

Use proper selections and delete the data which is specific to your source.

Assumed as you delete transaction data related to your source.

Thanks

[former_member217770]

Hi ,

FIRST I  DELETED TRANSACTIONAL DATA RELATED TO THE MASTER DATA INFO OBJECT.

THEN I  STARTED DELETING  A SPECIFIC SOURCE SYSTEM DATA.

BUT IT IS GIVING ERROR DELETING MASTER DATA.

THEN I DELETED THE LINKED INFO OBJECTS DAATA BUT STILL IT IS NOT ALLOWING ME DELTE MASTER DATA.

i AM ATTACHING SCREEN SHOTS

Then i  deleted  REFERENCE INFO OBJECT master data of  PRAN (NEMP)

STILL MASTER DATA IS NOT DELETING.

CAN YOU PLEASE SUGGEST

[former_member182516]

Hi Naidu,

You can create a program to forcibly delete the data entries from the P table of the info object with out deleting the Transaction data.

Its a small program you can take help of ABAP person.

Regards

KP