topic Re: query not working in Application Development and Automation Discussions

query not working

Former Member — Wed, 25 Oct 2006 11:13:49 GMT

Hi all,

I am working in 4.6c, i have written a select query as below but it is not populating the internal table.please help . urgent.

SELECT lifnr

name1

brsch

INTO CORRESPONDING FIELDS OF TABLE vend_det

FROM lfa1

FOR ALL ENTRIES IN po_hdr

WHERE lifnr = po_hdr-lifnr

AND brsch = 1.

Re: query not working

Former Member — Wed, 25 Oct 2006 11:17:59 GMT

try this..., change the ones in bold

<b>if not po_hdr[] is initial.</b>

SELECT lifnr
name1
brsch
INTO CORRESPONDING FIELDS OF TABLE vend_det
FROM lfa1
FOR ALL ENTRIES IN po_hdr
WHERE lifnr = po_hdr-lifnr
AND brsch = <b>'0001'</b>. 
<b>
endif.</b>

Re: query not working

Former Member — Wed, 25 Oct 2006 11:21:31 GMT

I tried even this, but it is not populating the internal table. the required vendor number(LIFNR) is present in the PO_HDR internal table but i dont know why it is not populating the <b>vend_det</b> internal table.

Re: query not working

Former Member — Wed, 25 Oct 2006 11:24:51 GMT

for that combination of LIFNR and BRSCH chk if it exits in LFA1,

also while checking if the internal table used for for all entries is initial or not , check the whole body , i.e give square brackets

Re: query not working

Former Member — Wed, 25 Oct 2006 11:26:57 GMT

Hi Satya,

get all the lifnrs into IT_lifnr.

delete adjacent duplicates from it_lifnr.

if not it_lifnr[] is initial.

select lifnr

name1

into table vend_Det

from lfa1

for all entries in it_lifnr

where lifnr = it_lifnr-lifnr

and brsch = '0001'.

endif.

this should work.

-Anu