topic Re: select statement not working in Application Development and Automation Discussions

select statement not working

Former Member — Fri, 04 Apr 2008 03:28:34 GMT

my second select statement is failed. bseg table having data for this condition.

DATA : BEGIN OF it_bkpf OCCURS 0,

bukrs LIKE bkpf-bukrs,

budat LIKE bkpf-budat, "posting date

belnr LIKE bkpf-belnr,

monat LIKE bkpf-monat, "posting period

saknr LIKE bseg-saknr, " G/L Account

aufnr LIKE bseg-aufnr, " Internal order No

sgtxt LIKE bseg-sgtxt, " JOB (Item Text)

blart LIKE bkpf-blart, " Document Type

dmbtr LIKE bseg-dmbtr, " amount in local currency

waers LIKE bkpf-waers, " currency Key

END OF it_bkpf.

DATA : BEGIN OF it_bseg OCCURS 0,

bukrs LIKE bseg-bukrs,

belnr LIKE bseg-belnr,

werks like bseg-werks,

saknr LIKE bseg-saknr, " G/L Account

aufnr LIKE bseg-aufnr, " Internal order No

dmbtr LIKE bseg-dmbtr, " amount in local currency

sgtxt LIKE bseg-sgtxt, " JOB (Item Text)

END OF it_bseg.

SELECT bukrs budat belnr monat blart waers

INTO TABLE it_bkpf

FROM bkpf

WHERE bukrs = '012'

AND blart IN s_blart

AND budat IN s_budat

AND waers IN s_waers.

SELECT bukrs belnr werks saknr aufnr dmbtr sgtxt

from bseg

INTO table it_bseg

WHERE bukrs = '012'

AND saknr = '461100'

AND werks = '1201'.

Re: select statement not working

Former Member — Fri, 04 Apr 2008 03:33:41 GMT

SELECT bukrs budat belnr monat blart waers

INTO TABLE it_bkpf

FROM bkpf

WHERE bukrs = '0012'

AND blart IN s_blart

AND budat IN s_budat

AND waers IN s_waers

Always BUKRS 4 chars.

Reward points...

Re: select statement not working

Former Member — Fri, 04 Apr 2008 03:34:01 GMT

Hi,

Pass the values into variables of type bseg-bukrs,bseg-werks,

and bseg-saknr.

Use this variables in WHERE condition.

Maintain Company code of 4 characters length.

You may get the solution.Let me know the result.

Regards,

Chandu

Re: select statement not working

Former Member — Fri, 04 Apr 2008 03:36:59 GMT

hi thr..

modify the second select statement

use

select........ into corresponding fields of table....

do reward if helpful... and get bak if any more help reqd.

Re: select statement not working

Former Member — Fri, 04 Apr 2008 03:41:35 GMT

Pass the GL account with leading zeros.



SELECT bukrs belnr werks saknr aufnr dmbtr sgtxt
from bseg
INTO table it_bseg
WHERE bukrs = '012'
AND saknr = '0000461100'   "GL acc with leading zeros
AND werks = '1201'.

Hope this helps.

Thanks,

Balaji

Re: select statement not working

Former Member — Fri, 04 Apr 2008 03:41:41 GMT

Try to Use

SELECT bukrs belnr werks saknr aufnr dmbtr sgtxt

from bseg

INTO corresponding fields of table it_bseg

WHERE bukrs = '012'

AND saknr = '461100'

AND werks = '1201'.

or check any conversion routine for the fields saknr or werks

Re: select statement not working

Former Member — Fri, 04 Apr 2008 03:42:04 GMT

Kumar,

I think need to pass 4 char value to bukrs.

bukrs= '0012' and

saknr = '0000461100' and

werks = '1201'

Now try.

Don't forget to reward if useful...