How To Update only characteristics in ODS or in Cube

[Former Member]

Hi, All BW Gurus,

Here i got a scenario in which i have to update only charasteristics in ODS so how to achieve this. I have created two Generic Data Sources one from MSEG and other from RSEG table. for that i have created two ODS and from this ODS i am updating one more ODS,

Now from here i am creating report like Global Purchase.

from here i can see all different wise report like Plant, company,broker , trader,purchasing group, purchase org,supplying vendor,

my problem is i am updating data from RSEG table where I do not have all thias different charasteristics so it is not possible to show IV Value and Quantity. ,but if i can update all these req charasteristics against Purchae Order Doc and Item then it is possible. so can any body tell me hoe to solve this problem

Thanks in Adavance.

I know best way to reward.

Kiran Patel

SAP BW

[former_member184494 · Accepted solution]

Kiran,

By having the right combination of key fields in the ODS - you can update only the characteristics into the same - look at having the characteristic only extractor going in first followed by the one with the numbers..

Arun

[Former Member · Accepted solution]

Hi , Arun Varadarajan

Thanks for immediate reply,

but whatever you said that i have done it, and here system is adding new record instead of updating existing record.

here i don't want to add more record in ODS only Update existing record.

thanks

Kiran Patel

[Former Member · Accepted solution]

Hi All BW Experts,

Please give me some input,

your valuable time and input will be appriciated to give solution.

thanks

Kiran Patel