topic Re: Error in Select query in Application Development and Automation Discussions

Error in Select query

Former Member — Fri, 25 Apr 2014 05:13:15 GMT

Hi ,

In my select query

SELECT BELNR

VBELN

FKDAT

NETWR

BUKRS

WAERK

GJAHR

from vbrk

INTO TABLE it_vbrk

where vbeln in s_vbeln

and gjahr in s_gjahr

and fkdat in s_fkdat

and bukrs = p_bukrs.

IF not it_vbrk[] is INITIAL.

SELECT vbeln

volum

voleh

matnr

arktx from vbrp

INTO TABLE it_vbrp

FOR ALL ENTRIES IN it_vbrk

where vbeln = it_vbrk-vbeln.

endif.

IF NOT it_vbrk[] is INITIAL.

SELECT BUKRS

BELNR

GJAHR

BLART

BLDAT

XBLNR

from bkpf

INTO TABLE it_bkpf

FOR ALL ENTRIES IN it_vbrk

where bukrs = it_vbrk-bukrs

AND xblnr = it_vbrk-vbeln

and bstat <> 'A'.

ENDIF.

Getting error 'When you use the additional 'FOR ALL ENTRIES IN itab' the fields 'XBLNR'. and the 'IT_VBRK-VBELN' must have same type and same length'.

Re: Error in Select query

Arun_Prabhu_K — Fri, 25 Apr 2014 05:19:55 GMT

Hello Meenakshi.

I guess the error message is very clear.

The data and data types should match.


IF NOT it_vbrk[] is INITIAL.
     SELECT BUKRS
           BELNR
           GJAHR
           BLART
           BLDAT
           XBLNR 
       from bkpf
       INTO TABLE it_bkpf
       FOR ALL ENTRIES IN it_vbrk
       where bukrs = it_vbrk-bukrs
       AND xblnr = it_vbrk-vbeln
       and bstat <> 'A'.
ENDIF.

Regards.

Re: Error in Select query

Former Member — Fri, 25 Apr 2014 05:50:30 GMT

Thanks for your reply......i find the length length of vbrk-vbeln is 20 and bkpf-xblnr is 16 only....may this might be the problem.....

Re: Error in Select query

Arun_Prabhu_K — Fri, 25 Apr 2014 05:55:30 GMT

Exactly.

Re: Error in Select query

Former Member — Fri, 25 Apr 2014 05:58:11 GMT

But in my req they specified...

a. Select BKPF based on VBRK like detailed below:

BKPF-BUKRS eq VBRK-BUKRS
BKPF-BSTAT NOT EQUAL ‘A’
BKPF-XBLNR eq VBRK-VBELN

Re: Error in Select query

matt — Fri, 25 Apr 2014 06:01:07 GMT

The really big problem with your program, and which would get it a fail if I were your reviewer, is that you are using FOR ALL ENTRIES. Please rewrite your select using INNER JOIN.

Re: Error in Select query

Private_Member_15166 — Fri, 25 Apr 2014 10:51:19 GMT

Hi Meenakshi,

In the internal table it_vbrk, define an extra field like xblnr_t type bkpf-xblnr. After accessing the data through your first select statement, loop at that internal table with field symbol and copy the value of vbeln into xblnr_t upto 16 characters.

Now in third select statement, use like this,

SELECT BUKRS

BELNR

GJAHR

BLART

BLDAT

XBLNR

from bkpf

INTO TABLE it_bkpf

FOR ALL ENTRIES IN it_vbrk

where bukrs = it_vbrk-bukrs

AND xblnr = it_vbrk-xblnr_t

and bstat <> 'A'.

If you still get any problem, feel free to ask... I also once got this situation but this is not your fault as this is sometimes the functional needs..

Regards

Dhananjay

Re: Error in Select query

matt — Fri, 25 Apr 2014 11:02:47 GMT

It probably will work, but still suffers from the big flaw that it is using FOR ALL ENTRIES.