Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

We are passing 12345.000 to BDC but SAP saving it as 12345000.000!

former_member194142
Participant
0 Kudos

Hello

We have custom field in KNA1, say, Z_SIZE_QUAN_11_3, its data type is QUAN and length is 11 with 3 decimals.


We have a custom BDC program to create the customer records in KNA1, which will be run by WF-BATCH in background.


Users are creating customers from a saved variant of selection screen, on the selection screen the SIZE we defined as type of QUAN_11_3, in this variant the this QUAN_11_3 has value of 12345.000 (just as an example)


So, in this BDC program, we transferring the data from selection screen's QUAN_11_3 data into a LV_CHAR_17 local variable, then, we are passing this local LV_CHAR_17 data to BDC itab and finally calling XD01 transaction


But, after successful creation of customer I am seeing the size as 12,345,000.000 in XD02/XD03 transaction, actually it supposed to be just 12,345.000 because I passed LV_CHAR_17 just as 12,345.000


Pls. let us know why SAP is saving as 12,345,000.000?


Thank you

1 ACCEPTED SOLUTION

jogeswararao_kavala
Active Contributor
0 Kudos

Try by changing the default Decimal Notation ( to 1,234,567.89 ) as under:

OR

use Commas format in your code for Decimal Notation.

6 REPLIES 6

jogeswararao_kavala
Active Contributor
0 Kudos

Try by changing the default Decimal Notation ( to 1,234,567.89 ) as under:

OR

use Commas format in your code for Decimal Notation.

0 Kudos

Thank you, but since 3 yrs. my decimal notation in my user profile is PERIOD and the comma is thousand separator, hence am seeing as 12345.000 in debug mode, but in XD03 am seeing it as 12,345,000.000

I don't think this is something w/ decimal notation

0 Kudos

May be data types used are the reason. Check in this direction.

0 Kudos

In KAN1, the custom field is as QUAN 11_3,

In selection screen as QUAN_11_3

in BDC, its LV_CHAR_17, am passing this LV_CHAR_17 to BDC_ITAB into XD01 tx

All looks OK to me!

0 Kudos

In one of such threads (given below)  the author finally says


" THANKS EVERYBODY. My problem got solved. The problem was with the country currency setting under  general setting in SPRO."

0 Kudos

Thank you, yes, from provided thread's link helped me, it worked for me

Thx again