topic Re: Query in Application Development and Automation Discussions

Query

Former Member — Wed, 17 Aug 2005 08:22:27 GMT

Hi,

I have a query with 3 fields numerics. But I don't know how to define it because if I define them like numeric, it doesn't work, if I define them like Char it doesn't works. In one case I define it like numerric but appears like float. I don't know if there are a function to convert the field to a numeric o something like that

Re: Query

Former Member — Wed, 17 Aug 2005 08:31:08 GMT

Hi, you do the query for which table?

Can you paste your code here?

Thanks a lot

Re: Query

Former Member — Wed, 17 Aug 2005 08:35:37 GMT

Hi,

It isn't in a program, it is by Infoset in the SQ02

Re: Query

Former Member — Wed, 17 Aug 2005 08:39:43 GMT

can u explain with some example for the output you are expecting in the query?

Re: Query

Former Member — Wed, 17 Aug 2005 09:06:37 GMT

I want this:

Field 1 Field2 Field3

box 2000 4000

But appears this:

Field 1 Field2 Field3

box 2E+4

Re: Query

Former Member — Wed, 17 Aug 2005 09:13:36 GMT

Hi,

U check with the output structure u defined.

Sometimes if the length of the Column Header and the field differs it will appear as Exponent too.

Re: Query

Former Member — Wed, 17 Aug 2005 09:19:31 GMT

I have this code in the query

TYPE-POOLS ibco2 .

DATA: v_conf_ca TYPE ibco2_instance_tab2,

v_atinn_ca LIKE ibvalue0-atinn,

v_values_ca LIKE ibvalue0.

FIELD-SYMBOLS:

<i_conf_ca> TYPE ibco2_instance_rec2.

******************************************************

CHECK NOT mara-cuobf IS INITIAL.

CALL FUNCTION 'CE_C_GET_CBASE'

EXPORTING

instance = mara-cuobf

IMPORTING

configuration = v_conf_ca

EXCEPTIONS

internal_error = 1

instance_is_a_classification = 2

OTHERS = 3.

READ TABLE v_conf_ca ASSIGNING <i_conf_ca> INDEX 1.

CALL FUNCTION 'CONVERSION_EXIT_ATINN_INPUT'

EXPORTING

input = 'CANAL'

IMPORTING

output = v_atinn_ca.

READ TABLE <i_conf_ca>-values

INTO v_values_ca WITH KEY atinn = v_atinn_ca.

WRITE v_values_ca-atwrt TO v_atwrt_canal.