topic Re: select quiery in Application Development and Automation Discussions

select quiery

Former Member — Thu, 03 Aug 2006 19:35:23 GMT

Hi everybody

plz help in writing select quiery

in the spec it given as

'qals-matnr selected based on the inspection lot number qals-prueflos in transaction qa32 the matnr material number will include dashes. for example 0398-0457-08-c1 MAT NO = MATNO 0398-0457--08-c1.'

can u plz me how to write this select statement.

regards

siri

Re: select quiery

Former Member — Thu, 03 Aug 2006 20:16:24 GMT

someone plz help me friends

regards

siri

Re: select quiery

RichHeilman — Thu, 03 Aug 2006 20:20:12 GMT

This is about all I could get out of the "Horrible" spec that you were given.



report zrich_0001.

data: xmatnr type qals-matnr.

parameters: p_ps type qals-prueflos.

select Single matnr into xmatnr
              from qals
                   where prueflos = p_ps.

  write:/ xmatnr.

Regards,

Rich Heilman

Comment on horrible spec

Message was edited by: Rich Heilman

Re: select quiery

Former Member — Thu, 03 Aug 2006 20:20:16 GMT

If this is the spec you got, then it is horrible. It doesn't talk about what to select from what tables using what conditions. The information 'matnr material number will include dashes. for example 0398-0457-08-c1 MAT NO = MATNO 0398-0457--08-c1.' doesn't tell why that is given.

Please go back to the person who wrote the spec and ask for some more details.

Re: select quiery

LucianoBentiveg — Thu, 03 Aug 2006 20:21:13 GMT

Can you clarify your answer?

Re: select quiery

Former Member — Thu, 03 Aug 2006 20:23:15 GMT

Hi,

Try this:

parameters: p_lotnum type qplos.

data: wa_matnr type matnr.

select single selmatnr from qals into wa_matnr
   where prueflos = p_lotnum.
if sy-subrc ne 0.
*  handle "not found" case
endif.

The material number is just a character field, so I don't see how the dashes come into play. If table QALS already stores the material number with the dashes, then the value you select into wa_matnr will also have the dashes.

Best Regards,

James

Re: select quiery

LucianoBentiveg — Thu, 03 Aug 2006 20:23:38 GMT

Yes, like Srinivas says, go back to the person who wrote the spec and ask for some more details (and hit him too).

Re: select quiery

Former Member — Thu, 03 Aug 2006 20:24:21 GMT

Rich,

You are too fast for me... lol Once again great minds thinking alike (see my reply above).

One other thing I noticed is that table QALS has multiple fields with data element MATNR. Not sure if SELMATNR or MATNR is the correct field, but I'd guess that it is MATNR.

Cheers,

James

Re: select quiery

RichHeilman — Thu, 03 Aug 2006 20:25:34 GMT

LOL!!!! Peluka, thanks, I needed that laugh today. I busted up laughing really loud after reading that. People were looking at me funny.

Regards,

Rich Heilman

Re: select quiery

RichHeilman — Thu, 03 Aug 2006 20:31:50 GMT

James, the MATNR field does exists in this table. I can't really tell which field will actually hold the correct data as we do not use this file in my system. Table Records = 0

REgards,

Rich Heilman