topic Re: problem in select query in Application Development and Automation Discussions

problem in select query

Former Member — Fri, 03 Oct 2008 06:44:34 GMT

i want to put a section query on table vbrp vbfa and vbrk based on vbrk-vbeln and vbfa-erdat..i hav written this code but its not working.. can nnbdy suggest me sth..

SELECT v1~vbeln AS vbeln

v1~kunag AS kunag

v1~vkorg AS vkorg

v1~netwr AS netwr

v2~ntgew AS ntgew

v2~matnr AS matnr

v3~erdat AS erdat

INTO CORRESPONDING fields of table it_data1

FROM vbrk AS v1

INNER JOIN vbrp AS v2

ON v1_{vbeln = v2}vbeln

INNER JOIN vbfa AS v3

ON v2_{vbeln = v3}vbeln

WHERE v1~vbeln eq s_vbeln .

delete it_data1 where erdat not in s_erdat.

thanks in advance....

Re: problem in select query

Former Member — Fri, 03 Oct 2008 06:48:04 GMT

in VBFA just understand the meaning of vbeln and vbelv.

I think it will solve u'r problem.

S@meer

Re: problem in select query

Former Member — Fri, 03 Oct 2008 06:52:44 GMT

try with this code...

SELECT v1~vbeln

v1~kunag

v1~vkorg

v1~netwr

v2~ntgew

v2~matnr

v3~erdat INTO CORRESPONDING fields of table it_data1

FROM vbrk AS v1

INNER JOIN vbrp AS v2

ON v1_{vbeln = v2}vbeln

INNER JOIN vbfa AS v3

ON v2_{vbeln = v3}vbeln

WHERE v1~vbeln in s_vbeln .

loop at it_data1 into wa_data1 where erdat not in s_erdat.

delete it_data1 from wa_data1.

endloop.

Re: problem in select query

Former Member — Fri, 03 Oct 2008 06:53:52 GMT

Hi,

If S_vbeln is select-options then-

write-

SELECT v1~vbeln

v1~kunag

v1~vkorg

v1~netwr

v2~ntgew

v2~matnr

v3~erdat

INTO CORRESPONDING fields of table it_data1

FROM vbrk AS v1

INNER JOIN vbrp AS v2

ON v1_{vbeln = v2}vbeln

INNER JOIN vbfa AS v3

ON v2_{vbeln = v3}vbeln

WHERE v1~vbeln IN s_vbeln

and v3~erdat IN s_erdat.

And do not use into corresponding fields of , better make a internal table with the specified fields and use into table.

Re: problem in select query

Former Member — Fri, 03 Oct 2008 06:55:42 GMT

Hi,

Try like this.....


SELECT v1~vbeln AS vbeln
v1~kunag AS kunag
v1~vkorg AS vkorg
v1~netwr AS netwr
v2~ntgew AS ntgew
v2~matnr AS matnr
v3~erdat AS erdat
INTO CORRESPONDING fields of table it_data1
FROM vbrk AS v1
INNER JOIN vbrp AS v2
ON v1~vbeln = v2~vbeln
INNER JOIN vbfa AS v3
ON v1~vbeln = v3~vbeln
WHERE v1~vbeln in s_vbeln 
and v3~erdat in s_erdat.

Hope it will helps

Re: problem in select query

Former Member — Fri, 03 Oct 2008 07:02:58 GMT

hi .....

its giving me an error s_erdat is not an internal table.... s_erdat and s_vbeln are parameter names...

Re: problem in select query

Former Member — Fri, 03 Oct 2008 07:08:30 GMT

try this....

SELECT v1~vbeln

v1~kunag

v1~vkorg

v1~netwr

v2~ntgew

v2~matnr

v3~erdat INTO CORRESPONDING fields of table it_data1

FROM vbrk AS v1

INNER JOIN vbrp AS v2

ON v1_{vbeln = v2}vbeln

INNER JOIN vbfa AS v3

ON v2_{vbeln = v3}vbeln

WHERE v1~vbeln EQ s_vbeln .

loop at it_data1 into wa_data1 where erdat NE s_erdat.

delete it_data1 from wa_data1.

endloop.

Re: problem in select query

former_member585060 — Fri, 03 Oct 2008 07:09:01 GMT

Try this code

SELECT v1~vbeln

v1~kunag

v1~vkorg

v1~netwr

v2~ntgew

v2~matnr

v3~erdat

INTO CORRESPONDING FIELDS OF TABLE it_data1

FROM vbrk AS v1

INNER JOIN vbrp AS v2

ON v1_{vbeln = v2}vbeln

INNER JOIN vbfa AS v3

ON v1_{vbeln = v3}vbeln " v1 not v2

WHERE v1~vbeln EQ s_vbeln .

Regards

Bala Krishna

Edited by: Bala Krishna on Oct 3, 2008 12:39 PM

Re: problem in select query

Former Member — Fri, 03 Oct 2008 07:09:04 GMT

Hi,

If s_vbeln and s_erdat is parameters not select-options means


SELECT v1~vbeln AS vbeln
v1~kunag AS kunag
v1~vkorg AS vkorg
v1~netwr AS netwr
v2~ntgew AS ntgew
v2~matnr AS matnr
v3~erdat AS erdat
INTO CORRESPONDING fields of table it_data1
FROM vbrk AS v1
INNER JOIN vbrp AS v2
ON v1~vbeln = v2~vbeln
INNER JOIN vbfa AS v3
ON v1~vbeln = v3~vbeln
WHERE v1~vbeln eq s_vbeln 
and v3~erdat ne s_erdat.