topic Re: query problem in Application Development and Automation Discussions

query problem

Former Member — Thu, 16 Aug 2007 04:15:33 GMT

Hi experts

I used the following query, its not picking the value for the field ZUONR.

I dont understand, why it is not picking for the particular field only.

SELECT bukrs

belnr

gjahr

buzei

shkzg

wrbtr

hkont

kunnr

lifnr

sgtxt

KOART

ZUONR * this field not picking the data

matnr

PSWSL

FROM bseg

INTO TABLE it_bseg

FOR ALL ENTRIES IN it_bkpf

WHERE belnr EQ it_bkpf-belnr

AND gjahr EQ it_bkpf-gjahr

AND bukrs IN s_bukrs.

Can anyone explain me why it is, and how to correct this query.

Thanks in advance

Regards

Rajaram

Re: query problem

Former Member — Thu, 16 Aug 2007 04:19:46 GMT

deleted

Message was edited by:

Kiran Machavarapu

Re: query problem

former_member189059 — Thu, 16 Aug 2007 04:24:06 GMT

try this...

SELECT bukrs

belnr

gjahr

buzei

shkzg

wrbtr

hkont

kunnr

lifnr

sgtxt

KOART

ZUONR * this field not picking the data

matnr

PSWSL

FROM bseg

INTO <b>corresponding fields of </b>TABLE it_bseg

FOR ALL ENTRIES IN it_bkpf

WHERE belnr EQ it_bkpf-belnr

AND gjahr EQ it_bkpf-gjahr

AND bukrs IN s_bukrs.

Re: query problem

former_member194669 — Thu, 16 Aug 2007 04:26:59 GMT

Hi,

1. First check it_bseg internal table contains the same field name

2. Check in it_bseg the fields are in same order as you mentioned.

3. if above are okay change the query as


SELECT bukrs
belnr
gjahr
buzei
shkzg
wrbtr
hkont
kunnr
lifnr
sgtxt
KOART
ZUONR * this field not picking the data
matnr
PSWSL
FROM bseg
INTO corresponding fields of TABLE it_bseg
FOR ALL ENTRIES IN it_bkpf
WHERE belnr EQ it_bkpf-belnr
AND gjahr EQ it_bkpf-gjahr
AND bukrs IN s_bukrs.

a®

Re: query problem

Former Member — Thu, 16 Aug 2007 04:33:51 GMT

Now its picking the data yar, what is the problem before.

what u chnages now.

Regards

Rajaram

Re: query problem

former_member189059 — Thu, 16 Aug 2007 04:40:17 GMT

when you put data into a table, it puts all the data in the same order that it gets it from the table

in many cases (such as yours) the data fetched is not in the same order as your internal table's structure

in order to keep the order, we can use 'into corresponding fields of' addition

this checks the field names and puts the data in them accordingly

Re: query problem

Former Member — Thu, 16 Aug 2007 06:06:11 GMT

ok thank you very much yar.

Regards

Rajaram