topic ALV and numeric fields in Application Development and Automation Discussions

ALV and numeric fields

Former Member — Wed, 13 Dec 2006 16:00:54 GMT

Hello,

I'm working with ALV tables.

In my code i have:

loop at t_clientes.

SELECT SINGLE * FROM knkk WHERE kunnr = t_clientes-kunnr

and kkber = t_clientes-bukrs.

i_alv_credito-limite = knkk-klimk.

if sy-subrc eq 0.

append i_alv_credito.

endif.

endloop.

i_alv_credito-limite have the Type knkk-klimk.

In SAP table i have knkk-klimk = '12.000.000,00' but when i saw that value in my ALV table i have '12000000,00'.

I want to have the same format than in Knkk-klimk.

How i can do that?

Thanks

Best regards

Re: ALV and numeric fields

Former Member — Wed, 13 Dec 2006 16:06:39 GMT

HI,

First Check your User Own data Settings.

In any SAP Screen click SYSTEM -> USER PROFILE -> USER OWN DATA

or open transactoin SU3.

Click on tab DEFAULTS.

on the left side there will be provision to choose the Decimal Notation, choose 1,234,567.89. Save the settings and run your ALV again.

Second option.

Along with the value specify the Corresponding Unit in ALV Fieldcatalog.

Regards,

Vara

Re: ALV and numeric fields

Former Member — Thu, 14 Dec 2006 08:58:54 GMT

Hi,

Didn't work.. In User Profile i already have the decimal notation.

In ALV Fieldcatalog i specify the value type currency, but it always appears '12000000,00' and not '12.000.000,00' .

Thanks

Best regards

Re: ALV and numeric fields

Former Member — Thu, 14 Dec 2006 09:05:35 GMT

try like this.

data : v_data(20).

loop at t_clientes.

SELECT SINGLE * FROM knkk WHERE kunnr = t_clientes-kunnr

and kkber = t_clientes-bukrs.

v_data = knkk-klimk

i_alv_credito-limite = v_data.

if sy-subrc eq 0.

append i_alv_credito.

endif.

endloop.

in your internal table declare the field as charecter.

it may work

regards

shiba dutta

Re: ALV and numeric fields

Former Member — Thu, 14 Dec 2006 09:15:20 GMT

also mentioned

in the field catalog parameters

reference tsble name & reference field name.......

( -just try it - iam not sure )

Ramesh.

Re: ALV and numeric fields

Former Member — Thu, 14 Dec 2006 10:28:16 GMT

Hi Yukimai,

Make sure you have specified REF_FIELDNAME and REF_TABNAME in the fieldcatalog with the following values:

REF_FIELDNAME = 'KLIMK'

REF_TABNAME = 'KNKK'

Regards,

Hendy

Re: ALV and numeric fields

Former Member — Thu, 14 Dec 2006 11:03:26 GMT

Hi,

in your output table add one more field for decimalplaces for ex say DECP.

and populate this field

then in your fieldcat for the field klimk decimalsfieldname = DECP

and decmal placestabname = your internal table name.

it will work.

assign points if helpful.

Regards

SAI

Re: ALV and numeric fields

Former Member — Thu, 14 Dec 2006 11:05:55 GMT

Hi,

You can try creating a conversion routine in the below allowd namespace

CONVERSION_EXIT_<i>XXXXX</i>_INPUT and

CONVERSION_EXIT_<i>XXXXX</i>_OUTPUT.

Inside the second one just write the code

WRITE input TO output CURRENCY .

And specify this conv, routine in ur ALV table

Regards,