How to set attribute values to initial when ECC master data deleted

[Former Member]

I have a generic datasource on KNVP table.  Sometimes the Ship-To (KNVP-PARVW="WE") record is deleted from the KNVP table.  When this happens, I need to set the BW attribute values to initial for the deleted records.  Since the record no longer exists in the KNVP table, the record will not be transferred to BW anymore.  Is executing a self-update in BW to first set all the attribute values to initial and then execute the update for the datasource the best process to set the attribute values to blank for  the deleted KNVP master records?

Thanks.

[Former Member]

Hi,

Full load extracts all the data in BW from source Tables.It will load each records whatever is changed in source tables.

In case of Delta Load ,The MD Job triggers first with attribute change run.it will activate all the attributes/Text and then if you run the delta load it will work.

Regards,

Vijay

[former_member185132]

Hi,

Is the Infopackage a delta or a full? If it is a full, then what you propose is fine.

If it is a delta, then this approach will not work.

Regards,

Suhas