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

Select statement failing when Interaction Records are in error

Hi,

I'm unable to select from table crmd_activity_h, even though the entries to be retrieved are in the table. These records are actually error records. When I'm correcting the error in those records, only then the select is working. Can anyone pls tell me why this is happening and what I can do to retrieve all records as per selection criteria even if they are in error.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 12:25 PM

    You might get a better answer in ABAP forum since this is a basic ABAP question. As far as I know ABAP, if there is an entry in the table and if your select statement is not picking it up (whereas it was supposed to do that) , then its problem with your SELECT queury and it has nothing to do with the error record.

    So, probably you could specify your query so that someone can help. I am sure its a syntax error.

    Regards,

    Alin

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 07:17 AM

    try giving where condition. select where record type = error

    regards

    dheeraj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 07:23 AM

    try giving where condition. select where record type = error

    regards

    dheeraj

    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.