Delete a single record of specific Master Data

[Former Member]

Hello Experts,

We have this InfoObject '0FUND' which is time-dependent. For a specific Master Data, exp: 40002, we have a list of records, that vary in 'Valid from' and 'Valid To'. Example:

FMArea__Fund____ValidTo____ValidFrom____Attribute...

CM______40002__31.12.2001__01.01.1000_____MOD

CM______40002__31.12.2002__01.01.2002_____MOD

CM______40002__31.12.2003__01.01.2003_____MOD

This master data as no transactional data in any InfoProvider. When we try to delete a single record, the system delete all the records for 0FUND=40002.

Is there possible to make a selective deletion, in order to choose a single record?

At same time, we delete from the InfoCube all transactional data assign to a specific Master Data in a particular year. Exp (0FUND=40022; 0FISCYEAR=2004). When we try to delete this specific record:

FMArea__Fund____ValidTo____ValidFrom____Attribute...

CM_____40022___31.12.2004__01.01.2004_____MOD

The BW System doesn't allow deleting this specific record. Why this occur, its necessary delete all the transactional data assigned to 40022 Master Data??

Best Regards,

IB

[Former Member]

Hi IB,

Yes. It is necessary to delete the transacton data where the master data is referred before deleting the master data. This because the master data value in the Cube/ODS looks up at the SID table for the master data.

Bye

Dinesh