Question:
hello,
I have a Ztable in R/3 with a Zfield that I need to load into BW as an attributte of OMATERIAL.
This field has 8 decimal places that i need to keep in BW.
I have created a key figure and loaded the data, however the best I can get is 3 decimal places.
I have created the key figure as Quantity, Number, "key figure with maximum precision, etc. I have also tryed Number with data type FLTB, and I could get loats of decimal places in a ODS that I created for test porposes, however I got an error displaying the data on the 0MATERIAL because of this data type (FLTB)!!!!!
Can someone let me know how should I create my key figure to allow the 8 decimal places? Its very frustrating because I can see my 8 decimal places on the PSA and I loose it on the Master record / DataProvider
thanks
EF
Answer:
Just to let you know guys what I have done to solve this issue.
I have created a new domain with 17 + 8 decimal places (transaction SE11)
Then I created my Key Figure and enter in the data elemement (third Tab) then I changed the domain of the generated data element to my Zdomain.
regards
EF
Answer:
Hi EF,
Just wanted to know - how did you transport your new key figure with ZDOMAIN from BW Development system to BW Test/Production System ?
Thanx in advance.