topic Re: Select data from BKPF for a date range in Application Development and Automation Discussions

Select data from BKPF for a date range

Former Member — Wed, 15 Mar 2006 03:41:56 GMT

Hi,

I want to select data from BKPF depending upon the date range given in the selection screen.

SELECTION-SCREEN : BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.

" Selection Criteria

SELECT-OPTIONS : S_DATE FOR SY-DATUM OBLIGATORY.

SELECTION-SCREEN : END OF BLOCK B1.

How do I do that??.. Please help.

Thank You,

SB.

Re: Select data from BKPF for a date range

Former Member — Wed, 15 Mar 2006 03:44:38 GMT

TABLES: BKPF.
DATA itab LIKE TABLE OF bkpf WITH HEADER LINE.
SELECTION-SCREEN : BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.
" Selection Criteria
SELECT-OPTIONS : S_DATE FOR <b>BKPF-BLDAT</b> OBLIGATORY.
SELECTION-SCREEN : END OF BLOCK B1.

<b>SELECT *
 FROM BKPF
 INTO TABLE itab
 WHERE BLDAT IN s_date.</b>

Re: Select data from BKPF for a date range

Former Member — Wed, 15 Mar 2006 03:44:47 GMT

HI SB,

Create Indexes and select the data ...

i.e,

SELECTION-SCREEN : BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.

" Selection Criteria

<b>SELECT-OPTIONS : S_DATE FOR BKPF-BLDAT OBLIGATORY.</b>

SELECTION-SCREEN : END OF BLOCK B1.

<b> SELECT * FROM BKPF WHERE BLDAT IN s_date.</b>

Regards,

Santosh P

Message was edited by: Santosh Kumar Patha

Re: Select data from BKPF for a date range

Former Member — Wed, 15 Mar 2006 03:49:13 GMT

hi SB,

data : itab like table of bkpf with header line.
  tables :bkpf.
 SELECTION-SCREEN : BEGIN OF BLOCK B1 WITH FRAME TITLE  TEXT-001.
" Selection Criteria
SELECT-OPTIONS : S_DATE FOR bkpf-bldat OBLIGATORY.
SELECTION-SCREEN : END OF BLOCK B1.
 
 select * from bkbf 
  into table itab 
  where bldat in s_date.

regards

satesh

Re: Select data from BKPF for a date range

suresh_datti — Wed, 15 Mar 2006 03:50:35 GMT

Hi SB,

Santhosh is right.. An INDEX will be very useful if you are not using the key fields BUKRS,BELNR & GJAHR in the WHERE clause and just want to SELECT by BLDAT (Document date) or BUDAT (Posting Date).

Regards,

Suresh Datti

Re: Select data from BKPF for a date range

Former Member — Wed, 15 Mar 2006 03:51:47 GMT

Hi,

But will this selection select all the dates in the "from" date "to" date & between date ranges also ??

Thank You,

SB.

Re: Select data from BKPF for a date range

suresh_datti — Wed, 15 Mar 2006 03:52:53 GMT

YES

Suresh

Re: Select data from BKPF for a date range

Former Member — Wed, 15 Mar 2006 03:54:03 GMT

Yes,

In the selection screen enter the date from and to in the field.

It will retrieve all the results.

Re: Select data from BKPF for a date range

Former Member — Wed, 15 Mar 2006 03:55:15 GMT

hi Sb,

yes..it will select ..

if you want to select only either one of them ..

use

select * from bkpf into table itab where bldat eq s_date-low.

simliarly s_date-high.

regards

satesh

Re: Select data from BKPF for a date range

Former Member — Wed, 15 Mar 2006 03:56:17 GMT

Hi,

Declare internal table of BKPF.

In select statement compare the date in select-option with BUDAT .

select * from BKPF into where budat in S_date.

I think this will help u out....

Thanks,

Sreevani

Re: Select data from BKPF for a date range

Former Member — Wed, 15 Mar 2006 04:01:22 GMT

Thank You Santosh

Re: Select data from BKPF for a date range

Former Member — Wed, 15 Mar 2006 14:13:02 GMT

There's no need to create an index. There already is one on budat. If you construct your select properly, you'll be able to use it.

Rob