Skip to Content
author's profile photo Former Member
Former Member

An exception with the type CX_SY_OPEN_SQL_DB occurred,plz solve this

Hi ,

i want 2 display the fields from crmd_order_index table.

i written the code in ON INTIALIZATION IS LIKE THIS

select guid

header

item

object_type

partner_no from crmd_order_index INTO

table index

WHERE object_type eq 'bus2000140' and partner_no eq partner_no.

BUT I M GETTING THE

An exception with the type CX_SY_OPEN_SQL_DB occurred,An exception with the type CX_SY_OPEN_SQL_DB occurred,

The data that was read could not be written to the specified target field during a SELECT access. Either the conversion is not supported for the type of the target field, or the target field is too short to accept the value, or the data is not in the appropriateformat for the target field.

PLEASE SOLVE THIS PROBLEM.

THANKS,

Usha

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jan 21, 2008 at 12:19 PM

    whats the definition of the internal table index? (note: index is a key word would suggest to name your internal table with another name)

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi

      i declared in type definitions

      types:it_index type standard table of crmd_order_index,

      wa_index type crmd_order_index.

      with respect to these declarations i decalred in page attributes like this

      index type it_index

      wa type wa_index.

  • Posted on Jan 21, 2008 at 12:55 PM

    i dont have crm system to check the table crmd_order_index .

    try this.

    select guid 
    header
    item 
    object_type
    partner_no from crmd_order_index INTO corresponding fields of 
    table index
    WHERE object_type eq 'bus2000140' and partner_no eq partner_no.
    
    

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2008 at 06:18 AM

    hi

    my problem is solved

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.