Skip to Content

BW update master data key value


We are using SAP BW on HANA SP 10.

I have a master data Infoobject as Z_CustID with 15 characters 12345678XCVAB and all its transaction data are loaded into many DSOs.

Now we have requirement to consider only the first of 6 Characters as 123456. I can correct it in transaction data (DSOs) in end routine to get only first 6 characters.

But how to correct master data without inserting a new row.

In master data infoobject also would like to have 123456 instead of 12345678XCVAB.

  1. Delete and reinsert is the best option? Will BW allow to delete master data when transaction data available?
  2. Is there any other best way?

Thanks a lot in advance!



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 16, 2017 at 09:23 AM


    when you change the transactional flow to length 6, automatically all those "new" entries will be created in MD object, so you will have to do a reload of your MD as well. to have the attributes correctly linked with your data.



    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      if the Master Data is still connected via SID's with Transactional Data you can not delete it. But when you have no "old" data in your transactional flow, you can easily delete the Master data of you infoobject, do also delete the SID's, right click on infoobject and delete master data!