Help need in select statement?

[Former Member]

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

[Former Member]

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

[Former Member]

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<b> BUDAT IN RA_BUDAT.</b>

Vasanth

[Former Member]

Hello,

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

Thanks

Vasanth

[RichHeilman]

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

[Former Member]

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

[RichHeilman]

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

DATA: RA_BUDAT <b>TYPE</b> RANGE OF BUDAT WITH HEADER LINE.

Regards.

Rich Heilman

[RichHeilman]

<i>is there any possible simplest way... or this is the best way includes performance?</i>

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

[Former Member]

Thanks Rich & Vasanth.

I will appreciate your time and effort.

Regards

Giri