topic Re: select sql in Application Development and Automation Discussions

select sql

Former Member — Fri, 15 Feb 2008 10:26:42 GMT

SELECT vbelv posnv vbeln posnn vbtyp_n rfmng meins plmin erdat bwart

FROM vbfa

INTO TABLE it_vbfa

FOR ALL ENTRIES IN it_ekbe_del

WHERE vbelv = it_ekbe_del-belnr

AND vbeln IN pr_vbel2

AND posnn = it_ekbe_del-ebelp

AND ( vbtyp_n = '5' OR vbtyp_n = 'i' ) .

what wrong with this sql stametment vbtyp_n = 'i' is not comming only '5' is comming

if i remove breaket then it going to display both for i, and 5 but all the 'i' from table near about 2000 of 'i' its fetching...

Re: select sql

former_member404244 — Fri, 15 Feb 2008 10:30:19 GMT

Hi,

it seems the query is correct

try like this

AND ( vbtyp_n = '5' OR vbtyp_n = 'I' ) .

small I is for goods receipt and big I is for order w/o change..

Regards,

Nagaraj

Re: select sql

Former Member — Fri, 15 Feb 2008 10:32:20 GMT

Try if u r getting any result for the below query

if no there is no data in ur table with vbtyp_n = 'i' which satisfies other conditions also

SELECT vbelv posnv vbeln posnn vbtyp_n rfmng meins plmin erdat bwart
FROM vbfa
INTO TABLE it_vbfa
FOR ALL ENTRIES IN it_ekbe_del
WHERE vbelv = it_ekbe_del-belnr
AND vbeln IN pr_vbel2
AND posnn = it_ekbe_del-ebelp
AND vbtyp_n = 'i' .

Re: select sql

Former Member — Fri, 15 Feb 2008 10:33:33 GMT

no its right small 'i' for Good Receipt

Re: select sql

Former Member — Fri, 15 Feb 2008 11:04:11 GMT

SELECT vbelv posnv vbeln posnn vbtyp_n rfmng meins plmin erdat bwart

FROM vbfa

INTO TABLE it_vbfa

FOR ALL ENTRIES IN it_ekbe_del

WHERE vbelv = it_ekbe_del-belnr

AND vbeln IN pr_vbel2

AND posnn = it_ekbe_del-ebelp

AND VBTYP_N IN ( '5' , 'i' ) .

use this query.i think it helps u.

regards,

sastry