select stmt

[Former Member]

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

[Former Member]

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

[Former Member]

<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

[Former Member]

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

[Sandeep_Kumar]

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.

[sreeramkumar_madisetty]

Hi

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

[Former Member]

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.

[Former Member]

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...!