topic select statement in Application Development and Automation Discussions

select statement

Former Member — Fri, 01 Dec 2006 19:43:25 GMT

Hello friends,

I amusing this select statement.

In my selection screen i have material number and the material number i am putting in the selection screen does not exist in my data base. So i am excepting it would not pull any results. However it is pulling all records. any suggestions,

SELECT a_{werks a}budat a_{grund a}ism03 a_{aufnr a}rueck a~rmzhl

a_{stzhl a}erzet

b_{matnr c}verid INTO CORRESPONDING FIELDS OF TABLE itab FROM

afru AS a INNER JOIN afpo AS b ON

a_{aufnr = b}aufnr INNER JOIN

mkal AS c ON b_{matnr = c}matnr

FOR ALL ENTRIES IN it_blpk

WHERE c~verid = it_blpk-verid

AND a~budat = it_blpk-budat

AND a~erzet = it_blpk-uzeit

and a~werks = it_blpk-werks

and b~matnr = it_blpk-matnr

and a~grund IN s_grund

and ( a_{budat >= c}adatu

and a_{budat <= c}bdatu )

and a~ism03 <> 0

and a~ile03 EQ 'STD'.

thanks ,

shejal.

Re: select statement

Former Member — Fri, 01 Dec 2006 19:46:01 GMT

Hi,

I believe the material number given in the selection screen is used in a different select statement that populates the internal table it_blpk..

ALso add this...

IF NOT it_blpk[] IS INITIAL.

SELECT a_{werks a}budat a_{grund a}ism03 a_{aufnr a}rueck a~rmzhl

a_{stzhl a}erzet

b_{matnr c}verid INTO CORRESPONDING FIELDS OF TABLE itab FROM

afru AS a INNER JOIN afpo AS b ON

a_{aufnr = b}aufnr INNER JOIN

mkal AS c ON b_{matnr = c}matnr

FOR ALL ENTRIES IN it_blpk

WHERE c~verid = it_blpk-verid

AND a~budat = it_blpk-budat

AND a~erzet = it_blpk-uzeit

and a~werks = it_blpk-werks

and b~matnr = it_blpk-matnr

and a~grund IN s_grund

and ( a_{budat >= c}adatu

and a_{budat <= c}bdatu )

and a~ism03 <> 0

and a~ile03 EQ 'STD'.

ENDIF.

Thanks,

Naren

Re: select statement

Former Member — Fri, 01 Dec 2006 19:46:49 GMT

Got it.

Re: select statement

Former Member — Fri, 01 Dec 2006 19:48:09 GMT

Yes u r right, It_blpk was initial because I am usng the selecting criteria for it_blpk.

Thanks,

Shejal.

Re: select statement

ferry_lianto — Fri, 01 Dec 2006 19:48:32 GMT

Hi,

Please ensure to check internal table it_blpk is not empty before select statement.

CHECK NOT it_blpk[] IS INITIAL.

...

Regards,

Ferry Lianto

Re: select statement

Former Member — Fri, 01 Dec 2006 19:49:14 GMT

Well, you're not showing the connection between what's on your selection screen (material no.) and the contents of it_blpk-matnr. Is this field always blank in the internal table?

Rob