topic Re: LOOGIC NEEDED in Application Development and Automation Discussions

LOOGIC NEEDED

Former Member — Wed, 06 Feb 2008 03:51:54 GMT

select single * from aufk where aufnr = zmm_isslip-aufnr and

werks = zmm_isslip-werks AND AUART BETWEEN 'PM01' And 'PM07'.

IS THIS THE CORRECT WAY TO USE BEWTEEN

pLZ GUIDE

Re: LOOGIC NEEDED

Former Member — Wed, 06 Feb 2008 03:53:53 GMT

instead of this you should write

select single * from aufk where aufnr = zmm_isslip-aufnr and

werks = zmm_isslip-werks

AND AUART GT 'PM01' And AUART LT 'PM07'.

plz reward if useful

keep rockin

vivek

Re: LOOGIC NEEDED

Former Member — Wed, 06 Feb 2008 04:02:21 GMT

hi,

Select single is to be used when only one unique record has to be picked from the database table.

Also in the query

select single * from aufk where aufnr = zmm_isslip-aufnr and

werks = zmm_isslip-werks AND AUART BETWEEN 'PM01' And 'PM07'.

YES Between can be used this way.

Its not clear whether you are using header or body of the table.

If you are using header then your query will work with ADDITION INTO wa(WORK AREA).

Re: LOOGIC NEEDED

former_member156446 — Wed, 06 Feb 2008 04:11:00 GMT

If I were you I would create a range for the Order type and use that.

ranges: ra_auart for vbap-auart.

MOVE 'I' TO ra_auart-sign.
MOVE 'EQ' TO ra_auart-option.
MOVE 'PM01' TO ra_auart-low.
APPEND ra_auart.
MOVE 'PM07' TO ra_auart-low.
APPEND ra_auart.
CLEAR ra_auart.


select single * from aufk 
where aufnr = zmm_isslip-aufnr and
werks = zmm_isslip-werks AND 
AUART in ra_aurat.


select single * from aufk
where aufnr = zmm_isslip-aufnr and
werks = zmm_isslip-werks AND
AUART IN ('PM01' , 'PM07').

Re: LOOGIC NEEDED

Former Member — Wed, 06 Feb 2008 04:31:49 GMT

Hi,

Instead of between Use,

select single * from aufk

where aufnr = zmm_isslip-aufnr and

werks = zmm_isslip-werks AND

AUART IN 'PM01' And 'PM07'.

Don't forget to reward if useful...

Re: LOOGIC NEEDED

Former Member — Wed, 06 Feb 2008 04:38:52 GMT

hi,

select single * from aufk where

aufnr = zmm_isslip-aufnr and

werks = zmm_isslip-werks and

AUART IN ('PM01' , 'PM07').

here in works like between. it takes the ranges from Pm01 to pm07.

Re: LOOGIC NEEDED

Former Member — Wed, 06 Feb 2008 06:25:07 GMT

ERROR MESSAGE

The IN operator with "RA_AURAT" is followed neither by an internal table nor by a value list.

PLZ GUIDE

Re: LOOGIC NEEDED

Former Member — Wed, 06 Feb 2008 06:40:20 GMT

Hi Abhut,

I believe the query that you have writeen should work fine.

Example of using In between.

This expression is true if the content of the column col lies (not) between the values of data objects dobj1 and dobj2 (interval limits enclosed). You can define no column descriptor for the interval limits.

E.g.

SELECT carrid connid fldate

FROM sflight

INTO CORRESPONDING FIELDS OF TABLE sflight_tab

WHERE fldate BETWEEN sy-datum AND date.

Jayant Sahu