topic Re: Offset problem in select query in Application Development and Automation Discussions

Offset problem in select query

satish_kumar127 — Thu, 08 May 2014 10:46:39 GMT

Hi experts,

I have a select query , in my where condition , comparing fields types are different

following is my select query

SELECT spras prctr ktext FROM cepct INTO CORRESPONDING FIELDS OF TABLE it_cepct FOR ALL ENTRIES IN it_vbsegd

WHERE prctr = it_vbsegd-bupla .

here prctr length = 10

and bupla length = 4.

we can give offset after "=" sign, but i want to use on prctr field, could anybody please give me some idea to achieve this.

thanks in advance

Re: Offset problem in select query

Former Member — Thu, 08 May 2014 10:51:39 GMT

Hi Satish,

use as follws;

WHERE prctr(4) = it_vbsegd-bupla .

Regards,

Ritesh

Re: Offset problem in select query

former_member196651 — Thu, 08 May 2014 10:54:36 GMT

Hi,

Whether your field it_vbsegd-bupla is containing both PRCTR and BUPLA? Then you can use it in 2 ways.

If PRCTR is first in it_vbsegd-bupla, then use like it_vbsegd-bupla+0(10).

If PRCTR is after BUPLA, then use like it_vbsegd-bupla+4(10).

Regards,

Abijith

Re: Offset problem in select query

satish_kumar127 — Thu, 08 May 2014 11:02:23 GMT

hi ritesh,

thanks for the reply, but it will not work, it's throwing error like

field prctr(4) is unknown.

Regards

satish

Re: Offset problem in select query

Former Member — Thu, 08 May 2014 11:03:58 GMT

If zeros alone will be there in prctr when it compare to bupla(prctr = 0000001000 & bupla = 1000 ). If that is the the problem. then you can add zeros to the bupla field and put it in one variable. and u an use that to compare to prctr.

like ,

where prctr = v_bupla

Regards,

Poornima

Re: Offset problem in select query

Former Member — Thu, 08 May 2014 11:04:28 GMT

Hi satish,

You can't do that, you can't control field length in the ABAP SQL side, at least not without HANA or native SQL.

I'd probably add a new column to table it_vbsegd, like PRCTR with your value. And then:

loop at it_vbsegd assigning <fs>.

<fs>-prctr = <fs>-bupla.

endloop.

your sql instruction:

SELECT spras prctr ktext FROM cepct INTO CORRESPONDING FIELDS OF TABLE it_cepct FORALL ENTRIES IN it_vbsegd

WHERE prctr = it_vbsegd-prctr .

regards,

Edgar

Re: Offset problem in select query

satish_kumar127 — Thu, 08 May 2014 11:05:39 GMT

Hi Abijith,

here it_vbsegd is an internal table

as i know when we are comparing with internal table field, we can use "=" sign only. any other alternate please

thanks & regards

satish

Re: Offset problem in select query

Former Member — Thu, 08 May 2014 11:10:35 GMT

Oh, like Poornima mentioned, you might need to add zeros in left. Something like:

call function 'CONVERTION_EXIT_ALPHA_INPUT'

exporting input = <fs>-bupla importing output = <fs>-prctr.

Re: Offset problem in select query

Former Member — Thu, 08 May 2014 11:27:04 GMT

Dear Satish Kumar,

Try this

SELECT spras prctr ktext FROM cepct

INTO CORRESPONDING FIELDS OF TABLE IT_CEPCT

WHERE prctr cs it_vbsegd-bupla

AND SPRAS EQ 'E'.

Regards,

Re: Offset problem in select query

Former Member — Thu, 08 May 2014 11:30:29 GMT

Hi,

created another internal table it_tab to get the result which you wanted.

DATA : it_cepct TYPE TABLE OF cepct,

it_vbsegd TYPE TABLE OF vbsegd,

wa_vbsegd type vbsegd.

TYPES : BEGIN OF ty_tab,

bupla(10),

END OF ty_tab.

DATA : it_tab TYPE TABLE OF ty_tab,

lv_bupla(10).

select * UP TO 2 ROWS FROM vbsegd INTO TABLE it_vbsegd.

loop at it_vbsegd INTO wa_vbsegd.

UNPACK wa_vbsegd-bupla to lv_bupla.

append lv_bupla to it_tab.

CLEAR : lv_bupla,wa_vbsegd.

ENDLOOP.

SELECT spras prctr ktext FROM cepct INTO CORRESPONDING FIELDS OF TABLE it_cepct FOR ALL ENTRIES IN it_tab

WHERE prctr = it_tab-bupla.