Skip to Content
0

BW update master data key value

May 12, 2017 at 01:15 PM

83

avatar image
Former Member

Hello,

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!

Regards,

Naru

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Koen Hesters May 16, 2017 at 09:23 AM
0

Hi,

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.

Grtz

Koen

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

How to correct already exiting MD?

0

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!

Grtz

Koen

0