cancel
Showing results for 
Search instead for 
Did you mean: 

How to delete data from DSO if deleted from Source system for generic exctractor

pavneet_rana
Active Participant
0 Kudos

Hi to all,

Please can any one share some light on below senerio.

We have a generic extractor and based on time satamp field we are geting delta to DSO in BI.

Now if in source system if we delete some data, then how this will be captured in as 'D' image, so it can delete data from DSO in BI ?.

Is there any way we can write any program in generice extractor or any BADI can be sued for this purpose to get 'D' image in BI ?.

or any other way also ?.

Regards

Pavneet Rana

Accepted Solutions (0)

Answers (4)

Answers (4)

RamanKorrapati
Active Contributor
0 Kudos

Hi,

in general when source team will delete the record from SAP(ECC), same information need to pass to BW team to take same action from bw. thru selective deletion we can do the particular record deletion form bw targets.

Thanks

former_member182196
Contributor
0 Kudos

Hi,

Ask user to delete records from the T code not directly in table label, So if you deleting in this manner then your you will get records mode D in DSO for delete records.

other wise use selective deletion option.

Regards,

SM

RamanKorrapati
Active Contributor
0 Kudos

Hi,

If records are deleted from source then there won't be any record will come into dso as D image.

by using program we can't propose D images, its need to come in standard way only.

if you just need delete records into bw side, then with help of source team, create a custom table and store all deleted(going to delete at source) records and pull them into bw.

Thanks

sakthi_ss
Active Participant
0 Kudos

Hi Pavneet

This generic extractor is it on a view or functional module?

What are the ECC tables involved in the extraction?

Regards,

Sakthi.

pavneet_rana
Active Participant
0 Kudos

Thanks for reply.,

This genercie extracotre based on FM, and source system in SAP TM.

Does is that possible that if i change the DELTA field from AIE to AIED in ROOSURCE table for this generic extracotr, does it will bring the 'D' image to BI.


Regards

Pavneet Rana

sakthi_ss
Active Participant
0 Kudos

Pavneet What are the table from which this extractor is getting data from?

or else

by any-chance is there any deletion indicator (flag) in the data extracted at source system?