topic Re: Select strange error in Application Development and Automation Discussions

Select strange error

Former Member — Wed, 01 Oct 2008 10:25:44 GMT

Hello,

I'm doing a SELECT on bkpf and vbsegs with a join and got an "error" only when I fill 2 values in my select-options

ex:

p_bukrs = 1000

s_gjahr = 2007

s_kostl= XXX

-> work fine

p_bukrs = 1000

s_gjahr = 2007 to 2008

s_kostl = XXX

-> no reply no error, nothing :s

SELECT * INTO CORRESPONDING FIELDS OF TABLE it_fact
             FROM bkpf INNER JOIN vbsegs ON bkpf~belnr = vbsegs~belnr
             client specified 
             WHERE bkpf~mandt = sy-mandt 
               AND bkpf~bukrs = p_bukrs
               AND bkpf~gjahr IN s_gjahr
               AND bkpf~budat IN s_budat
               AND bkpf~bldat IN s_bldat
               AND vbsegs~kostl IN s_kostl.

I ve tried the same select only on the bkpf table (without JOIN) and all hapen fine.....

I got crazy : )

Thanks for help

Re: Select strange error

Former Member — Wed, 01 Oct 2008 10:35:18 GMT

hii

may i know where u r using this query an module pool or report

Re: Select strange error

Former Member — Wed, 01 Oct 2008 10:53:37 GMT

Hi,

it would be helpful to know what error you are getting.

Greetings,

Gert.

Re: Select strange error

Former Member — Wed, 01 Oct 2008 11:04:02 GMT

I need this tables to select a belnr based on the gjahr and kost data selection...

-> Unfortunatly, i dont have any error 😕

Just waiting in debug until I cut the transaction...

Thx for reply

Re: Select strange error

h_senden2 — Wed, 01 Oct 2008 11:14:15 GMT

Strange,

i'm tried your code in our test system, and your test scenario, but no error here !

What is exactly the error you're get ?

regards,

Hans

Re: Select strange error

ThomasZloch — Wed, 01 Oct 2008 11:22:26 GMT

The ON-conditions need to be enhanced:

 FROM bkpf INNER JOIN vbsegs ON bkpf~bukrs = vbsegs~ausbk
                             AND bkpf~belnr = vbsegs~belnr
                             AND bkpf~gjahr = vbsegs~gjahr

It would actually be better to join VBKPF instead of BKPF. Also delete CLIENT SPECIFIED and the WHERE-condition on bkpf~mandt, not needed.

Thomas

Re: Select strange error

Former Member — Wed, 01 Oct 2008 11:27:16 GMT

thx a lot