topic problem in select in Application Development and Automation Discussions

problem in select

Former Member — Tue, 25 Mar 2008 09:44:09 GMT

Hi friends ,

i want to pick dmbtr value from bseg table in report.

where zuonr = invoice no.

Hkont = 6105410 to 6105500.

i use this select clause

SELECT bukrs belnr gjahr dmbtr

zuonr FROM bseg

INTO CORRESPONDING FIELDS OF TABLE i_bseg

FOR ALL ENTRIES IN i_vbtab

WHERE zuonr = i_vbtab-vbeln

and Hkont in ( '610547' , '6105500' ).

but there is error that zuonr = i_vbtab-vbeln lenght does not match.

is where clause used for hkont correct

Re: problem in select

Former Member — Tue, 25 Mar 2008 09:46:17 GMT

hi,

SELECT bukrs belnr gjahr dmbtr

zuonr FROM bseg

INTO CORRESPONDING FIELDS OF TABLE i_bseg

FOR ALL ENTRIES IN i_vbtab

WHERE zuonr = i_vbtab-vbeln

and Hkont in ( '0000610547' , '0006105500' ).

Reward if helpful

Regards

Vodka.

Re: problem in select

Former Member — Tue, 25 Mar 2008 09:48:34 GMT

Hi,

in your code the ZUONR(Assignment number) from BSEG table is of length 18. Whereas the VBELN is of length 10.

Thats why it shows the error.

Regards,

Sankar.

Re: problem in select

Former Member — Tue, 25 Mar 2008 09:50:09 GMT

Hi,

Try this out.

Change the Data type of Vbeln as the type of zuonr in the table i_vbtab.

Regards,

Balakumar.G

Reward Points if helpful.

Re: problem in select

Former Member — Tue, 25 Mar 2008 09:52:09 GMT

HI,

where clause(hkont) will not give u the desired result for that write the code like this.you have to use ranges if u use in it will check on only for those two values not for that range.


ranges:r_hkont for bseg-hkont.
r_hkont-sign = 'I'.
r_hkont-option = 'BT'.
r_hkont-low = '610547'.
r_hkont-high = '6105500'.
APPEND r_hkont.

SELECT bukrs belnr gjahr dmbtr
zuonr FROM bseg
INTO CORRESPONDING FIELDS OF TABLE i_bseg
FOR ALL ENTRIES IN i_vbtab
WHERE Hkont in r_hkont and zuonr = i_vbtab-vbeln.

and for the first error while decalring internal table i_vbtab declare the field vbeln is of length 18.

rgds,

bharat.

Re: problem in select

Former Member — Tue, 25 Mar 2008 09:55:05 GMT

Hi,

Check the length for zuonr and i_vbtab-vbeln?

And the hkont values you are passing, that should be prefixed by 0000 leading zeros, otherwise your select statement will fail to retrieve the data.

Chnage the code as below:


SELECT bukrs belnr gjahr dmbtr
zuonr FROM bseg
INTO CORRESPONDING FIELDS OF TABLE i_bseg
FOR ALL ENTRIES IN i_vbtab
WHERE zuonr = i_vbtab-vbeln "Check the length
and Hkont in ( '0000610547' , '00006105500' ). "Changed the code here.

Thanks,

Sriram Ponna.

Re: problem in select

Former Member — Tue, 25 Mar 2008 09:55:48 GMT

Hi Guru

Whether u check u Declare data r not.

Data : zuonr like bseg-zuonr.

Reward Me Points

Pari

Re: problem in select

Former Member — Tue, 25 Mar 2008 09:56:18 GMT

Try like this...

data: zuonr like bseg-zuonr.

call function 'CONVERSION_EXIT_ALPHA_INPUT'

exporting

input = i_vbtab-vbeln

importing

output = zuonr.

SELECT bukrs belnr gjahr dmbtr

zuonr FROM bseg

INTO CORRESPONDING FIELDS OF TABLE i_bseg

FOR ALL ENTRIES IN i_vbtab

WHERE zuonr = zuonr

and Hkont in ( '610547' , '6105500' ).

hope it will help u..

Regards

Sugumar G

Re: problem in select

Former Member — Tue, 25 Mar 2008 09:58:39 GMT

declair as below

VBELN LIKE table_name- ZUONR

your problem will be solve.

Re: problem in select

Former Member — Tue, 25 Mar 2008 11:00:29 GMT

sriram.

in vbtab i had already define vbeln as bkpf-AWKEY.

here i had requirement where AWKEY = I_VBTAB-VBELN

now how to define it again as bseg-zuonr

Re: problem in select

Former Member — Tue, 25 Mar 2008 11:45:38 GMT

in vbtab i had already define vbeln as bkpf-AWKEY.

here i had requirement where AWKEY = I_VBTAB-VBELN

now how to define it again as bseg-zuonr

Re: problem in select

Former Member — Tue, 25 Mar 2008 11:59:58 GMT

Try Like this,

data:

wrk_zuonr type bseg-zuonr.

move i_vbtab-vbeln to wrk_zuonr.

SELECT bukrs belnr gjahr dmbtr

zuonr FROM bseg

INTO CORRESPONDING FIELDS OF TABLE i_bseg

FOR ALL ENTRIES IN i_vbtab

WHERE zuonr = wrk_zuonr

and Hkont in ( '610547' , '6105500' ).

Re: problem in select

Former Member — Wed, 26 Mar 2008 03:05:07 GMT

Hi friends .

There is still a problem.

i had used.

data:zuonr type bseg-zuonr.

call function 'CONVERSION_EXIT_ALPHA_INPUT'

exporting

input = i_vbtab-vbeln

importing

output = zuonr.

SELECT bukrs belnr gjahr dmbtr

zuonr FROM bseg

INTO CORRESPONDING FIELDS OF TABLE i_bseg

FOR ALL ENTRIES IN i_vbtab

WHERE zuonr = zuonr

and Hkont in ( '610547' , '6105500' ).

i had given all commas where required

but it says comma with out precending colon after select.

Re: problem in select

gopi_narendra — Wed, 26 Mar 2008 03:15:19 GMT

ZUONR is of length 18 and VBELN is of length 10.

And the first 10 characters of ZUONR are the VBELN. So change the program accordingly and select the data from BSEG.

Regards

Gopi

Re: problem in select

Former Member — Wed, 26 Mar 2008 03:28:19 GMT

HI,

Just copy this query and replace it.

SELECT bukrs belnr gjahr dmbtr

zuonr FROM bseg

INTO CORRESPONDING FIELDS OF TABLE i_bseg

FOR ALL ENTRIES IN i_vbtab

WHERE zuonr = zuonr

and Hkont in ('0000610547','0006105500' ).

Reward if helpful

Regards

Vodka.