generic delta update into ODS

[Former Member]

Hi everybady,

I have created generic infosource based on some InfoSet. Delta field CANGE_DT has format YYYYMMDDHHMMSS (time stamp). Data target is ODS. I've initialized delta and get all new records as delta. But if I delete some records on the R/3 side, I have't got any changes in the BW side. Could you give me a hand with resolving the problem.

Thanks,

Aleks.

[sven_mader2]

Hi,

don't delete data in R/3.

=> in BW you have no data/delta. So you can't calculate something.

Can you set a flag in R/3 table - like LOEVM in MARA? So you can set in the BW the keyfigure to 0 or delete the record with 0RECORDMODE.

Or: you must implement a myself-transformation. Then check, your data.

- You must load all data every day.

- create a infoobject for current day.

- then check is the value of the infoobject not today.

=> this data you havn't loaded today => this data was deleted.

Sven

[Former Member]

Thanks, for help !

[MartinMaruskin]

Are you using characteristics 0RECORDMODE (R/3 field ROCANCEL) in your data flow?

By this field changes of data are taken into consideration, like add/change/delete.

[Former Member]

Hi Martin,

No, we haven't used the field Rocancel because sourse table is ourself develop, w/o field contained operation flag. Martin, if I'll add the field ROCANCEL and I set it after change records, how the system unset it after successful loading data in the BW?

Aleks.