topic Re: Select statement help in Application Development and Automation Discussions

Select statement help

Former Member — Wed, 30 Apr 2008 14:36:13 GMT

I need somebody to look at this statement for me. I can't figure out why it is giving me a syntax error:

DATA: meg001 LIKE coss-meg001,
      meg002 LIKE coss-meg002,
      meg003 LIKE coss-meg003,
      meg004 LIKE coss-meg004,
      meg005 LIKE coss-meg005,
      meg006 LIKE coss-meg006,
      meg007 LIKE coss-meg007,
      meg008 LIKE coss-meg008,
      meg009 LIKE coss-meg009,
      meg010 LIKE coss-meg010,
      meg011 LIKE coss-meg011,
      meg012 LIKE coss-meg012.




    SELECT SINGLE meg001 meg002 meg003 meg004 meg005 meg006 meg007 meg008 meg009 meg010 meg011 meg012
            INTO (d_meg001, d_meg002, d_meg003, d_meg004, d_meg005, d_meg006, d_meg007, d_meg008, d_meg009, d_meg010, d_meg011, d_meg012)
            FROM coss WHERE objnr = wa_table-objnr.

Regards,

Aaron

Re: Select statement help

Former Member — Wed, 30 Apr 2008 14:38:43 GMT

Hello,

You declared the data objects without d_ and in the select you're using d_ in the variables name.

Regards,

Re: Select statement help

Former Member — Wed, 30 Apr 2008 14:39:57 GMT

You know, I looked at it for 5 minutes and couldn't see that; now I feel like an idiot.

Thanks a lot!

Aaron

Re: Select statement help

Former Member — Wed, 30 Apr 2008 14:40:28 GMT

Try this,



DATA: d_meg001 LIKE coss-meg001,
      d_meg002 LIKE coss-meg002,
      d_meg003 LIKE coss-meg003,
      d_meg004 LIKE coss-meg004,
      d_meg005 LIKE coss-meg005,
      d_meg006 LIKE coss-meg006,
      d_meg007 LIKE coss-meg007,
      d_meg008 LIKE coss-meg008,
      d_meg009 LIKE coss-meg009,
      d_meg010 LIKE coss-meg010,
      d_meg011 LIKE coss-meg011,
      d_meg012 LIKE coss-meg012.
 
 
 
 
    SELECT SINGLE meg001 meg002 meg003 meg004 meg005 meg006 meg007 meg008 meg009 meg010 meg011 meg012
            INTO (d_meg001 , d_meg002 , d_meg003 , d_meg004 , d_meg005 , d_meg006 , d_meg007 , d_meg008 , d_meg009 , d_meg010 , d_meg011 , d_meg012)
            FROM coss WHERE objnr = wa_table-objnr.

Re: Select statement help

Former Member — Wed, 30 Apr 2008 14:41:11 GMT

Where did you declare d_meg001?

it should be into (meg001 , meg002....)

DATA: meg001 LIKE coss-meg001,

meg002 LIKE coss-meg002,

meg003 LIKE coss-meg003,

meg004 LIKE coss-meg004,

meg005 LIKE coss-meg005,

meg006 LIKE coss-meg006,

meg007 LIKE coss-meg007,

meg008 LIKE coss-meg008,

meg009 LIKE coss-meg009,

meg010 LIKE coss-meg010,

meg011 LIKE coss-meg011,

meg012 LIKE coss-meg012.

data: v_objnr type coss-objnr.

SELECT SINGLE meg001 meg002 meg003 meg004 meg005 meg006 meg007 meg008 meg009 meg010 meg011 meg012

INTO (meg001, meg002, meg003, meg004, meg005, meg006, meg007, meg008, meg009, meg010, meg011, meg012)

FROM coss WHERE objnr = v_objnr.

Re: Select statement help

rajasekhar_matukumalli3 — Wed, 30 Apr 2008 14:47:25 GMT

Hi,

You have declared the variables as

DATA: meg001 LIKE coss-meg001,

meg002 LIKE coss-meg002,

meg003 LIKE coss-meg003,

meg004 LIKE coss-meg004,

meg005 LIKE coss-meg005,

meg006 LIKE coss-meg006,

meg007 LIKE coss-meg007,

meg008 LIKE coss-meg008,

meg009 LIKE coss-meg009,

meg010 LIKE coss-meg010,

meg011 LIKE coss-meg011,

meg012 LIKE coss-meg012.

But you are selecting into d_meg001, d_meg002, d_meg003, d_meg004, d_meg005, d_meg006, d_meg007, d_meg008, d_meg009, d_meg010, d_meg011, d_meg012.

Remove D_ and execute the code.

Hope this solves your problem

Enjoy SAP

Raj