topic Re: performance in select statement in Application Development and Automation Discussions

performance in select statement

Former Member — Mon, 16 Jul 2007 11:10:21 GMT

Hi Everybody,

i had a small problem that

in selection screen iam gaetting company code,date as input for bsid-budat

i need to fetch data from bsid using company code and budat

But with condition:

If posting date (from parameter) is not blank.

Get all items with BSID-BUDAT less than or equal to “Posting Date”.

Else.

Do not filter by posting date.

Endif.

now how to write the select statement

select BUKRS KUNNR ZUONR GJAHR BELNR

FROM BSID

INTO TABLE ITAB

WHERE BUKRS IN S_BUKRS AND

BUDAT ..................... .

WHAT SHOULD BE THE ........

Re: performance in select statement

Former Member — Mon, 16 Jul 2007 11:13:15 GMT

IF NOT P_BUDAT IS INITIAL.

select BUKRS KUNNR ZUONR GJAHR BELNR 
FROM BSID 
INTO TABLE ITAB
WHERE BUKRS IN S_BUKRS AND
BUDAT LE P_BUDAT.

ELSE.

 select BUKRS KUNNR ZUONR GJAHR BELNR 
FROM BSID 
INTO TABLE ITAB
WHERE BUKRS IN S_BUKRS.

ENDIF.

Re: performance in select statement

Former Member — Mon, 16 Jul 2007 11:13:48 GMT

Ur parameter screen is having Posting date as p_pdate.

select BUKRS KUNNR ZUONR GJAHR BELNR

FROM BSID

INTO TABLE ITAB

WHERE BUKRS IN S_BUKRS AND

BUDAT <=( or give LE) p_pdat.

Re: performance in select statement

Former Member — Mon, 16 Jul 2007 11:13:48 GMT

Hi,

Dont give the less than or equal condition in select query . fetch all records then filter data in itab. then performance will be good.

regards,

Nandha

Reward if it helps

Re: performance in select statement

Former Member — Mon, 16 Jul 2007 11:14:05 GMT

Hi,

the select shud be conditional :

if Posting date is not initial.

select BUKRS KUNNR ZUONR GJAHR BELNR

FROM BSID

INTO TABLE ITAB

WHERE BUKRS IN S_BUKRS AND

BUDAT LT Posting date .

else.

select BUKRS KUNNR ZUONR GJAHR BELNR

FROM BSID

INTO TABLE ITAB

WHERE BUKRS IN S_BUKRS.

endif.

Regards,

Himanshu

Re: performance in select statement

Former Member — Mon, 16 Jul 2007 11:16:08 GMT

hi Sunil

set Parameter as Mandatory (OBLIGATORY) then you no need to check its not blank ...

you must enter data otherwise your cant proceed

select *

into corresponding fields of <itab>

from BUDAT

where budat eq <date - parameter>

Rewards if useful.

Re: performance in select statement

Former Member — Mon, 16 Jul 2007 11:21:27 GMT

Hi sunil,

try this:

TABLES: BSID.

SELECT-OPTIONS: S_BUKRS FOR BSID-BUKRS.

PARAMETERS: P_BUDAT LIKE BSID-BUDAT.

IF NOT P_BUDAT IS INITIAL.

SELECT * FROM BSID WHERE BUKRS IN S_BUKRS

AND BUDAT LE P_BUDAT.

WRITE: / BSID-BUKRS, BSID-BUDAT.

ENDSELECT.

ENDIF.

Regards, Dieter

Re: performance in select statement

Former Member — Mon, 16 Jul 2007 11:21:33 GMT

IF P_DATE is not initial.
SELECT BUKRS KUNNR ZUONR GJAHR BELNR 
              FROM BSID 
               INTO TABLE ITAB
               WHERE BUKRS IN S_BUKRS 
                AND BUDAT LT P_DATE.

ELSE.
SELECT BUKRS KUNNR ZUONR GJAHR BELNR 
FROM BSID 
INTO TABLE ITAB
WHERE BUKRS IN S_BUKRS.

endif.

Re: performance in select statement

Former Member — Mon, 16 Jul 2007 11:21:38 GMT

IF P_DATE is not initial.
SELECT BUKRS KUNNR ZUONR GJAHR BELNR 
              FROM BSID 
               INTO TABLE ITAB
               WHERE BUKRS IN S_BUKRS 
                AND BUDAT LT P_DATE.

ELSE.
SELECT BUKRS KUNNR ZUONR GJAHR BELNR 
FROM BSID 
INTO TABLE ITAB
WHERE BUKRS IN S_BUKRS.

endif.

Re: performance in select statement

Former Member — Tue, 17 Jul 2007 04:41:33 GMT

keeping performance issue in mind.iam accessing the BSID without the BUDAT,later i will filter the data.

Thanks for all the guys replied for my query