topic Re: Equivalent select statement for complex selection in Application Development and Automation Discussions

Equivalent select statement for complex selection

Former Member — Thu, 02 Mar 2006 12:46:43 GMT

HI,

What is the equivalent select statement for below mentioned condition.

SELECT-OPTIONS : SALEDOCU FOR VBAK-VBELN OBLIGATORY,

DATE FOR VBAK-ERDAT OBLIGATORY,

CHANEEL FOR VBAK-VTWEG,

SALETYPE FOR VBAK-AUART OBLIGATORY DEFAULT 'QT'

NO INTERVALS NO-EXTENSION.

Regards,

John.

Re: Equivalent select statement for complex selection

FredericGirod — Thu, 02 Mar 2006 12:49:48 GMT

mmmh, what do you means with equivalent select ?

select * from vbak
       where vbeln in saledocu 
       and   erdat in date
       and   vtweg in chaneel
       and   auart in saletype.

endselect.

Rgd

Frédéric

Re: Equivalent select statement for complex selection

Former Member — Thu, 02 Mar 2006 12:52:08 GMT

Hi john,

1. we can use like this :

DATA : itab LIKE TABLE OF vbak WITH HEADER LINE.

SELECT * FROM vbak

INTO TABLE itab

WHERE vbeln IN saledocu

AND audat IN date

AND vtweg IN chaneel

AND auart in saletype

regards,

amit m.

Re: Equivalent select statement for complex selection

Former Member — Thu, 02 Mar 2006 12:53:01 GMT

Hi,

Select * from VBAK into table it_vbak

where vbeln in SALEDOCU

and ERDAT in DATE

and AUART in SALETYPE

and VTWEG in CHANEEL.

Regards,

GSR.

Re: Equivalent select statement for complex selection

Former Member — Thu, 02 Mar 2006 12:54:55 GMT

Hi john dias

select * from vbak where vbeln in saledocu and erdat in date and vtweg in chanel and auart in saletype.

you can use AND or OR as per requirement.

regards

kishore

Re: Equivalent select statement for complex selection

Former Member — Thu, 02 Mar 2006 12:55:39 GMT

hi john,

Could you be please clear about ur question.

What i understand is ur looking for a select query using the above selection screen parameters.

You can use Array fetch by doing:

select * from vbak into table it_vbak

where vbeln in saledocu

and erdat in date

and vtweg in chaneel

and auart in saletype.

Cheers

Sunny

Re: Equivalent select statement for complex selection

Former Member — Thu, 02 Mar 2006 12:57:03 GMT

hi,

you can use following code.

tables vbak.

data : begin of t_vbak occurs 0.

include structure vbak.

data : end of t_vbak.

select * from vbak into table t_vbak where

vbeln in saledocu and

erdat in date and

vtweg in chaneel and

auart in saletype.

Hope this helps.

Regards,

Shashank

Re: Equivalent select statement for complex selection

vinod_gunaware2 — Thu, 02 Mar 2006 13:04:08 GMT

use In operation in where condition of select.

regard

vinod

Re: Equivalent select statement for complex selection

Former Member — Thu, 02 Mar 2006 13:18:22 GMT

tables : vbak.

start-of-selection.

select * into table itab from vbak

where vbeln in saledocu

and erdat in date

and vtweg in channel

______________________

and auart in saletype

_______________________

*or u can use as

select * into table itab from vbak

where vbeln in saledocu

and erdat in date

and vtweg in channel

________________________

and auart = 'QT'.

_________________

regards,

vijay.