topic Re: Help need in select statement? in Application Development and Automation Discussions

Help need in select statement?

Former Member — Fri, 09 Feb 2007 15:44:14 GMT

Hi experts...

I have an internal table with 2 records...i_mara with fields matnr and ersda

matnr ersda

2345 01/26/2007

3445 02/05/2007

i need to write a select statement to collect all MBLNR from MKPF table where BUDAT is in between 01/26/2007 and 02/05/2007..

Thanx

Giri

Re: Help need in select statement?

Former Member — Fri, 09 Feb 2007 15:49:09 GMT

DATA: BEGIN OF IT_MBLNR OCCURS 0,

MBLNR LIKE MKPF-MBLNR,

BUDAT LIKE MKPF-BUDAT,

END OF IT_MBLNR.

IF NOT I_MARA[] IS INITIAL.

SELECT MBLNR BUDAT

INTO TABLE IT_MBLNR

FROM MKPF

FOR ALL ENTRIES IN I_MARA

WHERE BUDAT GE I_MARA-ERSDA AND BUDAT LE I_MARA-ERSDA.

ENDIF.

Thanks,

Santosh

Re: Help need in select statement?

Former Member — Fri, 09 Feb 2007 15:49:21 GMT

Hello,

Built a range table like this.

DATA: RA_BUDAT RANGE OF BUDAT WITH HEADER LINE.

Read table i_mara index 1.

RA_BUDAT-SIGN = 'I'.

RA_BUDAT-OPTION = 'BT'.

RA_BUDAT-LOW = i_mara-ersda.

Read table i_mara index 2.

RA_BUDAT-HIGH = i_mara-ersda.

APPEND RA_BUDAT.

SELCT MBLNR FROM MKPF INTO ITAB WHERE BUDAT IN RA_BUDAT.

Vasanth

Re: Help need in select statement?

RichHeilman — Fri, 09 Feb 2007 15:50:03 GMT

ranges: r_datum for sy-datum.
Data: imkpf type table of mkpf.

r_datum-sign = 'I'.
r_datum-option = 'BT'.

read table i_mara index 1.
r_datum-low = i_mara-ersda.

read table i_mara index 2.
r_datum-high = i_mara-ersda.

append r_datum.



select * into table imkpf from mkpf
               where BUDAT in R_DATUM.

You could try using a RANGE.

Regards,

Rich Heilman

Re: Help need in select statement?

Former Member — Fri, 09 Feb 2007 16:12:12 GMT

Hello,

May I know the difference between my answer and Mr. Rich's answer.

Thanks

Vasanth

Re: Help need in select statement?

Former Member — Fri, 09 Feb 2007 16:12:48 GMT

HI vasanth and rich...

thanks for replies...

vasanth i am getting error with the statement.. so i assigned 6 points to u..

DATA: RA_BUDAT RANGE OF BUDAT WITH HEADER LINE.

Unable to interpret range.... Possible error with spelling or comma

Rich: ur solution worked good....

is there any possible simplest way... or this is the best way includes performance?

Regards

Giri

Re: Help need in select statement?

RichHeilman — Fri, 09 Feb 2007 16:19:05 GMT

Vasanth's answer would have worked for you, but the TYPE keyword is missing in the DATA statement.

DATA: RA_BUDAT TYPE RANGE OF BUDAT WITH HEADER LINE.

Regards.

Rich Heilman

Re: Help need in select statement?

RichHeilman — Fri, 09 Feb 2007 16:21:45 GMT

is there any possible simplest way... or this is the best way includes performance?

Well, there are always 3 different ways to accomplish the same thing in ABAP. Some good, some bad, some it doesn't really matter. I like to use RANGES when working with multple values for a field in a SELECT statement, I think it is easier to understand and hence, the next developer can easily modify. Also, it is a matter of personal preferenece.

Regards,

Rich Heilman

Re: Help need in select statement?

Former Member — Fri, 09 Feb 2007 16:22:09 GMT

Thanks Rich & Vasanth.

I will appreciate your time and effort.

Regards

Giri