topic Re: Select is not selecting in Application Development and Automation Discussions

Select is not selecting

Former Member — Wed, 07 Jul 2010 12:19:43 GMT

i have written a select statement that although the table is populated with values, it is not selecting the records based upon the field i have specificed.


TYPES: BEGIN OF measure_docs,
        ref_obj TYPE imrc_mdocm,
        nodeid     TYPE diohfw_nodeid,
  END OF measure_docs.

        SELECT ref_obj nodeid FROM diohfw_nodes INTO TABLE gt_measure_docs
          FOR ALL ENTRIES IN gt_diohfw_nodes
          WHERE sup_nodeid = gt_diohfw_nodes-nodeid
          AND   type       = 'MDC'.
     

      IF NOT gt_measure_docs IS INITIAL.
        SELECT * FROM imrg INTO TABLE gt_imrg
          FOR ALL ENTRIES IN gt_measure_docs
          WHERE mdocm = lt_measure_docs-ref_obj.

      ENDIF.

i have 15 entries in my gt_measure_docs table... i can copy the paste into se11 IMRG and see the values in the data display.

the field mdocm has an ALPHA conversion on so i tried adding the 00000000000000000234 to convert to 234, but it still cannot find the entries... i am sure i have missed something simple....

i typed the "ref_obj" as imrc_mdocm but still no dice! :o( any ideas what i have missed?

Re: Select is not selecting

Former Member — Wed, 07 Jul 2010 12:27:14 GMT

Hi,

just add

IF NOT gt_measure_docs[] IS INITIAL.

and

SELECT * FROM imrg INTO TABLE gt_imrg

FOR ALL ENTRIES IN gt_measure_docs

WHERE mdocm = gt_measure_docs-ref_obj. --> GT

Edited by: Madhukar Shetty on Jul 7, 2010 2:27 PM

Re: Select is not selecting

Former Member — Wed, 07 Jul 2010 12:27:43 GMT

Hello


      IF NOT gt_measure_docs IS INITIAL. " <- gt_measure_docs
        SELECT * FROM imrg INTO TABLE gt_imrg
          FOR ALL ENTRIES IN gt_measure_docs " <- gt_measure_docs
          WHERE mdocm = lt_measure_docs-ref_obj. " <- lt_measure_docs ??? are you sure ?
 
      ENDIF.

Re: Select is not selecting

kesavadas_thekkillath — Wed, 07 Jul 2010 12:30:38 GMT

Ignore

Maroz - Well spotted

Edited by: Keshav.T on Jul 7, 2010 6:01 PM

Re: Select is not selecting

Former Member — Wed, 07 Jul 2010 12:47:06 GMT

sorry! that was still in there as i had loop round gt_measure_docs then called CONVERSION_EXIT_ALPHA_OUTPUT and changed the number and appended to a lt_measure_Docs as it was not working... i just did not change the LT back to GT for all of them.

i have now amended the code and it still does not like it.

Re: Select is not selecting

Former Member — Wed, 07 Jul 2010 13:36:13 GMT

Have you checked your data type/length mismatch? 40 characters in one table, 20 in the other...is it not matching because of that?

Re: Select is not selecting

prasenjit_sharma — Wed, 07 Jul 2010 20:32:08 GMT

Can you show your final code that does not work?

Regards

Prasenjit

Re: Select is not selecting

Former Member — Thu, 08 Jul 2010 11:57:53 GMT

i linked up on another field and via another table... works better now..

thanks anyway!