cancel
Showing results for 
Search instead for 
Did you mean: 

In BPC, the value of a property gets truncated after loading from BW

0 Kudos
401

In BW, I have a custom infoobject which contains NET_WEIGHT field (QUAN 17,3). This field is mapped in the transformation file for BPC master data loading like this below:

NET_WEIGHT = 0NET_WEIGHT

After importing data, the value/amount in BPC is truncated whenever the amount contains 6 digits or more. It shows an asterisk * just before the thousand digit.

Note: Property in BPC has 17 char length (which is enough for the amount below right?).

BW ----> BPC

118.370,000 -----> *8370.000

What I noticed was DEC datatype that were mapped did not behave like this and still contained correct digits/format.

QUAN datatype fields had this truncate issue.

If you faced a similar issue, I appreciate your help on this 🙂

Accepted Solutions (0)

Answers (3)

Answers (3)

Shrikant_Jadhav
Active Contributor
0 Kudos

Hi Raymond,

Try changing decimal notation user defaults in SU3 and reload data.

-Shri

former_member186338
Active Contributor
0 Kudos

Try to create a simple routine badi to understand in debug mode what do you have in the table.

0 Kudos

I tried to increase length to 30 and also 40 but the amount was still truncated.. I also tried to change decimalpoint under OPTIONS but still did not work

former_member186338
Active Contributor
0 Kudos

Sorry, but PLEASE, respect forum rules! Your "answer" is not an answer. Use comment instead!

"I tried to increase length to 30 and also 40 but the amount was still truncated" - truncated to the same number of digits?

"decimalpoint under OPTIONS" - useless!!!

0 Kudos

"truncated to the same number of digits?"

Yes, it was still like this --> *8370.000