topic Re: select stmt in Application Development and Automation Discussions

select stmt

Former Member — Thu, 01 Mar 2007 05:48:45 GMT

hi gurus,

Select * from bkpf into table itab

WHERE bukrs = 1800

AND bstat in (SPACE, 'A' , 'B' , 'D')

AND budat IN zpdate

AND STBLG = ''.

order by primary key.

the above select stmt is going to dump. plz help to solve this issue.

thanks and regards,

vinay

Re: select stmt

Former Member — Thu, 01 Mar 2007 05:50:46 GMT

Hi,

Select * from bkpf into table itab

WHERE bukrs = 1800

AND bstat in (SPACE, 'A' , 'B' , 'D') AND budat IN zpdate

AND STBLG = ''. <b>Here give Space like ' '.</b> I think it is taking the value equal to ".

order by primary key.

Regards,

Anji

Re: select stmt

Former Member — Thu, 01 Mar 2007 05:51:48 GMT

<b>Select * from bkpf into table itab

WHERE bukrs eq '1800'

AND bstat in ('', 'A' , 'B' , 'D')

AND budat IN zpdate

AND STBLG eq ''.</b>

Regards

Prabhu

Re: select stmt

Former Member — Thu, 01 Mar 2007 05:59:06 GMT

Alson,

First the internal table should have the same structure of BKPF.

Second ---ZPDATE should be the type of "BKPF-budat".

Thire Do like this.

Select * from bkpf into table itab

WHERE bukrs = '1800'

AND bstat in (SPACE, 'A' , 'B' , 'D')

AND budat IN zpdate

AND STBLG = ''.

SORT itab by bukrs belnr gjahr.

Pls. mark if useful

Re: select stmt

Sandeep_Panghal — Thu, 01 Mar 2007 06:03:45 GMT

Hi alson,

Try this:

SELECT * FROM bkpf INTO TABLE itab

WHERE bukrs = 1800

AND bstat IN (space, 'A' , 'B' , 'D')

AND budat In zpdate

AND stblg = ' '

ORDER BY PRIMARY KEY.

*reward if helps.

Re: select stmt

sreeramkumar_madisetty — Thu, 01 Mar 2007 06:04:27 GMT

Hope only mistake here is:

Select * from bkpf into table itab

WHERE bukrs = 1800

AND bstat in (SPACE, 'A' , 'B' , 'D')

AND budat IN zpdate

AND STBLG = ''.

order by primary key.

U have to give

Select * from bkpf into table itab

WHERE bukrs = 1800

AND bstat in (SPACE, 'A' , 'B' , 'D')

AND budat IN zpdate

AND STBLG = ' '.

order by primary key.

Here space convention gone wrong.

Regards,

kumar

Re: select stmt

Former Member — Thu, 01 Mar 2007 06:08:18 GMT

REPORT YJJTEST1 .

tables bkpf.
DATA: itab TYPE STANDARD TABLE OF bkpf WITH HEADER LINE.
select-options zpdate for bkpf-budat.

Select * from bkpf into table itab
WHERE bukrs = 'ITC1'
AND bstat in (SPACE, 'A' , 'B' , 'D')
AND budat IN zpdate
AND STBLG = ''
order by primary key.

see this code adn see teh table declaration u r using.

Reward if this helsp.

Re: select stmt

Former Member — Thu, 01 Mar 2007 06:10:56 GMT

Try this ...

its not going for dump..

TABLES BKPF.

SELECT-OPTIONS ZPDATE FOR BKPF-BUDAT.

DATA ITAB TYPE STANDARD TABLE OF BKPF WITH HEADER LINE.

Select * from bkpf into table itab

WHERE bukrs = '1800'

AND bstat in (SPACE, 'A' , 'B' , 'D')

AND budat IN zpdate

AND STBLG = ' '

order by primary key.

still if it goes for a dump then there may be some declaration mistakes in ur prgram check that...!